Question

In: Accounting

You are given the following budgeted and actual data for the Grey Company for each of...

You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year.

In December of the prior year, sales were forecasted as follows: January, 93 units; February, 88 units; March, 95 units; April, 100 units; May, 107 units; June, 115 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 83 units; March, 95 units; April, 95 units; May, 97 units; June, 110 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 90 units; April, 95 units; May, 92 units; June, 110 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 95 units; May, 87 units; June, 100 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 77 units; June, 95 units. In May of the current year, sales for June were reforecasted as 95 units.

Actual sales for the six-month period, January through June, were as follows: January, 82 units; February, 83 units; March, 94 units; April, 99 units; May, 101 units; June, 110 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.

Solutions

Expert Solution

SCHEDULE OF FORECAST SALES
1 January February March April May June
Actual Sales 82 83 94 99 101 110
Forecast in December 93 88 95 100 107 115
Forecast in January 83 95 95 97 110
Forecast in February 90 95 92 110
Forecast in March 95 87 100
Forecast in April 77 95
Forecast in May 95
2 Three Month Forecast Error Rate
a 3 Month Forecast Error for March 1 (95-94) December Forecast= 95
b 3 Month Forecast Error for April 4 (99-95) January Forecast= 95
c 3 Month Forecast Error for May 9 (101-92) February Forecast 92
d 4 Month Forecast Error for June 10 (110-100) March Forecast 100
e Actual Sales in March 94
f Actual Sales in April 99
g Actual Sales in May 101
h Actual Sales in June 110
i=a/e Forecast Error Rate For March 1.06% Actual Sales Volume below Forecast
j=b/f Forecast Error Rate For April 4.04% Actual Sales Volume above Forecast
k=c/g Forecast Error Rate For May 8.91% Actual Sales Volume above Forecast
l=d/h Forecast Error Rate For June 9.09% Actual Sales Volume above Forecast

Related Solutions

You are given the following budgeted and actual data for the Grey Company for each of...
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 105 units; February, 100 units; March, 107 units; April, 112 units; May, 119 units; June, 127 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 95 units; March, 107 units; April, 107 units;...
The following data is given for the Stringer Company: Budgeted production 954 units Actual production 1,030...
The following data is given for the Stringer Company: Budgeted production 954 units Actual production 1,030 units Materials: Standard price per ounce $1.92 Standard ounces per completed unit 12 Actual ounces purchased and used in production 12,731 Actual price paid for materials $26,099 Labor: Standard hourly labor rate $14.49 per hour Standard hours allowed per completed unit 4.8 Actual labor hours worked 5,304.5 Actual total labor costs $80,894 Overhead: Actual and budgeted fixed overhead $1,031,000 Standard variable overhead rate $25.00...
The following data are given for Harry Company: Budgeted production 1,056 units Actual production   900 units...
The following data are given for Harry Company: Budgeted production 1,056 units Actual production   900 units Materials:     Standard price per ounce $1.758     Standard ounces per completed unit 11     Actual ounces purchased and used in production 10,197     Actual price paid for materials $20,904 Labor:     Standard hourly labor rate $14.09 per hour     Standard hours allowed per completed unit 4.4     Actual labor hours worked 4,635     Actual total labor costs $75,319 Overhead:     Actual and budgeted fixed overhead $1,054,000     Standard variable overhead rate $24.00 per...
The following data are given for Stringer Company: Budgeted production 959 units Actual production   1,063 units...
The following data are given for Stringer Company: Budgeted production 959 units Actual production   1,063 units Materials:     Standard price per ounce $1.9     Standard ounces per completed unit 10     Actual ounces purchased and used in production 10,949     Actual price paid for materials $22,445 Labor:     Standard hourly labor rate $14.96 per hour     Standard hours allowed per completed unit 4.6     Actual labor hours worked 5,474.45     Actual total labor costs $83,485 Overhead:     Actual and budgeted fixed overhead $1,186,000     Standard variable overhead rate $27.00 per...
16.The following data is given for the Stringer Company: Budgeted production 906 units Actual production   1,059...
16.The following data is given for the Stringer Company: Budgeted production 906 units Actual production   1,059 units Materials:     Standard price per ounce $1.84     Standard ounces per completed unit 10     Actual ounces purchased and used in production 10,908     Actual price paid for materials $22,361 Labor:     Standard hourly labor rate $14.81 per hour     Standard hours allowed per completed unit 4.1     Actual labor hours worked 5,453.85     Actual total labor costs $83,171 Overhead:     Actual and budgeted fixed overhead $1,002,000     Standard variable overhead rate $25.00...
The following data is given for the XYZ Company:       Budgeted production                         &nbsp
The following data is given for the XYZ Company:       Budgeted production                                                          26,000 units       Actual production                                                               27,500 units       Materials:                                                                                  Standard price per ounce                                                 $6.50        Standard ounces per completed unit                                 8        Actual ounces purchased and used in production              228,000        Actual price paid for materials                                          $1,504,800       Labor:                                                                                        Standard hourly labor rate                                                $22 per hour        Standard hours allowed per completed unit                      6.6        Actual labor hours worked                                                183,000        Actual total labor costs                                                     $4,016,850...
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts:...
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: Variable costs of production:      Direct materials 3 pounds @ $0.60 per pound      Direct labor 0.5 hr. @ $16.00 per hour      VOH 0.5 hr. @ $2.20 FOH:      Materials handling $6,200      Depreciation $2,600 At the end of the year, Bowling had the following actual costs for production of 3,800 units: Direct materials $6,800 Direct labor 30,500 VOH 4,200 FOH:      Materials handling 6,300      Depreciation $2,600 Required: 1....
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts:...
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: Variable costs of production:      Direct materials 3 pounds @ $0.60 per pound      Direct labor 0.5 hr. @ $16.00 per hour      VOH 0.5 hr. @ $2.20 FOH:      Materials handling $6,200      Depreciation $2,600 At the end of the year, Bowling had the following actual costs for production of 3,800 units: Direct materials $6,800 Direct labor 30,500 VOH 4,200 FOH:      Materials handling 6,300      Depreciation $2,600 Required: 1....
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts:...
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: Variable costs of production:      Direct materials 3 pounds @ $0.60 per pound      Direct labor 0.5 hr. @ $16.00 per hour      VOH 0.5 hr. @ $2.20 FOH:      Materials handling $6,200      Depreciation $2,600 At the end of the year, Bowling had the following actual costs for production of 3,800 units: Direct materials $6,800 Direct labor 30,500 VOH 4,200 FOH:      Materials handling 6,300      Depreciation $2,600 Required: 1....
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts:...
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: Variable costs of production:      Direct materials 3 pounds @ $0.60 per pound      Direct labor 0.5 hr. @ $16.00 per hour      VOH 0.5 hr. @ $2.20 FOH:      Materials handling $6,200      Depreciation $2,600 At the end of the year, Bowling had the following actual costs for production of 3,800 units: Direct materials $6,800 Direct labor 30,500 VOH 4,200 FOH:      Materials handling 6,300      Depreciation $2,600 Required: 1....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT