16. The Gonzales Electric Companys 12 products are further grouped into four product families. Products A, B,

Question:

16. The Gonzales Electric Company’s 12 products are further grouped into four product families. Products A, B, and C compose family l; D, E, and F are in family 2; G, H, and I compose family 3; and products J, K, and L make up family 4. Ernesto Gonzales has the following exponential smoothing forecasts of monthly demand for each product.

image text in transcribed

Gonzales’s sales force has also come up with the monthly forecasts of sales for each product family.

image text in transcribed

image text in transcribed

a. Roll up the individual product forecasts and compare them to the forecast provided by the sales force. Using a spreadsheet, roll down the forecast to make the individual item forecast agree with the sales force forecast. Calculate dollar value and number of units in the individual item forecast.

b. Top management has independently decided to set a $300,000 overall monthly sales goal for the company. Adjust the sales force forecast to reflect this new goal; then roll down the forecast to the individual item level. Calculate dollar value and number of units in the individual item forecast.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Manufacturing Planning And Control For Supply Chain Management The CPIM Reference

ISBN: 9781265138516

3rd Edition

Authors: F. Robert Jacobs, William Lee Berry, D. Clay Whybark, Thomas E. Vollmann

Question Posted: