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 [a] [b] [c] [d] [e] [f] 8 EOM [g] [h] [i] [j] [l] [m] 9 S/S Ratio [n] X X [o] X X 10 Turn [p] X X [q] X X 11 Qtr Turn [r] [s] 12 Season Turn: [t] 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: [u] F9: [v] G10: [w]
Read Details