Complete the two problems in the attached file.

Both problems should be solved using Excel with Solver.

Be sure to show your Inputs in Solver when saving your file.

1. Emulsion Chemical Company has two facilities to produce an additive for three major customer facilities. The costs to transport the additive in 50 gallon barrels are listed in the table below. Supply and Demand quantities are the number of barrels per week. Customer 1 Customer 2 Customer 3 Supply Facility (sources) 1 $ 14 $ 8 $ 10 $ 10 $7 $ 5 30 20 2 Demand 25 15 10 Setup and solve the Emulsion Chemical Company problem in Excel with Solver-what is the optimal cost? 2. Tax Pros has established five teams to prepare the taxes for the businesses which have been long term clients of Tax Pros. Only four clients have submitted their tax documents and are ready to be assigned to a team. The following table contains the time estimates (in days) for completing similar business tax returns for each team. A B D Teams Clients 1 2 4 5 7 6 8 5 7 6 9 8 7 10 3 4 5 8 7 6 8 7 5 9 6 Which team should be assigned to each client and what is the optimal total time that will be required