Part A. (40%)
- As a buyer for XYZ retail store (name your store) you will choose a classification of merchandise that
you will buy. - You will decide your store location and the type of store it will be.
- This information will be backed up by documented valid research and trend information.
This written portion of the project will be a minimum of three typed double space pages, in APA format.
In it, you will cite the research material used to choose this type of store, its customer demographic and its
location. You will also describe the reasons why you chose your specific product classification.
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 of 2021, which will encompass Aug, Sep, Oct, Nov, Dec of 2021 and
Jan of 2022.
Using the planned figures provided you will calculate the following for your store.
Show this work on an Excel spreadsheet in traditional OTB grid format.
- Open to buy for each month
- Average monthly sales
- Average monthly on order
- Mark down % for each month
Employee Merchandise
Sales Discount MD $ Shortages BOM EOM On Order
August $220,000 2% $57,200 1.5% $440,000 $356,000 $100,900
September $178,000 2% $37,380 1.5% $356,000 $270,000 $ 35,610
October $135,000 2% $28,350 1.5% $270,000 $560,000 $258,075
November $280,000 3% $72,800 1.5% $560,000 $650,000 $155,400
December $325,000 4% $100,750 2.5% $650,000 $280,000 $ 26,875
January $100,000 2% $26,000 1.5% $280,000 $350,000 $ 100.500
• Your spreadsheet should be set up so that the months run across the top (from left to right) and your
descriptions run down. There is a sample in the Term Project Module.
• As a reminder, OTB is the amount of merchandise that needs to be purchased so that the department
achieves its EOM inventory goal. It is calculated as:
o Planned Sales + Planned Reductions + Planned EOM = Total Monthly Needs
o Total Monthly Needs – Planned BOM Stock = Planned Purchases
o Planned Purchases – Merchandise Onorder = Open to Buy
Created in Master PDF Editor
Page 2 of 2
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. There is a sample in the Term Project Module.
Part D. (10%)
Solve the following:
- 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, 2022, of+ 10.3%. Based on this year’s sales plan what is the companies
projected sales plan for the next season? - In the 2020 Fall sales period the XYZ store had actual sales of $1,125,000. What is the Fall 2021
planned increase or decrease for sales when compared to Fall 2020? Suggest reasons for the change from one
season to the next.
Sample Solution