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, 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; May, 109 units; June, 122 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 102 units; April, 107 units; May, 104 units; June, 122 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 107 units; May, 99 units; June, 112 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 89 units; June, 107 units. In May of the current year, sales for June were reforecasted as 107 units.

Actual sales for the six-month period, January through June, were as follows: January, 106 units; February, 95 units; March, 104 units; April, 105 units; May, 123 units; June, 129 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.

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; May, 109 units; June, 122 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 102 units; April, 107 units; May, 104 units; June, 122 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 107 units; May, 99 units; June, 112 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 89 units; June, 107 units. In May of the current year, sales for June were reforecasted as 107 units.

Actual sales for the six-month period, January through June, were as follows: January, 106 units; February, 95 units; March, 104 units; April, 105 units; May, 123 units; June, 129 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.


Required 1

Month of Forecast January February March April May June

December
January
February
March
April
May

Required 2

   January February March    April    May    June
Actual Sales
Forecast Error Rate - - % % % %
Direction of Error - -

Solutions

Expert Solution

ekkarill92 answered 1 year ago
Next > < Previous

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, 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;...
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
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT