Use the provided Excel template to calculate a plan for unit need by specific price points, sizes, and dollars for a classification. You will build formulas to determine classification dollars, units, and sizes needed.
A B D E F G H J K L M N Q R 1 Classification Plan Women's Shoes 2 August 1, 202_ BOM Stock: Student Practice Template 3 General Breakdown: BOM Stock Classification Problem: Calculate the retail dollars and units to complete the plan with the following information: Boys Jacket classification # 7 has a BOM stock plan of $ 120,000 Lower price point jackets will be priced @ $20 ea and represent 30% of business Middle price point jackets will be priced @ $30 ea and represent 50% of business Upper price point jackets will be priced @ $50 ea and represent 20% of business 4. Price Line % to Stock Total Retail Retail Units 5 0% 0% 0% 0% 6 Lower $ 7 Middle $ 8 Upper $ 9 Total 10 11 Style Breakdown Lower Price 12 13 Sizes Percent (%) 14 Lower Price Middle Price Middle Price Upper Price Upper Price Calculate the retail dollars and number of pieces and complete the plan with the following information: For lower price jackets the sizes will be broken down as follows: Small 10%, Medium 40%, Large 30% and X large 20% For medium price jackets the sizes will be broken down as follows: Small 5%, Medium 50%, Large 35% and X Large 10% For higher price jackets the sizes will be broken down as follows: Small 5%, Medium 40%, Large 35% and X Large 20% Pieces Percent (%) Pieces Percent (%) Pieces 15 16 17 18 19 20 21 A B D E F G H J K L M N Q R 1 Classification Plan Women's Shoes 2 August 1, 202_ BOM Stock: Student Practice Template 3 General Breakdown: BOM Stock Classification Problem: Calculate the retail dollars and units to complete the plan with the following information: Boys Jacket classification # 7 has a BOM stock plan of $ 120,000 Lower price point jackets will be priced @ $20 ea and represent 30% of business Middle price point jackets will be priced @ $30 ea and represent 50% of business Upper price point jackets will be priced @ $50 ea and represent 20% of business 4. Price Line % to Stock Total Retail Retail Units 5 0% 0% 0% 0% 6 Lower $ 7 Middle $ 8 Upper $ 9 Total 10 11 Style Breakdown Lower Price 12 13 Sizes Percent (%) 14 Lower Price Middle Price Middle Price Upper Price Upper Price Calculate the retail dollars and number of pieces and complete the plan with the following information: For lower price jackets the sizes will be broken down as follows: Small 10%, Medium 40%, Large 30% and X large 20% For medium price jackets the sizes will be broken down as follows: Small 5%, Medium 50%, Large 35% and X Large 10% For higher price jackets the sizes will be broken down as follows: Small 5%, Medium 40%, Large 35% and X Large 20% Pieces Percent (%) Pieces Percent (%) Pieces 15 16 17 18 19 20 21
