Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question about cost variances. Unfortunately, we haven't used Excel at all up until this point. The function and If formulas are throwing me more than

Question about cost variances. Unfortunately, we haven't used Excel at all up until this point. The function and If formulas are throwing me more than anything. Help!

image text in transcribed

image text in transcribed

image text in transcribed

Standards for one of Patterson, Inc.sproducts is shown below, along with actual cost data for the month s Direct materials: $2.75 per yard 4 Standard 2.4 yards $6.60 $2.7o per yard 5 Actual 3 yards $8.10 6 Direct labor: $18.00 per hour andard 0.6 hours 10.80 $22.00 per hour Actual 0.5 hours 11.00 ariable overhead 10 Standard 0.6 hours $7.00 per hour 4.20 $7.10 per hour 11 Actual 0.5 hours 3.55 13 Total cost per unit s21se $22.65 15 Excess of actual cost over standard cost per unit $1.05 16 17 Actual production for the month 13,500 units 18 variable overhead is assigned to products based on direct labor hours. There 19 was no beginning or ending inventory of materials for the month. 21 Using formulas, compute the following. Input all numbers as positive amounts. Indicate whether the variances are For U. write if statements for variance cells F30 to F47. Use cell 22 references (formulas) for cells DS3 -D60, Enter an F or U to indicate the correct variance in cells F54 tn Fi

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 Cost Accounting

Authors: Edward J. Vanderbeck

16th edition

9781133712701, 1133187862, 1133712703, 978-1133187868

More Books

Students also viewed these Accounting questions