View the step-by-step solution to:

Question

6.5% increase to last year. This goes in space J11.


  1. Plan monthly sales - find each

month's percent to last year's total then take this year's sales times that percent. (So the formula for AUG = (D13/$J$13)*$J$11)


  1. Check yourself, if you are correct, each month should have a 6.5% increase over LY. 


  1. Plan your BOMs using a 4.5 Stock to Sales Ratio for all months except for December which should be a 3.0 SS Ratio.


  1. Do not figure any BOM for the total. As BOM and EOM are only monthly figures, they cannot be calculated as a total.


  1. Calculate MD's. This year's markdowns will be planned down 3% from LY. Calculate this year's total markdowns and type in cell J25.


  1. Plan monthly MD's - the same way you did step 2 (monthly sales). 


  1. Calculate the MD % for each month and the total - you need to remember the formula for MD% yourself


  1. Calculate the shortage $ for the 6-month period. Shortage % will be planned the same as LY at 2% for the year. This will go in cell J31. Remember the shortage $ formula from unit 4.


  1. You will be taking physical inventory in the same month you did LY, type the same amount you just got (the actual number) in cell I31. Remember that shortage is only figured after physical inventory is taken. This store takes it once a season so all months are blank except the month when the inventory is completed.


  1. Calculate the shortage % in cells I34 and J34. You need to remember this formula on your own


  1. You know your EOM numbers through DEC (remember that EOM = BOM of the next month). Type them in now. Your Jan EOM = $435. Type that in now as well.


  1. Plan your purchases at retail through December. Use the purchase formula from unit 5.


  1. Plan your IMU on purchases. Your IMU for each month will be 71%. Type that in every month and the total (starting in cell D22 through cell J22). Remember that stores plan an IMU and though each item varies, the IMUs are averaged with the goal of achieving the planned IMU.


  1. Plan purchases at cost for each month, remember if you have retail and MU$ you can find cost.


  1. Find this year's average inventory for each month (remember you cannot copy this formula as the number of inventories changes each month it's figured)


  1. The total average inventory number should = January's average inventory


  1. Calculate each month's SS Ratio (the total column should be blank)


  1. Figure each month's turnover as well as the total turnover


Make sure everything is formatted correctly, check print preview to be sure it fits to one page.


Congratulations, you've just completed your first 6-month plan!

Screen Shot 2019-08-01 at 1.04.38 AM.png


Screen Shot 2019-08-01 at 1.04.59 AM.png

Screen Shot 2019-08-01 at 1.04.38 AM.png

Screen Shot 2019-08-01 at 1.04.59 AM.png

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question