Question: Show work in excel please PC.62 Trek is a manufacturing company that produces high-end bicycles. Their prime road bike, the MadOne, can be fully customized

Show work in excel please PC.62 Trek is aShow work in excel please

PC.62 Trek is a manufacturing company that produces high-end bicycles. Their prime road bike, the MadOne, can be fully customized through a program called Project One. Last year they rolled out 1,870 bikes which sold on average for $6,700 and used the following inputs as found in the table below: Inputs Amount Cost ($) Labor Hours 12,300 $20.00 OCLV Carbon (square feet) 1,500 $10.15 Rubber (pounds) 3,075 $4.20 Paint (gallons) 430|| $27.19 Energy (kWh) 12,358,670 $0.14 What was last year's single-factor productivity for Trek in terms of rubber (not dollars)? (Display your answer to four decimal places.) Number What was last year's single-factor productivity for Trek in terms of OCLV Carbon (input and output units, not dollars)? (Display your answer to four decimal places.) Number What was last year's multi-factor productivity for Trek in terms of dollars? (In other words, how many dollars of revenue were generated for each dollar of input? Display your answer to two decimal places.) Number Suppose in the coming year they expect their multi-factor productivity to increase by 8% over last year (what you just computed). What should be their multi- factor productivity in the coming year? (Display your answer to two decimal places.) Number

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!