Question: Linear Programming with Solver Advertising. Intronix uses copy editors, computer graphics specialists, and Java programmers to produce ads for magazines and the intemet. The average
Linear Programming with Solver Advertising. Intronix uses copy editors, computer graphics specialists, and Java programmers to produce ads for magazines and the intemet. The average new ad for magazines typically requires hours of a copy editor's time and hours of a computer graphics specialist's time, whereas ads produced for the internet require hours of copy editor time, hours of computer graphics time, and hours of a Java programmer's time. Lassie Food, a dog food manufacturer, has hired Intronix to produce ads in the next four week. Based on past data, one magazine ads increases sales by bags and one internet ads increases sales by bags. It wishes to have at least of each type of ads produced within the next four weeks. Intronlx has assigned up to copy editors, computer graphics specialists, and Java programmer, each committed to work up to hours per week on the project. How many of each type of ad should be produced to maximize the sale increase to Lassie Foods? Formulate this problem as an optimization problem by stating the decision variable, the objective functions and constraints. Show your model in the algebraic format in the first tab of the excel file. Solve the problem in the second tab of this excel file using excel addin Solver. Attach your completed excel file for this problem.
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
