Business Requirements
joshstudy
excel_template.xlsxMy 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.
https://www.myfoodandfamily.com/brands/kraft-jello
