Need help

OTB: $975,760 at retail to spend to stock on store

Part B. (30%) In Part B, you will calculate your OTB, which is the amount of retail S you can spend to stock your store. This OTB money will be for the fall season, which will encompass Aug, Sep, Oct, Nov, Dec and Jan of 2020. Using the figures provided you will calculate the following for your store. Show this work on an Excel spreadsheet in traditional OTB grid format. 1. Open to buy for each month 2. Average monthly sales 3. Average monthly on order 4. Mark down % for each month Planned sales + Planned reductions + Planned EOM Stock - Total monthly needs - BOM Stock - Planned purchases - Merchandise on order - Open to buy Page 1 of 2 Planned Employee Sales Discount $175,000 2% $150,000 2% $125,000 $250,000 3% $300,000 4% $100,000 August September October November December January 2% MD $ Shortages $35,000 1.5% $30,000 1.5% $25,000 1.5% $50,000 2.5% $60,000 2.5% $20,000 1.5% Merchandise On Order $81,125 $65,250 $204,376 $208,750 $ 19,500 $ 64,500 EOM BOM $300,000 $350,000 $250,000 $300,000 $500,000 $250,000 $600,000 $500,000 $250,000 $600,000 $300,000 $250,000 3% Part C. (20%) Using an Excel Spreadsheet: - You will detail your open to buy merchandise, down to the style level (not size) by month.* - Units in this spread shedt should yield the total OTB dollars by month and the total OTB that you calculated in Part B. *When describing your style information, please be sure you list the cost, markup (this should be 50% mark up at a minimum) and retail for each item. *Your spreadsheet should be set up so that the months run across the top (from left to right) and your descriptions run down. Part D. (10%) Solve the following: 1. After careful analysis of the economic data from the U.S. Government, the XYZ store set a sales plan increase for the next years fall season (2021) of 9.7%. Based on this year's sales plan what is the companies projected sales plan for the next season? 2. In the 2019 fall sales period the XYZ store had actual sales of $1,050,000.00. What was the fall 2020 planned increase or decrease for sales? Suggest reasons for the change from one season to the next. Part B. (30%) In Part B, you will calculate your OTB, which is the amount of retail S you can spend to stock your store. This OTB money will be for the fall season, which will encompass Aug, Sep, Oct, Nov, Dec and Jan of 2020. Using the figures provided you will calculate the following for your store. Show this work on an Excel spreadsheet in traditional OTB grid format. 1. Open to buy for each month 2. Average monthly sales 3. Average monthly on order 4. Mark down % for each month Planned sales + Planned reductions + Planned EOM Stock - Total monthly needs - BOM Stock - Planned purchases - Merchandise on order - Open to buy Page 1 of 2 Planned Employee Sales Discount $175,000 2% $150,000 2% $125,000 $250,000 3% $300,000 4% $100,000 August September October November December January 2% MD $ Shortages $35,000 1.5% $30,000 1.5% $25,000 1.5% $50,000 2.5% $60,000 2.5% $20,000 1.5% Merchandise On Order $81,125 $65,250 $204,376 $208,750 $ 19,500 $ 64,500 EOM BOM $300,000 $350,000 $250,000 $300,000 $500,000 $250,000 $600,000 $500,000 $250,000 $600,000 $300,000 $250,000 3% Part C. (20%) Using an Excel Spreadsheet: - You will detail your open to buy merchandise, down to the style level (not size) by month.* - Units in this spread shedt should yield the total OTB dollars by month and the total OTB that you calculated in Part B. *When describing your style information, please be sure you list the cost, markup (this should be 50% mark up at a minimum) and retail for each item. *Your spreadsheet should be set up so that the months run across the top (from left to right) and your descriptions run down. Part D. (10%) Solve the following: 1. After careful analysis of the economic data from the U.S. Government, the XYZ store set a sales plan increase for the next years fall season (2021) of 9.7%. Based on this year's sales plan what is the companies projected sales plan for the next season? 2. In the 2019 fall sales period the XYZ store had actual sales of $1,050,000.00. What was the fall 2020 planned increase or decrease for sales? Suggest reasons for the change from one season to the next