Staff Scheduling: Security Guard Scheduling Problem Answer the questions below based on the 24-7 Mall staff scheduling example shown in class. Use it to find the fewest number of workers as you can using manual "trial and error" methods. Lamorinda Mall is a small shopping center. It needs only two guards on duty most of the time but it needs four during some times of the week as shown in the yellow "DEMAND MATRIX A" matrix below. Only full time officers are permitted. They work 8 consecutive hours per day, 5 consecutive days per week. 'Note: This could be a hospital, a hotel, or any other operation open 24/7.) The current mall manager compiled the schedule manually as shown in the NUMBER STARTING MATRIX B. Each guard costs $150,000 per year including wages and benefits. The town council is trying to balance its budget and has asked if the chief can design a schedule to meet the demand with fewer officers. The number of officers currently on the force is: The current annual cost of the guard wages is therefore: $5,400,000 As a new management trainee, you have been asked to help analyze this problem and determine if there any way to reduce the cost of the guards. A. Build the Number on Duty and Surpluses/Shortages matrices. Use them to determine how much time is being wasted in surplus hours with the current schedule? Answer: Surplushours = B. Can you find a new schedule that will meet the demands with a fewer number of guards (with no shortages). Any answer saving at least four guards will be given full credit. You answers should appear in the green Number Starting matrix. Show your answer in your new model in the green Number Starting matrix. Demand Matrix DEMAND MATRIX A: Enter t Time 12AM-2AM Staff Scheduling: Security Guard Scheduling Problem Answer the questions below based on the 24-7 Mall staff scheduling example shown in class. Use it to find the fewest number of workers as you can using manual "trial and error" methods. Lamorinda Mall is a small shopping center. It needs only two guards on duty most of the time but it needs four during some times of the week as shown in the yellow "DEMAND MATRIX A" matrix below. Only full time officers are permitted. They work 8 consecutive hours per day, 5 consecutive days per week. 'Note: This could be a hospital, a hotel, or any other operation open 24/7.) The current mall manager compiled the schedule manually as shown in the NUMBER STARTING MATRIX B. Each guard costs $150,000 per year including wages and benefits. The town council is trying to balance its budget and has asked if the chief can design a schedule to meet the demand with fewer officers. The number of officers currently on the force is: The current annual cost of the guard wages is therefore: $5,400,000 As a new management trainee, you have been asked to help analyze this problem and determine if there any way to reduce the cost of the guards. A. Build the Number on Duty and Surpluses/Shortages matrices. Use them to determine how much time is being wasted in surplus hours with the current schedule? Answer: Surplushours = B. Can you find a new schedule that will meet the demands with a fewer number of guards (with no shortages). Any answer saving at least four guards will be given full credit. You answers should appear in the green Number Starting matrix. Show your answer in your new model in the green Number Starting matrix. Demand Matrix DEMAND MATRIX A: Enter t Time 12AM-2AM