operations management excel problems
wmashles88
ch2hmwk.xlsx2-P2
| Chapter 2-Problem 2 | ||||||
| Productivity Ratios | ||||||
| Week 1 | 3 | houses | 5 | days | 0.600 | houses/day |
| Week 2 | 2 | houses | 4 | days | 0.500 | houses/day |
| Productivity=Ouput/Input |
Chapter 2 Solutions-&A
&P of &N
2-P4
| Chapter 2-Problem 4 | ||||||
| Productivity Ratios | ||||||
| Facility 1 | 240 | chairs | 6 | workers | 40.0 | chairs/wkr |
| Facility 2 | 210 | chairs | 4 | workers | 52.5 | chairs/wkr |
| Productivity=Ouput/Input |
Chapter 2 Solutions-&A
&P of &N
2-P6
| Chapter 2-Problem 6 | ||||||
| Productivity Ratios | ||||||
| Old process | 60 | pieces | 1 | day | ||
| Defects | 10 | pieces | 1 | day | defect/day | |
| Total produced | 50 | pieces | 1 | day | pieces/day | |
| New process | 90 | pieces | 1 | day | ||
| Defects | 1 | pieces | 1 | day | defect/day | |
| Total produced | 89 | pieces | 1 | day | pieces/day | |
| Change in Productivity | increase in productivity | |||||
| Change in Defects | decrease in defects |
Chapter 2 Solutions-&A
&P of &N
2-P8
| Chapter 2-Problem 8 | ||||||
| Cost per patient | patient | |||||
| Labor | $ 15 | patient | ||||
| Materials | $ 20 | patient | ||||
| Overhead | $ 20 | patient | ||||
| Multifactor Productivity | 1.09 | (Markup is ~9% over costs) | ||||
| Labor Productivity | $ 60.00 | dol | 3 | hours | $ 20.00 | per hr |
Chapter 2 Solutions-&A
&P of &N
