Please take the information reviewed this week in the class lecture notes and begin to understand how
Question:
Please take the information reviewed this week in the class lecture notes and begin to understand how we manage and control costs for our projects. Costs have the ability to make or break any project and will determine the success of the next project you embark upon. As the assignment for this week please complete the following activities
Develop a Cost Ledger Sheet that shows three projects and how the project are doing financially. In spreadsheet, please demonstrate the following costs for a project:
- Project Cost Code/Job Code
- Description of Task/Project
- Current Cost To Date
- Estimated Cost to Date
- Estimated Profit
- Actual Costs to date
- Earned Profit
- Total Billed
- Percent Complete
- Project Costs billed monthly over 6 months- Show costs each month of the six months with cost increasing 25% each month until the 6th month where it increases by 12%
Using the documents provided below, please make your spreadsheet with this information. Use the Change orders for the specific costs identified in the document . In the table 2 Document, use that information to add your values for sub-contracted work for the various trades identified.
PDF'S:
Budget: https://peralta.instructure.com/courses/38228/files/3505108?wrap=1
Construction Accounting: https://peralta.instructure.com/courses/38228/files/3505103?wrap=1
Orders for table: https://peralta.instructure.com/courses/38228/files/3505100?wrap=1
Management information systems
ISBN: 978-0073376813
10th edition
Authors: James A. O Brien, George M. Marakas