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 180 hours of a copy editor's time and 135 hours of a computer graphics specialist's time, whereas ads produced for the internet require 35 hours of copy editor time, 195 hours of computer graphics time, and 60 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 3000 bags and one internet ads increases sales by 1000 bags. It wishes to have at least 2 of each type of ads produced within the next four weeks. Intronlx has assigned up to 3 copy editors, 4 computer graphics specialists, and 1 Java programmer, each committed to work up to 70 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 add-in Solver. Attach your completed excel file for this problem.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
