ONLY SOLVE QUESTION "20"

Use the following 6 Month Buying Plan to post your answers for Problems 17-20. Make certain to complete both the header and the body of the buying plan: Fall 2019 Plan Net Sales, Fall 2019 Average Stock, Retail: Inventory Turnover: Planned Reductions, $ Reductions % Sales Plan IMU % 2019 6 Month Buying Plan August September October December January November Net Sales % Fall Plan BOM Stock Stock /Sales Ratio Plan EOM Stock Plan Reductions % Fall Purchases, Retail Purchases, Cost 17. The total department plan sales for Fall 2019 is $500,000. Plan sales by month using the following sales curve: % Fall 2019 August 14% September 18% October 16% %Fall 2019 November December January % Fall 2019 Particulars 18% Department Sales 22% August 12% September October November December January 0.14 0.18 0.16 0.18 0.22 0.121 Amount 500000 0 0 0 0 0 0 18. Reductions are planned to be 20% of net sales. Plan reductions by month using the following curve: % Fall 2019 August 8% September 15% October 15% November December January % Fall 2019 22% 25% 15% Amount 100000 0 0 Particulars Reductions August September October November December January %Fall 2019 500000* 20% 0.08 0.15 0.15 0.22 0.25 0 0 0 0 0.15 19. Use the following stock to sales ratios to plan monthly BOM and EOM stocks: Stock /Sales August 2.9 November September 2.6 December October 2.9 January Plan the January EOM stock to be $200,000. Stock/Sales 2.9 P 3.4 de 5 Solution to Question 19. Data Given: MONTH STOCK/SALES RATIO August 2.9 September 2.6 October 2.9 November 2.9 December 2.2 January 3.4 End of Month Stock as at January end = $ 200,000 Workings: MONTH August September October November December January All amounts in $ BEGINNING OF MONTH (BOM) STOCK SALES END OF MONTH (EOM) STOCK 1,267,827 325,084 942,743 942,743 261,873 680,870 680,870 174,587 506,288 506,288 129,817 376,471 376,471 117,647 258,824 258,824 58,824 200,000 CROSS-CHECK RATIOS = EOM STOCK/SALES 2.9 2.6 2.9 2.9 2.2 3.4 20. A. Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2019. B. The IMU% for Fall 2019 is planned at 52%. Calculate the monthly purchases at cost and sum the total purchases at cost for Fall 2019. Use the following 6 Month Buying Plan to post your answers for Problems 17-20. Make certain to complete both the header and the body of the buying plan: Fall 2019 Plan Net Sales, Fall 2019 Average Stock, Retail: Inventory Turnover: Planned Reductions, $ Reductions % Sales Plan IMU % 2019 6 Month Buying Plan August September October December January November Net Sales % Fall Plan BOM Stock Stock /Sales Ratio Plan EOM Stock Plan Reductions % Fall Purchases, Retail Purchases, Cost 17. The total department plan sales for Fall 2019 is $500,000. Plan sales by month using the following sales curve: % Fall 2019 August 14% September 18% October 16% %Fall 2019 November December January % Fall 2019 Particulars 18% Department Sales 22% August 12% September October November December January 0.14 0.18 0.16 0.18 0.22 0.121 Amount 500000 0 0 0 0 0 0 18. Reductions are planned to be 20% of net sales. Plan reductions by month using the following curve: % Fall 2019 August 8% September 15% October 15% November December January % Fall 2019 22% 25% 15% Amount 100000 0 0 Particulars Reductions August September October November December January %Fall 2019 500000* 20% 0.08 0.15 0.15 0.22 0.25 0 0 0 0 0.15 19. Use the following stock to sales ratios to plan monthly BOM and EOM stocks: Stock /Sales August 2.9 November September 2.6 December October 2.9 January Plan the January EOM stock to be $200,000. Stock/Sales 2.9 P 3.4 de 5 Solution to Question 19. Data Given: MONTH STOCK/SALES RATIO August 2.9 September 2.6 October 2.9 November 2.9 December 2.2 January 3.4 End of Month Stock as at January end = $ 200,000 Workings: MONTH August September October November December January All amounts in $ BEGINNING OF MONTH (BOM) STOCK SALES END OF MONTH (EOM) STOCK 1,267,827 325,084 942,743 942,743 261,873 680,870 680,870 174,587 506,288 506,288 129,817 376,471 376,471 117,647 258,824 258,824 58,824 200,000 CROSS-CHECK RATIOS = EOM STOCK/SALES 2.9 2.6 2.9 2.9 2.2 3.4 20. A. Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2019. B. The IMU% for Fall 2019 is planned at 52%. Calculate the monthly purchases at cost and sum the total purchases at cost for Fall 2019