can you plz show the excel formula and explain your answer and also i will have an example of the question

AN example

1 The buyer wants to place a third order for an additional 700 pieces, or a combined total order of 1500 2 units. 3 4 How much should the buyer expect to pay per unit given the expected benfit of the learning curve 5 (which affects direct-labor requirements)? 6 7 8 Order: 700 Labor Cost ($/hr): $ 10.00 9 Step 1: Calculate the average labor hours for the entire commbined order of 800 units. 10 First Order Labors Hours and Unit Cost 11 Units (less tl Total Labc Average l Learing Rate Total Cost ($) 200 $ 400 20.0% 800 20.0% 1600 20.0% 12 13 14 15 16 17 Step 2: Calcualte the additional total and per unit labor cost for the additional 600 unit order. 18 Items Cost ($) Notes 19 Material 20 Direct Labor Five hours on average per unit at $10 per hour 21 Overhead Assume 100% of direct labor 22 Total costs 23 Profit 20% of the total cost 24 Total per unit This is quoted price. 25