Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Authentication
digital resources
572x Filetype XLSX File size 0.03 MB Source: irp-cdn.multiscreensite.com
Sheet 1: Example
| Project Cost vs. ROI Calculation | ||||||||
| Project Cost | Hours | Cost | ||||||
| Tooling | $200.00 | Manual Input | ||||||
| Material | $400.00 | Automatic Calculation | ||||||
| Labor: | Engineering ($75.00 hr) | 20 | $1,500.00 | |||||
| Welding ($60.00 hr) | 30 | $1,800.00 | ||||||
| Machining ($60.00 hr) | 10 | $600.00 | ||||||
| Assembly ($22.40 hr) | 3 | $67.20 | ||||||
| Inspection ($22.40 hr) | 2 | $44.80 | ||||||
| Material Handling ($22.40 hr) | 3 | $67.20 | ||||||
| Painting ($22.40 hr) | 1 | $22.40 | ||||||
| Total Project Cost | $4,500.00 | |||||||
| Cost Saving | Operation | Minutes Saved Per Part | Hours Saved Per Part | Monthly Volume | Monthly Savings | Annual Volume | Annual Savings | |
| Machinist Time ($60.00 hr) | 2 | 0.03 | 50 | $100.00 | 600 | $1,200.00 | ||
| Welder Time ($60.00 hr) | 2 | 0.03 | $100.00 | $1,200.00 | ||||
| Material Handling Time ($22.40 hr) | 2 | 0.03 | $37.33 | $448.00 | ||||
| Engineering Time ($75.00 hr) | 2 | 0.03 | $125.00 | $1,500.00 | ||||
| Quality/Inspection Time ($22.40 hr) | 2 | 0.03 | $37.33 | $448.00 | ||||
| Painter Time ($22.40 hr) | 2 | 0.03 | $37.33 | $448.00 | ||||
| Motion/Walking ($22.40 hr) | 2 | 0.03 | $37.33 | $448.00 | ||||
| Assembly Time ($22.40 hr) | 2 | 0.03 | $37.33 | $448.00 | ||||
| Monthly Savings | $511.67 | Annual Savings | $6,140.00 | |||||
| ROI | Months | Savings Totals | Project Cost | |||||
| 1 | $511.67 | $4,500.00 | ||||||
| 2 | $1,023.33 | $4,500.00 | ||||||
| 3 | $1,535.00 | $4,500.00 | ||||||
| 4 | $2,046.67 | $4,500.00 | ||||||
| 5 | $2,558.33 | $4,500.00 | ||||||
| 6 | $3,070.00 | $4,500.00 | ||||||
| 7 | $3,581.67 | $4,500.00 | ||||||
| 8 | $4,093.33 | $4,500.00 | ||||||
| 9 | $4,605.00 | $4,500.00 | ||||||
| 10 | $5,116.67 | $4,500.00 | ||||||
| 11 | $5,628.33 | $4,500.00 | ||||||
| 12 | $6,140.00 | $4,500.00 | ||||||
| 13 | $6,651.67 | $4,500.00 | ||||||
| 14 | $7,163.33 | $4,500.00 | ||||||
| 15 | $7,675.00 | $4,500.00 | ||||||
| 16 | $8,186.67 | $4,500.00 | ||||||
| 17 | $8,698.33 | $4,500.00 | ||||||
| 18 | $9,210.00 | $4,500.00 | ||||||
| 19 | $9,721.67 | $4,500.00 | ||||||
| 20 | $10,233.33 | $4,500.00 | ||||||
no reviews yet
Please Login to review.
