The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 407 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
The accounting firm of Coopers & Andersen is conducting a benchmarking survey to assess the satisfaction level of their clients versus clients served by competing accounting firms. The clients are divided into four groups:
Â

A total of 4,000 companies are being surveyed either by telephone or via a two-way web cam interviews. The costs associated with surveying the different types of companies are summarized in the following table:

Coopers & Andersen wants the survey to carry out the survey in the least costly way that meets the following conditions:
• At least 10% but not more than 50% of the total companies surveyed should come from each group.
• At least 50% of the companies surveyed should be clients of Coopers & Andersen.
• At least 25% of the surveys should be done via web cam.
• At least 50% of the large clients of Coopers & Anderson who are surveyed should be done via web cam.
• A maximum of 40% of those surveyed may be small companies.
• A maximum of 25% of the small companies surveyed should be done via web cam.
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem, and solve it using Solver.
c. What is the optimal solution?
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- Th-----------ank----------- Yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill-----------