Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on Lab 2-1 Excel Variances and Conditional Formatting, using the Exhibit below, answer the following question. Calculation of Direct Materials and Direct Labor Variance
Based on Lab 2-1 Excel Variances and Conditional Formatting, using the Exhibit below, answer the following question. Calculation of Direct Materials and Direct Labor Variance Direct Materials Variance Q 8 Sun Jun 16 Finish up Actual Quantity (AQ) Actual Price (AP) Actual Cost (AQ * AP) Actual Cost Actual Quantity @ Actual Price 490,120 0.24 $117,628.80 Actual Quantity @ Standard Price Actual Quantity (AQ' Standard Price (SP) Actual Quantity@ Standard Price (AQ * SP) 490,120 0.25 $122,530.00 Standard Cost Standard Quantity @ Standard Price Standard Quantity (SQ) Standard Price (SP) Standard Cost (SQ * SP) 480,120 0.25 5120,030.00 Check Total Direct Materials Variance $2,401.20 $2,401.20 Materials Price Variance 54.901.21 The green color in the variance analysis represents a favorable or unfavorable variance? Favorable Variance Unfavorable Variance The variance cannot be determined
Step 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