Homework \#4 (Due date: Apr. 21 1st,2023 ) 1. Mega Pizza store's demands for pizza for the last 5 months were 450,360,280,150,90. Using a forecast of the first month of 500 , an initial trend forecast of 100 , and smoothing parameter of 0.5 for the demand smoothing and 0.5 for the trend smoothing, forecast for the demand for the next month? (40/100) 2. Mt. Bear is a ski resort in California. Many guests visit there; however, most of them come in the winter season because of the phenomenal skiing. A group of hotels has analyzed their demand for the last three years (see the table below). (60/100) Using a smoothing parameter of 0.3 and an initial forecast of 18,000, forecast demand for the four quarters in 2023 (If you use Excel spreadsheet in your problem-solving, you must submit screenshots or scans or photos of your Excel spreadsheet.). Homework \#4 (Due date: Apr. 21 1st,2023 ) 1. Mega Pizza store's demands for pizza for the last 5 months were 450,360,280,150,90. Using a forecast of the first month of 500 , an initial trend forecast of 100 , and smoothing parameter of 0.5 for the demand smoothing and 0.5 for the trend smoothing, forecast for the demand for the next month? (40/100) 2. Mt. Bear is a ski resort in California. Many guests visit there; however, most of them come in the winter season because of the phenomenal skiing. A group of hotels has analyzed their demand for the last three years (see the table below). (60/100) Using a smoothing parameter of 0.3 and an initial forecast of 18,000, forecast demand for the four quarters in 2023 (If you use Excel spreadsheet in your problem-solving, you must submit screenshots or scans or photos of your Excel spreadsheet.)