In December of the prior year, sales were forecasted as follows: January, 96 units; February, 91...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In December of the prior year, sales were forecasted as follows: January, 96 units; February, 91 units; March, 98 units; April, 103 units; May, 110 units; June, 118 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 86 units; March, 98 units; April, 98 units; May, 100 units; June, 113 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 93 units; April, 98 units; May, 95 units; June, 113 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 98 units; May, 90 units; June, 103 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 80 units; June, 98 units. In May of the current year, sales for June were reforecasted as 98 units. Actual sales for the six-month period, January through June, were as follows: January, 88 units; February, 86 units; March, 110 units; April, 94 units; May, 115 units; June, 125 units. Required: 1. 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.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. 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 April May June Forecast January February March December January February March April May In December of the prior year, sales were forecasted as follows: January, 96 units; February, 91 units; March, 98 units; April, 103 units; May, 110 units; June, 118 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 86 units; March, 98 units; April, 98 units; May, 100 units; June, 113 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 93 units; April, 98 units; May, 95 units; June, 113 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 98 units; May, 90 units; June, 103 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 80 units; June, 98 units. In May of the current year, sales for June were reforecasted as 98 units. Actual sales for the six-month period, January through June, were as follows: January, 88 units; February, 86 units; March, 110 units; April, 94 units; May, 115 units; June, 125 units. Required: 1. 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.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. (Round "Forecast error rate" answers to 2 decimal places. For example, 23.423% = 23.42%.) Actual sales Forecast error rate Direction of error January February March % April % May % June % Show less In December of the prior year, sales were forecasted as follows: January, 96 units; February, 91 units; March, 98 units; April, 103 units; May, 110 units; June, 118 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 86 units; March, 98 units; April, 98 units; May, 100 units; June, 113 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 93 units; April, 98 units; May, 95 units; June, 113 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 98 units; May, 90 units; June, 103 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 80 units; June, 98 units. In May of the current year, sales for June were reforecasted as 98 units. Actual sales for the six-month period, January through June, were as follows: January, 88 units; February, 86 units; March, 110 units; April, 94 units; May, 115 units; June, 125 units. Required: 1. 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.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. 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 April May June Forecast January February March December January February March April May In December of the prior year, sales were forecasted as follows: January, 96 units; February, 91 units; March, 98 units; April, 103 units; May, 110 units; June, 118 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 86 units; March, 98 units; April, 98 units; May, 100 units; June, 113 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 93 units; April, 98 units; May, 95 units; June, 113 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 98 units; May, 90 units; June, 103 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 80 units; June, 98 units. In May of the current year, sales for June were reforecasted as 98 units. Actual sales for the six-month period, January through June, were as follows: January, 88 units; February, 86 units; March, 110 units; April, 94 units; May, 115 units; June, 125 units. Required: 1. 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.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. (Round "Forecast error rate" answers to 2 decimal places. For example, 23.423% = 23.42%.) Actual sales Forecast error rate Direction of error January February March % April % May % June % Show less
Expert Answer:
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Compare Figure 3.21 with Figure 3.23, and explain the difference between the geodatabase and the coverage in handling the route data structure. Route ID 1 1 1 07 Section- ID 1 2 1 3 Figure 3.21 The...
-
Q4 11 Points 4. Consider the following Current Data for ABC Corp.: Debt Equity Market Value (in millions of $) 16,000 26,000 Cost 7% 14% If ABC moves to and maintains a debt-to-value (D/V) ratio of...
-
Which statement about sarcormere contraction is incorrect? a. The A bands shorten. b. The 11 zones shorten. c. The l bands shorten. d. The sarcormeres shorten.
-
North Star prepared the following unadjusted trial balance at the end of its second year of operations ending December 31, 2012. Other data not yet recorded at December 31, 2012: a. Rent expired...
-
Identify the effects of the following transactions on total stockholders' equity: Each transaction is independent. a. A \(10 \%\) stock dividend. Before the dividend, 500,000 shares of \(\$ 1\) par...
-
Each of the following items must be considered in preparing a statement of cash flows for Blackwell Inc. for the year ended December 31, 2010. State where each item is to be shown in the statement,...
-
Why don't governments like private issues of money, or even foreign currency, being used in their countries, and try to monopolise the issue of domestic money?
-
Andy and Marcia Tufts, both age 35, are married with two children and file a joint return. Assume the children do not qualify for the child tax credit (Ch. 9), and the mortgage is not over $750,000....
-
On January 1 , 2 0 2 3 , Fisher Corporation purchased 4 0 percent ( 7 2 , 0 0 0 shares ) of the common stock of Bowden, Incorporated, for $ 9 9 2 , 0 0 0 in cash and began to use the equity method...
-
What do you think are some pressing questions for health communication researchers to investigate?
-
True or False: If \(F W(\mathrm{~A})>F W(\mathrm{~B})\), then \(D P B P(\mathrm{~A})
-
In Exercise 8.7, a nonminimum delay overlapped solution is possible by choosing \[\mathbf{C}_{l}(z)=\left[\begin{array}{cccc}D_{0}(z) & R_{1}(z) & 0 & 0 \\0 & R_{0}(z) & R_{1}(z) & 0 \\0 & 0 &...
-
Moving money forward in time while accounting for the time value of money is referred to as a. weighted average cost of capital. b. minimum attractive rate of return. c. discounting. d. compounding.
-
If you invest \(\$ 3,000\) three years from now, how much will be in the account 15 years from now if \(i=8\) percent compounded annually? a. \(\$ 3,500\) b. \(\$ 7,555\) c. \(\$ 9,415\) d. \(\$...
-
What are the differences among direct mapping, associative mapping, and set associative mapping?
-
Outline some of the major problems confronting an international advertiser.
-
Identify four or five potential critical success factors for a manufacturer of industrial chemicals. Explain why you consider those factors critical for the firm to be successful.
-
Fashion House, a manufacturer of high-fashion clothing for women, is located in South London. Its product line consists of trousers (45 percent), skirts (35 percent) , dresses (15 percent), and other...
-
Habib Manufacturing has five manufacturing departments and operating and cost information for the most recent two months of activity. Required Identify whether the cost in each department is fixed,...
-
Solve Chapter Problem 13.21, assuming the power spectral density is band limited with \(\omega_{1}=50 \mathrm{rad} / \mathrm{s}\) and \(\omega_{2}=200 \mathrm{rad} / \mathrm{s}\). Data From Chapter...
-
Solve Chapter Problem 13.21, assuming the force is narrowband with a power spectral density given by \(S_{F}(\omega)=\frac{3 \times 10^{-3}}{2+5 \omega^{2}}\). Data From Chapter Problem 13.21: A SDOF...
-
Fine Leather Ltd has provided the following production and sales information for each pair of its dress shoes. The fixed costs for the period are \($1\) 125 000. Required (a) Calculate the...
Study smarter with the SolutionInn App