calculate the demand for next four quarters for Ethiopia. Use the different forecasting techniques, perform error...

 

Transcribed Image Text:

calculate the demand for next four quarters for Ethiopia. Use the different forecasting techniques, perform error analysis and select the technique that is best. Table 1: demand in thousands per country over the past eight quarters Quarter Brazil Russia India China South Africa 2017Q4 3 7 9 10 201801 4 5 10 201802 5 6 11 2018Q3 7 6 12 2018Q4 6 8 15 8 16 8 17 9 18 10 21 12 22 11 25 13 24 2019Q1 5 2019Q2 6 2019Q3 8 2019Q4 7 202001 4 202002 6 202003 7 11 13 15 17 18 20 22 22 22 24 26 1.6 1.5 2.3 3.8 2.1 2.3 3.7 4.1 3.9 4.6 5.1 5.9 Ethiopia 1.7 2.1 2.5 3.4 2.7 3.1 3.3 3.8 4.1 3.8 4.4 5.2 Section 2) BRICS & Ethiopia have decided to collaborate and select the combination of sites that is collectively most profitable (lowest cost). Determine the network design (use approach in Chapter 5). Use the projected annual demand based on calculations in section 1 to fill in the blank slot in the table below for demand (annual demand in thousands of units). Table 2: Production & Transportation cost (cost per thousand units produced) In hundreds of US$ Brazil Russia Brazil Russia India China S Africa Ethiopia Demand 23 65 60 60 40 26 25 65 29 40 40 65 60 45 India China South Africa 40 65 39 40 19 26 14 60 40 20 30 39 60 70 60 40 30 25 40 65 80 Ethiopia 27 60 58 61 23 18 fixed cost 1500 low capacity 50 2000 50 1800 50 2000 1500 50 00 50 1400 50 fixed high cost 4000 150 5000 150 4000 150 4500 150 3500 150 3200 150 capacity calculate the demand for next four quarters for Ethiopia. Use the different forecasting techniques, perform error analysis and select the technique that is best. Table 1: demand in thousands per country over the past eight quarters Quarter Brazil Russia India China South Africa 2017Q4 3 7 9 10 201801 4 5 10 201802 5 6 11 2018Q3 7 6 12 2018Q4 6 8 15 8 16 8 17 9 18 10 21 12 22 11 25 13 24 2019Q1 5 2019Q2 6 2019Q3 8 2019Q4 7 202001 4 202002 6 202003 7 11 13 15 17 18 20 22 22 22 24 26 1.6 1.5 2.3 3.8 2.1 2.3 3.7 4.1 3.9 4.6 5.1 5.9 Ethiopia 1.7 2.1 2.5 3.4 2.7 3.1 3.3 3.8 4.1 3.8 4.4 5.2 Section 2) BRICS & Ethiopia have decided to collaborate and select the combination of sites that is collectively most profitable (lowest cost). Determine the network design (use approach in Chapter 5). Use the projected annual demand based on calculations in section 1 to fill in the blank slot in the table below for demand (annual demand in thousands of units). Table 2: Production & Transportation cost (cost per thousand units produced) In hundreds of US$ Brazil Russia Brazil Russia India China S Africa Ethiopia Demand 23 65 60 60 40 26 25 65 29 40 40 65 60 45 India China South Africa 40 65 39 40 19 26 14 60 40 20 30 39 60 70 60 40 30 25 40 65 80 Ethiopia 27 60 58 61 23 18 fixed cost 1500 low capacity 50 2000 50 1800 50 2000 1500 50 00 50 1400 50 fixed high cost 4000 150 5000 150 4000 150 4500 150 3500 150 3200 150 capacity

Answer rating: 100% (QA)

Section 1 Forecasting Demand for Ethiopia To forecast demand for Ethiopia over the next four quarters we can use different forecasting techniques Lets start by calculating the forecast using a simple ... View the full answer