Please answer it using ExcelPlease answer it using Excel

Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson Clty plant which can produce up to 50 tons per month and the Omaha plant which can produce up to 40 tons per month. NGC sells its candy to three different distributors, Des Moines (demand = 25 tons per month), Kansas City (demand = 15 tons per month), and St. Louis (demand = 10 tons per month). The costs of shipping between the respective plants is shown in the table to the left: What is the optimal shipping plan to minimize NGC's shipping costs? (Use solver and include a screeshot of the solver window) Suppose that the Jefferson City plant was required to run at capacity. How would you accommodate this change in Solver?(Again, include a screenshot of your solver window.) What would the optimal shipping plan be in this case? Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson Clty plant which can produce up to 50 tons per month and the Omaha plant which can produce up to 40 tons per month. NGC sells its candy to three different distributors, Des Moines (demand = 25 tons per month), Kansas City (demand = 15 tons per month), and St. Louis (demand = 10 tons per month). The costs of shipping between the respective plants is shown in the table to the left: What is the optimal shipping plan to minimize NGC's shipping costs? (Use solver and include a screeshot of the solver window) Suppose that the Jefferson City plant was required to run at capacity. How would you accommodate this change in Solver?(Again, include a screenshot of your solver window.) What would the optimal shipping plan be in this case