10. Insert the following Stock-to-Sales ratios by month to calculate the BOM Stock for each month. What is the BOM stock for April? February March April May June July APRIL PLANNED BOM 2.6 2.4 2.3 2.0 1.8 1.7 11. Use the planned BOM stocks to insert the estimated EOM stocks by month. Use the final EOM stock of $120,000 for the last month. What is the Planned EOM Stock for April? APRIL PLANNED EOM 12. Calculate the Average Inventory or Stock. What is the Average Stock Value? Average Stock 13. Calculate the Planned Turnover. What is the Turnover (show two decimals)? Planned Turnover 14. Calculate the Planned Purchases at RETAIL for Each month. Add the total sum. TOTAL Planned Purchase RETAIL 15. Calculate the Planned Purchases at COST for Each month. Use the Markup % given of 56%. What are the Total Planned Purchases for the Six month plan at COST? TOTAL Planned Purchase COST