Solve Using Exel- Assignments- Formulas
P4-46
| Police force scheduling | ||||||
| Starting 4 hours of 8-hour shift | ||||||
| M-4A | 4A-8A | 8A-N | N-4P | 4P-8P | 8P-M | |
| Number starting | ||||||
| Number available each 4-hour period | ||||||
| Number required | ||||||
| Total employed | ||||||
Problem 3.2
P4-48
| Producing drugs | |||
| Cost/lb of chemicals | |||
| Chemical 1 | |||
| Chemical 2 | |||
| Chemical 3 | |||
| Chemical 4 | |||
| Ingredient/lb of chemical | |||
| A | B | C | |
| Chemical 1 | |||
| Chemical 2 | |||
| Chemical 3 | |||
| Chemical 4 | |||
| Required percentages of ingredients | |||
| A | B | C | |
| Production plan | |||
| Lbs used | Required | ||
| Chemical 1 | |||
| Chemical 2 | |||
| Chemical 3 | |||
| Chemical 4 | |||
| Total | |||
| Percentage constraints (expressed in lbs) | |||
| A | B | C | |
| Actual | |||
| Required | |||
| Cost |
Problem 3.5
P4-50
| Selling oranges and orange juice | |||||
| Revenues, variable costs | |||||
| Juice | Bags | ||||
| Revenue | |||||
| Variable cost | |||||
| Grades used to make juice and bags | |||||
| Grade | Juice | Bags | Used | Available | |
| Sold | |||||
| Required average quality | |||||
| Juice | Bags | ||||
| Quality constraints | |||||
| Juice | Bags | ||||
| Actual | |||||
| Required | |||||
| Total variable cost | |||||
| Total revenue | |||||
| Profit |
Problem 3.7