2. Jewelry unlimited sells an array of jewelry from moderately priced items to some rather expensive...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
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... View the full answer
Related Book For
Principles of heat transfer
ISBN: 978-0495667704
7th Edition
Authors: Frank Kreith, Raj M. Manglik, Mark S. Bohn
Posted Date:
Students also viewed these general management questions
-
Develop a multiple regression model containing all four independent variables. Show clearly the regression coefficients. Write a short report discussing the model. In your report make sure you cover...
-
A market research analyst used multiple regression analysis to determine the impact of price and promotion on the sale of a new brand of cereal. The analyst collected data from three variables from...
-
A 1200 kg car is accelerated from 30 to 50 km/h in 5 s. How much work is that? If you continue from 50 to 70 km/h in 5 s is that the same?
-
Raheem & Co. purchased a fixed asset on 1.4.2018 for Rs.2,50,000. Depreciation is to be provided @10% annually according to the Straight-line method. The books are closed on 31st March every year....
-
A random variable follows the continuous uniform distribution between 130 and 300. a. Calculate the following probabilities for the distribution: 1. P (180 < x < 260) 2. P (130 < x < 200) 3. P (x 7...
-
The human resource (HR) director of a large corporation wishes to study absenteeism among its mid- level managers at its central office during the year. A random sample of 25 mid-level managers...
-
A stainless-steel component is exposed to laser heating at an initial temperature of \(300 \mathrm{~K}\). After a short transient the surface reaches its melting point, and the surface recedes at a...
-
1. To compute the price elasticity of demand, we divide the percentage change in_______ by the percentage change in _______and then take the _______value of the ratio. 2. If a 10 percent increase in...
-
The Sky Blue Corporation has the following adjusted trial balance at December 31. Cash Accounts Receivable Prepaid Insurance Notes Receivable (long-term) Equipment Accumulated Depreciation Accounts...
-
Reconsider the Lockhead Aircraft Co. problem presented in Problem 16.15 regarding a project to develop a new fighter airplane for the U.S. Air Force. Management is extremely concerned that current...
-
Zapper has beginning equity of $257,000, during the current year Zapper reported net income of $51,000, dividends of $40,000 and new stockholder investments of $6,000. Assume further that Zapper had...
-
Why might it be difficult to establish contributory negligence as a defence in a case involving negligent misrepresentation?
-
Explain the importance of notice of terms in a standard form contract. To what extent does the law protect the interest of the public in standard form contracts?
-
Which provisions of the Charter have particular application to business activity?
-
Explain inherent safety and passive safety in the reactors.
-
How does a court determine if competition has been unduly lessened?
-
Blue Spruce Corp. has the following account balances at December 31, 2021: Notes payable ($ 46,000 due after 12/31/22) $ 76,000 Unearned service revenue 53,000 Mortgage Payable ($ 68,000 due in...
-
General Electric Capital, a division of General Electric, uses long-term debt extensively. In a recent year, GE Capital issued $11 billion in long-term debt to investors, then within days filed legal...
-
Mercury at an inlet bulk temperature of 90?C flows through a 1.2-cm-ID tube at a flow rate of 4535 kg/h. This tube is part of a nuclear reactor in which heat can be generated uniformly at any desired...
-
Two concentric spheres 0.2 m and 0.3 m in diam, with the space between them evacuated, are to be used to store liquid air (133 K). If the surfaces of the spheres have been flashed with aluminum and...
-
Hot flue gases from a combustion furnace flow though a chimney, which is 7 m tall and has a hollow cylindrical cross section with inner diameter d i = 30 cm and outer diameter d o = 50 cm. The flue...
-
To address his concern regarding the previous advisers asset allocation approach, Raye should assess the Laws portfolio using: A. a homogeneous and mutually exclusive asset classbased risk analysis....
-
Raye believes the previous advisers specification for debt is incorrect given that, for purposes of asset allocation, asset classes should be: A. diversifying. B. mutually exclusive. C. relatively...
-
Walker Patel is a portfolio manager at an investment management firm. After successfully implementing meanvariance optimization (MVO), he wants to apply reverse optimization to his portfolio. For...
Study smarter with the SolutionInn App