Week 7 Activity – Create a Work Breakdown Structure (Template is Excel)
This activity is designed to help you prepare for the assignment due next week, Analysis of Direct and Indirect Costs.
You will use the provided template to create a Work Breakdown Structure (WBS) sheet using the project information from the Week 8 assignment. It includes a place for both direct and indirect costs for the following items:
· Labor.
· Manufacturing.
· Research and Development.
· General Administrative.
This activity is designed to help you better understand the difference between direct and indirect costs. For example, your direct labor costs may be the crew that needs to install solar panels, but indirect labor costs would be any sort of maintenance work required to clean up after the installation.
Please note: The sum formulas are pre-populated in the Total row, so make sure that as you edit, you keep those formulas properly updated. For example, rows should only be inserted above the Total row.
Note: The provided template has a space for each category and formulas to calculate your total expenses. If you need to add more items than the provided three spaces in each category, just add a row below the last row in the category (above the row that calculates the total). Continue adding rows as needed.