60.1K

Verified Solution

Link Copied!

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 firms 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)

Answer & Explanation Solved by verified expert

See Answer