In Part B, you will calculate your OTB, which is the amount of retail $ you can
Question:
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 of 2021, which will encompass Aug, Sep, Oct, Nov, Dec and Jan of 2021. 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 Discount - Merchandise - Shortages - EOM - BOM - Merchandise On Order
August $200,000 2% $50,000 1.5% $320,000 $350,000 $67,000
September $160,000 2% $32,000 1.5% $240,000 $320,000 $57,600
October $120,000 2% $24,000 1.5% $520,000 $240,000 $228,200
November $260,000 3% $65,000 2.5% $600,000 $520,000 $219,300
December $300,000 4% $75,000 2.5% $250,000 $600,000 $ 4,500
January $100,000 3% $20,000 1.5% $300,000 $250,000 $ 84,500
*Your spreadsheet should be set up so that the months run across the top (from left to right) and your descriptions run down.
Visualizing Environmental Science
ISBN: 978-1119147527
4th edition
Authors: Linda R. Berg, David M. Hassenzahl, Mary Catherine Hager