Complete this question by entering your answers in the tabs below. 4 Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January • February March April May Required 1 Required 2 >

Complete this question by entering your answers in the tabs below. 4 Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January • February March April May Required 1 Required 2 >

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

Please see attached image, I need to construct a table to show a three month moving average forecast for January of year 2
The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 17 12 15 15 15 19 22 22 23 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied the most recent month = sales (round your response to one decimal place). Using exponential smoothing with a = 0.35 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…
Monthly sales of storage sheds at Wallace Garden supply are shown in the following table. Using the 3-month moving average forecasting method (simple average), what is your forecast of December sales? Actual Month Sales January February March April May June July August September October November December? O 15.2 16.7 20.67 O None of the above 10 12 16 13 17 19 15 20 22 19 21
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Davis and Davis have expected sales of $490, $465, $450, and $570 for the months of January through April, respectively. The accounts receivable period is 28 days. What is the accounts receivable balance at the end of March? Assume a year has 360 days. a. $450 b. $420 c. $440 d. $426
Ecology Co. sells a biodegradable product called Dissol and has predicted the following sales for the first four months of the current year: Sales in units O 3,010 O 3,100 O 3,190 O 2,830 O 3,700 Jan. 2,500 Ending inventory for each month should be 15% of the next month's sales, and the December 31 inventory is consistent with that policy. How many units should be purchased in February? Question 8 Feb. 3,100 March. 3,700 April. 2,800 F6 F7 F8
ARE YOU READY TO PRACTICE: Complete the table below. A Company has the following sales 2,000 in January, 2,200 in February, 2,800 in Apr and 3,000 in May. Assuming the selling prices is P100/unit. Sales for each month ar expected to be collected as follows: • Month of sales: 20% ► A month after sales: 50% ► 2 months after sales: 30% - How much is total receipts from sales? Apr Jan Feb Mar May Total Units Sold 12, 500 P1,250,000 P250,000 Sales in Pesos Collection from current months sales Collection from previous P150,000 months sales Collection from two months P84,000 sales Total Collections from Sales 40,000 P926,000 PRACTICE EXERCISE 1: Fill the table below. A Company has the following sales 2,000 in January, 2,200 in February, 2,800 in April and 3,00 in May. Assume that cost per unit is PHP50. All purchases this month are paid the following month. How much is total cash disbursements for purchases? Jan Feb Mar Apr May Total Required production Cost in Pesos Payment from current…
You have been provided with monthly sales projections for year one for Maggie’s Coffee Café. Use these projections to answer the following: Based on the sales projections for Maggie’s Coffee Cafe determine: Sales per day for the first month they are open (January) ______________ Sales per day for the 6th month they are open (June) ______________ Sales per day for the 12th month they are open (December) ______________ (assume the business is open 7 days/week; Jan and Dec have 31 days; June has 30) Which month has the highest sales? Which month has the lowest sales? Why do you think this is so?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows. Month Soles Forecast 1 Forecast 2 1 835 785 810 2 835 800 825 3 830 845 845 4 855 830 815 5 770 765 810 6 835 805 811 7 780 790 810 8 845 790 780 9 790 820 810 10 815 795 840 a. Compute the MSE and MAD for each forecast (Round your answers to 2 decimal places.) MSE MAD Forecast 1 Forecast 2
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.