CBUS 364 - Purchasing and Supply Management Homework .Chapters 12 - 25 points 1) 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: Material Direct labor Overhead Total costs Profit (20%) Total per unit $70 S 32 4 hours at $8 per hour) $ 32,.(100% of direct labor) $134 $.2680 (20% of total costs) $160.80 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 What is the pieces assuming a 90% learning curve (3.pts) Calculate the hours required for the total combined order 400 units (2 pts) For the new order of 350 pieces calculate (20 pts) average labor hours for the entire combined order of 400 a. b. c. i. The labor hours required to complete this order ii. The total labor cost ili. The per unit labor cost iv. The expected per unit price Highlight the answers in your workbooks