please answer question 2

2. Jewelry unlimited sells an array of jewelry from moderately priced items to some rather expensive items. These products are organized into four product families by price range: moderate, high-moderate, high, and premium. Forecasts for each item are developed using a combination of numerical methods. To augment the product level forecasts, the marketing managers for each of these product families independently develop forecasts at the product family level using a combination of multiple regression analysis and market research. The product level and product family level forecasts are given below. Family Product Units Price($)/ unit Moderate A 1500 50 B 1200 75 C 1 100 100 Hi gh-modemte D 500 500 E 600 750 F 650 1000 High G 200 5000 H 150 6000 I 100 7000 Premium 1 25 10000 K 15 12000 L 1 0 15000 Family level Sales S$0005 ! Moderate 350 High-moderate 1,250 High 2,150 Premium 900 Calculate a roll-up of the individual product forecasts and compare it to the product family forecast. Do a force down of the family level forecast in each family to obtain revised unit level forecasts that will add-up to the family level dollar forecast. Roll up the product family dollar forecasts to a corporate level forecast. Top management has decided that sales will come in at $5,250,000. How do these two numbers compare? Force d0wn the corporate forecast to the family and to the product levels (in units and dollars at both levels) using the original item level forecasts as the basis for the force down. 1. Chemicals-RUs provides its customers with two types of a potassium-based feedstock: Regular K and Extra K. This product is sold in a reusable 150 gallon tote bin. Next year's sales, in number of tote bins, by sales region (east and west) appears in the table below. Regular K sells for $400 per bin; Extra K sells for $900 per bin. Calculate aroll-up ofthe individual product forecasts to the region level (total units and dollars), and then to the corporate level (just dollars). The corporate economist has independently forecasted total sales of these potassium- based feedstocks at $1,200,000. How does this forecast compare to the roll-up. Force dewn the corporate forecast to the region (total units and dollars) and then to the product level in both regions (in units and dollars)