Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
can I get Excell formulas as well please and thank you ! PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need
can I get Excell formulas as well please and thank you !
PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View J17 VX fx A B C D E F 1 Problem 4: Computing Direct Materials and Direct Labour Variances 2. Relevant Form 3 Essential Suppliers Inc, manufactures Custom shelves in a small manufacturing facilitiy. DM Price Variai 4 The shelves are made from recycled wood. Essential Suppliers has 50 employees. 5 Each employee presently provides 37.5 hours of labor per week. DM Quantity Va 6 Information about a production week is as follows: Total DM Cost 7 DL Rate Varian 8 Standard wage rate per hour $18.00 9 Standard labor time per unit of shelf 48 minutes DL Time Varian 10 Standard number of yards of wood per unit of shelf 2.5 yards Total DL Cost v 11 Standard price per yard of wood $7.00 12 Actual price per yard of wood $7.50 13 Actual yards of wood used during the week 6,900 yards 14 Number of units of shelves produced during the week 3,000 units 15 Actual wage rate per hour $19.00 16 Actual hours for the week (50 employees x 37.5 hours) 1875 hours 17 18 Required: 19 20 A. Determine the followings Material Variances and indicate if they are "favorable" or "unfavor 21 Use Excel formula or show your working clearly to obtain partial marking 22 23 Direct Materials Price Variance: 24 25 26 Direct Materials Quantity Variance 27 28 29 Total Direct Materials Cost Variance 30 31 32 B. Determine the followings Labor Variances and indicate if they are "favorable" or "unfavorab 33 34 Direct Labor Rate Variance: 35 36 37 Direct Labor Time Variance: 38 39 40 Total Direct Labor Cost Variance 41 42 43 E F G H K M IN O P Relevant Formulae DM Price Variance = (Actual Price - Standard Price) x Actual Quantity for Actual production DM Quantity Variance= (Actual Quantity - Standard Quantity) for Actual Production x Standard Price Total DM Cost Variance = DM Price variance + DM Quantity variance DL Rate Variance = (Actual Rate - Standard Rate) x Actual Hours for Actual Production DL Time Variance = (Actual Hours - Standard Hours) for Actual Production x Standard Rate Total DL Cost Variance = DL Rate Variance + DL Time Variance +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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