Please show the calculation. The table below has date related to the performance
ID: 411060 • Letter: P
Question
Please show the calculation.
The table below has date related to the performance of 3 workers. Based on that date answer the following 4 questions Performance Data Units Produced Material Cost per unit Avg Sales Value of Units Hours Worked Hourly Wage 1. What is the production rate (in units) for each employee? 2. What is the production rate (in dollars) for each employee? 3. What is each employees ROl for Material? 4. How much money does each employee make for the company for each dollar they are paid? Brad 1200 $9.50 30.00 42 $16 Gre 925 $12.00 $36.00 40 $17 Wend 1250 8.25 $25.00 43 $15Explanation / Answer
Production rate for each employee = Units produced / Number of hours worked
Thus,
Production rate for Brad = 1200 / 42 = 28.57 units / hour
Production rate for Wendy = 1250 / 43 = 29.07 units / hour
Production rate for Greg = 925/40 = 23.12 units/ hour
Thus ,
Production rate ( in Dollars ) for Brad = 1200 x 30/42 = $ 857.14 / hour
Production rate ( in Dollars ) for Wendy = 1250 x 25/ 43 = $726.74/ hour
Production rate ( in Dollars ) for Greg = 925 x 36 / 40 = $832.5 / hour
Return = Average sales value / unit – Material cost / unit
Thus ROI for material = Return/ Material cost x 100
ROI for Brad = ( 30 – 9.5) / 9,5 x 100 = 215.79 %
ROI for Wendy = ( 25 – 8.25) / 8.25 x 100 = 203.03%
ROI for Greg = ( 36 – 12 ) / 12 x 100 = 200%
Total earned by each employee = Hours worked x Hourly wage
Thus, Money each employee make for the company for each dollar they are paid = Total return / Total earned by each employee
Money Brad makes for company for each Dollar paid
= 1200 x ( 30 – 9.5) / ( 42 x 16 )
= 1200 x 20.5/ ( 42 x 16)
= $36.60
Money Wendy makes for company for each Dollar paid
= 1250 x ( 25 – 8.25)/ ( 43 x 15 )
= 1250 x 16.75 / ( 43 x 15 )
= $32.46
Money Greg makes for company for each Dollar paid
= 925 x ( 36 – 12 ) / ( 40 x 17 )
= 925 x 24 / ( 40 x 17 )
= $ 32.65