Question: Please answer in Excel format showing formulas in the cells. Please do not round up. Please show all math in the excel cell. 3. NIA

  • Please answer in Excel format showing formulas in the cells.
  • Please do not round up.
  • Please show all math in the excel cell.

Please answer in Excel format showing formulas in

3. NIA Motor is an e-scooter manufacturer that employs ten people at $15 per hour. Assume you were tasked to track productivity performance measures using the data shown in the following table: 2018 Results Financial Information Net sales Current assets Net income after taxes Current liabilities Cost of goods sold (purchased items) Avg. inventory value Inputs and Outputs Scooters produced Labor hours Lease payments $400,000 $108,000 $88,200 $44,000 $50,000 $16,000 4,000 9,600 $40,000 a. Calculate the labor productivity, lease productivity, and material productivity. b. Calculate the multiple-factor productivity. If the multiple factor productivity for 2017 was 0.008 scooter/dollar, then what was the productivity growth from 2017 to 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!