Cookie Fundraiser Budge Analysis

profileDaneT
AragonBakeSale.xlsx

Sheet1

Budget Bake Sale for Club at Aragon
Prepared by Joshua Busch, Makayla Hensen, Dane Torrison
All Ingredients bought at Raley's supermarket
Recipe Brand buying at store Size of ingredients at store Price at store Conversion Price per Batch
2 and 1/4 cups (280g) all-purpose flour  Raley's 5 lb $ 2.48 280g=.0617p $ 0.15
1 teaspoon baking soda Raley's 16 oz $ 0.93 1tps=.16667oz $ 0.16
1 and 1/2 teaspoons cornstarch ARGO 16 oz $ 2.35 1.5tps=.25oz $ 0.59
1/2 teaspoon salt Morton 26 oz $ 2.49 .5tps=.08333oz $ 0.21
3/4 cup (1.5 sticks or 170g) unsalted butter, melted & slightly cooled Challenge 16 oz $ 4.29 .75cup=6oz $ 1.61
3/4 cup (150g) packed light or dark brown sugar Raley's 2 lb $ 3.29 150g=.3307p $ 1.09
1/2 cup (100g) granulated sugar C&H 4 lb $ 3.29 100g=.2205p $ 0.73
1 large egg Nulaid 12 ct $ 2.98 $ 0.25
2 teaspoons pure vanilla extract McCormick 2 oz $ 8.59 2tps=.333oz $ 2.86
1 and 1/4 cups (225g) semi-sweet chocolate chips Toll House 12 oz $ 4.29 1.25cups=10oz $ 3.58
*Yields 12 Large Cookies. Two batches per Package $ 34.98 $ 11.21
Batches take 30 minutes to prepare/bake * Prices from Raley's *prices rounded
500 package per home game baked
1000 batches baked taking 500 hours total
CVP Analyst
Sales (2400 packages) $ 22,800
Variable Cost
Direct Labor $ 6,500.00
Direct Materials $ 11,209.01
Cost of Packaging $ 300.00
Commission $ 360.00 $ 18,369.01
Contribution Margin $ 4,430.99
Fixed Cost
Baking Utensils and supplies $ 500.00
Rental Fee $ 400.00
Clean-Up Labor $ 250.00
Advertistment $ 1,000.00 $ 2,150.00
Net Income $ 2,280.99