6.5% increase to last year. This goes in space J11.
- 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)
- Check yourself, if you are correct, each month should have a 6.5% increase over LY.
- 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.
- Do not figure any BOM for the total. As BOM and EOM are only monthly figures, they cannot be calculated as a total.
- 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.
- Plan monthly MD's - the same way you did step 2 (monthly sales).
- Calculate the MD % for each month and the total - you need to remember the formula for MD% yourself
- 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.
- 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.
- Calculate the shortage % in cells I34 and J34. You need to remember this formula on your own
- 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.
- Plan your purchases at retail through December. Use the purchase formula from unit 5.
- 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.
- Plan purchases at cost for each month, remember if you have retail and MU$ you can find cost.
- 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)
- The total average inventory number should = January's average inventory
- Calculate each month's SS Ratio (the total column should be blank)
- 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!
Recently Asked Questions
- Max has the utility function U (x1,x2) = x1 (x2 + 1). 1. Suppose that the price of commodity one is p1, the price of commodity two is p2, and Max has an income
- "Max Gross has the utility function U (x1,x2) = max(x1,x2). If the price of commodity one is the same as the price of commodity two, Max will buy equal amounts
- "Darlene's utility function is U(q1,q2,q3) = q3 1q7 2q3. If her income doubles and prices remain unchanged, her demand for commodity two will more than