Problem 3-3 (Algo) Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is Jan, Feb, and Mar, 2nd quarter Apr May, Jun; 3rd quarter Jul, Aug. Sep; and 4th quarter Oct. Nov, Dec. (Round final answer to a whole number.) JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 220 210 205 275 300 325 Last year 175 195 205 235 245 275 This year 195 205 155 270 250 200 Forecast for the third quarter

Problem 3-3 (Algo) Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is Jan, Feb, and Mar, 2nd quarter Apr May, Jun; 3rd quarter Jul, Aug. Sep; and 4th quarter Oct. Nov, Dec. (Round final answer to a whole number.) JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 220 210 205 275 300 325 Last year 175 195 205 235 245 275 This year 195 205 155 270 250 200 Forecast for the third quarter

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Please help me with show calculation thanku
Please do not give solution in image format thanku
Why was the amount for December multiplied by 40 and the amount for January when its 40% of the prior month and 60% of the current?
mni.3
Sales for February of this year totaled $192,096. If the planned seasonal sales distribution is as follows, figure the dollar sales for the remaining months of the period. Round to the nearest dollar. February 10% March 14% April 16% May 18% June 14% July 12%
3-a. Compute the break-even point in dollar sales for April.
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 >
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
Subject :Accounting Not pictured: A 4th column (after "2") titled "Six Months", one blank on the final row
None
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?