a) Fill in the blanks for OTB and EOM for each month (you’ll…

a) Fill in the blanks for OTB and EOM for each month (you’ll need to also note the BOM for each month on your own): b) Calculate Stock to Sales Ratio and Turn for the months of Feb and May c) Calculate Turn for each quarter and for the season Express stock to sales and turn answers 3 places to the right of the decimal & use a comma for numbers with 5+ digits (no dollar sign needed) A B C D E F G 1   Feb Mar Apr May  June July 2 BOM 290,000           3 Sales 120,000 120,000 184,000 135,000 190,000 200,000 4 Markdowns 25,000 30,000 20,000 14,000 26,000 40,000 5 Purchases 300,000 175,000 180,000 126,000 165,000 130,000 6 On Order 130,000 50,000 65,000 45,000 4,000 0 7 OTB 8 EOM 9 S/S Ratio X X X X 10 Turn X X X X 11 Qtr Turn 12 Season Turn:  d) If inputing the above Merchandise Plan into a MS Excel spreadsheet, write out the formula EXACTLY how you would input it for the following cells: E8: F9: G10:    

  Units sold OH Jackets 1090 4000 Shirts 946 6000 Swea…

  Units sold OH Jackets 1090 4000 Shirts 946 6000 Sweaters 800 5700 Pants 743 6100 Skirts 605 7000 a) Calculate the top to bottom ratio (round 1 place to the right of the decimal) for selling: for OH: b) From your top to bottom ratio analysis, what do you need more inventory of? (tops or bottoms)