A local restaurant has recorded the demand for bottled water in each of the last 15 months of business. Use the recorded demand data below to develop three-period and four-period moving-average forecasts for bottles of water.
Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations.
Period
Demand
Period
Demand
Period
Demand
1
890
6
890
11
870
2
910
7
960
12
860
3
905
8
895
13
900
4
850
9
910
14
940
5
860
10
905
15
925
1) What is the forecast for period 16 using the three-period weighted method?
(Weights are t=0.5, t-1=0.4 and t-2=0.1)
A) Less than or equal to 890
B) Greater than 890 but less than or equal to 900
C) Greater than 900 but less than or equal to 910
D) Greater than 910 but less than or equal to 920
E) Greater than 920
2) What is the forecast for period 16 using the four-period weighted method?
(Weights are t=0.3, t-1=0.2, t-2=0.3 and t-3=0.2)
A) Less than or equal to 890
B) Greater than 890 but less than or equal to 900
C) Greater than 900 but less than or equal to 910
D) Greater than 910 but less than or equal to 920
E) Greater than 920
3) What is the MAD for the three-period weighted moving-average forecast as of period 15?
A) Less than or equal to 15.00
B) Greater than 15.00 but less than or equal to 20.00
C) Greater than 20.00 but less than or equal to 25.00
D) Greater than 25.00 but less than or equal to 30.00
E) Greater than 30.00
4) What is the MAPE for the three-period weighted moving average forecast as of period 15?
A) Less than or equal to 3.00%
B) Greater than 3.00% but less than or equal to 3.50%
C) Greater than 3.50% but less than or equal to 4.00%
D) Greater than 4.00%but less than or equal to 4.50%
E) Greater than 4.50%
5) What is the MAD for the four-period weighted moving average forecast as of period 15?
A) Less than or equal to 15.00
B) Greater than 15.00 but less than or equal to 20.00
C) Greater than 20.00 but less than or equal to 25.00
D) Greater than 25.00 but less than or equal to 30.00
E) Greater than 30.00
6) What is the MAPE for the four-period weighted moving average forecast as of period 15?
A) Less than or equal to 3.00%
B) Greater than 3.00% but less than or equal to 3.50%
C) Greater than 3.50% but less than or equal to 4.00%
D) Greater than 4.00% but less than or equal to 4.50%
E) Greater than 4.50%
7) Which forecast is the best (the three-period or four-period weighted method)?
A) The 3-period moving average is the best forecast because the MAD and MAPE are less than the 4-period moving average MAD and MAPE .
B) The 3-period moving average is the best forecast because the MAD and MAPE are greater than the 4-period moving average MAD and MAPE.
C) The 4-period moving average is the best forecast because the MAD and MAPE are less than the 3-period moving average MAD and MAPE.
D) The 4-period moving average is the best forecast because the MAD and MAPE are greater than the 3-period moving average MAD and MAPE.
Answers: 1
Business, 22.06.2019 05:30
Financial information that is capable of making a difference in a decision is
Answers: 3
Business, 22.06.2019 08:40
During january 2018, the following transactions occur: january 1 purchase equipment for $20,600. the company estimates a residual value of $2,600 and a five-year service life. january 4 pay cash on accounts payable, $10,600. january 8 purchase additional inventory on account, $93,900. january 15 receive cash on accounts receivable, $23,100 january 19 pay cash for salaries, $30,900. january 28 pay cash for january utilities, $17,600. january 30 firework sales for january total $231,000. all of these sales are on account. the cost of the units sold is $120,500. the following information is available on january 31, 2018. depreciation on the equipment for the month of january is calculated using the straight-line method. the company estimates future uncollectible accounts. at the end of january, considering the total ending balance of the accounts receivable account as shown on the general ledger tab, $4,100 is now past due (older than 90 days), while the remainder of the balance is current (less than 90 days old). the company estimates that 50% of the past due balance will be uncollectible and only 3% of the current balance will become uncollectible. record the estimated bad debt expense. accrued interest revenue on notes receivable for january. unpaid salaries at the end of january are $33,700. accrued income taxes at the end of january are $10,100
Answers: 2
Business, 22.06.2019 16:00
In microeconomics, the point at which supply and demand meet is called the blank price
Answers: 3
Business, 22.06.2019 16:10
The following are line items from the horizontal analysis of an income statement:increase/ (decrease) increase/ (decrease) 2017 2016 amount percent fees earned $120,000 $100,000 $20,000 20% wages expense 50,000 40,000 10,000 25 supplies expense 2,000 1,700 300 15 which of the items is stated incorrectly? a. fees earned b. supplies expense c. none of these choices are correct. d. wages expense
Answers: 3
A local restaurant has recorded the demand for bottled water in each of the last 15 months of busine...
English, 26.03.2020 01:02
Mathematics, 26.03.2020 01:02
Mathematics, 26.03.2020 01:02
Mathematics, 26.03.2020 01:02
Mathematics, 26.03.2020 01:02
Mathematics, 26.03.2020 01:02
Mathematics, 26.03.2020 01:02
Social Studies, 26.03.2020 01:02