Excel and operation management
bahanshla3
ch2_productivity_measures.xlsExhibit 2.5
| Exhibit 2.5 - Productivity measures | |||||
| Input and Output Production Data($) | Product Measure Examples | ||||
| Output | Total Measure | ||||
| 1. Finished units | $10,000 | 0.89 | |||
| 2. Work in process | $2,500 | ||||
| 3. Dividends | $1,000 | ||||
| 4. Bonds | Multifactor measures: | ||||
| 5. Other income | 4.28 | ||||
| Total outputs = | $13,500 | ||||
| 3.17 | |||||
| Input | |||||
| 1. Human | $3,000 | ||||
| 2. Material | $153 | ||||
| 3. Capital | $10,000 | Partial measures | 25.00 | ||
| 4. Energy | $540 | 18.52 | |||
| 5. Other expenses | $1,500 | ||||
| Total inputs = | $15,193 |
Total output/Total input
Total output/(Human+Material) = 13,500/3,153
Finished units/(Human+Material) = 10,000/3,153
Total output/Energy = 13,500/540
Finished units/Energy = 10,000/540
