You receive the following memo from your Project Manager.
From: PM
To: Project Team
We've got a great plan in place and now it's time to submit your requisition requests. Since this is going to be a totally separate project and new source of revenue for the company, we're going to ask you to draw up all the business requirements you need for your piece of the project. You can assume that other members of the team are going to request things under their purview that your team will need.
For example, the data managers can assume the cybersecurity expert will provide proper firewall support. But you will need to address all the items you need on your end to make things work. This will include licenses to software, all hardware, outside contractor space, applications, plus any monies needed for additional staff or contractors, hours needed by existing personnel to work on your part of the project, and so on.
Your budget will be based on your need, so prepare a list of resources to add to the project using the Microsoft Excel spreadsheet. Total up your needs on the bottom line and provide documentation on where / how you came up with your estimates. Provide as much detail as possible and then explain each item in an accompanying memo or email back to me.
Instructions
Using the provided templates, create business requirements documents.
Use the Excel template to create a list of each of the resources needed for your area of the project, along with the cost of those resources and the total of each of those costs.
Use the Word Document to provide documentation on where or how you came up with the estimates you provided in the Excel document. This document should address the following:
- An explanation of how you created an estimate for each of the resources you have listed in the Excel spreadsheet.
- Also, for each of the resources listed, include information on where you looked for the pricing.
- Whether or not you looked at more than one price and why.
- Any additional details that may help provide context to the costs identified.
- Excel spreadsheet in the provided template.
- MS Word document in the provided template.
My Company Name
| My Company Name Cost Sheet – Bill of Materials | ||||||
| Name | Brand | Price per unit | Quantity | Subtotal | Purchased? | Source |
| Bowls of Jello Bleach Bleacher: Bleach Bleacher: Add the item you need to pay for here. Be specific with details, but explain it in your memo fully |
Jello Bleach Bleacher: Bleach Bleacher: If there is a brand name, add it here. For example, the name of the service/company that provides this item. |
$ 1,500.00 Bleach Bleacher: Bleach Bleacher: This is the cost of one unit. One computer, one hour of contractor time, one month of subscription to a service, etc. |
15 Bleach Bleacher: Bleach Bleacher: This is the number of units you need. Computers, hours of service, months of subscription |
$ 22,500.00 | Y Bleach Bleacher: Bleach Bleacher: Did you already get this item? Y for yes, N for no. |
https://www.myfoodandfamily.com/brands/kraft-jello Bleach Bleacher: Bleach Bleacher: Replace this link with the link to the website where you found the item. If the web page produced a quote, also include a screen shot of the quote in your memo and explain it. |
| PopTarts | Post | $ 1,200.00 | 12 | $ 14,400.00 | Y | https://www.myfoodandfamily.com/brands/kraft-jello |
| Cupcakes | Bettry Crocker | $ 0.81 | 3000 | $ 2,430.00 | Y | https://www.myfoodandfamily.com/brands/kraft-jello |
| Pumpkin Pies | Mrs. Smiths | $ 3,500.00 | 3 | $ 10,500.00 | N | https://www.myfoodandfamily.com/brands/kraft-jello |
| Apple Pies | Mrs. Smiths | $ 998.00 | 16 | $ 15,968.00 | Y | https://www.myfoodandfamily.com/brands/kraft-jello |
| Cookie Dough | Pillsbury | $ 1,508.00 | 2 | $ 3,016.00 | N | https://www.myfoodandfamily.com/brands/kraft-jello |
| Cake Frosting | Duncan Hines | $ 234.00 | 3 | $ 702.00 | Y | https://www.myfoodandfamily.com/brands/kraft-jello |
| Chocolate Cake Ingredients | Duncan Hines | $ 322.00 | 4 | $ 1,288.00 | N | https://www.myfoodandfamily.com/brands/kraft-jello |
| Chef fees (Houry for the duration of the baking challenge) | The Chef: NYC | $ 38.00 | 265 | $ 10,070.00 | Y | https://www.myfoodandfamily.com/brands/kraft-jello |
| Other stuff | Etc | $ 334.00 | 3 | $ 1,002.00 | N | https://www.myfoodandfamily.com/brands/kraft-jello |
| Other stuff | Etc | $ 3.00 | 4 | $ 12.00 | Y | https://www.myfoodandfamily.com/brands/kraft-jello |
| $ – 0 | ||||||
| $ – 0 | ||||||
| $ – 0 | ||||||
| $ – 0 | ||||||
| $ – 0 | ||||||
| $ – 0 | ||||||
| $ – 0 | ||||||
| $ 81,888.00 | Grand Total |
Note: Replace everything on this sheet with your needs. Notes are available with the little red triangles in the top row of each column. Just hover over the triangle to see the note. Here is where you will list your needed items and in your memo, you will make a full explanation for each item, along with the other items in the instructions.
,
Business Requirements Document
Your Name
Your Professor’s Name
Date of Submission
Memo
To: <Project Manager’s Name Here> (note: Remove the <> and put in your people’s names)
From: <Your Name Here>
CC: <Anyone else who gets a copy here>
Dear <PM’s Name Here>.
Business Requirements:
<Describe all your business requirements for your part of the project. Draw on all your knowledge, education, and any personal experience or research to identify everything you will need and add it to the Excel Spreadsheet. Then return here and describe your spreadsheet including cost and benefit to your clients/constituents/customers (depending on your type of organization)>
How I created an estimate for each of the resources have listed in the attached Excel spreadsheet:
<First I… Then I… Your narrative here should be for each of the items listed in the Excel document, provide a corresponding explanation of how you created an estimate for that resource including where you looked for pricing of that resource. >
Process Used:
<Explain your process for identifying costs including whether or not you looked at more than one price for each resource and why. Add any other rationale or details you may have to support the identified costs. Keep in mind that if you did not comparison shop, the leaders will want to know why and you should have a good reason. Include Any additional details that may help provide context to the costs identified.>
2
