For the following problem, provide an objective in words, datadefinition, variable definition, and algebraic formulation (usingsummation notation when possible). You do not need to implementand solve.Submit your solution as an attached file. You may type up your workusing Microsoft Word.Hire-a-Car System rents three types of cars at two different locations. The profitcontribution made per day for each car type at each location is listed below.Car TypeLocationEconomyMid-sizeLuxuryA$25$40$10$30$35$45The management forecasts the demand per day by car type as follows:125 rentals for Economy cars, 55 rentals for Mid-size cars, and 40rentals for Luxury cars. The vehicle capacity of each location is 100 carsin location A and 120 cars in location B.

Decision Variables: Let, x11 be renting from Location A for Economy. x12 be renting from Location A…

Answered: Hire-a-Car System rents three types of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
The exclusive Swink Golf Driving Range has had astandard price of $15 per hour. The facility has 36 golfing stations,with average usage of 50%, 10 hours a day, 7 days a week. MorganSwink, the owner, would like to enhance revenue. He proposes newpricing at $10 per hour on weekdays and $20 per hour on weekends.He estimates that weekday usage will increase to 60% and weekendusage will remain at 500/o, even with the price increase. Variable costis a consistent $3 per hour. Which strategy is better?
The Candle Company plans to open a new retail store in Portland, Maine. The store will sell specialty candles for an average of $10 each. The average variable costs per candle are as follows: Wax $4 Other additives $2 Base $1 The company is negotiating its lease for the new location. The landlord has offered two leasing options: Option A) a lease of $2,500 per month; or Option B) a monthly lease cost of $2,000 plus 10% of the company's monthly sales revenue. The lease option that is more attractive for the company under its current sales expectations is option B, the fixed lease payment plus sales based commission because it results in the lowest total lease costs The indifference point is The company expects to sell approximately 400 candles per month. Requirement 2. At what level of sales (in units) would the company be indifferent between the two lease options? Show your proof. candles. Begin by selecting the equation to determine the indifference point. (Abbreviations used" FC =…
Develop a network showing the origin nodes, destinations, arcs, cost per arc, supply, and demand. Match the correct answer to each question. Warehouse A B C D City E City F City G City H Warehouse Supply. 0.51 0.21 0.52 0.41 4000 Question 1 0.31 Question 2 0.56 0.43 0.35 0.41 0.28 City Demand 4,400 3,000 6,500 4,700 Match the correct answer to the following questions: 1. What is the supply constraint for Warehouse D? 2. What demand constraint for City H? 0.32 0.54 0.33 4000 0.54 0.34 0.52 6300 6000 [Choose ] [Choose ] > >
A city would like to know how many vehicles it could move through its streets in an emergency. The most likely situation is an evacuation starting at the school and ending at the park. The connections between these two locations, plus their capacity and direction, is shown below. School B Path Capacity Oak Street Elm Street A 10 с E B C 20 15 1 Street D 30 2nd Street E 25 F F 20 Park G 15
Problem 2. An electric switch manufacturing company has to choose one of three different assembly methods. Method A will have first cost of $ 40,000, an annual operating cost of $9,000 and a service life of 2 years. Method B will cost $80,000 to buy and will have an annual operating cost of $6,000 over its 4 year service life. Method C will cost $130,000 initially with an annual operating cost of $4,000 over its 8-year life. Methods A and B will have no salvage value, but method C will have some equipment worth an estimated $12,000. Which method should be selected? Use present worth analysis at an interest rate of 10% per year.
Use the following for the next 2 questions: A company forecasts that it will ship 120,000 boxes of product in June. The product has a monthly turnover of 3. The company plans to use its facility to ship 80,000 boxes and the balance of the 40,000 boxes will ship from a rented facility. Space may be rented for a charge of $7 per box per month with an in-and-out handling charge of $0.45 per box shipped. 1. What is the rented (fixed) storage cost for June? - $280,000 - $180,000 - $42,500 - $250,000 - $93,333 - $153,333 - $173,333 2. What is the rented variable cost for June? - $33,333 - $43,333 - $6,000 - $38,000 - $18,000 - $28,000 - $23,333
3. Figure 1 Daily Subway and Bus Use in Five Major Cities 0.75 0.5 0.25 Subway OBus London Tokyo Singapore Hong Kong Figure 2 Subway vs. Bus Ridership, New York City OBus Subway 1970 1980 1990 2000 2010 Information in figure I suggests that public transportation users in London Information in Figure I supports the author's point that buses are growing in popularity as a means of urban transport by indicating that A) take subways and buses at similar rates. B) are unusually reliant on buses. C) take at least one subway trip daily. D) take subways at about the same rate as people A) many people around the world take at least one bus trip every day. B) bus ridership surpasses subway ridership in some major cities. C) people in Tokyo make far more trips by bus daily than they do trips by subway. D) the number of bus trips taken by people in major cities has substantially increased. in New York. 2 Which of the following statements about bus use in New York City is best supported by…
Your fast-food outlet, Burger Queen, has obtained a license to open branches in three closely situated South African cities: Brakpan, Nigel, and Springs. Your market surveys show that Brakpan and Nigel each provide a potential market of 2,500 burgers a day, while Springs provides a potential market of 1,000 burgers per day. Your company can only finance an outlet in one of those cities at the present time. Your main competitor, Burger Princess, has also obtained licenses for these cities, and is similarly planning to open only one outlet. If you both happen to locate at the same city, you will share the total business from all three cities equally, but if you locate in different cities, you will each get all the business in the cities in which you have located, plus half the business in the third city. The payoff is the number of burgers you will sell per day minus the number of burgers your competitor will sell per day. Set up the payoff matrix. O a. Your Competitor B N S Вг 1,5001…
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS