Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to know the formulas so I can but them on excel myself Problem I: The weekly output of a production process is shown
I need to know the formulas so I can but them on excel myself
Problem I: The weekly output of a production process is shown below together with data for labor and material inputs. The standard value of the output is S24 per unit. Assume a 40 hour- week and an hourly wage rate of S18.50. Material cost is $48 per unit. Overhead is charged according to one of the following equations. (a) Equation A: Overhead S1,000 plus 0.88 times the total labor cost; (b) Equation B: Overhead S8,500 plus 0.25 times the total material cost and (c) Equation C: Overhead S2,700 plus 0.46 times the total of labor and material costs. Calculate a. Labor productivity per week, b. Material productivity per week, c. Multi-factor productivity per week using overhead A, d. Multi-factor productivity per week using overhead B, c. Multi-factor productivity per week using overhead C, f. What is your conclusion with respect to labor productivity? g. What is your conclusion with respect to material productivity? h. What is your conclusion with respect to multi-factor productivity (option A)? i. What is your conclusion with respect to multi-factor productivity (option B)? j. What is your conclusion with respect to multi-factor productivity (option C)? Value of Output Work Week (hours) 24.00 Hourly Wage 18.50 Material Cost48.00 Norfolk State University-An Egual Opportunity Employer Output #of Material Week (units Workers (units) 4500 3150 4950 5100 5250 19 3255 213360 22 3465 18 19 3675Step 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