Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Help with calculations please The Utica Company produces engine parts for car manufacturers. A new accountant intern at Utica has accidentally deleted the company's variance
Help with calculations please
The Utica Company produces engine parts for car manufacturers. A new accountant intern at Utica has accidentally deleted the company's variance analysis calculations for the year ended December 31, 2020. The following table is what remains of the data. : (Click the icon to view the data.) Read the requirements. X u Data table Requirement 1. Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.) Begin with the flexible budget columns, then the sales volume variance column. Label each variance as favorable (F) or unfavorable (U). (For variances with a $0 balance, make sure t Static Actual Results 105,000 Flexible-Budget Variance Performance Report, Year Ended December 31, 2020 Actual Flexible-Budget Sales-Volume Results Variances Flexible Budget Variances 105,000 Flexible Sales-Volume Budget Variance 105,000 15,000 341,250 $ 48,750 210,000 30,000 Budget 90,000 Static Budget 90,000 Units sold F Units sold Revenues (sales) $ F $ F $ $ $ 672.000 $ 435,000 330,750 225,000 105,750 292,500 180.000 672,000 435,000 Revenues (sales) Variable costs Contribution margin 292,500 180,000 Variable costs Contribution margin U F 18,750 F 237,000 219,500 131,250 95,000 112,500 95,000 237,000 219,500 112,500 95,000 Fixed costs 124.500 U Fixed costs $ 17,500 $ 18,750 $ 36,250 $ 18,750 $ 17,500 $ 17,500 $ 17,500 U Operating income Operating income Calculate the total static-budget variance to verify your work is accurate. Determine the labels and then enter the amounts to calculate the static-budget variance. (For variances with a contribution margin.) Total flexible-budget variance Total sales-volume variance Total static-budget variance $ 18.750 U 18,750 F 0 = Print Done Requirement 2. What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit? (Round your answers to the nearest cent.) The actual selling price is $ 6.40 per unit. The budgeted selling price is $ 3.25 per unit The actual variable cost is $ 4.14 per unit. The budgeted variable cost is $ 2.00 per unit. Requirement 3. Review the variances you have calculated and discuss possible causes and potential problems. What is the important lesson learned here? Actual variable costs increased causing a(n) unfavorable flexible-budget variable cost variance. This variance could be a result of a(n) increase in direct material prices. (Round percentage to the nearest whole number.) Utica was able to pass most of the change in direct material prices on to its customers. Actual selling price by approximately 97 %, bringing about an offsetting flexible-budget revenue variance. increasedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started