1.The demand for Pepsi at a local store is shown in the table below. Forecast the demand for 2018, using a smoothing constant for the average of 0.3, and a smoothing constant for the trend of 0.2. The forecast for 2012 is 200 units and the trend for 2012 is 60 units.

Year Demand

2012 200

2013 300

2014 500

2015 600

2016 800

2017 1000

2.Using the Forecast of Question 1, find the following types of error

a.Mean Absolute Deviation (MAD)

b.Mean Squared Error (MSE)

c. Mean Absolute PercentageError(MAPE)

3.Starbucks coffee shop wants to buy espresso machines.A local dealer has offered them the following packages:

The Lite Package:2 espresso machines for USD 80,000.Output range:0 - 1000 cups.

The Popular Package: 4 espresso machines for USD 140,000.Output range 0 - 2000 cups.

The Master Package:6 espresso machines for USD 160,000.Output range 0 -3000 cups.

The store plans to charge USD 150 per espresso-based drink.Its cost of making each drink is USD 50.Forecast demand is 1500 cups to 1700 cups.Considering the information, you have, which package do you recommend?Why?

4.Given below is a table is showing Electricity usage of a Hospital. Find out the forecast for the next seven days' electricity usage.Perform all calculations to zero decimal points.

Day Electricity Usage Actual

1 1284

2 1385

3 1266

4 1308

5 1254

6 1235

7 1328

8 1229

5. Yudu Bank employs three loan officers. Each officer processes an average of five loans per day. The bank's payroll cost for the officers is USD 65,600 per day, and there is a daily overhead expense of USD 40,000. Compute the multi factor productivity, using loans per dollar cost as the measure.