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

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

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 Finance Questions!