Overview
In the last activity, you practiced communicating professionally by writing an informative email to your customer(s). Now it’s time to practice using spreadsheet software and take a closer look at the resources, goods, and services necessary to complete your project and estimate the associated costs.
Instructions
Before beginning this activity, make sure you have:
- Downloaded the Week 4 Activity: Project Resources and Budget template [.XLSX].
- Installed Microsoft Excel. As a Strayer student, you have free access to Office 365 products, including Excel. See Office365 in the left-hand menu for the link, technical support, and other information.
For this activity, complete the following:
- In the provided spreadsheet template, you will find four tabs along the bottom of the screen. Read through the “Instructions” tab and the “Sample” tab.
- In the “Blank Template – Fill This In” tab, complete the following:
- Outline a plausible list of resources, goods, and services needed to complete your chosen project.
- Assign each resource a “type”.
- Estimate appropriate costs for each resource.
- Lastly, in the “Sources” tab, include at least one credible source.
Submit your assignment by uploading the completed template document to Blackboard in Week 4.
Resources
Use at least one resource to complete this assignment. Cite your resource(s) on the fourth tab in the template document and format your citations according to the Strayer Writing Standards (SWS).
Instructions
| Week 4 Activity – Project Resources and Budget Instructions: Carefully look through the "Sample" tab. Pay close attention to the amount of detail included, and the formatting and organization of the list. You will use this sample list as a guide to create your own list of resources. Navigate to the third tab titled, "Blank Template – Fill This In" and complete the following: 1. In the “Resources” column, outline a plausible list of resources, goods, and services needed to complete your chosen project. Include at least five resources in your list. 2. In the “Type” column, assign each resource a type. Include at least two different types in your list. You may categorize each resource using the same types as in the Sample tab or utilize your own. 3. In the “Cost” column, estimate appropriate costs for each resource. Though these figures are hypothetical estimates, they should relate to each other and be proportional. . Then, in the fourth tab titled, "Sources," list your resources in proper SWS style. |
Sample
| Project Resources and Budget Developed by John Smith August 2022 | ||
| Resource | Type | Cost |
| Foundation Contractor | Labor | $10,000.00 |
| Framing Contractor | Labor | $10,000.00 |
| Roofing Contractor | Labor | $5,000.00 |
| Windows Contractor | Labor | $2,500.00 |
| Doors Contractor | Labor | $2,500.00 |
| Bricks Contractor | Labor | $5,000.00 |
| Siding Contractor | Labor | $5,000.00 |
| Insulation Contractor | Labor | $5,000.00 |
| Drywall Contractor | Labor | $5,000.00 |
| Plumbing Contractor | Labor | $5,000.00 |
| Electrical Contractor | Labor | $10,000.00 |
| HVAC Contractor | Labor | $5,000.00 |
| Cabinet Contractor | Labor | $2,500.00 |
| Flooring Contractor | Labor | $2,500.00 |
| Appliances Contractor | Labor | $2,500.00 |
| Driveway/Sidewalk Contractor | Labor | $2,500.00 |
| Fencing Contractor | Labor | $2,500.00 |
| Deck Contractor | Labor | $2,500.00 |
| Landscaping Contractor | Labor | $2,500.00 |
| Government Inspector | Labor | $500.00 |
| Inspection Resolvers | Labor | $500.00 |
| Cleaning Service | Labor | $500.00 |
| Lumber | Materials | $100,000.00 |
| Bricks | Materials | $50,000.00 |
| Windows | Materials | $10,000.00 |
| HVAC | Equipment | $10,000.00 |
| Appliances | Equipment | $20,000.00 |
| Fence | Equipment | $10,000.00 |
| Deck | Equipment | $10,000.00 |
| Flooring | Materials | $10,000.00 |
| Bathroom / Kitchen Fixtures | Equipment | $10,000.00 |
| Cabinets | Equipment | $5,000.00 |
| $324,000.00 |
Blank Template – Fill This In
| Project Resources and Budget Name Date | ||
| Resource | Type | Cost |
| $ – 0 |
Sources
| Sources |