Complete the following questions using Excel and the Solver add-on. Upload the completed Excel file with formulas and parameters remaining in the tabs to Moodle. Linear Programming 1. A local bakery is trying to determine the optimal product mix for the current inventory of ingredients. The bakery produces muffins, two types of cakes, cookies, and bread. The profits for each baked good are $2.50 for 6 muffins, $3.50 for a chocolate cake, $3.00 for a vanilla cake, $2.00 for 12 cookies and $1.50 for a loaf of bread. Each baked good requires a combination of flour, milk, sugar, butter, and eggs. Current inventory shows that the bakery has 1200 cups of flour, 15 L of milk, 25 kg of sugar, 200 blocks of butter and 90 dozen eggs. To make a dozen muffins you require 2 cups of flour, 30 ml of milk, 40 grams of sugar, 2 blocks of butter, and 2 eggs. A chocolate cake requires 3 cups of flour, 50 ml of milk, 100 grams of sugar, and 3 eggs. A vanilla cake requires 3 cups of flour, 40 ml of milk, 80 grams of sugar, and 3 eggs. Two dozen cookies requires 3 cups of flour, 100 grams of sugar, 2 blocks of butter and 2 eggs. A loaf of bread requires 4 cups of flour, 25 ml of milk, half a block of butter and 2 eggs. The bakery also requires that the total number of cakes made is at least 200, the number of muffins be less than 800 and the loaves of bread be 100 or more. Find the optimal solution and ensure each quantity for each baked goods is a whole number.

Transportation 2. Samsung produces semiconductor chips in South Korea, China, and the United States. Products using these chips are sold around the world and therefore Samsung sells them on every continent. Below is the available supply and demand for all locations with the associated shipping costs.

Supply (in millions) Demand (in millions) South Korea - 2.5 North America - 2.1 Africa - 1.1 China - 3.5 South America - 1.4 Asia - 2.3 United States - 2.0 Europe - 1.2 Australia - 0.8 Shipping North America south America Europe Africa Asia Australia Costs

South Korea $12 $14 $9 $7 $3 $13

China N/a $15 $10 $8 $5 $16

united states $4 $6 $11 $17 N/A $18 Ongoing trade tensions between the United States and China have resulted in a ban on imports/exports. Additionally, the United States can only supply North America with 1.5 million and Australia requires at least 500,000 from South Korea. Using all this information, determine the optimal solution to the problem.