A buyer has placed an order with a supplier for $50$ pieces of a new item at a per$-$

unit price of $$180$ and has accumulated the following cost data:

The buyer now wants to place an order for an additional $350$ pieces. Create an EXCEL

spreadsheet that can provide answers to the following questions:

a$.$ What is the average labor hours for the entire combined order of $400$

pieces assuming a $90\%$ learning curve $(10$ pts$)$

b$.$ Calculate the hours required for the total combined order $400$ units $(10$

pts$)$

c$.$ For the new order of $350$ pieces calculate $(20$ pts$)$

i$.$ The labor hours required to complete this order

ii$.$ The total labor cost

iii. The per unit labor cost

iv$.$ The expected per unit price