Convert the accompanying database to an Excel table to find:

a$.$ The total cost of all orders.

b$.$ The total quantity of airframe fasteners purchased.

c$.$ The total cost of all orders placed with Manley Valve.

Click the icon to view the database.

Suppose that a manufacturer can produce a part for $$12\mathrm{.}00$ with a fixed cost of $$7,000.$ Alternately, the manufacturer could contract with a supplier in Asia to purchase the part at a

cost of $$15\mathrm{.}00,$ which includes transportation.

a$.$ If the anticipated production volume is $1,200$ units, compute the total cost of manufacturing and the total cost of outsourcing.

b$.$ What is the best decision?

a$.$ The total cost of manufacturing is $$$

$$