The operations manager for a water taxi company wants to decide whether to purchase a small, medium, or large new boat for the company. The manager estimates that the annual profits (in thousands of dollars) will vary depending upon whether passenger demand is low, moderate, orhigh, as shown in the following table.DemandBoatLow MediumHighSmall505770Medium377989Large1751119Probability0.30.30.4If the company uses the expected value approach, which size boat will it decide to purchase?O small000mediumlargeO none

Calculate the expected value for each boat size by multiplying the annual profits for each demand by…

Answered: The operations manager for a water taxi…

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 Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: Month April May June July August September Production Days 14 20 24 26 20 18 Forecasted Demand (in hundreds of cases) 75 100 200 140 100 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty's production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and objective…
A company wants to forecast demand using the weighted moving average. If the company uses two prior yearly sales values (i.e., year 2015 = 110 and year 2016 = 130), and we want to weight year 2015 at 0.10 and year 2016 at 0.90, which of the following is the weighted moving average forecast for year 2017? Group of answer choices a. 120 b. 138 c. 142 d. 128 e. 133
A plastic injection molding machine operates 334 days a year. It is the bottleneck workstation in a process that produces plastic housed wall clocks. Industrial engineers collected data on the probability of machine breakdowns, the costs of preventive maintenance, and the cost of a breakdown. Number of Molding Machine Breakdowns per Day Probability of a breakdown 0 0.32 1 0.27 2 0.22 3 0.13 4 0.06 The cost of preventive maintenance is high due to performing it between 1 and 4 a.m. each day by two machine experts. The preventive maintenance cost is $2,030 per day including replacement parts, cleaning, and software upgrades. The cost of a breakdown of $1,940 is also high because the downstream workstations can only work until all work-in-progress inventory is completed; then the entire process must stop. What are the economics of the situation? Do not round intermediate calculations. Round your answers to the nearest cent. The expected cost of a breakdown per day is $ The manufacturing…
The following table shows the actual demand observed over the last 4 years: 1 Year Demand 8 Year Forecast (ES) 1 7.0 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place). 3 5 Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers). Year Forecast (NA) 2 10 2 2 3 4 3 4 4 9 4 5
Practice example. Please shoow solution.
1
The following table shows the actual demand observed over the last 11 years: Year Demand 1 7 Year Forecast 2 8 2 3 4 3 4 10 4 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). 3 2 4 5 6 T 8 9 Year 1 Forecast 6.0 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers) 5 12 5 6 7 6 7 8 11 14 7 8 9 10 9 10 10 10 13 11 11 11 8 12 12
The Blah Cafe operates a restaurant location in Fresno, CA where they serve food in an eclecticcasual blah whatever setting. Blah Cafe analyzes their operations in two seasonal periods – Spring& Summer being the first seasonal period and Fall & Winter being the second. The averagemonthly demand, with revenue and variable cost figures for both the seasonal periods is given in the data tableAs can be seen in the Table, demand is pretty high and robust in the Spring and Summer season,with demand falling in the Fall and Winter season.1. Help Blah Cafe develop an EXCEL spreadsheet model to determine the break-even point*demand quantity for each of the seasonal periods. Explain how you found the break-evenpoint. Should the restaurant be kept open during the Fall & Winter months? Explain.*At the Breakeven Point (demand), Total Revenue = Total Costs (or at Breakeven Point,Profit = zero). 2. Now given current demand for each season, what fixed cost will justify keeping therestaurant…
DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a 3-year moving average to forecast demand. Forecast demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the…
Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, whereas the advanced model is faster but costs more. Profitability will depend on future demand. The following table presents an estimate of profits over the next three years. Demand Volume Decision Low Medium High Basic model $90,000 $110,000 $155,000 Advanced model $60,000 $135,000 $190,000 Fill in the table below for maximum and minimum profit payoffs under each model. Round your answers to the nearest dollar. Decision alternative Maximum Minimum Basic model $ $ Advanced model $ $ Calculate the amounts foregone by not adopting the optimal course of action for each possible demand level. Determine the maximum opportunity cost for each model. Fill in the table below. If your answer is zero, enter "0". Round your answers to the nearest dollar. Opportunity Loss Matrix Future events Decision alternative Low Medium High Maximum…
Hi, need help solving for part B. Thank you.
Given the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are: Regular output $20 Overtime $30 Subcontract $25 Average Inventory $10 Backlog $18 Month 1 2 3 4 5 6 Forecast 540 540 570 590 650 680

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