Calculate the open-to-buy for March given the following data: March sales $30,000 markdowns $5,000 March BOM stock $90,000 March EOM stock $100,000 March on order $10,000 85 9. 86 Calculate the open-to-buy for March given the following data: 87 March sales $30,000 88 markdowns $5,000 89 March BOM stock $90,000 90 March EOM stock $100,000 91 March on order $10,000 92 Page 3 19 20 2. 21 A department has experienced the following sales trends to last year: 22 Past 90 days trend to LY = +9% 23 Past 30 days trend to LY = +10% 24 Which of the following sales forecasts would be most appropriate to plan for the coming season? 25 A. I would not plan a sales increase to LY. 26 B. a sales increase to LY of +10% 27 C. a sales increase to LY of +20% 28 D. a sales increase to LY of +25% 30 Use the following 6 Month Buying Plan to post your answers for Problems 3.8. 31 Make certain to complete both the header and the body of the buying plan: 32 Fall 2019 33 Plan Net Sales, Fall 2019 34 Average Stock, Retail: 35 Inventory Turnover: 36 Planned Reductions, $: 37 Reductions % Sales: 38 Plan IMU % Fall 2019 6 Month Buying Plan September October November December August January Fall 2019 Net Sales % Fall SALES Plan BOM Stock Stock /Sales Ratio Plan EOM Stock Plan Reductions % Fall REDUCTIONS Purchases, Retail Purchases, Cost The total department plan sales for Fall 2019 is $500,000. 54 Plan sales by month using the following sales curve: % Fall 2019 % Fall 2019 August 14% November 18% September 18% December 22% October 16% January 12% T=Page 2 Reductions are planned to be 20% of net sales. Plan reductions by month using the following curve: % Fall 2019 August 8% November September 15% December October 15% January % Fall 2019 22% 25% 15% 69 Use the following stock to sales ratios to plan monthly BOM and EOM stocks: Stock / Sales Stock/Sales 71 August 2.9 November 2.9 72 September 2.6 December 73 October 2.9 January 3.4 Plan the January EOM stock to be $200,000. 2.2 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2019, 80 The plan IMU for Fall 2019 is 52.00%. Plan the monthly purchases at cost and sum the total purchases at cost for Fall 2019. 81 82 8. 83 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2019: 84 Calculate the open-to-buy for March given the following data: March sales $30,000 markdowns $5,000 March BOM stock $90,000 March EOM stock $100,000 March on order $10,000 85 9. 86 Calculate the open-to-buy for March given the following data: 87 March sales $30,000 88 markdowns $5,000 89 March BOM stock $90,000 90 March EOM stock $100,000 91 March on order $10,000 92 Page 3 19 20 2. 21 A department has experienced the following sales trends to last year: 22 Past 90 days trend to LY = +9% 23 Past 30 days trend to LY = +10% 24 Which of the following sales forecasts would be most appropriate to plan for the coming season? 25 A. I would not plan a sales increase to LY. 26 B. a sales increase to LY of +10% 27 C. a sales increase to LY of +20% 28 D. a sales increase to LY of +25% 30 Use the following 6 Month Buying Plan to post your answers for Problems 3.8. 31 Make certain to complete both the header and the body of the buying plan: 32 Fall 2019 33 Plan Net Sales, Fall 2019 34 Average Stock, Retail: 35 Inventory Turnover: 36 Planned Reductions, $: 37 Reductions % Sales: 38 Plan IMU % Fall 2019 6 Month Buying Plan September October November December August January Fall 2019 Net Sales % Fall SALES Plan BOM Stock Stock /Sales Ratio Plan EOM Stock Plan Reductions % Fall REDUCTIONS Purchases, Retail Purchases, Cost The total department plan sales for Fall 2019 is $500,000. 54 Plan sales by month using the following sales curve: % Fall 2019 % Fall 2019 August 14% November 18% September 18% December 22% October 16% January 12% T=Page 2 Reductions are planned to be 20% of net sales. Plan reductions by month using the following curve: % Fall 2019 August 8% November September 15% December October 15% January % Fall 2019 22% 25% 15% 69 Use the following stock to sales ratios to plan monthly BOM and EOM stocks: Stock / Sales Stock/Sales 71 August 2.9 November 2.9 72 September 2.6 December 73 October 2.9 January 3.4 Plan the January EOM stock to be $200,000. 2.2 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2019, 80 The plan IMU for Fall 2019 is 52.00%. Plan the monthly purchases at cost and sum the total purchases at cost for Fall 2019. 81 82 8. 83 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2019: 84