Question

Annual manufacturing cost data (1000s) for four product lines are as follows:

Answer 1

Answer:

1st rank Line 3

2nd rank Line 1

3rd rank  Line 2

4th rank Line 4

Explanation:

Using a spreadsheet approach all of the costs information can be set in excel such that it starts with costs of direct materials followed by the cost of direct labor with summing up to be prime costs of production.

However,the total indirect is then apportioned to the product in proportion of the product's total direct costs(the prime costs) as done in the attached spreadsheet.

The manufacturing cost per unit is the total manufacturing costs divided by annual production in each case.

Find attached.

Download xlsx