Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with the actual excel formula input. Thank You. - Basic variance analysis for direct materials, direct labor and variable overhead - Excel ?

Need help with the actual excel formula input. Thank You. image text in transcribed
image text in transcribed
- Basic variance analysis for direct materials, direct labor and variable overhead - Excel ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME Sign In X Be Calibri 11 % Paste BIU.23 Alignment Number C Calls Conditional Format as Formatting Table Styles - Styles Clipboard Font 13 1 B29 A B D E F 2 3 4 Direct materials: 5 Direct labor: 6 Variable overhead (based on labor hours): Standard Quantity 2.5 yards @ 0.5 hours @ 0.5 hours @ Standard Price/Rate $8.00 per yard $18.00 per hour $10.00 per hour Standard Unit Cost $20.00 9.00 5.00 7 14,000 units 13.500 units 10 8 Budgeted production for the month 9 Actual production for the month 1. Actual Costs incurred to Produce 13,500 units: 12 Direct Materials Purchased and Used 13 Direct Labor Paid 14 Variable Overhead Incurred 35,100 yards 7.425 hours 7.425 hours @ $7.00 per yard $17.50 per hour S12.00 per hour Total Actual Cost $245.700 $129,938 $89.100 15 Complete the following table comparing actual costs to the fexible budget and master budget. Use 16 formulas for the spending and volume variances so that variance will appear as a negative number if unfavorable and a positive number favorable. 17 18 Spending Hexiblo Volume Master Actual Costs Variances Budget Variances Budget 19 Direct materials: S245.700 $24.300 $270,000 $10.000 $280,000 20 Direct labor SI 29.01 SUN S121.500 54500 $126.000 Baslo variance analysis for direct materials, direct labor and variable overhead - Excel x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 AA De Paste BT % Alignment Number Conditional Formatas Cell Formatting Table Styles Cells Clipboard Font Styles B29 X B F Master Budget $280,000 $126,000 $70,000 A D E 18 Spending Flexible Volume Actual Costs Variances Budget Variances 19 Direct materials: $245,700 $24,300 $270.000 $10,000 20 Direct labor: $129,938 (58.438) $121,500 $4.500 21 Variable overhead: $89,100 ($21.600) $67,500 $2.500 22 23 24 Using the formulas provided, compute the following variances 25 Write if statements to enter an For U to indicate whether the variance is favorable or unfavorable. 26 27 Direct materials: Variance For U 28 Price Variance = AQ* (SP-AP) $35.100 29 Quantity Variance - SP (SQ-AQ) 30 Total Spending Variance 31 Direct Labor 32 Rate Variance - AH (SR - AR) 33 Efficiency Variance = SR (SH - AH) 34 Total Spending Variance 35 Variable Overhead 36 Rate Variance - AH (SR - AR) 37 Efficiency Variance = SR (SH - AH) 38 Total Spending Variance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Consolidated Financial Reporting

Authors: Paul Taylor

1st Edition

1853962503, 9781853962509

More Books

Students also viewed these Accounting questions