8. Calculate the average inventory for the three-month season that follows. Month Ending Stock Level January $10,500 February $11,600 March $9,900 9. Planned sales for the three-month season in problem #8 are $10,000. Calculate the stock turnover 10. Use the following information to answer the questions below. Last Year Last Year Monthly Sales BOM Stock January $10,000 $20,000 February $12,000 $25,000 March $14,000 $30,000 April $18,000 $38,000 May $19,000 $40,000 June $18,000 $39,000 July $19,000 $41,000 August $21,000 $43,000 September $23,000 $47,000 October $26,000 $52,000 November $31,000 $60,000 December $30,000 $58,000 Ending Inventory December 31 $28,000 a. For the time period presented, what were total sales? b. What was the average inventory for the period? c. What was the annual stock turnover rate? Month Sales January $10,000 February $12,000 March $14,000 April $18,000 May $19,000 June $18,000 July $19,000 August $21,000 September $23,000 October $26,000 November $31,000 December $30,000 EOM 12/31 EOM Stock $20,000 $25,000 $30,000 $38,000 $40,000 $39,000 $41,000 $43,000 $47,000 $52,000 $60,000 $58,000 $28,000 TOTALS $241,000 $521,000 d. Calculate last year's stock-sales ratio for each of the months given. Stock to Sales Ratio Month January February March April May June July August September October November December Stock/ Sales $20,000/$10,000 $25,000/$12,000 $30,000/$14,000 $38,000/$18,000 $40,000/$19,000 $39,000/$18,000 $41,000/$19,000 $43,000/$21,000 $47,000/$23,000 $52,000/$26,000 $60,000/$31,000 $58,000/$30,000 e. Next December, the buyer wants to maintain the current stock-to-sales ratio but reduce the BOM stock to $55,000. What sales must occur next year for this to occur