Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Jewelry unlimited sells an array of jewelry from moderately priced items to some rather expensive items. These products are organized into four product

2.Jewelry unlimited sells an array of jewelry from moderately priced items to some rather expensive items. Theseproducts arFamily levelModerateHigh-moderateHighPremiumSales($000s)3501,2502,150900Calculate a roll-up of the individual prod 

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 Moderate High-moderate High Premium Family level Moderate High-moderate High Premium Product A B D E F G H I J K L Sales ($000s) 350 1,250 2,150 900 Units 1500 1200 1100 500 600 650 200 150 100 25 15 10 Price(S)/unit 50 75 100 500 750 1000 5000 6000 7000 10000 12000 15000 Family level Moderate High-moderate High Premium Sales ($000s) 350 1,250 2,150 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 down 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.

Step by Step Solution

3.48 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

Roll up of Individual Product Forecasts to Product Family Forecasts The roll up of the individual product forecasts to product family forecasts can be done by summing the units and prices of each prod... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of heat transfer

Authors: Frank Kreith, Raj M. Manglik, Mark S. Bohn

7th Edition

495667706, 978-0495667704

More Books

Students also viewed these General Management questions