We have seven accounts. The total number of calls is limited to 16. Using solver to find
Fantastic news! We've Found the answer you've been seeking!
Question:
We have seven accounts. The total number of calls is limited to 16.
Using solver to find the optimal number of calls on each account in order to maximize the total profit.
*NEED FORMULA AND SOLUTIONS*
Transcribed Image Text:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16. 17 18 19 20 2 ជ ន ន ន ព ន ឯគ 21 22 23 24 25 26 27 28 B A с E F G H J Here is a problem very similar to the sales calls. Now we have seven accounts. The total number of calls is limited to 16 Using solver to find the optimal number of calls on each account in order to maximize the total profit Number of Calls 1 2 3 4 5 6 7 8 9 10 Call Plan Profit Total Profit Account D A с E F B G $ 1,200 $3,000 $ 200 $2,000 $ 300 $ 500 $ 1,200 $2,100 $4,500 $ 390 $3,800 $1,300 Ś 950 $2,100 $ 2,950 $5,300 $ 570 $5,000 $2,100 $ 1,370 $2,900 $3,600 $ 5,500 $ 730 $6,000 $2,600 $ 1,770 $ 3,300 $ 4,090 $ 5,600 $ 880 $6,500 $3,000 $2,120 $3,600 $ 4,450 $ 5,675 $ 1,015 $ 6,700 $ 3,300 $ 2,370 $ 3,825 $ 4,700 $5,725 $ 1,145 $ 6,900 $3,500 $ 2,570 $ 3,985 $4,865 $5,765 $ 1,270 $ 7,000 $ 3,600 $2,720 $ 4,095 $ 4,950 $ 5,795 $ 1,390 $ 7,100 $ 3,690 $ 2,820 $ 4,165 $ 4,965 $ 5,820 $ 1,505 $ 7,150 $ 3,740 $ 2,870 $ 4,215 K 0 L Total Calls <= 20 M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16. 17 18 19 20 2 ជ ន ន ន ព ន ឯគ 21 22 23 24 25 26 27 28 B A с E F G H J Here is a problem very similar to the sales calls. Now we have seven accounts. The total number of calls is limited to 16 Using solver to find the optimal number of calls on each account in order to maximize the total profit Number of Calls 1 2 3 4 5 6 7 8 9 10 Call Plan Profit Total Profit Account D A с E F B G $ 1,200 $3,000 $ 200 $2,000 $ 300 $ 500 $ 1,200 $2,100 $4,500 $ 390 $3,800 $1,300 Ś 950 $2,100 $ 2,950 $5,300 $ 570 $5,000 $2,100 $ 1,370 $2,900 $3,600 $ 5,500 $ 730 $6,000 $2,600 $ 1,770 $ 3,300 $ 4,090 $ 5,600 $ 880 $6,500 $3,000 $2,120 $3,600 $ 4,450 $ 5,675 $ 1,015 $ 6,700 $ 3,300 $ 2,370 $ 3,825 $ 4,700 $5,725 $ 1,145 $ 6,900 $3,500 $ 2,570 $ 3,985 $4,865 $5,765 $ 1,270 $ 7,000 $ 3,600 $2,720 $ 4,095 $ 4,950 $ 5,795 $ 1,390 $ 7,100 $ 3,690 $ 2,820 $ 4,165 $ 4,965 $ 5,820 $ 1,505 $ 7,150 $ 3,740 $ 2,870 $ 4,215 K 0 L Total Calls <= 20 M
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To find the optimal number of calls on each account we can use Solver an Excel addin that allows us to solve optimization problems by adjusting the values of certain cells in a worksheet subj... View the full answer
Related Book For
An Introduction to Management Science Quantitative Approach to Decision Making
ISBN: 978-1337406529
15th edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Posted Date:
Students also viewed these accounting questions
-
A manufacturer purchases a part for use at both of its plants-one at Roseville, California, the other at Akron, Ohio. The part is available in limited quantities from two suppliers. Each supplier has...
-
If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?
-
If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?
-
Suppose that we have a linear program that is not in standard form. We could produce the dual by first converting it to standard form, and then taking the dual. It would be more convenient, however,...
-
Fancy Foods Company produces and sells canned vegetable juice. The ingredients are first combined in the blending department and then packed in gallon cans in the canning department. The following...
-
Determine the exact value(s) for which the rational expression f(x) = than one value, list them separated by a comma, e.g. x = 2,3. -11x+1 -30x225x+5 is undefined. If there's more
-
If \(P=150 \mathrm{kN}\), determine the total strain energy stored in the truss. Each member has a cross-sectional area of \(8.0\left(10^{3} ight) \mathrm{mm}^{2}\) and is made of A-36 steel. P D -3...
-
Danner Company expects to have a cash balance of $46,000 on January 1, 2012. Relevant monthly budget data for the first 2 months of 2012 are as follows. Collections from customers: January $85,000,...
-
< Break-Even Units, Contribution Margin Ratio, Multiple-Product Breakeven, Margin of Safety, Degree of Operating Leverage Jellico Inc.'s projected operating income (based on sales of 450,000 units)...
-
When faced with a clearly erroneous precedent, my rule is simple, writes Supreme Court Justice Clarence Thomas. We should not follow it. How do these words offer a cautionary tale for managers...
-
Find the area between the curves. x = -2, x= 2, y = 6x, y = x-7 The area between the curves is (Simplify your answer.)
-
An Investor has given you $1 million to start a consumer products wholesale company. You decided that your going to sell flags, will import all your products from Asia and sell them to leading...
-
As of September 8th, the Jewelry Company intends to acquire 20,000 ounces of platinum sometime in November. The present December platinum futures price is $926.05 per ounce. The standard deviation of...
-
Suppose you are using SOFR discounting (use zero rates implied by SOFR to discount payments). For this problem, all the swaps feature semiannual payments, and all swap rates are expressed per annum...
-
Kevin has met with you and Brenda. Brenda has explained his current duties as an enduring power of attorney holder. She has also provided Kevin with a copy of Norman's will and briefly explained his...
-
At the end of five years, you will receive $15,000 and deposit this in the bank toward your goal of $59,000 at the end of year 12. In addition to the lump-sum deposit, how much must you deposit in...
-
Home Wood manufactures fold-up patio table. Their facility enables them to manufacture 8,000 tables per month. These tables sell for $225 per table. The facility is currently operating at 90%...
-
The following processes constitute the air-standard Diesel cycle: 12: isentropic compression,23: constant-volume energy addition (T and P increase),34: constant-pressure energy addition (v...
-
South Central Airlines (SCA) operates a commuter flight between Atlanta and Charlotte. The regional jet holds 50 passengers, and currently SCA only books up to 50 reservations. Past data show that...
-
The Corporate Average Fuel Economy (CAFE) regulations were put into law by Congress in 1975 to promote the sale of fuel-efficient automobiles and light trucks. The law requires automakers to boost...
-
Tucker, Inc., produces high-quality suits and sport coats for men. Each suit requires 1.2 hours of cutting time and 0.7 hours of sewing time, uses 6 yards of material, and provides a profit...
-
S1 Ltd and S2 Ltd belong to the same capital gains group. In May 2020, S1 Ltd transferred a chargeable asset to S2 Ltd. The original cost of this asset to S1 Ltd was 10,000 and its market value in...
-
The ordinary share capital of W Ltd (which is a trading company) is owned 30% by X Ltd, 25% by Y Ltd and 45% by Z Ltd. All of these companies are UK resident and they prepare accounts to 31 March....
-
E Ltd has taxable total profits of 800,000 for the year to 31 March 2024 and receives no dividends. For many years, the company has owned 65% of the ordinary shares of F Ltd and 30% of the ordinary...
Study smarter with the SolutionInn App