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:

  1. Which forecasting method is the best for Black Plastic Demand forecasting? Why?

Estimate the forecasting error based on MSE.

  1. Which forecasting method is the best for Clear Plastic Demand forecasting? Why?

Estimate the forecasting error based on MSE.

  1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!