Construct spreadsheet model to help manager forecast demand

Assignment Help Business Management

Reference no: EM131194267

The manager of a small health clinic needs to forecast demand for laboratory services in the facility. Data from the last six weeks are available and are, respectively, 330, 350, 320, 370, 368, and 343 tests. The manager decides to use a forecasting technique known as the three-period moving average.

For this technique, the most recent three weeks' demands are averaged together to produce the forecast for the upcoming week. For example, weeks 1-3 are used to produce the forecast for week 4.

(a) Construct a spreadsheet model to help the manager forecast demand. Assume that this technique has been in place in the previous weeks as well, and generate the forecasted demand for week 7. You will not be able to generate forecasted demands for weeks 1-3.

(b) Expand the model to calculate the error in the forecast each week. The error should be calculated as the actual demand for the week minus the forecasted demand. Which week had the largest error? Which had the smallest error? What does it mean that some errors are positive and some are negative?

Reference no: EM131194267

Questions Cloud

Find the mole fraction of steam required in the feed : Side reactions are suppressed by the introduction of steam. If equilibrium is attained at 925 K and 1 bar and if the reactor product contains 12-mol-% 1,3-butadiene

Explain the organizations statement of cash flows : Analyze the organization's statement of cash flows. Explain the format that the organization utilizes, including any unique areas of emphasis that differ from-GAAP accounting format.

Rationalizations-dilemmas and resolutions : You are an executive with a large pharmaceutical company and you have to decide whether to market a product that might have undesirable side effects for a small percentage of users.

Examine effects that government policies have on production : Examine the major effects that government policies have on production and employment. Predict the potential effects that government policies could have on your company

Construct spreadsheet model to help manager forecast demand : Construct a spreadsheet model to help the manager forecast demand. Assume that this technique has been in place in the previous weeks as well, and generate the forecasted demand for week 7.

Compromise between interviews and questionnaires : A group meeting sometimes is suggested as a useful compromise between interviews and questionnaires. In such a group meeting, one systems analyst meets with and asks questions of a number of users at one time. Discuss the advanctages and disadvant..

Operations management is important for businesses : 1) What do you think operations management means? 2) Why do you think operations management is important for businesses?

Developing successful websites : "Developing a Winning Website" in Chapter 8 discusses a number of strategic questions to answer while developing successful Websites. For the Website you chose in the e-Activity, identify and describe how these strategic questions were addressed w..

The given memo has faults in proofreading : The following memo has faults in proofreading, grammar, spelling, punctuation, capitalization, word use, and number form.- print the message as shown and edit it with handwritten proofreading marks.

User Account

All Pages