Question: I need to solve this problem through excel by using the solver. i need the steps please PP4 - Rochak's Ink Company Bookmark this page

I need to solve this problem through excel by using the solver. i need the steps please
I need to solve this problem through excel by
PP4 - Rochak's Ink Company Bookmark this page Part 1 O points possible (ungraded Rochak owns an Indian ink manufacturing company that makes cyan, magenta, and yellow ink. The ink creation process Involves two steps: 1. Mixing powder ingredients to create the correct color 2. Mixing liquids into the powder to create the correct ink properties Machines involved in the first process require heavy maintenance and operate 17 hours per day. Machines involved in the second process require less maintenance and operate 23 hours per day. Rochak has no storage space, so he will never manufacture more than he can selle Rochak wants to maximize his profits. Help Rochak choose how much of each ink color to create per day, given the following Information: Color Stage 1 Time (seconds/unit) 0.44 Stage 2 Time (seconds/unit) 0.55 Demand (units/per day) Profit (in Rupees/per unit) 84000 0.6 Cyan Magenta 0.51 0.6 0.72 72000 93000 Yeow 0.5 0.50 0.62

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!