| ROI Analysis - Assumptions | Customer A - Overview Link | ||||||||||
| ROI analysis for a company similar to Customer A | |||||||||||
| The following data was collected by our consultant during a needs analysis meeting | |||||||||||
| Admin Employees | |||||||||||
| Average Employee Salary | £17,500 | ||||||||||
| NI (10%) | £1,750 | ||||||||||
| Overheads of Employment per Employee | £17,200 | Includes adminstration, management, space, IT support etc. | |||||||||
| Total Cost of Employment per Employee | £36,450 | ||||||||||
| Productive Hours per Day | 6.50 | ||||||||||
| Sickness pa | 13.00 | National average is 14 | |||||||||
| Bank Holidays pa | 8.00 | ||||||||||
| Annual Leave pa | 22.00 | ||||||||||
| Total Employee Cost per Productive Hour | £25.84 | ||||||||||
| Documents | |||||||||||
| # Document Titles | 20 | ||||||||||
| Versions Each pa | 4 | ||||||||||
| # Concurrent Versions | 2 | ||||||||||
| Components per Document | 5.00 | Tabs, Covers etc. | |||||||||
| Average Document Manufacturing Cost | £18.00 | ||||||||||
| Average ReStock Qty | 50 | ||||||||||
| Non-Document Items | |||||||||||
| # Stock Lines | 5 | ||||||||||
| Average Manufacturing Cost | £2.00 | ||||||||||
| Average ReStock Qty | 1000 | ||||||||||
| Orders | |||||||||||
| Restock Orders pa | 337 | ||||||||||
| Pallet/Restock Order | 1.00 | ||||||||||
| Shipping Orders pa | 500 | ||||||||||
| Documents per Ship Order | 6.00 | ||||||||||
| Non-Doc Items per Ship Order | 12.00 | ||||||||||
| Packaging Cost per Ship Order | £1.00 | ||||||||||
| Shipping Cost per Order | £7.50 | ||||||||||
| Manufacturing Cost per Order | £132.00 | ||||||||||
| # Consignment Progressed pa | 500 | ||||||||||
| Efficiency | |||||||||||
| Turnaround Missed Delegates or Packs | 5% | ||||||||||
| Stock Redundancy | 10% | ||||||||||
| Tracking Inability re-sends | 3% | ||||||||||
| Errors - resend | 3% | ||||||||||
| Complaints | 3% | ||||||||||
| Disatisfaction Effect on Re-orders | 5% | ||||||||||
| Maverick Spending | 10% | ||||||||||
| Other | |||||||||||
| GP Markup (%) of Total Costs | 125.00% | ||||||||||
| Rent/Rates Warehouse/Office £'s per sq ft | £20.00 | ||||||||||
| Space sq ft | 750 | ||||||||||