PLEASE HELP!!!!

PLEASE NO handwritting - SPREADSHEET ONLY!!!

Will give thumbs up for correct and complete answer!!!

Goshford Company produces a single product and has capacity to produce 190,000 units per month. Costs to produce its current sales of 152,000 units follow. The regular selling price of the product is $138 per unit. Management is approached by a new customer who wants to purchase 38,000 units of the product for $79.20 per unit. If the order is accepted, there will be no additional fixed manufacturing overhead and no additional fixed selling and administrative expenses. The customer is not in the company's regular selling territory, so there will be a $5.80 per unit shipping expense in addition to the regular variable selling and administrative expenses. Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling and administrative expenses Fixed selling and administrative expenses Totals Per Unit $12.50 15.00 12.00 17.50 17.00 14.00 Costs at 152,000 Units $ 1,900,000 2,280,000 1,824,000 2,660,000 2,584,000 2,128,000 $ 13,376,000 $88.00 Calculate the combined total net income if the company accepts the offer to sell additional units at the reduced price of $79.20 per unit. Determine whether management should accept or reject the new business. Complete this question by entering your answers in the tabs below. Net Income Accept or Reject Calculate the combined total net income if the company accepts the offer to sell additional units at the reduced price of $79.20 per unit. Normal Volume Additional Volume Combined Total Costs and expenses: Total costs and expenses Net income (loss) Net Income Accept or Reject>