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

The vessel, nicknamed Lovers Deep, is a specially adapted leisure submarine designed and furnished for couples to spend their time together in complete isolation and harmony underwater. Staffed by an onboard crew of three, consisting of a captain, chef, and personal butler, Lovers Deep has a unique capability of being moored at various locations chosen by customers, whether that be a stunning coral reef off the coast of St. Lucia or a sunken battleship in the Red Sea, In which industry would you place the leisure submarine? Select one: a. Travel & tourism b. Hospitality & travel C Tourism & hospitality d: Travel, tourism & hospitality
Grocers Inc. is considering offering a purified water service through a contract company that would locate a machine on the inside of the market store. There are two contract companies Grocers Inc. is considering, ClearWater and PureVida. ClearWater would charge an annual lease fee of $800 for set-up of the machine and for this machine, there is a utility cost of $0.10 for every gallon of water dispensed and ClearWater charges $0.05 for maintenance. For PureVida, the annual lease fee is $700, the utility cost is $0.12 for every gallon and PureVida charges $0.06 for maintenance. Grocers Inc. customers would purchase refilled gallons of water for $0.97.a. What is the annual break-even point for each option?b. At what volume in number of gallons would the two options have the same cost?c. At what forecasted volume should Grocers Inc. select ClearWater and what volume should they select PureVida and why?
Please show the solution to the corresponding answer stated in the problem.
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 A B Path Capacity Oak Street Maximum Flow Elm Street E A B с 15 15 30 D 10 1¹ Street 2nd Street E 5 F G F 5 (Round your answer to the nearest whole number.) Park G 30
The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown below. Shipping Cost per Case to Warehouses Factory Сарacity W1 W2 W3 W4 W5 $1.20 $3.60 | $4.80 $6.00 $7.20 F1 40,000 30,000 10,000 $2.40 $2.40 | $1.20 $4.80 $6.00 F2 30,000 25,000 5,000 $1.20 $6.00 $1.20 $3.60 $1.20 F3 30,000 10.000 20,000 $6.00 $2.40 $4.80 $6.00 $4.80 F4 25,000 25,000 Demand 30,000 35,000 25,000 15,000 20,000 125,000 What is the total cost of the optimal solution? Total cost = $ (Enter your response to the nearest dollar.)
‏صورة
A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? is/are best and 4 8 is/are least desirable.
Scenario E.1 SimQuick is being used to simulate the following bank process: Entrance Door Buffer Line Work Station Teller Buffer Served Customers Customer arrivals at the Entrance Door of the bank with an average time between arrivals of 2.5 minutes. The Line Buffer holds 6 customers. If a customer arrives and the buffer line is filled, the customer leaves. The Work Station Teller's processing time per customer is normally distributed, with a mean of 3.0 minutes and a standard deviation of 0.5 minutes. The Served Customer Buffer in the flow chart is used to count the number of customers processed during the period simulated. A 2-hour period was simulated. The SimQuick simulation is run, and the results are as follows: Overall Element Types Element Names Statistics Means Entrance Door Objects entering process 41.80 Objects unable to enter 6.23 Service level 0.87 Buffer Line Objects leaving 37.83 Final inventory 3.98 Minimum inventory 0.00 Maximum inventory 5.85 Mean inventory 3.08 Mean…
please do it in excel BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. Note:One image is of the data and the other image is option 1 to solve the exercise.
AlwaysRain Irrigation, Inc. would like to determine capacity requirements for the next four years. Currently, two production lines are in place for making bronze and plastic sprinklers. Three types of sprinklers are available in both bronze and plastic: 90- degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: Plastic 90 Plastic 180 Plastic 360 Bronze 90 Bronze 180 Bronze 360 1 (IN 0005) 33 14 51 6 4 10 YEARLY DEMAND 2 (IN 000s) 3 (IN 000s) 4 (IN 0005) 42 15 54 6 4 Plastic Demand for plastic sprinklers Percentage of capacity used Machine requirements Labor requirements Bronze Demand for bronze sprinklers Percentage of capacity used Machine requirements Labor requirements 12 54 18 61 5 6 14 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require four operators and can produce up to 15,000 sprinklers. The plastic…
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?
Please answer the question as quickly as possible A toy company has developed two new toys for possible inclusion in its product line for the upcoming Christmas season. Setting up the production facilities to begin production would cost $50,000 for toy 1 and $80,000 for toy 2. Once these costs are covered, the toys would generate a unit profit of $10 for toy 1 and $15 for toy 2. The company has two factories that are capable of producing these toys. However, to avoid doubling the start-up costs, just one factory would be used, where the choice would be based on maximizing profit. For administrative reasons, the same factory would be used for both new toys if both are produced. Toy 1 can be produced at the rate of 50 per hour in factory 1 and 40 per hour in factory 2. Toy 2 can be produced at the rate of 40 per hour in factory 1 and 25 per hour in factory 2. Factories 1 and 2, respectively, have 500 hours and 700 hours of production time available before Christmas that could…

SEE MORE QUESTIONS

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