Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. A CFO of a certain retail chain realised that one of the reasons for failing profits is that the shops are closed early. So,
1. A CFO of a certain retail chain realised that one of the reasons for failing profits is that the shops are closed early. So, he decided to move from 2 shifts a day to 3 shifts a day. Every shop requires staff in three departments, namely, Accounts, Front Desk and Supplies and the staff are equally skilled in all departmental activities. He calculated the minimum and maximum number of staff needed for each shift and for each shop in order ensure efficient operation and this information is provided below: Department Shift Accounts Supplies Front Desk Shift 1 (6,8) (4,6) (2,4) Shift 2 (11,12) (11,12) (10,12) Shift 3 (7,12) (7,12) (5,7) The CFO wants to create a schedule that effectively makes use of his staff. The accounts, Supplies and Front desk department need at least 26, 24, and 19 staff respectively and shifts 1, 2 and 3 cannot have more than 22, 32, and 25 staff respectively. Help the CFO to formulate this as an optimisation problem and create a spreadsheet model to determine a feasible schedule with the least number of staff needed for a shop.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started