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
Get step-by-step solutions from verified subject matter experts
