Bhikho 2. A company is planning to open a maximum of 11 new stores in Chicago. The stores will be builtin one of three sizes: a convenience store (open 24 hrs.), a standard store, and an expandedservice store. The convivence store requires $4.1215 million to build and 30 employees tooperate. The standard store requires $8.25 million to build and 15 employees to operate. Theexpanded-services store requires $12.375 million to build and 45 employees to operate. Thecompany can dedicate up to $82.5 million for construction, and 300 employees to staff thestores. On average, the convenience store nets $1.2 million annually, the standard store nets $2million and the expanded service store nets $2.6 million annually. How many of each storeshould the company build to maximize revenue? Use excel solver.

Solution:Hence,Convenience store = 2Standard store = 9Expended store =0

Answered: A company is planning to open a maximum…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
The subject property has a pool valued at $30,000 and two bathrooms valued at $10,000 each. Comp 1 does not have a pool and has one less bathroom than the subject property. What adjustments should be made to Comp 1's value? subtract $40,000 from Comp 1's value add $40,000 to Comp 1's value add $20,000 to Comp 1's value subtract $20,000 from Comp 1's value
Manny signs a variable lease. He pays $10/ square foot. His index is 2.His utilities will cost $350.If his index goes up to 2.5 next year, how much will Manny payin rent? $25/square foot $12.50/square foot $8/square foot $50/square foot |
The subject property has a pool valued at $30,000 and two bathrooms valued at $10,000 each. Comp 1 does not have a pool and has one less bathroom than the subject property. What adjustments should be made to Comp 1's value? add $20,000 to Comp 1's value add $40,000 to Comp 1's value subtract $20,000 from Comp 1's vatue subtract $40,000 from Comp 1's value
. A group of students organizes a bake sale in which they sell hundreds of cookies at $1per piece. They set up a table on campus and wait for students to come and purchasetheir cookies. Consider the following variables in this bake sale operation:1. Size of the cookies2. Weather conditions on campus3. Organization of the table4. Number of cookies sold5. Competition from other fund-raisers coinciding on campus6. Amount of advertising and shouting of the students at the bake sale table7. Number of students on campus that dayWhich of these variables is an output variable?a. 3b. 4c. 5d. None of the above
An electronics firm is currently manufacturing an item that has a variable cost of $0.50 per unit and a selling price of $1.10 per unit. Fixed costs are $15,000. Current volume is 30,000 units. The firm can substantially improve the product quality by adding a new piece of equipment at an additional fixed cost of $5,600. Variable cost would increase to $0.65 and the selling price would be revised to $1.30 with the expectation that the volume would be 50,000 units as a result of a higher-quality product. If the firm does not add new equipment, its profit will be =_____ dollars (round your response to the nearest whole number and include a minus sign if the profit is negative).
4. Optimal Rental Decisions in Cloud Computing Assume that AWS has the following 3 options for renting servers. Fraction of Job in one Server Description Rental Low Power Medium Power High Power $2/hr. $4/hr. $9/hr. Hour 1/8 1/6 1/3 L M Note that if you rent a server for less than one hour, you still must pay the rent for the entire hour. You have a job that must finısh in at most 5 hours. The low-power server can finish 1/8th of the job in 1 hour, the medium-power server can finish 1/6 of the job in one hour, and the high- power server can finish 1/3rd of the job in one hour. (a) The typical practice used by most firms is to find a single server that can do the work at the least cost and within the available time. Find the best sıngle server solution-that is, which single server should you use and for how many hours will you rent this server?
Bimala is interested in buying a new house and has found a house she likes in Surry Hills. Bimala comes to you for advice about which of the following items would pass to her automatically if she buys the house: • A plastic bird bath which rest on the ground in the back garden; • A concrete swimming pool in the back garden; • A tapestry attached by small tapestry nails to the wall of the living room; and • A barbecue on wheels on the back deck. Advise Bimala. In your advice, please ensure that you refer to relevant case law. *NOTE: This is business law question. can you write more details about the question and answer.
2. Maximize subject to p = x + 2y X +3y24 2x + y 18 x ≥ 0, y ≥ 0.
5. The manager of a fast-food restaurant featuring hamburgers is adding salads to the menu. If they choose to include a salad bar (i.e., the MAKE option), it will cost $14,000 in annual fixed costs for the leased equipment and added employee, and $1 per salad variable cost. If they choose to have pre-made salads (i.e., the BUY option), it will cost $3 per salad. The manager expects to sell 7,500 salads per year. What is the make or buy quantity (i.e., the breakeven point between making vs. buying)?
Assuming your company is producing Apple and Samsung phone cases. It is required to process in the assembly and paint shops to make either phone case. It takes 1/60 of a day and 1/40 of a day to paint an Apple case and a Samsung case in the paint shop, respectively. It takes 1/50 of a day to assemble either type of case in the assembly shop. An Apple phone case and a Samsung phone case yield profits of $300 and $220, respectively, per case sold. What is a maximum-profit daily production plan for your company?
Mary is a sales person for Challenge Furniture. She receives an incremental commission based on the table below. If she sells $26,000 and has already received a draw of $766.15, how much commission is still owed to Mary? level 1 1-11,700 3.7% sales volume 2 11,701-21,200 4.3% commission rate 3 over 21,200 4.7%

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS