Help with Optimization and Decision Support Modeling for Business HW1
Redhand
HW1_Template.xlsxQ1-d
| Wood-framed | Aluminum-framed | ||||
| Unit Profit | |||||
| Square-feet Used Per Unit Produced | Used | Available | |||
| Glass | <= | ||||
| Wood-framed | Aluminum-framed | Total Profit | |||
| Units Produced | |||||
| <= | <= | ||||
Q2-c
| Special Risk | Mortgage | ||||
| Unit Profit | |||||
| Work-Hours | Work-Hours | ||||
| Work-Hours per Unit | Used | Available | |||
| Underwriting | <= | ||||
| Administration | <= | ||||
| Claims | <= | ||||
| Special Risk | Mortgage | Total Profit | |||
| Sales Quota |
Q3-a
| Bread | Peanut Butter | Jelly | Milk | Juice | |||||||
| (slice) | (tbsp) | (tbsp) | Apples | (cup) | (cup) | ||||||
| Unit Cost | |||||||||||
| Nutritional Data | Total in Diet | ||||||||||
| Calories from Fat | Needed | Maximum | |||||||||
| Calories | >= | <= | |||||||||
| Vitamin C (mg) | >= | ||||||||||
| Fiber (g) | >= | ||||||||||
| Bread | Peanut Butter | Jelly | Milk | Juice | |||||||
| (slice) | (tbsp) | (tbsp) | Apples | (cup) | (cup) | Total Cost | |||||
| Diet (ounces) | |||||||||||
| >= | >= | >= | |||||||||
| Minimums | |||||||||||
| Fat Calories | <= | of Total Calories | |||||||||
| Milk and Juice | >= |
