I need to solve the part two this problem through excel. Can someone show me the steps please. Thanks

PP2 - Jim's Meat Packing Company Bookmark this page PP2 - Jim's Meat Packing Company poires pour This lean ground beef is a mixture of two meat cutschuck and siron, both of which contain both lean and fat meat The cost per pound and percentage of lean meat and fat meat for these two cuts are as follows: Cut Lean Meat Fat Meat Cost Check 9x 2 303 So GON ON SHAD In order for din company to market its beet ose ground bei mucon Onwand amous fame Jim wishes to contin creating this comparean ground tools need to mast 50 pounds of me per day Part 2 0 points possible ungraded) How much would the objective improve if we relaxed the constraint concerning the daily shipment requirement of ground beef by 1 unit? In other words, what is the marginal value dual value' or 'shadow price for the dally shipment amount constraint? Enter your answer with two decimals You have used 3 of attempts Show answer PP2 - Jim's Meat Packing Company Tha tean ground beef is a mixture of two meet cuts Check and still both of which contain both semans famnet The cost per pound and percentage of lean meat and at meat for these two cuts we as follows Cut Cos Chuck $9.31 Sirion 80% $8.470 In order for Jims company to market its beet as "tean ground best must contain a lot 30% en mest and almost fat meat Jim wishes to minimizo his cost in creating his company staan ground beet. Sen no needs to make 2 a 50 pounds of met per day Part 1 What is the optimal cost of creating these ground beetle. what is the lowest price the condary can pay by optimizing their chuck and rolin purchase? indows herming eduarg course courseMCISCO-ST2020 VMCTL3+372030-type sie wishes to minimize this cost in creating his company's teen ground beet en needs to make at least 50 pounds of meal per day Part 1 What is the optimal cost of creating this bon ground beat;le, what is the lowest price the company can pay by coming their chuck and sirloin purchases? Dobmit you had 3 Part 2 popote How much would the objective improve it wereld the constraint concerning the daily shipment requirement of ground beef by 1 unit in other words, what is the marginal value dual value of shadow price for the daily shipment amount constraint? PP3-A New Office Plant Bookmark this page A New Office Plant 0 points possible (ungraded) As the new VP of Supply Chain for a large corporation, you have been given a nice corner office, with large windows and a view of the river. To celebrate this good news, your spouse has made a special gift to you: a potted specimen of Piripiri patchiflora, an exotic plant from Tasmania that flowers only once a year and smells vaguely like asparagus. To stay alive, the Pirripimi plant requires a specific combination of nutrients dissolved in its watering solution every day. Your spouse, who is very keen on this plant's health, has explained that its daily watering solution requires between 1800 mg and 2200 mg of Nitrogen, and exactly 100mg of Potassium. Your spouse has been kind enough to send you the link to three products that you can buy online, which you can dissolve in the daily watering solution for the Pirripiri Product #1 has 360 mg of Nitrogen and 30 mg of Potasium per gram, and costs 1.59 cents per gram. Product #2 has 380 mg of Nitrogen and 20 mg of Potasium per gram, and costs 2.19 cents gram Product #3 has 310 mg of Nitrogen and 20 mg of Potasium per gram, and costs 2.99 cents per gram. You intend to spend as little as possible on these products, while meeting the nutritional requirements of the plant. Part 1 You want to figure out how many grams of each product you should buy in order to minimize the daily cost of keeping the Pirripirri alive. (Please enter your answer in grams, with two decimals, with no weight unit. For example, if your answer is 12345 grams, enter 1.23 in the space.) Grams of Product 1