Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please read the assignment and answer the blue cells with formulas Requirement 1 Direct materials: The first row of blue cells is simpy to put
please read the assignment and answer the blue cells with formulas
Requirement 1 Direct materials: The first row of blue cells is simpy to put your answer to multiplying the individual quantity and price $150,822 ###### $ 4.20 AQ AP AQ SP SQA SP Use the absolute value function in Excel when inputting this formula Use an "if" statement to determine "F" or "U" $150,822 U Price Var. (For U) Qty Var. (For U) $ 15,960 check figure Requirement 2 Direct labor: Actual Cost AH SR SHA SR Eff. Var. (For U) Rate Var. (For U) $ 7,320 check figure Requirement 3 Variable overhead: Actual Cost AH SR SHA SR Rate Var. (For U) Eff. Var (For U) $ 1,452 check figure Requirement 4 Fixed overhead: Actual Budgeted Std Allocated to Production SHASR Budget Var. (For U) Volume Var. (For U) $ 1,720 check figure $ Standard Data Actual Data 3.0 Direct materials (sq. feet per jacket) 2.70 Direct materials used (sq. feet per jacket) 4.00 Direct materials (cost per sq. foot) $ 4.20 Direct materials (cost per sq. foot) 2.0 Direct labor (hours per jacket) 24,400 Direct labor hours (total) 9.60 Direct labor cost per hour) $ 241,560 Direct labor cost (total) 2.0 Variable overhead (labor hrs applied per jacket $ 56,902 Fixed overhead cost 0.66 Variable overhead (cost applied per labor hr) $ 20,740 Variable overhead cost 2.0 Fixed overhead (labor hrs applied per jacket) 13,300 Jackets produced 2.30 Fixed overhead (cost applied per labor hour) 62,900 Total fixed overhead budgeted for the month $ $ $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