l

Solve Using excel

13. A fertilizer company makes two products: Hiph and Lo-ph . There are three raw materials that go into making these products: RM1, RM2, and RM3. The table below summarizes the raw material requirements and limits as well as the profit margin for each of the two products: The company needs to decide how many tons of each product to make daily. Additionally, they have set the following goals: - Profit goal: make at least $13,000 - Market share: make at least 1,150 tons of fertilizer (total of both products) - Upsell Hiph : make at least 400 tons of Hiph daily They have set penalty weights of: - 0.5 for the profit goal - 0.3 for the market share goal - 0.2 for the Hiph goal Formulate and solve a goal programming problem to advise the company on their product mix. Are all goals met? If not, which one(s) fall(s) short