Brewers at Singh Brewery work full-time or part-time. Full-time employees work either 8 AM to 4...

Transcribed Image Text:

Brewers at Singh Brewery work full-time or part-time. Full-time employees work either 8 AM to 4 PM, 11 AM to 7 PM, or 1 PM to 9 PM. The shifts of part-time employees are 12 PM to 4 PM or 3 PM to 8 PM. Employees working full-time take an hour meal break at 12 PM, 4 PM, or 5 PM, respectively. Employees working part-time do not receive a meal break. Full-time employees are paid $28.50 an hour while part-timers make $26.25 an hour. Breaks are unpaid. The brewery cannot schedule more than four part-time shifts and must schedule the number of employees required for each 1-hour-block as shown below. Only full shifts are scheduled. Develop a simplex LP Solver model to determine how the brewery can minimize daily labor costs. Hour # Required 8 AM-9 AM 1 9 AM-10 AM 1 10 AM-11 AM 2 11 AM-12 PM 3 12 PM-1 PM 1 PM-2 PM 2 PM-3 PM 4 3 PM-4 PM 4 PM-5 PM 5 PM-6 PM 6 PM-7 PM 7 PM-8 PM 3 8 PM-9 PM 666 m m Brewers at Singh Brewery work full-time or part-time. Full-time employees work either 8 AM to 4 PM, 11 AM to 7 PM, or 1 PM to 9 PM. The shifts of part-time employees are 12 PM to 4 PM or 3 PM to 8 PM. Employees working full-time take an hour meal break at 12 PM, 4 PM, or 5 PM, respectively. Employees working part-time do not receive a meal break. Full-time employees are paid $28.50 an hour while part-timers make $26.25 an hour. Breaks are unpaid. The brewery cannot schedule more than four part-time shifts and must schedule the number of employees required for each 1-hour-block as shown below. Only full shifts are scheduled. Develop a simplex LP Solver model to determine how the brewery can minimize daily labor costs. Hour # Required 8 AM-9 AM 1 9 AM-10 AM 1 10 AM-11 AM 2 11 AM-12 PM 3 12 PM-1 PM 1 PM-2 PM 2 PM-3 PM 4 3 PM-4 PM 4 PM-5 PM 5 PM-6 PM 6 PM-7 PM 7 PM-8 PM 3 8 PM-9 PM 666 m m

Answer rating: 100% (QA)

Formulas used Use Exce... View the full answer