Question: Q2 please use Excel file and formula for these it a mexe ofist wien st siohtip: [4isy deftir an inout, jathe Question Set 2. For

it a mexe ofist wien st siohtip: [4isy deftir an inout, jathe Question Set 2. For this question set, you will calculate labor productivity and multifactor productivity, both in tons of rice produced per dollar value of inputs. A Rice Manufacturer employs 50 field workers (each working 40 hours per week at a wase of $12/hr ) and 25 line workers (each working 20 hours per week at a wage of $10/hr ). The business has capital expenses of $20,000 per week and produces 345,000 tons of rice per week. Recently, the company decided to invest on additional equipment which increased the capital expenses by 10\%. Also, the number of flield workers was cut short by 10% whereas line workers were 10% more recruited. Both were given a ralse of 6%6 and 8%5, respectively. Due to the above-mentioned changes, the new system reported to have an 7 . more output than the old system. You will need the following formulas: Laborproductivity=[Weektytotallaborcost]][Weeklyoutput]Multifactorproductivity=[Weeklytotallaborcost+Weeklycapitalexpensed]][Weeklyoutput] Leyout Relerences Mallings Priview View Hele After copying the tible below into Excel, sohve the following questions and fill the table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
