10_problems.xlsx

Requirements

Joy of Baking produces and sells a new Tie Dye cake mix. The mix sells for $28 per package, each of which contains individual packages to prepare 5 cakes.
Standard unit cost for this product are as follows: ingredients, 6 oz. at $1.00 per ounce; packaging $1.20; direct labor, .8 hours at $14.00 per hour;
standard variable overhead, $4.00 per direct labor hour; and standard fixed overhead, $6.40 per direct labor hour. Normal capacity for this product
is 46,875 units per week. During the first week of the quarter the company produced 50,000 packages but used materials for 50,200 packages costing $60,240.
It also used 305,000 ounces of ingredients costing $292,800. The total cost of direct labor for the week was $579,600; direct labor hours totaled 40,250.
Total variable overhead was $161,100 , and total fixed overhead was $242,000. Budgeted fixed overhead for the week was $240,000.
On the following tabs:
1 Prepare a standard cost card for the Tie Dye Cake Mix
2 Compute the direct materials price and quantity variances,
Direct labor price and quantity variances,
Variable overhead spending and efficiency variances,
and the fixed overhead budget and volume variances.
3 Prepare a performance report based on your variance analysis, and suggest possible causes for each significant variance.

Std. Cost Card

Standard Cost Card Tie Dye Cake Mix
Direct Materials
Component Quantity Unit Cost Total Cost
Ingredients
Package
Total
Direct Labor
Quantity Unit Cost Total Cost
Direct Labor
Total
Manufacturing Overhead
VOH ($4 per DLH)
FOH ($6.40 per DLH)
Total
Total Std. Cost per Unit

Materials Variances

Labor Variances

OH Variances

Performance Report

Joy of Baking Inc.
Production Performance and Cost Variance Report
Product: Tie Dye Cake Mix
First week of quarter
Productivity Summary:
Normal Capacity Units
Good units produced Units
Cost and Variance Analysis:
Standard Actual Cost Total Variance Breakdown
Cost Incurred Variance Amount Type
Direct Materials:
Ingredients
Packages
Direct Labor
Variavle OH
Fixed OH
Totals

Variance explanation