Using Excel. Please show all work in Excel (formulas) and do all parts (A-E). Thank you!

Q1 (100 points) Oz Inc. produces coffee tables in its plants in Raleigh and Houston that must be shipped to their distribution centers (DCs) in New Jersey and San Diego. The tables are distributed to the local retailers through these DCs. Oz Inc. uses a 3PL (Third Party Logistics) company to make the shipments. Suppose, through the 3PL, Oz Inc. can ship either directly to their DCs or through the DCs of the 3PL company located in Detroit and Salt Lake City. The monthly production capacity at the Raleigh and Houston plants are 4,600 and 6,500 units, respectively, and the demands at the New Jersey and San Diego retailers are forecasted at 5,600 and 3,500 units, respectively. The cost of shipping per unit is given in the following table: [ Identify the best shipping routes and cost by applying the a) (20 points) Least Stage Cost Heuristic (see lecture slides) b) (20 points) Total Landed Cost Heuristic (see lecture slides) c) (20 points) Linear Programming d) (20 points) How do the results from parts (a), (b) and (c) compare? e) (20 points) There is an alternate 3PL company indicating that they would provide the same pricing except for the Raleigh New Jersey shipment cost would be lower at $1.90 /unit but Houston to Detroit would be higher at $3.30 /unit. Which career would you choose? Why? How much cost would you be saving or adding if you would switch careers? (Base your answer on the LP Solution) Approach 3: Linear Programming (LP) - An LP is a Mathematical Model - A mathematical representation of reality for experimentation, analysis, and decision making purposes. - Reduces risks, costs, and sheds light into complex problems in fast mode. - An LP is an Optimization Model - We attempt to maximize or minimize an objective function given the system constraints. Step 1. Find the cheapest route from each plant to each customer Q1 (100 points) Oz Inc. produces coffee tables in its plants in Raleigh and Houston that must be shipped to their distribution centers (DCs) in New Jersey and San Diego. The tables are distributed to the local retailers through these DCs. Oz Inc. uses a 3PL (Third Party Logistics) company to make the shipments. Suppose, through the 3PL, Oz Inc. can ship either directly to their DCs or through the DCs of the 3PL company located in Detroit and Salt Lake City. The monthly production capacity at the Raleigh and Houston plants are 4,600 and 6,500 units, respectively, and the demands at the New Jersey and San Diego retailers are forecasted at 5,600 and 3,500 units, respectively. The cost of shipping per unit is given in the following table: [ Identify the best shipping routes and cost by applying the a) (20 points) Least Stage Cost Heuristic (see lecture slides) b) (20 points) Total Landed Cost Heuristic (see lecture slides) c) (20 points) Linear Programming d) (20 points) How do the results from parts (a), (b) and (c) compare? e) (20 points) There is an alternate 3PL company indicating that they would provide the same pricing except for the Raleigh New Jersey shipment cost would be lower at $1.90 /unit but Houston to Detroit would be higher at $3.30 /unit. Which career would you choose? Why? How much cost would you be saving or adding if you would switch careers? (Base your answer on the LP Solution) Approach 3: Linear Programming (LP) - An LP is a Mathematical Model - A mathematical representation of reality for experimentation, analysis, and decision making purposes. - Reduces risks, costs, and sheds light into complex problems in fast mode. - An LP is an Optimization Model - We attempt to maximize or minimize an objective function given the system constraints. Step 1. Find the cheapest route from each plant to each customer