Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedI 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 3675

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions