Question: Create a two way Solver Table for the product mix model
Create a two-way Solver Table for the product mix model, where total profit is the only output and the two inputs are the testing line 1 hours and testing line 2 hours available. Let the former vary from 4000 to 6000 in increments of 500, and let the latter vary from 3000 to 5000 in increments of 500. Discuss the changes in profit you see as you look across the various rows of the table. Discuss the changes in profit you see as you look down the various columns of the table.
Answer to relevant QuestionsModel 8 has fairly high profit margins, but it isn’t included at all in the optimal mix. Use Solver Table, along with some experimentation on the correct range, to find the (approximate) selling price required for model 8 ...Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don’t forget to modify range names. Then modify the model again so that there ...A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing restrictions require ...There are three factories on the Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1500 to ...A company manufactures two products on two machines. The number of hours of machine time and labor depends on the machine and product as shown in the file S13_43.xlsx. The cost of producing a unit of each product depends on ...
Post your question