Question
Write answer in the given answer form. Part 1: Table 1 summarizes the average monthly wage for China and Mexico from the year 1999 to
Write answer in the given answer form.
Part 1:
Table 1 summarizes the average monthly wage for China and Mexico from the year 1999 to the year 2010. Forecast monthly wage for China and Mexico from the year 2011 to the year 2015 using Table 1 data.
Table 1: Average Monthly Wages
China (CNY) | Mexico (MXN) | |
1999 | 649.5 | 2392 |
2000 | 729.2 | 2910.5 |
2001 | 814.5 | 3367.6 |
2002 | 916.8 | 3537.5 |
2003 | 1041.3 | 3737.7 |
2004 | 1169.4 | 3858.8 |
2005 | 1313.1 | 3983.8 |
2006 | 1497.2 | 4112.9 |
2007 | 1740.3 | 4246.2 |
2008 | 2016 | 4387.7 |
2009 | 2187.3 | 4514.6 |
2010 | 2289.7 | 4649.8 |
Part 2:
Table 2 summarizes the exchange rate for China/USD and Mexico/USD from the year 2000 to the year 2010. Forecast the exchange rate for China/USD and Mexico/USD for China and Mexico from the year 2011 to the year 2015 using Table 2 data.
Table 2: Exchange Rate History.
CNY/USD | MXN/USD | |
2000 | 8.279 | 9.46 |
2001 | 8.277 | 9.33 |
2002 | 8.277 | 9.67 |
2003 | 8.277 | 10.79 |
2004 | 8.277 | 11.29 |
2005 | 8.194 | 10.88 |
5006 | 7.973 | 10.91 |
2007 | 7.608 | 10.93 |
2008 | 6.949 | 11.15 |
2009 | 6.831 | 13.07 |
2010 | 6.770 | 12.62 |
Part 3:
Case Study (Specialty Packing Corporation: P 202 -203)
Answer the following questions:
- Which forecasting method is the best for Black Plastic Demand forecasting? Why?
Estimate the forecasting error based on MSE.
- Which forecasting method is the best for Clear Plastic Demand forecasting? Why?
Estimate the forecasting error based on MSE.
- Using the method selected, forecast demand for years 6 and 7.
Year | Quarter | Black Plastic | Clear Plastic |
6 | Q1 | ||
Q2 | |||
Q3 | |||
Q4 | |||
7 | Q1 | ||
Q2 | |||
Q3 | |||
Q4 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started