Help ASAP !

SPREADSHEET PROBLEM (Use Excel )

a. Create a spreadsheet that calculates throughput for the following combinations:

Productive capacity = 1,000 units per hour

Productive processing time ranges from 90% to 98% increasing in increments of 2%

Yield ranges from 91% to 99% increasing in increments of 2%

Costs of productive processing time:

• 90%=$100
• 92%=$150
• 94%=$250
• 96%=$400
• 98%=$600

Costs of yield rates:

• 91%=$10
• 93%=$20
• 95%=$35
• 97%=$60
• 99%=$100

b. Include a formula that displays in a labeled cell the maximum throughput.

c. Create a cell range that displays the total costs for the various combinations of yield and productive processing time.

d. Below the cell range created in step 3, write a statement explaining whether the company should focus on changing productive processing time or yield to minimize total costs for the same amount of throughput.