Assignment 5 – Project Budget
Team Assignment – Cost Estimate. See attached Project Description.
AD642-TeamProject-Description-and-Deliverables-2019 Universal.pdf
Here is a template from which you can work:
budget-cost_estimate-template.xlsx
PERT Estimation spreadsheet:
PERT ESTIMATING SPREADSHEET.xls
Need Help?
- If you have any questions or comments regarding this assignment, please contact your facilitator or instructor via the discussion boards or directly via email.
- Instructions on how to access and upload assignments are available via the Help link in the left-hand course menu.
Solution
Internal Labor | $/hour | Internal | External Labor | $/hour | External | Labor $ | Non-labor $ | Total Cost | |
WBS Categories | $ Total | $ Total | Reserves | Reserves | |||||
1.1. manufacturing | |||||||||
1.1.1. Press production line | 10 | $160 | $1,600 | 40 | 100 | 4000 | $5,600 | ||
1.1.2. Body center | 40 | $100 | $4,000 | 400 | $70 | $28,000 | $32,000 | ||
1.1.3. Paint center | 40 | $100 | $4,000 | 400 | $70 | $28,000 | $32,000 | ||
1.1.4. Assembly center | 70 | $100 | $7,000 | 600 | $70 | $42,000 | $49,000 | ||
1.2. Exchange Station | |||||||||
1.2.1. Location Selection | 70 | $80 | $5,600 | 0 | $0 | $0 | $5,600 |
Please follow the link below to purchase the solution at $10