Question: Problem 2 Decisin Variables (2pts): Solver solution (1 pts) (create the excel tables below this box) The JUICEBAR CO. Wants to explore the posibility of

Problem 2 Decisin Variables (2pts): Solver

Problem 2 Decisin Variables (2pts): Solver solution (1 pts) (create the excel tables below this box) The JUICEBAR CO. Wants to explore the posibility of launching three new products to the market Multi function juicer, Blender juicer and the ultimate multifunction juicer cube. For the launch they would have to pay for the patent of each of the products to be able to produce them. The cost of each patent is: $10,000 for product 1,$15,000 for product 2 and $12,000 for product 3 . The revenue per unit sold is: Objective Fuention (1.5 pts): Product 1$3.2, product 2$4.5 and product 3$3.8 The products go torugh three different departments (Modling, assembly. and packaging). The folkowing is the time (in minutes) each product will take in esch department : Time available in each depertment is 19000min in molding, 27000min in assembly, and 22800 in packaging. The marketing department estimates that all is produced can be sold. Formulate the above problem mathematically as a linear programming model: - Define you decision variables clearly and use them to formulate the objective function and constraints. Finally, combine everything to get the final model. Solve the problem using solver and give a brief interpretation of the results Interpretation of results ( 0.5pts)

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!