Page 1 of 1
11. Bruce wants to determine whether partnering with another fitness company would reduce the costs of fitness training
Posted: Wed Jul 06, 2022 6:08 am
by answerhappygod
- 11 Bruce Wants To Determine Whether Partnering With Another Fitness Company Would Reduce The Costs Of Fitness Training 1 (31.35 KiB) Viewed 33 times
11. Bruce wants to determine whether partnering with another fitness
company would reduce the costs of fitness training services. Switch to the Training Providers worksheet, and then run Solver to solve this problem as follows: Set the objective as minimizing the value in cell F10 (Total Costs). a. b. C. d. e. f. 9. Use the range C4:E4 as the changing variable cells. Adjust the hours provided by each
company using the following constraints: F4-600, the total hours of fitness services provided F10 is less than or equal to 130,000, the maximum fees paid to another fitness
company C4:E4 is less than or equal to 220, the maximum hours provided by a single fitness
company C4:E4 should be an Integer Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range B14:B21, and then close the Solver Parameters dialog box.