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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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