Unlock access to all the studying documents.
View Full Document
Enter the appropriate amounts in the shaded cells in columns C, F, H, L, and N.
1) Profile:
/
Base Year
Materials / =
Labor / =
Current Year
Materials / =
Labor / =
2)
Base Year Current Year
Sales
Materials
Labor
3) Input x P PQ x P AQ x P AQ x P Change
(output / unit price)
Enter the appropriate amounts in the shaded cells in columns C, F, H, L, and N.
1) Profile:
/
Base Year
Materials / = 0.750
Labor / = 3.000
2)
Base Year Current Year
Sales $13,500,000 $16,200,000
Materials 6,000,000 6,480,000
3) Input x P PQ x P AQ x P AQ x P Change
(output / unit price)
( 1,080,000 / 0.750 ) x $6 = 8,640,000$ 1,080,000 x $6 = 6,480,000$ 2,160,000$
1,080,000
540,000