In: Accounting
Flexible Budgeting and Variance Analysis
I Love My Chocolate Company makes dark chocolate and light chocolate. Both products require cocoa and sugar. The following planning information has been made available:
Standard Amount per Case | ||||||
Dark Chocolate | Light Chocolate | Standard Price per Pound | ||||
Cocoa | 9 lbs. | 6 lbs. | $5.40 | |||
Sugar | 7 lbs. | 11 lbs. | 0.60 | |||
Standard labor time | 0.4 hr. | 0.5 hr. |
Dark Chocolate | Light Chocolate | |||
Planned production | 5,300 cases | 11,800 cases | ||
Standard labor rate | $14.00 per hr. | $14.00 per hr. |
I Love My Chocolate Company does not expect there to be any beginning or ending inventories of cocoa or sugar. At the end of the budget year, I Love My Chocolate Company had the following actual results:
Dark Chocolate | Light Chocolate | |||
Actual production (cases) | 5,000 | 12,300 | ||
Actual Price per Pound | Actual Pounds Purchased and Used | |||
Cocoa | $5.50 | 119,400 | ||
Sugar | 0.55 | 166,000 | ||
Actual Labor Rate | Actual Labor Hours Used | |||
Dark chocolate | $13.60 per hr. | 1,820 | ||
Light chocolate | 14.40 per hr. | 6,300 |
Required:
1. Prepare the following variance analyses for both chocolates and the total, based on the actual results and production levels at the end of the budget year:
a. Direct materials price variance, direct materials quantity variance, and total variance.
b. Direct labor rate variance, direct labor time variance, and total variance.
Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
a. | Direct materials price variance | $ | |
Direct materials quantity variance | $ | ||
Total direct materials cost variance | $ | ||
b. | Direct labor rate variance | $ | |
Direct labor time variance | $ | ||
Total direct labor cost variance | $ |
ACCT 101B - CH 23 EXAMPLE 2
Direct Material Price Variance | |||
Cocoa | Sugar | Total | |
Actual Price | $ 5.500 | $ 0.55 | |
Standard Price | $ 5.40 | $ 0.60 | |
Difference | $ 0.100 | $ -0.05 | |
Actual Quantity (Units) | 119400 | 166000 | |
Direct Material Price Variance | $ 11,940.00 | $ -8,300.00 | $ 3,640.00 |
Unfavorable | Favorable | Unfavorable | |
Dark | Light | Total Standard Quantity | |
Cocoa | 45000 | 73800 | 118800 |
Sugar | 35000 | 135300 | 170300 |
Direct Material Qunatity Variance | |||
Cocoa | Sugar | Total | |
Actual Quantity | 119400 | 166000 | |
Standard Quantity | 118800 | 170300 | |
Difference | 600 | -4300 | |
Standard Price | $ 5.40 | $ 0.60 | |
Direct Material Qunatity Variance | $ 3,240.00 | $ -2,580.00 | $ 660.00 |
Unfavorable | Favorable | Unfavorable | |
Direct Labor Rate Variance | |||
Dark | Light | Total | |
Actual Rate | $ 13.60 | $ 14.40 | |
Standard Rate | $ 14.00 | $ 14.00 | |
Difference | $ -0.40 | $ 0.40 | |
Actual Hours | 1820 | 6300 | |
Direct Labor Rate Variance | $ -728.00 | $ 2,520.00 | $ 1,792.00 |
Favorable | Unfavorable | Unfavorable | |
Direct Labor Time Variance | |||
Dark | Light | Total | |
Actual Hours | 1820 | 6300 | |
Standard Hours | 2000 | 6150 | |
Difference | -180 | 150 | |
Standard Rate | $ 14.00 | $ 14.00 | |
Direct Labor Time Variance | $ -2,520.00 | $ 2,100.00 | $ -420.00 |
Favorable | Unfavorable | Favorable |
a. | Direct materials price variance | $ 3,640.00 | U |
Direct materials quantity variance | $ 660.00 | U | |
Total direct materials cost variance | $ 4,300.00 | U | |
b. | Direct labor rate variance | $ 1,792.00 | U |
Direct labor time variance | $ -420.00 | F | |
Total direct labor cost variance | $ 1,372.00 | U |