Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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
Need help
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669be247be37a_039669be247134ad.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669be248c9571_040669be24821279.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started