1. Create an excel spreadsheet for the following: Suppose a manufacturer can produce a part for $ 10.00 with a fixed cost of $ 5000.00. The Manufacturer can contract with supplier in Asia to purchase the part for $12.00, which includes transportation. Create a simple spreadsheet to answer the following (Create a Tab for each 1a, 1b, and 1c): a. If the anticipated production volume is 1,200 units, compute the total cost of manufacturing and the total cost of outsourcing. What is the best decision? b. Find the Break-even volume using a formula. C. Find the breakeven using Goal seek. Set as like the example below: 1 Outsourcing Decision Model Manufactured in-house Fixed cost Unit variable cost $50,000 $125 Purchased from supplier Unit coat $175 Production volume $175.000 $175.000 Total manufacturing cost Total purchased cost 19 Cost difference (Manufacture - Purchase) Best Decision 1. Create an excel spreadsheet for the following: Suppose a manufacturer can produce a part for $ 10.00 with a fixed cost of $ 5000.00. The Manufacturer can contract with supplier in Asia to purchase the part for $12.00, which includes transportation. Create a simple spreadsheet to answer the following (Create a Tab for each 1a, 1b, and 1c): a. If the anticipated production volume is 1,200 units, compute the total cost of manufacturing and the total cost of outsourcing. What is the best decision? b. Find the Break-even volume using a formula. C. Find the breakeven using Goal seek. Set as like the example below: 1 Outsourcing Decision Model Manufactured in-house Fixed cost Unit variable cost $50,000 $125 Purchased from supplier Unit coat $175 Production volume $175.000 $175.000 Total manufacturing cost Total purchased cost 19 Cost difference (Manufacture - Purchase) Best Decision