Table 1 Order wiring hr/unit harnessing hr/unit Type M34 2300 3.00 Type A53 1600 3.40 3.00 Type R27 2400 2.40 0.90 3.40 Table 2 $ Cost to Make Cost to Buy Type M34 63.0 $ 67.0 $ Type A53 112.0 $ 104.0 $ Type R27 53.0 56.0 $ Tetrotec is the Canada's leading manufacturer of slip rings. A slip ring is an electrical coupling device that allows current to pass through a spinning or rotating connection. The company recently received a $500,000 order from TekTool for various quantities of three types of slip rings. Each slip ring requires a certain amount of time to wire and harness (see table 1 in Dataset_3). Unfortunately, Tetrotec doesn't have enough wiring and harnessing capacity to fill the order by its due date. The company has only 7400 hours or wiring capacity and 6000 hours of harnessing capacity available to devote to this order. However, the company can subcontract any portion of the order. You can find the unit costs of producing each model in-house and buying the finished products from a subcontractor in table 2 (Dataset_3). Please note, unless stated otherwise, each question is independent of one another. Assuming the production of fractions is possible (e.g. 6.77 Type R27). If you cannot answer the question due to insufficient data, enter 'NA'. Do not change the formatting of the yellow cells. Round to three digits after decimal, unless specified otherwise. 1) Determine the total cost of the order if Tetrotec decides to produce all types in-house (ignore the wiring and harnessing constraints). total cost 2) Determine the number of slip rings to make and the number to buy in order to fill the customer order at the lowest possible total cost. Round the unit quantity to the whole number. Type M34 Type A53 Type R27 quantity make buy total cost 3) Should Tetrotech accept the order from TekTool? accept? 4) Tetrotec received an offer from MOOG Corp. that needs 3170 units of 'M34' and 4970 units of 'R27' immediately. However, the client is only willing to pay $450000. What is the highest possible total profit for Tetrotec? Which offer should the Tetrotec accept? total profit $ (MOOG) recommendation End--- decline both accept MOOG accept TekTool