2-6 Show All Work Especially 4 & 5 also list where prices came from

Here's the scenario: You are managing a bake sale for a club at your school. It's being held each weekend in the fall that the football team has a home game. This year, there will be ve home games. The club sells cookies in packages of two dozen. The selling price per package is $9.25. The packaging material costs $.18 (18 cents) per package. You pay the regular kitchen staff a direct labor cost for mixing and baking at $15.50 per hour. Baking utensils and supplies for the entire season will cost $610 (excluding the direct costs of cookies). Before each game, the cookies are prepared in a school kitchen for a xed rental fee of $77 per session and clean-up labor is paid a xed total of $52 per session. You estimate that 500 packages of cookies will be baked for each sale and that 96% of them will be sold. Alumni volunteers, who receive no compensation, sell half of the packages and students, who receive a commission of $.20 (20 cents) per package, sell the other half. You plan to run an advertisement in the school newspaper before all ve games and each advertisement costs $176. You are to: . . . 2) Go to the internet and nd a cookie reelpe. 3. Your recipe must have at least 5 ingredients. b. Your recipe will need to be copied into your practice set in full including preparation directions, number of cookies the recipe creates as well as baking time. You can use your snipping tool here ifyou like. No links, copy and paste. 3) Research the prices of the cookie ingredients at a local supermarket, warehouse store or online grocer. Document where you found your costs in your analysis. Price full quantities as the materials are sold in the market and do NOT change the base recipe quantities. 4) Develop your materials cost and document this work in your Excel budget le. Your budget work needs to describe the total direct material cost to make cookies for an entire cookie sale. This involves converting things like one cup of flour for 24 cookies to the amount of flour and cost of flour for the entire sale. Hints are following: a. To convert the recipe quantities, you can use an online conversion calculator. There are several available so use your favorite search engine. Once you have conversions, give the steps the conversion calculator used. h. Break down your conversions from the recipe quantities to the quantities to be purchased using clearly explained steps showing each step in your calculation. Here is an example of conversion work: If your recipe calls for 1.5 cups of flour it weighs .276 pounds per cup. Say you determine you need 266.4 pounds to make enough cookies for a sale and you buy flour in 50 pound bags, how many bags do you need for the sale? Price this number of bags. Remember you can't buy partial bags. (I used a conversion calculator to give me the dry weight pounds per cup. Here is the one I used.) 5) Develop a budget for the ve bake saies using your Excel budget le. Give the complete detailed budget amounts per each sale and the budget in total. You are free to develop any format for the budget. I encourage you to develop a format that is most useful to you. a Make sure your budget is complete. It will include details on your expected income and expected expenses by individual line items with an expected net income for each game as well this detail for all ve games in total. i..Use your imagination when it comes to the direct labor calculation. Your kitchen can be large and full of commercial ovens. Just describe your calculation in detail. You can support this with extra research if you'd like. c. Be sure that all items are labeled to make it understandable. a) Analyze the club's fundraising effort in written format using a Word le