Use Solver Table to run a sensitivity analysis on the cost per assembling labor hour, letting it vary from $5 to $20 in increments of $1. Keep track of the computers produced in row 21, the hours used in the range B26:B28, and the total profit. Discuss your findings. Are they intuitively what you expected?
Answer to relevant QuestionsCreate 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 ...Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using Solver Table and allowing the initial inventory to vary from 0 to 10,000 in increments ...A chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 units of B, and 100 ...A manufacturing company makes two products. Each product can be made on either of two machines. The time (in hours) required to make each product on each machine is listed in the file S13_33.xlsx. Each month, 500 hours of ...A pharmaceutical company manufactures two drugs at Los Angeles and Indianapolis. The cost of manufacturing a pound of each drug depends on the location, as indicated in the file S13_42.xlsx. The machine time (in hours) ...
Post your question