Question: 1. How many pounds to produce for next week? 2. What is the total profit? Question 2 - Transportation Scheduling Manager: What should you do to minimize the total shipping cost? Pet Food Ine, is a Canadian pet food manufacturer, it has maltiple warehouse locations in Ontario and serves several retail stores. You are the transportation manager and you are responsible for schedaling the delivery for tomorrow. Table 3 summarizes the unit shipping cost from each of the warchouses to esch of the retail stores: (Note: If a cost is missing in the table, the corresponding route is not avanabie) The total supply and demand for tomorrow's delivery are listed below in Tables 4 \& 5. Table 4: Total Supply for euch warehouse (in pucks) Table S: Total demand for each retailer (in packs) There are several special requirements that you must satisfy: - At least 30% of the shipments from Warchouse I must be delivered to Retailer 2 . - Retailer 1 should receive no more than 20% of the shipping from Warchouse 3. Questions: 1. Draw the L.P network diagram for this transportation schedule. Set up an LP model for this and use Solver to solve the problem. 2. What is the total shipping cost? Overview \& Instruction In this assignment, you have TWO main questions. Please submit an Excel file. Please include the mathematical LP model, the Excel setup, the SOLVER solution, and a proper conclusion for cach question. Question 1-Bakery Owner: What should you do to maximize the total profit? You are the owner of "Sunrise Sweets", a small artisanal bakery located in Vaughan. Sunrise Sweets specializes in producing four different types of cookies: Chocolate Chip Cookies (C), Brownie Cookies (B), Red Velvet Cookies (R), and Oatmeal Dark Chocolate Cookies ( O ). The bakery, passionate about providing high-quality treats, faces challenges due to fluctuating ingredient costs and increased compctition from neighbouring bakeries. To meet the growing demand for their cookies, the bakery must produce at least 800 pounds of Chocolate Chip Cookies (C), between 500 to 600 pounds of Brownie Cookies (B), at least 180 pounds of Red Velvet Cookies (R), and at least 250 pounds of Oatmeal Dark Chocolate Cookies (O) for the upcoming week. The ingredients used in each pack of cookies consist of different proportions: Each pound of Chocolate Chip Cookies (C), Brownie Cookies (B), Red Velvet Cookies (R), and Oatmeal Dark Chocolate Cookies (O) contains respectively 70%,50%,50%, and 30% of flour. Each pound of Chocolate Chip Cookies (C). Brownie Cookies (B), Red Velvet Cookies (R), and Oatmeal Dark Chocolate Cookies (O) contains respectively 25%,40%,30%, and 40% of chocolate. The remaining weight in each pack is made up of other baking ingredients. The bakery has 1300 pounds of flour and 1100 pounds of chocolate available for use in the next week. Additionally, they have 60 hours of production time available on each of the following machines: Mixing machine, Baking machine, Coating machine, and Packaging machine. The time required (in hours) for each pound of cookies on each machine is summarized in the following table: Table 1: Unit usage of each machine (in minutes) to produce products (per pound). The selling price and variable costs associated with each pound of product are summarized in the table below: Iable 2: Revenu and coss per pound of each product
