Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Principles Of Financial Auditing

Authors: Athmane Mokhbi

1st Edition

B09LGTJJFG, 979-8763532265

More Books

Students also viewed these Accounting questions

Question

Understanding Groups

Answered: 1 week ago