Please kindly show work with formulas on excel. thank you
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 65 field workers (each working 40 hours per week at a wage of $12/bc) and 18 line workers (each working 40 hours per week at a wage of $22/0). The business has capital expenses of $17,500 per week and produces 325,000 tons of rice per week. 1. Calculate the Total Input Cost for Old and New systems (Labor cost + capital expense) (2 pts) 2. Calculate the Capital Expenditure and Output of the new system (2 pts) 3. Calculate labor productivity including all employees (line workers & field workers) for the old and new systems, in tons of output per dollar of input. (4pts) 4. Calculate the multifactor productivity (including line workers, field workers, and capital expenses) for the old and new systems, in tons of output per dollar of input. (4pts) 5. Calculate the percentage changes in labor and multifactor productivity. (3pts) Recently, the company decided to invest on additional equipment which increased the capital expenses by 8%. Also, the number of field workers was cut short by 20% whereas line workers more recruited. Both field and line workers were given a raise of 10% and 8%, respectively. Due to the above-mentioned changes, the new system reported to have a 8% more output than the old system. You will need the following formulas: [Weekly output] Labor productivity = [Weekly total labor cost] Multifactor productivity [Weekly output) Weekly total labor cost-Weekly capital expenses] After copying the table below into Excel, solve the following questions and fill the table OLD SYSTEM 65 40 12 NEW CHANGE SYSTEM | -0.20 I ? 0.10 ? 0.05 22 0.08 Number of Field workers Hours Wages Total cost for field workers Number of Line workers Hours Wages Total cost for line workers TOTAL LABOR COST Capital expenditure Output LABOR PRODUCTIVITY MULTIFACTOR PRODUCTIVITY % CHANGE FOR LABOR PRODUCTIVITY % CHANGE FOR MULTIFACTOR PRODUCTIVITY 17500 325000 0.081 0.08 ? ? I ? ? 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 65 field workers (each working 40 hours per week at a wage of $12/bc) and 18 line workers (each working 40 hours per week at a wage of $22/0). The business has capital expenses of $17,500 per week and produces 325,000 tons of rice per week. 1. Calculate the Total Input Cost for Old and New systems (Labor cost + capital expense) (2 pts) 2. Calculate the Capital Expenditure and Output of the new system (2 pts) 3. Calculate labor productivity including all employees (line workers & field workers) for the old and new systems, in tons of output per dollar of input. (4pts) 4. Calculate the multifactor productivity (including line workers, field workers, and capital expenses) for the old and new systems, in tons of output per dollar of input. (4pts) 5. Calculate the percentage changes in labor and multifactor productivity. (3pts) Recently, the company decided to invest on additional equipment which increased the capital expenses by 8%. Also, the number of field workers was cut short by 20% whereas line workers more recruited. Both field and line workers were given a raise of 10% and 8%, respectively. Due to the above-mentioned changes, the new system reported to have a 8% more output than the old system. You will need the following formulas: [Weekly output] Labor productivity = [Weekly total labor cost] Multifactor productivity [Weekly output) Weekly total labor cost-Weekly capital expenses] After copying the table below into Excel, solve the following questions and fill the table OLD SYSTEM 65 40 12 NEW CHANGE SYSTEM | -0.20 I ? 0.10 ? 0.05 22 0.08 Number of Field workers Hours Wages Total cost for field workers Number of Line workers Hours Wages Total cost for line workers TOTAL LABOR COST Capital expenditure Output LABOR PRODUCTIVITY MULTIFACTOR PRODUCTIVITY % CHANGE FOR LABOR PRODUCTIVITY % CHANGE FOR MULTIFACTOR PRODUCTIVITY 17500 325000 0.081 0.08
