Having a problem with this. Need Help.

You will calculate your OTB, which is the amount of retail $ 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.

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

Planned Sales Employee MD Shortage EOM BOM Merchandise on order

Discount

August $175,000 2% $35,000 1.5% $300,000 $350,000 $81,125

September $150,000 2% $30,000 1.5% $250,000 $300,000 $65,250

October $125,000 2% $25,000 1.5% $500,000 $250,000 $204,376

November $250,000 3% $50,000 2.5% $600,000 $500,000 $208,750

December $300,000 4% $60,000 2.5% $250,000 $600,000 $19,500

January $100,000 3% $20,000 1.5% $300,000 $250,000 $ 64,500

Using an Excel Spreadsheet: - You will detail your open to buy merchandise, down to the style level (not size) by month.* - Units in this spreadsheet 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.

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 years 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

Highlight Rotate Markup Part B. (30%) In Part B, you will calculate your OTB, which is the amount of retail $ 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 August September October November December January Planned Employee Sales Discount $175,000 2% $150,000 2% $125,000 2% $250,000 3% $300,000 4% $100,000 3% MDS 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% 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 Merchandise On Order $81,125 $65,250 $204,376 $208,750 $ 19,500 $ 64,500 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 sheet 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. Highlight Rotate Markup Part B. (30%) In Part B, you will calculate your OTB, which is the amount of retail $ 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 August September October November December January Planned Employee Sales Discount $175,000 2% $150,000 2% $125,000 2% $250,000 3% $300,000 4% $100,000 3% MDS 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% 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 Merchandise On Order $81,125 $65,250 $204,376 $208,750 $ 19,500 $ 64,500 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 sheet 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