Total Operational Cost
31,006.39
-22.4%Reduced from 39,948.74
Total Revenue
24,000.00
Monthly projection stable
Net Profit/Loss
-7,006.39
+56% ImprovementLoss reduced by 8,942.35
Restructuring Savings %
22.38%
Total overhead reduction
Department Cost Breakdown
| Department | Current Cost | New Cost | Savings | Savings % | Status |
|---|---|---|---|---|---|
| Development | 19,250.00 | 12,000.00 | 7,250.00 | 37.66% | ↓ REDUCED |
| Support | 2,930.45 | 2,930.45 | 0.00 | 0.00% | → NO CHANGE |
| Management | 7,461.79 | 5,769.44 | 1,692.35 | 22.68% | ↓ REDUCED |
| Hosting | 10,306.50 | 10,306.50 | 0.00 | 0.00% | → NO CHANGE |
| TOTAL | 39,948.74 | 31,006.39 | 8,942.35 | 22.38% | - |
Product Profitability Breakdown
| Product Line | Revenue | New Operational Cost | Old Profit/Loss | New Profit/Loss | Status |
|---|---|---|---|---|---|
| TP/OO/API + Auto | 20,000.00 | 15,467.84 | -1,412.26 | +4,532.16 | PROFITABLE |
| TMS/Mobile | 4,000.00 | 7,442.13 | -6,440.06 | -3,442.13 | IMPROVING |
| Alex/Motqan/Wap | 0.00 | 8,096.42 | -8,096.42 | -8,096.42 | COST CENTER |
Full Cost Allocation Matrix
| Category | Current Cost Breakdown | New Cost Breakdown | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Class | Total | TP/OO/API | TMS/Mobile | Alex/Motqan | Auto | Total | TP/OO/API | TMS/Mobile | Alex/Motqan | Auto |
| Development | 19,250.00 | 6,850.00 | 5,300.00 | 5,475.00 | 1,625.00 | 12,000.00 | 2,650.00 | 2,650.00 | 5,575.00 | 1,125.00 |
| Support | 2,930.45 | 1,793.38 | 748.56 | 388.51 | 0.00 | 2,930.45 | 1,793.38 | 748.56 | 388.51 | 0.00 |
| Hosting | 10,306.50 | 6,728.00 | 2,863.50 | 715.00 | 0.00 | 10,306.50 | 6,728.00 | 2,863.50 | 715.00 | 0.00 |
| Management | 7,461.79 | 2,461.00 | 2,291.00 | 2,202.00 | 506.00 | 5,769.44 | 2,671.46 | 1,180.07 | 1,417.91 | 500.00 |
| TOTAL COST | 39,948.74 | 21,412.26 | 10,440.06 | 8,096.42 | 2,131.00 | 31,006.39 | 15,467.84 | 7,442.13 | 8,096.42 | 1,625.00 |
Personnel Allocation & Changes
| Name | Title | Action | Current Util. | New Util. | Cost Impact |
|---|---|---|---|---|---|
| Maha | SW Team Lead | Utilization Change | 100% TP/OO/API | 50% TP, 50% Alex | 0.00 |
| Reda | SW Team Lead | Utilization Change | 100% TMS/Mobile | 50% TMS, 50% Alex | 0.00 |
| Mohamed Farouk | Developer | No longer required | 100% TP/OO/API | 0% | -1,250.00 |
| MennatAllah Raafat | Developer | No longer required | 100% Alex/Motqan | 0% | -2,000.00 |
| Mohamed Yasser | Developer | No longer required | 100% Alex/Motqan | 0% | -1,250.00 |
| Bayan Maged | Automation | Stable | 50% Alex, 50% Auto | Unchanged | 0.00 |
| Faten | Tester | Utilization Change | 40% TP, 20% TMS, 40% Alex | 20% TP, 20% TMS, 60% Alex | 0.00 |
| Ahmed Mahdy | Tester | No longer required | 40% TP, 20% TMS, 40% Alex | 0% | -750.00 |
| Management | SW Management | Reduce Cost | Base: 4,000 | Base: 2,000 | -2,000.00 |