Justification-MVP-Plant-NEW

Does your maintenance department spend its time fighting fires, lack the technology making maintenance-related jobs easier or struggle to see a clear maintenance picture? If so, then look no further. CMMS Data Group is here to help. Complete the spreadsheet below to see your Return on Investment in MVP Plant.

Data Entry Field (Enter a value in each yellow field, where applicable.):
Calculated Field (Blue fields will automatically calculate for you.):
Labor
1. How many full-time maintenance employees do you have?
2. How many hours, on average, does each full-time maintenance employee work per week?
3. How many part-time maintenance employees does you have?
4. How many hours, on average, does each part-time maintenance employee work per week?
5. What is Accounting's hourly burden rate for Maintenance?
6. What % of total work time does maintenance employees spend on the following:
a. Waiting for, looking for, and/or ordering parts.
1-3%: Basic System - Managed by Software
4-6%: Basic System - Managed by Paper
7-9%: No System in Use
b. Waiting for work assignments (job information and instructions).
1-3%: Basic System - Managed by Software
4-6%: Basic System - Managed by Paper
7-9%: No System in Use
c. Changing work assignments due to poor instructions or lack of scheduling/prioritization.
1-3%: Basic System - Managed by Software
4-6%: Basic System - Managed by Paper
7-9%: No System in Use
Total Annual Maintenance Labor Hours:
Total % of Time Spent Inefficiently:
Total Annual No. of Lost Maintenance Hours:
Total No. of Full-Time Maintenance Employees Lost Per Year Due to Inefficiency:
Total Annual Labor Savings:
Inventory
1. What is the value of your current inventory?
2. What is the value of inventory purchased last year?
3. Enter the corresponding % for one of the following existing conditions:
1-3%: Basic System - Managed by Software
4-6%: Basic System - Managed by Paper
7-9%: No System in Use
One-Time Inventory Reduction Savings:
Savings on Duplicated & Expedited Purchasing:
Total Inventory Savings:
Critical Equipment Downtime
1. What % of critical equipment downtime was charged to Maintenance last year?
GUIDE: Use 10% if you do not know.
2. What is the projected number of production hours for next year's critical equipment?
3. What is the average cost per hour for critical equipment downtime?
GUIDE: Add the hourly downtime cost for all critical equipment and divide it by the total number of pieces of critical equipment.
4. Enter the corresponding % for one of the following existing conditions:
1-3%: Basic System - Managed by Software
4-6%: Basic System - Managed by Paper
7-9%: No System in Use
Total Projected Annual No. of Critical Equipment Downtime Hours:
Total Projected Annual Critical Equipment Downtime Hours Saved:
Total Projected Annual Critical Equipment Downtime Savings:
Implementation
Enter the anticipated cost of each of the following from your quote:
1. Software
2. Hardware
4. Training & Consulting
5. Annual Subscription and/or Support
Total Implementation Costs:
Summary
1. Overall 1st Year Savings
2. Total Implementation Costs
Grand Total Savings:
Payback Period (months):