Paste Wrap Text Format Painter General Normal Clipboard Merge & Center - Bad Good Font Conditional Format Alignment Formatting y as Table Neutral Calculation A2 Number Check Cell Delete Style Assuming there is an order of 250 shelves for each type starting January 1, 2010 and the company operates 5 days a week having 20 workers, find the following: Assuming there is an order of 250 shelves for each type starting January 1, 2010 and the company operates 5 days a week having 20 workers, find the following: 2 a. How much is the total profit if the job order is completed? b. When is the last day of the completion of the orderf? 3 Bookshelf workscheduling model 5 6 Decision variables: number of employees starting their five-day shift on various days 7 Mon Range names used: 8 Tue 20 Employees_available =Model!SB$23:SH$23 9 Wed Employees_required =Model!SB$25:SH$25 10 Thu Employees_starting =Model!$8$4:$8$10 Total_employees =Model!SB$28 11 Fri 12 iSat 13 Sun 14 15 Number of working hours per day 16 17 Result of decisions: number of employees working on various days (along top) who started their shift on various days (along side) Projecting bookshelf costs at Woodworks 18 Mon Tue Wed Thu Frill Sat Sun 19 Mon 20 20 20 20 Inputs 20 Tue Requirements per bookshelf o Board-feet required 21 Wed 30 Labor hours required 16 22 Thu 28 Fri Cherry 24 |Sat 0 Costs of wood Dak 7.3 25 Sun O current cost per board 26 Total + 27 Constraint on worker availabilities 20 20 20 Current cost per labor hour 28 (Employees available. 20 Hourly Wage rate 29 Average: 13473.4 Count: 193 Sum: 1468600.6 80%% 14 1 2 4.2 Select destination and press ENTER or choose Paste Type here to search O