operations 6&7
wmashles88
ch9hmwkdata.xlsxC9-2
| Problem 2 | |
| Boards/Day | |
| Actual Output | 950 |
| Effective Capacity | 700 |
| Design Capacity | 1000 |
| UtilizationEffective | |
| UtilizationDesign |
C9-8
| Problem 8 | |||||||||
| EV is a weighted avg of the chance events | |||||||||
| EVsmallexpansion | =(0.3*40000)+(0.7*50000) | ||||||||
| EVlargeexpansion | =(0.3*50000)+(0.7*80000) |
C9-10
| Problem 10 | |||
| Create diagram using TreePlan (Excel Addin) | |||
| EVsmallexpansion | =(0.3*50000)+(0.7*90000) | ||
| EVlargeexpansion | =(0.3*70000)+(0.7*100000) |
C9-12
| Problem 12 | |||||
| Factor Score | Weighted Score | ||||
| Factor | Factor Weight | Location 1 | Location 2 | Location 1 | Location 2 |
| Proximity to airport | 40 | 5 | 3 | ||
| Proximity to road access | 30 | 4 | 1 | ||
| Proximity to labor source | 10 | 3 | 5 | ||
| Size of facility | 20 | 2 | 4 | ||
C9-14
| Problem 14 | |||||
| Factor Score | Weighted Score | ||||
| Factor | Factor Weight | Location 1 | Location 2 | Location 1 | Location 2 |
| Proximity to customer | 30 | 5 | 2 | ||
| Proximity to competition | 10 | 4 | 2 | ||
| Proximity to labor supply | 30 | 2 | 5 | ||
| Transportation system | 20 | 5 | 3 | ||
| Quality of life | 10 | 3 | 5 | ||
C9-16
| Problem 16 | |||||
| Town | X | Y | Load | lixi | liyi |
| A | 4 | 18 | 15 | ||
| B | 12 | 2 | 10 | ||
| C | 10 | 8 | 12 | ||
| D | 8 | 15 | 8 | ||
| Xc.g. | |||||
| Yc.g. |
C9-18
| Problem 18 | ||||
| Location | Fixed Costs | Variable Costs/Unit | Total Variable Costs | Total Costs |
| A | $ 85,000 | $ 2 | ||
| B | $ 49,000 | $ 7 | ||
| C | $ 35,000 | $ 10 | ||
| D | $ 65,000 | $ 6 | ||
| Quantity | 3000 | |||
