Ex 18-18 Name:
Enter the appropriate amount in the shaded cells in column C.
1)
Direct material
Direct labor
Machine time
Variable overhead
Administrative costs
Total
2) Full-cost criteria and max. allow. return price:
Relevant costs (above)
Fixed overhead
Subtotal
Allowable return
Bid price
Minimum bid price:
Ex 18-18 Name:
Enter the appropriate amount in the shaded cells in column C.
1)
Direct material 10.20$
Direct labor 1.63
2) Full-cost criteria and max. allow. return price:
Relevant costs (above) 25.03$
Fixed overhead 2.00
Minimum bid price:
SOLUTION
Prob 18-31 Name:
Enter the appropriate amount in the shaded cells in columns D and F.
1) Actual results:
Basic Complete Total
Sales
Less: Variable expense
Contribution margin
Number of units
Contribution margin per unit
Budgeted results:
Basic Complete Total
Sales
Less: Variable expense
Contribution margin
Number of units
Contribution margin per unit
Actual contribution margin
Budgeted contribution margin
Contribution margin variance
Enter the appropriate amount in the shaded cells in columns D, F, H, J, and L.
2) Budgeted
avg. CM
= [( + ) – ( + )] x
= U
Enter the appropriate amount in the shaded cells in columns D, F, H, J and L.
Use the pull-down list to select the appropriate variance in cells E44 and E50.
3) Actual Budgeted Budgeted Budgeted
units units unit CM avg. CM
Basic sales mix data = ( – ) x ( – )
=
Actual Budgeted Budgeted Budgeted
units units unit CM avg. CM
Complete sales mix data = ( – ) x ( – )
=
Sales mix variance:
+
#VALUE!
Contribution margin
volume variance
Actual units
Prob 18-31 Name:
Enter the appropriate amount in the shaded cells in columns D and F.
1) Actual results:
Basic Complete Total
Sales $280,000 $120,000 400,000$
Less: Variable expense 170,000 96,000 266,000
Budgeted results:
Basic Complete Total
Sales $282,750 $133,400 $416,150
Less: Variable expense 175,500 111,320 $286,820
2) Budgeted
avg. CM
= [( 2,000 +400 ) – ( 1,950 +460 )] x $53.66
3) Actual Budgeted Budgeted Budgeted
units units unit CM avg. CM
Basic sales mix data = ( 2,000 –1,950 ) x ( $55.00 –$53.66 )
Actual Budgeted Budgeted Budgeted
units units unit CM avg. CM
Complete sales mix data = ( 400 –460 ) x ( $48.00 –$53.66 )
Contribution margin
volume variance
Actual units
SOLUTION