BUSN 6250 - DECISION ANALYSIS (EXCEL TYPE QUESTION)

Tab #2 Dog River Christmas Carnival Every year in Dog River, Saskatchewan they hold a Christmas Carnival. It can get quite boisterous, so over at the Dog River Police Department, Davis Quinton has asked Karen Pelly (who in turn has asked you) to have a security detail schedule for the Carnival.

Seasonal security staff are hired to work two 6-hour shifts chosen from 12 am to 6 am, 6 am to 12 pm, 12 pm to 6 pm, and 6 pm to 12 pm. The following number of security staff are needed during each shift: 12 am to 6 am 15 staff, 6 am to 12 pm 5 staff, 12 pm to 6 pm 12 staff, and 6 pm to 12 am 6 staff. Workers whose two shifts are consecutive are paid 12 $/hr, while staff whose shifts are not consecutive are paid an additional 6 $/hr premium on top of the usual wage.

The Dog River Christmas Carnival Organizing Committee (DRCCOC) wants to provide the required security coverage while minimizing the overall cost.

In a Text Box on your worksheet tab, type out the decision variables, objective function, and constraints.

Solve the problem of course, then

interpret the findings with a short summary (sentence or two) that Karen can give to Davis to give to Fitzy (the Mayor of Dog River) about how to meet the staffing requirements.