Question: Please submit your Excel .xlsx file produced from the following project. The objective of the project is to create project management sheets that may
Please submit your Excel .xlsx file produced from the following project. The objective of the project is to create project management sheets that may serve you in the future as project templates. To complete the exercise, the following should be performed. 1. Develop a project budget template. This template should include the following: 1) title, 2) task, 3) labor (hr & S/hr), 4) materials (units & S/unit), 5) travel, 6) equipment/space, 7) miscellaneous, 8) budget, 9) actual and 10) balance (over/under). 2. Develop a timesheet template. This template should include the following: 1) title, 2) project name, 3) employee, 4) week of, 5) approved by, 6) day of the week, 7) start time, 8) finish time, 9) regular hours, 10) overtime hours, 11) sick hours, 12) vacation hours, 13) holiday hours, 14) other hours, 15) total hours for each day, 16) total hours for each hour type, 17) rate/hr and 18) total pay. 3. Develop a construction schedule Gantt chart template. The template should include the following: 1) title, 2) task, 3) start date, 4) length in days, 5) completion date, 6) adjusted length in days and 7) chart with schedule. 4. Review your Excel spreadsheet and ensure that it is clear, organized, and easy to follow.
Step by Step Solution
3.38 Rating (151 Votes )
There are 3 Steps involved in it
Answer 1 Project Budget Template The project budget template is an Excel sheet that captures various costs associated with a project including labor c... View full answer
Get step-by-step solutions from verified subject matter experts
