Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
Please see the attached file.
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
The Gonzales Electronic Company’s 12 products are further grouped into four product families. Product A, B, and C compose family 1; D, E, and F compose family 2; and product s G, H, and I make up family 3; and products J, K, and L make up family 4. Dick Gonzales has the following forecasts of monthly demand for each product.
Family Product Forecast $/unit
1 A
B
C 10
15
20 1,000
1,200
900
2 D
E
F 5
3
2 5,000
7,000
9,000
3 G
H
I 100
180
220 250
100
100
4 J
K
L 2
4
3 10,000
9,000
8,000
Gonzales’s sales force has also come up with the monthly forecasts of sales for each product family.
Family $ Sales
1 50,000
2 50,000
3 75,000
4 75,000
a. Top management has independently set a $300,000 overall monthly sales goal for the company. Roll up the individual product forecasts and compare them with the family data. Use a spreadsheet and the family forecasts to revise the individual item forecasts (in both dollars and units).
b. Roll up the family forecasts to the top level, compare these to the overall forecasts, and roll the forecasts back down to families and to individual unit forecasts (dollars units).
c. Suppose a major customer order has just been received for 10 units of product J. This order wasn’t expected and it in addition to any other forecasts for product J. The company still wants to plan a total monthly sales volume of $300,000. Use the family forecasts (revised) to roll the forecasts to and down to get revised individual product forecasts.
© BrainMass Inc. brainmass.com March 21, 2019, 4:32 pm ad1c9bdddf
https://brainmass.com/business/business-management/roll-up-sales-forecast-gonzales-electronic-company-190245
Attachments
The+Gonzales+Electronic+Company[1].docSolution Preview
See attached for answers.
The question is essentially a weighted average type of problem where you figure new units to produce based upon a new sum, but using the same make up or the same percentages of product. In other words, if …
