Project Management Plan
money017
ProjectBudgetandProjectManagementSchedule.xlsBudget Summary
| Cosmo Inc. IoT Product and Wearable Market Expansion Project | |||||||
| Project Budget | Project Info | Budget Summary | |||||
| Project Lead: | Budget | Actual | Under(Over) | ||||
| Start Date: | 9/26/19 | $ 150,000.00 | $ 145,680.00 | $ 4,320.00 | |||
| Labor | Materials | ||||||
| Tasks | Hrs | Rate | Units | $/Unit | Budget | Actual | Under(Over) |
| Phase I | $ 2,058.00 | $ 1,120.00 | $ 938.00 | ||||
| Project Charter | 56 | $20.00 | $ 2,058.00 | $ 1,120.00 | $ 938.00 | ||
| Phase II | $ 29,410.00 | $ 27,720.00 | $ 1,690.00 | ||||
| Development Home IoT & Wearable Technology | 120 | $20.00 | $ 3,910.00 | $ 2,400.00 | $ 1,510.00 | ||
| Development | |||||||
| Purchase Raw Materials | 8 | $40.00 | $ 500.00 | $ 320.00 | $ 180.00 | ||
| Cosmos Flex Materials | 500 | $25.00 | $ 12,500.00 | $ 12,500.00 | $ - 0 | ||
| Cosmos Sense Necklace Materials | 3125 | $4.00 | $ 12,500.00 | $ 12,500.00 | $ - 0 | ||
| Production of Test Units | |||||||
| Phase III | $ 12,574.00 | $ 11,580.00 | $ 994.00 | ||||
| Quality Control of New Merchandise | 104 | $20.00 | $ 1,412.00 | $ 2,080.00 | $ (668.00) | ||
| Testing | |||||||
| Integration of Safeguards | 16 | $40.00 | 3625 | $2.40 | $ 9,750.00 | $ 9,340.00 | $ 410.00 |
| Quality Assurance of products | |||||||
| Sign-Off Quality and Testing | 8 | $20.00 | $ 1,412.00 | $ 160.00 | $ 1,252.00 | ||
| Phase IV | $ 103,604.00 | $ 103,660.00 | $ (56.00) | ||||
| Production | 64 | $20.00 | $ 677.00 | $ 1,280.00 | $ (603.00) | ||
| Purchase Raw Materials | 16 | $40.00 | $ 1,000.00 | $ 640.00 | $ 360.00 | ||
| Cosmos Flex Materials | 1500 | $25.00 | $ 37,500.00 | $ 37,500.00 | $ - 0 | ||
| Cosmos Sense Necklace Materials | 9375 | $4.00 | $ 37,500.00 | $ 37,500.00 | $ - 0 | ||
| Start Mass Production | 10875 | $2.40 | $ 26,250.00 | $ 26,100.00 | $ 150.00 | ||
| Customer Support Training | 32 | $20.00 | $ 677.00 | $ 640.00 | $ 37.00 | ||
| Phase V | $ 2,354.00 | $ 1,600.00 | $ 754.00 | ||||
| Marketing / Promotion | 64 | $20.00 | $ 1,854.00 | $ 1,280.00 | $ 574.00 | ||
| Marketing & Public Relations Strategy | 8 | $40.00 | $ 500.00 | $ 320.00 | $ 180.00 | ||
| Cosmo Flex Mirror | |||||||
| Cosmo Sense Necklace | |||||||
| Full Marketing & Production |
Labor Costs
| Cosmo Inc. IoT Product and Wearable Market Expansion Project | |||||
| Project Budget | Labor Budget Summary | ||||
| Budget | Actual | Under(Over) | |||
| $ 15,000.00 | $ 10,880.00 | $ 4,120.00 | |||
| Labor | |||||
| Tasks | Hrs | Rate | Budget | Actual | Under(Over) |
| Phase I | $ 2,058.00 | $ 1,120.00 | $ 938.00 | ||
| Project Charter | |||||
| Amber Sarda | 56 | $20.00 | $ 2,058.00 | $ 1,120.00 | $ 938.00 |
| Phase II | $ 4,410.00 | $ 2,720.00 | $ 1,690.00 | ||
| Development Home IoT & Wearable Technology | |||||
| Grace Hyatt | 120 | $20.00 | $ 3,910.00 | $ 2,400.00 | $ 1,510.00 |
| Harold Living | 8 | $40.00 | $ 500.00 | $ 320.00 | $ 180.00 |
| Phase III | $ 3,824.00 | $ 2,880.00 | $ 944.00 | ||
| Quality Control of New Merchandise | |||||
| Grace Hyatt | 104 | $20.00 | $ 1,412.00 | $ 2,080.00 | $ (668.00) |
| Harold Living | 16 | $40.00 | $ 1,000.00 | $ 640.00 | $ 360.00 |
| Scott Knight | 8 | $20.00 | $ 1,412.00 | $ 160.00 | $ 1,252.00 |
| Phase IV | $ 2,354.00 | $ 2,560.00 | $ (206.00) | ||
| Production | |||||
| Grace Hyatt | 64 | $20.00 | $ 677.00 | $ 1,280.00 | $ (603.00) |
| Harold Living | 16 | $40.00 | $ 1,000.00 | $ 640.00 | $ 360.00 |
| Rose Aker | 32 | $20.00 | $ 677.00 | $ 640.00 | $ 37.00 |
| Phase V | $ 2,354.00 | $ 1,600.00 | $ 754.00 | ||
| Marketing / Promotion | |||||
| Scott Knight | 64 | $20.00 | $ 1,854.00 | $ 1,280.00 | $ 574.00 |
| Harold Living | 8 | $40.00 | $ 500.00 | $ 320.00 | $ 180.00 |
| Employee Name | Std. Rate | ||||
| Harold Living | $ 40.00 | ||||
| Amber Sarda | $ 20.00 | ||||
| Scott Knight | $ 20.00 | ||||
| Rose Aker | $ 20.00 | ||||
| Grace Hyatt | $ 20.00 |
Material Costs
| Cosmo Inc. IoT Product and Wearable Market Expansion Project | |||||
| Project Budget | Budget Summary | ||||
| Budget | Actual | Under(Over) | |||
| $ 135,000.00 | $ 134,800.00 | $ 200.00 | |||
| Materials | |||||
| Tasks | Units | $/Unit | Budget | Actual | Under(Over) |
| Phase I | $ - 0 | $ - 0 | $ - 0 | ||
| Project Charter | |||||
| Phase II | $ 25,000.00 | $ 25,000.00 | $ - 0 | ||
| Development Home IoT & Wearable Technology | |||||
| Purchase Raw Materials | |||||
| Cosmos Flex Materials | 500 | $25.00 | $ 12,500.00 | $ 12,500.00 | $ - 0 |
| Cosmos Sense Necklace Materials | 3125 | $4.00 | $ 12,500.00 | $ 12,500.00 | $ - 0 |
| Phase III | $ 8,750.00 | $ 8,700.00 | $ 50.00 | ||
| Quality Control of New Merchandise | |||||
| Safeguard Software | 3625 | $2.40 | $ 8,750.00 | $ 8,700.00 | $ 50.00 |
| Phase IV | $ 101,250.00 | $ 101,100.00 | $ 150.00 | ||
| Production | |||||
| Purchase Raw Materials | |||||
| Cosmos Flex Materials | 1500 | $25.00 | $ 37,500.00 | $ 37,500.00 | $ - 0 |
| Cosmos Sense Necklace Materials | 9375 | $4.00 | $ 37,500.00 | $ 37,500.00 | $ - 0 |
| Safeguard Software | 10875 | $2.40 | $ 26,250.00 | $ 26,100.00 | $ 150.00 |
| Phase V | $ - 0 | $ - 0 | $ - 0 | ||
| Marketing / Promotion | |||||
| Raw Materials | $/Unit | # of Units Produced | |||
| Cosmos Flex (IoT Complete Product) | $ 25.00 | 2000 | |||
| Cosmos Sense Necklace (Wearable Product) | $ 4.00 | 12500 | |||
| Safeguard Software | $ 2.40 | 14500 |
