Reference no: EM131921753
For problems 1 and 2, use the following set of seasonal factors. Use 1200 for the starting deseasonal forecast (meaning, as of January 1, 2013) for problem 1. Seasonal factors for use in this problem set:
1. In January '13, seasonal actual demand came in at 1650 cases. Setting ? = 0.3, what will the new smoothed forecast be? What will the new seasonal forecasts be for February, April, July, and December?
2. In February '13, seasonal actual demand came in at 410 cases. What will the new smoothed forecast be? What are the new seasonal forecasts for March, April, July, and December?
3. March Demand comes in at 395. What will be the new smoothed (deseasonal) forecast? What are the new seasonal forecasts for April, July, and December?
4. April demand comes in at 745. What will be the new smoothed (deseasonal) forecast? What are the new seasonal forecasts for May, July, December?
Discussion Question: You have three years of historical sales data for the product that you forecasted in problems 1 through 4.
Based upon this data, do you think that the starting deseasonal forecast (as of January 1, 2013) of 1200 for problem 1 is reasonable?
Do you see any year-to-year trends? What about the given seasonality factors? (HINT: calculate the monthly seasonal factors for each of the past three years. Plot these factors on a graph.
Use a different color for each year. Do they look consistent? Do you notice any trends?)
HISTORICAL DEMAND FOR CASES OF SMART CARDS (USED IN DIGITAL CAMERAS)
|
Month
|
2010
|
2011
|
2012
|
|
Jan
|
1500
|
1510
|
1960
|
|
Feb
|
300
|
350
|
340
|
|
Mar
|
400
|
480
|
450
|
|
AN
|
600
|
630
|
760
|
|
May
|
1500
|
1700
|
1760
|
|
Am
|
1400
|
1540
|
1410
|
|
Jul
|
1000
|
1380
|
1600
|
|
Aug
|
1400
|
1540
|
1410
|
|
Sep
|
900
|
980
|
980
|
|
Oct
|
500
|
530
|
630
|
|
Nov
|
500
|
530
|
630
|
|
Dec
|
2000
|
2330
|
2270
|
|
Total
|
12000
|
13500
|
14200
|
|
Develop an analysis of the investments
: Develop an analysis of these three investments in Excel. Use expected value to determine which of the three alternatives you should choose.
|
|
Make a compelling argument for position
: You will need to make a compelling argument for your position, and use at least one source to support your perspective.
|
|
Analyze how would pangloss fit into sades novel justine
: Analyze how would Pangloss fit into Sade's novel Justine? How would he philosophise in the world of the libertine?
|
|
Cash flow be under proposed capital structure of firm
: FCOJ, Inc., a prominent consumer products firm, What will Melanie’s cash flow be under the proposed capital structure of the firm?
|
|
What are the new seasonal forecasts for may
: April demand comes in at 745. What will be the new smoothed (deseasonal) forecast? What are the new seasonal forecasts for May, July, December?
|
|
How did the newspaper and writers encourage imperialism
: What part did missionaries play in imperialism, How did the newspaper and writers encourage imperialism?
|
|
Identify each cost as being variable or mixed
: Identify each cost as being variable, fixed, or mixed. Use the high-low method to develop a schedule identifying the amount of each cost that is mixed.
|
|
When longer quotations are set off in actual separate lines
: When longer quotations are set off in actual separate lines, don't use slash marks between lines. Was merely a place by which she walked to sing.
|
|
Explain the main concepts of cloud computing
: Prepare a PowerPoint briefing for the Regional Gardens board - Explain the main concepts of Cloud Computing and why you think that a move to the Cloud
|