Problem 1: Optimization Modeling TABLE 1 Monthly Demand for Sandwich Patties Yummy Wholesome Max Monthly Total Production O Storage Cost per Unit TABLE 2 Cost per pound of raw materials Dark Meat Light Meat Grain Gruel TABLE 3 Raw material required per patty (lbs) Grain Gruel Month 1 Demand 12,000, Month 1 Cost per lb Dark Meat $0.10 $0.15 $0.02 4.00 0.00 c Month 2 Demand Month 2 Cost per lb $0.1 $0.18 So. Light Meat 4 TABLE4 Yummy Wholesome Yummy Wholesome 0.00 d. Fat r Pa Lp Optimization with Solver During the next two months Johnson-Perry Company must meet the demands provided in Table 1 for their Yummy brand and Wholesome brand sandwich patties. These demands must be met on time. During each month, at most 12 million patties total can be produced. Both Yummy and Wholesome patties can be held in inventory at a cost of $0.05 each per month in a cold storage facility. Table 2 shows the cost per pound of raw material used to produce sandwich patties. Table 3 shows the pounds of raw material required to produce a single patty of each type. Meat and grain gruel can be used only in the month it was purchased. As shown in Table 4, each Yummy patty produced contains 20 grams of fat and each Wholesome patty contains 8 grams of fat. Each month, the combination of all patties produced by the company must average no more than 13 grams of fat for regulatory reasons. Develop a linear model and properly optimize it with Solver to minimize the total cost of producing and storing Yummy and Wholesome sandwich patties. Non-integer solutions are fine - Do not use any integer constraints. g Max Avg Fat (g) ot Patties Produced per Mont 2 Montn 1 Demand