(20 points) The Brampton Burger Restaurant requires the following number of employees to work at the

French fires workstation on a given Saturday.

Time period	French fries employees needed
11 - noon	1
noon - 1 p.m.	2
1 - 2 p.m.	2
2 - 3 p.m.	1
3 - 4 p.m.	1
4 - 5 p.m.	1
5 - 6 p.m.	1

Employees work shifts that are 3, 5 or 7 hours long and can start work at the beginning of each hour,

starting at 11 a.m. but have to end their shift at 6 p.m. Operations management seeks to minimize total

employee hours used plus the number of work shifts employees use.

Required:

a) Create linear program in Excel to model this work shift scheduling problem.

b) Solve in good form using Excel Solver.