2. Accounting
3. a small firm has an ending inventory of 52000 as...

# Question: a small firm has an ending inventory of 52000 as...

###### Question details

A small firm has an ending inventory of $52,000 as at December 31, 2012 and the following accounting information.  Month Ending Inventory Cost of Goods Sold January 2013$75,000 $225,000 February$56,000 $325,000 March$25,000 $240,000 April$85,000 $325,000 May$125,000 $460,000 June$95,000 $220,000 July$72,000 $85,000 August$45,000 $156,000 September$52,500 $220,000 October$120,000 $265,000 November$162,500 $100,000 December$255,000 $350,000 a) Compute the monthly inventory turnover ratio for each of the twelve months. Do you see any trend in the monthly inventory turnover ratio? (4 points) Hints: the average inventory level = (ending inventory of previous period + ending inventory of current period)/2. Use Excel to do all calculations and copy/paste the result to Word file. b) What are the annual cost of goods sold and the average inventory for the year? (3 points) Hint: the annual cost of goods sold = summation of cost of goods sold of 12 months; the average inventory for the year = summation of average inventory of 12 months / 12. c) Compute the annual inventory turnover ratio. What can the purchasing department do to improve the firm’s performance? (3 points) Problem 2 (10 points) You are given the following information:  Costs Make Option Buy Option Fixed Cost$25,000 $3,000 Variable Cost$8 \$12
1. Find the break-even quantity and the total cost at the break-even point. (4 points)
2. If the requirement is 4,500 units, is it more cost-effective for the firm to buy or make the components? What is the cost savings for choosing the cheaper option? (3 points)
3. If the requirement is 6,000 units, is it more cost-effective for the firm to buy or make the components? What is the cost savings for choosing the cheaper option? (3 points)