Forecasting method on the deseasonalized data

Assignment Help Operation Management
Reference no: EM131344855

QUESTIONS

Be certain to state all assumptions, and be sure to show all of your analyses.

1. Use the monthly sales data over the past 4 years on outdoor swimming pools given below

DATA:


99

00

01

02

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

12

8

24

90

74

46

24

14

8

6

6

16

8

12

2

120

110

66

28

16

26

14

14

12

6

12

44

78

84

62

48

48

24

20

12

18

14

20

18

72

78

76

40

14

50

20

16

8

a. What are the seasonal indices for each month?

b. What's the "best" forecasting method on the deseasonalized data? Provide a summary table of the different forecast methods you looked at (try at least 3 methods, in addition to any naïve ones you may include), along with whatever error measure you calculated for the methods (e.g., MAD, MAPE, or MSE

c. What's your forecast for January 2003?

2. Joseph must order each year's calendar in August for delivery and eventual sale by December 31st. In previous years, standard Business Calendar sales have ranged from a low of 2000 to a high of 2300, so assume that demand is uniformly distributed between 2000 and 2300. Each calendar costs $17.90 and sells for $25.96, and unsold calendars usually sell out at a 1/2 price sale in January. Assume Joseph can only order in quantities of 50.

a. Write out the algebraic formula for profit as a function of both order quantity (Q) and demand (D).

b. What probability distribution will you use to model the random demand?

c. What is the optimal number to order to maximize Joseph's expected profit? What is the expected profit? Prepare a summary table of your Crystal Ball results (i.e., # ordered with its expected [or average] profit for all the order quantities you try).

Reference no: EM131344855

Questions Cloud

Types of customer-introduced variability : Name the five types of customer-introduced variability and discuss options that let companies offer a high level of accommodation at low cost or reduced variability without damaging the service experience. Provide your rationale and at least one s..
What is the value of voltage : The inverting OP AMP in given Figure is driven by a step input vS(t) = 2 u (t). Let R1 = 10 kΩ, R2 = 20 kΩ, and C = 0.1 μF.- If vC (0) = 4 V find v2(t) for t ≥ 0.
Identifying whether these recommendations are being : These three steps: commitment by leadership, development of a culture of safety, and the use of process improvement tools, are the core recommendations made by Dr. Chassin, the president of The Joint Commission and the president of the Joint Commi..
Find voltage and sketch its waveform : The switch in given Figure has been in position A for a long time and is moved to position B at t = 0.- The switch suddenly returns to position A after 10 ms. Find vC(t) fort ≥ 0 and sketch its waveform.
Forecasting method on the deseasonalized data : What's the "best" forecasting method on the deseasonalized data? Provide a summary table of the different forecast methods you looked at (try at least 3 methods, in addition to any naïve ones you may include), along with whatever error measure you..
How does your deposit change the banks t-account : You have decided to deposit $2,000 in a savings account in the Commonwealth Bank, which does not have any excess reserves at the time when you make a deposit. How does your deposit change the Bank's T-account?  Show the T-account changes
What are the safety factors in stress and in life : If a safety factor of 1.3 in stress is considered adequate, how many cycles can be appliedin service before the part is replaced?
What challenges did you experience : Discuss the installation of the software as well as the process of loading the company back up files, saving, renaming and restoring those. What challenges did you experience? What tips do you have for your classmates?
Find the voltage across the capacitor : Switches 1 and 2 in given Figure have both been in position A for a long time.- Find the voltage across the 0.22-μF capacitor for t ≥ 0 and sketch its waveform.

Reviews

Write a Review

Operation Management Questions & Answers

  How can ciena protect intellectual property in each country

Should CIENA pursue the Chinese market, look to establish production facilities there for export purposes, or do both?

  What was luxury bakings design capacity utilization

Luxury Baking can make 1,200 chocolate chip cookies per day under normal conditions and 1,500 with overtime labor. In the month of February, the average production was 1,300 cookies per day. What was Luxury Baking's design capacity utilization in Feb..

  Advise the team to manage conflict effectively

Describe how integrative negotiation strategies might achieve joint goals for the development team - describe how you will advise the team to manage conflict effectively.

  About applicant tracking systems

Review the information provided in the Research Guide and additional research, about Applicant Tracking Systems (ATS). As the new HR director, you have decided to make the change to use one of these systems. Evaluate some of the systems available, ch..

  Similarities between project plan and post project report

The difference and similarities between the project plan and the post project report. The extent to which the planned goals and objectives have been achieved. Prepare a summary of the differences and similarities between the two reports and to what e..

  Examine and compare the costs of the two projects in terms

analyze and compare the costs of the two projects in terms of performance efficiency budget and schedule. make sure to

  Profit corporations can be a force for good in society

Do you believe that for-profit corporations can be a force for good in society? Explain your answer. Develop your argument to explain why you feel the way you do, including real world examples of corporations that prove your point and examples of tho..

  What are the biggest challenges cuba

What are the biggest challenges Cuba is facing now that they are normalizing relations with the United States? Who do you think benefits most from ending the Embargo, U.S. or Cuba?

  Order to address the reasons why it fails to deliver returns

Why IT fails to deliver returns. Next, discuss the main steps that management could take in order to address the reasons why IT fails to deliver returns. Review the main factors that challenge the realization of IT value within health care organizati..

  Conducted on the production line of the mint

The U.S. Bureau of the Mint, a federal agency, produces collectible items such as commemorative coins and medals. Due to prior incidents of theft, a video surveillance was conducted on the production line of the Mint. The video shows what appears to ..

  Benefit from giving employee development opportunities

Why might an organization benefit from giving employee development opportunities to a dysfunctional manager, rather than simply dismissing the manager? Do these reasons apply to non management employees as well?

  Describe similarities and differences between tqm and sigma

Describe the similarities and differences between TQM and Six Sigma quality-management techniques.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd