Question: solve it as nonlinear programming solve it using excel A haberdashery produces scarves (S), ascots (A), and capes (C). The profit function for the haberdashery

solve it as nonlinear programming solve it using excel
A haberdashery produces scarves (S), ascots (A), and capes (C). The profit function for the haberdashery is expressed by the following equation: profit = 4S + 2A + 5C +0.892 +1.4A2+262 +2SAC. It takes 9 minutes to produce a scarf, 13 minutes to produce an ascot and 30 minutes to produce a cape. There is a total of 50 hours available for labor each week. Shipping poses another issue for the haberdashery; packaging and loading trucks for online orders is time consuming. It takes 1.5 minutes to pack and load a scarf, 2.5 minutes to pack and load an ascot, and 3.5 minutes to pack and load a cape. There is also a cross product term for packing and loading that is 0.15SA + 0.075SC + 0.025AC that must be considered. There is a total of 30 hours available for packaging and loading trucks for online orders. There must be at least 50 scarves, 100 ascots, and 25 capes produced each week. 1- Formulate the problem. 2- What is the optimum solutionStep 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
