Question: can i get an answer in excel sheet. 13. A fertilizer company makes two products: Hiph and Lo-ph . There are three raw materials that

can i get an answer in excel sheet.can i get an answer in excel sheet. 13. A

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 Hi-ph 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 Hi-ph 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!