82 8. 83 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2019: 84 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: Fall 2019 33 Plan Net Sales, Fall 2019 34 Average Stock, Retail: 35 Inventory Turnover: 36 Planned Reductions, $: 37 Reductions % Sales: 38 Plan IMU%: August September Fall 2019 6 Month Buying Plan October November December January Fall 2019 45 46 Net Sales % Fall SALES Plan BOM Stock Stock /Sales Ratio Plan EOM Stock Plan Reductions % Fall REDUCTIONS Purchases, Retail Purchases, Cost 48 49 51 52 3. 53 The total department plan sales for Fall 2019 is $500,000. Sheet1 O Type here to search PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 52 3. 53 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 56 August 14% November 18% 57 September 18% December 22% 58 October 16% January 12% 59 60 4. 61 Reductions are planned to be 20% of net sales. 62 Plan reductions by month using the following curve: % Fall 2019 % Fall 2019 64 August 8% November 22% 65 September 15% December 25% 66 October 15% January 15% 68 5. 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 74 Plan the January EOM stock to be $200,000 75 76 6. 77 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2019. 78 79 7. 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, 82 8. 83 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2019: 859 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 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 82 8. 83 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2019: 84 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: Fall 2019 33 Plan Net Sales, Fall 2019 34 Average Stock, Retail: 35 Inventory Turnover: 36 Planned Reductions, $: 37 Reductions % Sales: 38 Plan IMU%: August September Fall 2019 6 Month Buying Plan October November December January Fall 2019 45 46 Net Sales % Fall SALES Plan BOM Stock Stock /Sales Ratio Plan EOM Stock Plan Reductions % Fall REDUCTIONS Purchases, Retail Purchases, Cost 48 49 51 52 3. 53 The total department plan sales for Fall 2019 is $500,000. Sheet1 O Type here to search PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 52 3. 53 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 56 August 14% November 18% 57 September 18% December 22% 58 October 16% January 12% 59 60 4. 61 Reductions are planned to be 20% of net sales. 62 Plan reductions by month using the following curve: % Fall 2019 % Fall 2019 64 August 8% November 22% 65 September 15% December 25% 66 October 15% January 15% 68 5. 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 74 Plan the January EOM stock to be $200,000 75 76 6. 77 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2019. 78 79 7. 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, 82 8. 83 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2019: 859 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 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