Hello ,

I need help to solve these questions please.

Consider the following table

YEAR	Rape	Robbery	Felony Assault	Burglary
2006	1525	23739	17309	23143
2007	1351	21809	17493 1	21762
2008	1299	22401	16284	20725
2009	1205	18601	16773	19430
2010	1373	19486	16956	18600
2011	1420	19717	18482	18720
2012	1445	20144	19381	19168
2013	1378	19128	20297	17429
2014	1352	16539	20207	16765
2015	1438	16931	20207	16765
2016	1438	15500	20847	12990

Part II-Forecast 2017

Forecast with a 3 year moving average.

Forecast with exponential smoothing with a smoothing constant of .2.

Forecast with linear regression.

Of the three forecasts, which is the best?

Part III

Detectives are scheduled to work 8 hour shifts. The beginning times for the shifts are 8am, noon, 4pm, 8pm, midnight and 4am. The number of detectives needed varies depending on the time of day. The staffing guidelines require the following minimum of detectives on duty:

8am-noon 5 detectives

noon - 4pm 6 detectives

4pm - 8pm 10 detectives

8pm-midnight 7 detectives

midnight - 4am 4 detectives

4am-8am 6 detectives

Determine the number of detectives that should be scheduled to begin the 8 hour shifts at each of the six times to minimize the total number of detectives required.

Start the schedule at midnight.

Consider the following table

YEAR	Rape	Robbery	Felony Assault	Burglary
2006	1525	23739	17309	23143
2007	1351	21809	17493 1	21762
2008	1299	22401	16284	20725
2009	1205	18601	16773	19430
2010	1373	19486	16956	18600
2011	1420	19717	18482	18720
2012	1445	20144	19381	19168
2013	1378	19128	20297	17429
2014	1352	16539	20207	16765
2015	1438	16931	20207	16765
2016	1438	15500	20847	12990

Part I

Create a dashboard based on 10 years worth (2006-2016) of data for the 4 crimes.

Part II-Forecast 2017

Forecast with a 3 year moving average.

Forecast with exponential smoothing with a smoothing constant of .2.

Forecast with linear regression.

Of the three forecasts, which is the best?

Part III

Detectives are scheduled to work 8 hour shifts. The beginning times for the shifts are 8am, noon, 4pm, 8pm, midnight and 4am. The number of detectives needed varies depending on the time of day. The staffing guidelines require the following minimum of detectives on duty:

8am-noon 5 detectives

noon - 4pm 6 detectives

4pm - 8pm 10 detectives

8pm-midnight 7 detectives

midnight - 4am 4 detectives

4am-8am 6 detectives

Determine the number of detectives that should be scheduled to begin the 8 hour shifts at each of the six times to minimize the total number of detectives required.

Start the schedule at midnight.