Variances Practice Problems Attached Files: Variances Practice Problems.xlsx (21.739 KB) Overview: This activity will help you to prepare for your case analysis in this module. Instructions: 1. The attached Excel file contains practice problems for variance analysis. 2. Please complete the questions at the bottom of the Excel file. 3. Please show all work and place your responses on the Excel worksheet. 4. Submit your completed Excel file to this assignment link. A B C D E F G H Steel Dynamo Inc. produces precast metal bars for industrial use. The general manager of the plant has just reviewed the contribution format income statement for September. The statement is shown below: Sales (5,000 bars) Budgeted $ 250,000 Actual $ 250,000 Variable expenses: Variable cost of goods sold 80,000 96,660 Variable selling expenses Total variable expenses Contribution margin Fixed expenses: Manufacturing overhead 20,000 20,000 100,000 116,660 150,000 133,340 60,000 60,000 Selling and administrative Total fixed expenses Net operating income (loss) 75,000 75,000 135,000 135,000 $ 15,000 $ (1,660) *Contains direct materials, direct labor, and variable manufacturing overhead The general manager was shocked to see the loss for the month, especially since sales were exactly as budgeted. He met with the accounting manager to obtain information from the standard cost system. He reviewed the following standard variable cost per metal bar. Standard Quantity or Hours Standard Price or Rate Standar d Cost Direct materials 4.0 pounds Direct labor 0.6 hours $2.50 /pound $9.00 /hr $10.00 $5.40 Variable manufacturing overhead 0.3 hours* $2.00 /hr $0.60 Total standard variable cost $16.00 *Based on machine-hours During September, the plant produced 5,000 bars and incurred the following costs: a. Purchased 24,000 pounds of materials at a cost of $2.95 per pound. There were no raw materials in inventory at the beginning of the month. b. Used 20,800 pounds of materials in production (Finished goods and work-in-process inventories are insignificant and can be ignored.) c. Worked 3,500 direct labor-hours at a cost of $8.80 per hour. d. Incurred a total variable manufacturing overhead cost of $4,500 for the month. A total of 1,900 machine- hours was recorded. It is the company's policy to close all variances to cost of goods sold on a monthly basis. 1. Compute the following variances for September. a. Direct materials price and quantity variances b. Direct labor rate and efficiency variance. c. Variable overhead rate and efficiency variances. 2. Summarize the variances computed in question 1 by showing the net overall favorable or unfavorable variance for September. 3. Pick out the two most significant variances that you computed in question 1. Explain possible causes of these variances. J K