Question: Excel formulas are needed. Also some instruction on how the calculation are arrived. Thank you Flexible Budgets, Direct-Cost Variances, and Management Control Flexible budget, working

Excel formulas are needed. Also some instruction on how the calculation arearrived. Thank you Flexible Budgets, Direct-Cost Variances, and Management Control Flexible budget,Excel formulas are needed. Also some instruction on how the calculation are arrived. Thank you

Flexible Budgets, Direct-Cost Variances, and Management Control Flexible budget, working backward The Clarkson Company produces engine parts for car manufacturers. A new accountant intern at Clarkson has accidentally deleted the company's variance analysis calculations for the year ended December 31, 2017. The partial table of what remains of the data has been provided on the ENTERANSWERS tab. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Requirements 1 Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $O.) a. Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be subtracted b. Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances c. For variances with a zero amount, make sure to enter the result of "-0" in the appropriate cell and leave the drop- down to identify the variance as either F or U blank. 2 What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit? 1. Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.) (Always use cell references and formulas where appropriate to receive full credit.) Actual Results Flexible-BudgetFlexible Budget Sales-Volume Static Budget Variance Variances Units sold Revenues Variable costs Contribution margin Fixed costs Operating income 130,000 $715,000 515,000 $200,000 140,000 60,000 120,000 $420,000 240,000 $180,000 120,000 60,000 2. What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit? (Always use cell references and formulas where appropriate to receive full credit.) Actual selling price Budgeted selling price Actual variable cost per unit Budgeted variable cost per unit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!