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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
