Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
Target gross profit percentage
Total cost of production percentage
Total sales
Total cost of production percentage ×
Target cost of production
Total Cost of Production = Cost of Procedure 1 (P1) + Cost of Procedure 2 (P2)
Total cost of Procedure 1 is twice that of Procedure 2:
P1 = 2(P2)
Substitute for P1 in the formula:
= 2(P2) + P2
= 3(P2)
= P2
P1 = 2(P2) = ( 2 × ) =
Cost makeup of Procedure 1:
Percentage Amount
Labor
Materials
Overhead
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Cost makeup of Procedure 2:
Percentage Amount
Labor
Materials
Overhead
Materials cost of Procedure 1
Percentage
Materials cost = of P1, so P1 total cost =
Procedure 1 cost twice as much as Procedure 2, so P2 total cost =
Cost makeup of Procedure 1:
Percentage Amount
Labor
Materials
Overhead
Cost makeup of Procedure 2:
Percentage Amount
Labor
Materials
Overhead
Current total cost of production (P1 + P2)
Less target total cost of production
P2 materials cost savings needed
Current P2 overhead materials cost (60% of total overhead)
Less P2 overhead materials cost savings needed
Maximum new cost of P2 overhead materials
An asterisk (*) will appear to the right of an incorrect entry.
Total Cost of Production = Cost of Procedure 1 (P1) + Cost of Procedure 2 (P2)
Total cost of Procedure 1 is twice that of Procedure 2:
P1 = 2(P2)
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Cost makeup of Procedure 2: