Question

In: Accounting

Here’s the scenario: You are managing a bake sale for a club at your school. It’s...

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 five home games. The club sells cookies in packages of two dozen. The selling price per package is $9.00. The packaging material costs $.12 (12 cents) per package. You pay the regular kitchen staff a direct labor cost for mixing and baking at $10.50 per hour. Baking utensils and supplies for the entire season will cost $500 (excluding the direct costs of cookies) . Before each game, the cookies are prepared in a school kitchen for a fixed rental fee of $90 per session and clean-up labor is paid a fixed total of $60 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 $.15 per package, sell the other half. You plan to run an advertisement in the school newspaper before all five games and each advertisement costs $200. You are to: 1) Go to the internet and find a cookie recipe. Your recipe must have at least 5 ingredients. 2) Research the prices of the cookie ingredients at a local supermarket, warehouse or online grocer. Do NOT change the recipe. To convert the recipe quantities, you can use an online conversion calculator. There are several available so use your favorite search engine. 3) Develop a budget for the five bake sales. Give the 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. Make sure your budget is complete in that it includes both expected income and expected expenses with a bottom line expected n et income. Use your imagination when it comes to the direct labor calculation. Your kitchen can be large and full of commercial ovens.

Solutions

Expert Solution

AVSWER:

This is a huge case project. Some of the things are personalized so I request you to proofread it and personalize as per your requirement. I’m answering this case in the points that are mentioned and it goes as below: Go to the internet and find a cookie recipe. Your recipe must have at least 5 ingredients. Recipe of the plain cookie, taken from https://www.myrecipes.com/recipe/5-ingredient-sugar-cookies 1/2 cup butter, softened 3 cups powdered sugar, divided 1 large egg 1 1/2 teaspoons vanilla extract 1 1/2 cups all-purpose flour The ingredients are for 30 cookies but we need them for 60000 cookies, so we multiply it by 2000. So revised ingredient Butter 625 kg or 22046 oz Egg 3000 Sugar 6000 cups Vanilla extract 5000 tsp All purpose flour 1125 kg or 39683 oz Method Step 1

Beat butter and 1 cup sugar at medium speed with an electric mixer until creamy. Add egg and vanilla; beat 30 seconds. Add flour, beating at low speed until combined. Step 2 Place dough on lightly floured parchment paper, and roll to 1/4-inch thickness. Transfer rolled dough and parchment paper to a baking sheet, and chill 15 minutes. Step 3 Preheat oven to 375°. Cut dough with lightly floured 2-inch cutters; place 1/2 inch apart on 2 parchment paper-lined baking sheets. Reroll scraps, and repeat the process. Step 4 Bake, in batches, at 375° for 8 to 10 minutes or until golden brown around edges. Cool completely on a wire rack (about 30 minutes). Step 5 Whisk together 2 1/2 Tbsp. water and the remaining 2 cups powdered sugar.

2) Research the prices of the cookie ingredients at a local supermarket, warehouse or online grocer. Do NOT change the recipe. To convert the recipe quantities, you can use an online conversion calculator. There are several available so use your favorite search engine. I’ve researched the price of WalMart's online store. For butter, the total price would be $4464 for 22046oz

For the egg, the total price would be $833 for 3000 eggs For vanilla essence the total price would be $1146 for 5000 tsp For sugar the total price would be $1376 for 6000 cups For flour the total price would be $1727 for 39683oz

3) Develop a budget for the five bake sales. The total revenue from the sale of 2,400 packages is $ 20760 Here is the list of expenses for 2500 packages. Total expenses of ingredients $ 9546 Packing expenses $ 275 Kitchen staff $ 630 ( assuming our kitchen is huge and our kitchen staff spends 12 hours per season to bake cookies i.e. 60 hours in total Baking utensils rent $2500 Space rental $1350 (assuming that work is done in 4 hours in each session) Clean up cost $750 Advertisement $1000 Commission $36 The total of all expenses is $16087 Expected income can be $4673 or $4500 if we take extreme situation into account


Related Solutions

I am not sure how to approach this. You are managing a bake sale for a...
I am not sure how to approach this. 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 five home games. The club sells cookies in packages of two dozen. The selling price per package is $8.65. The packaging material costs $.11 (11 cents) per package. You pay the regular kitchen staff a direct labor cost for...
Devonna and Jerry are making cookies for a bake sale at their daughters’ school. They decide...
Devonna and Jerry are making cookies for a bake sale at their daughters’ school. They decide to make chocolate chip cookies and iced sugar cookies. Respond to the following questions (make sure the final answers are proper fractions or mixed numbers and include the correct unit for each item). Attempt History Attempt Time Score LATEST Attempt 1 1,022 minutes 50 out of 60 Question 1 Davonna is going to mix up five times a single recipe of chocolate chip cookies....
Case Study--Sarah CASE SCENARIO You are one of the school counselors at Northwest Middle School. Your...
Case Study--Sarah CASE SCENARIO You are one of the school counselors at Northwest Middle School. Your caseload includes Sarah, a seventh grader. She was referred to you by her classroom teacher. The teacher has concerns regarding Sarah due to Sarah’s recent change in behavior. Historically, Sarah has been a top student and is very outgoing. Sarah is a member of honor society, plays JV basketball, and is a member of the Drama team. Upon her return from Winter break, Sarah...
1. Read the following scenario: As the practice administrator, your monthly meeting with the managing physician...
1. Read the following scenario: As the practice administrator, your monthly meeting with the managing physician partner and the billing manager is taking place. The billing manager has reviewed the accounts receivable report and points out that the days in accounts receivable are 25 days, and that the total percentage of accounts older than 60 days is less than 10%. “I would like to point out that our billing department is doing an excellent job, as evidenced by our days...
The school bookstore wants you to write a Python script to calculate the point of sale...
The school bookstore wants you to write a Python script to calculate the point of sale (total cost) of their new 25$ gift cards. They are also running a special, if a customer buys a gift card they can buy all books for 5$ dollars each. The gift card cost is $25.00 plus $5.00 per book. In addition, there is a sales tax which should be applied to the subtotal and it is 8% (multiply the subtotal by 0.08.) Requirements:...
The school bookstore wants you to write a Python script to calculate the point of sale...
The school bookstore wants you to write a Python script to calculate the point of sale (total cost) of their new 25$ gift cards. They are also running a special, if a customer buys a gift card they can buy all books for 5$ dollars each. The gift card cost is $25.00 plus $5.00 per book. In addition, there is a sales tax which should be applied to the subtotal and it is 8% (multiply the subtotal by 0.08.) Requirements:...
The school bookstore wants you to write a Python script to calculate the point of sale...
The school bookstore wants you to write a Python script to calculate the point of sale (total cost) of their new 25$ gift cards. They are also running a special, if a customer buys a gift card they can buy all books for 5$ dollars each. The gift card cost is $25.00 plus $5.00 per book. In addition, there is a sales tax which should be applied to the subtotal and it is 8% (multiply the subtotal by 0.08.) Requirements:...
Scenario: Suppose you are a risk management professional working for risk managing firm which islocated in...
Scenario: Suppose you are a risk management professional working for risk managing firm which islocated in Dubai. risk managing firm provides consulting services to firms such as airlinecompanies and mining companies on their risk management. Mr. Abdul, the treasurer of goil Pte Ltd, approaches you today (assume it is now July 2020) to ask you for advice onthe financial risk management of his company. Goil (Dubai) Pte Ltd is a trading company which specializes in international trade of petrochemicals and...
Scenario you are a 30 year old college student going to school for business and will...
Scenario you are a 30 year old college student going to school for business and will graduate in a year. Instructions: Find a company online where you would like to apply for a job. Research the company and write a description using the guidelines below. Answer the question: Why do you want to work for this company? Do Your Homework When I say, “homework” I am referring to research and preparation in three key areas: Know yourself Know the company...
- You are not happy with the performance of the leadership in your school and you...
- You are not happy with the performance of the leadership in your school and you decided to start change to better improve the leadership practices and qualities. Use Lewin's Management Change Model to briefly implement this change.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT