Question

In: Accounting

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 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 $50 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 net income. Use your imagination when it comes to the direct labor calculation. Your kitchen can be large and full of commercial ovens. 4) Analyze the club’s fundraising effort in written format. 5) Make suggestions for next year’s bake sale manager, including those suggestions that would improve the bottom line with approximations of how much the bottom line will improve.
You will submit in your packet:  Title page with name of student who completed the analysis. Be sure to acknowledge those students who you worked with.  Your recipe including quantity and cost of the ingredients along with the source of the prices and directions for baking.  Your budget. Be sure that all items are labeled to make it understandable.  Your analysis, unique to each student, which should be at 2-3 pages in length. You might begin with an overview of the project, then analyze the results, and finally suggest alternative courses of action that would improve on the success of the project. Write as if you are providing this packet to your club faculty advisor and also to the next year’s bake sale manager. Specifically use their names in the report.  Have fun, be creative and include any additional items.

Solutions

Expert Solution

This is a huge case project. Some of things are personalized so I request you to proof read it and personalize as per your requirement. I’m answering this case in the points that are mentioned and it goes as below:

  1. Go to the internet and find a cookie recipe. Your recipe must have at least 5 ingredients.

Recipe of 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

Vanila 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 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 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 from walmart online store.

For butter the total price would be $4464 for 22046oz

For 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 sale of 2,400 package 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.

4) Analyze the club’s fundraising effort in written format

I don’t know what to analyze since there are no fundraising effort mentioned.

5) Make suggestions for next year’s bake sale manager, including those suggestions that would improve the bottom line with approximations of how much the bottom line will improve.

The sales manager next year can take the following points into account:

  • The shifts in which kitchen staff works can be increased to 6 hours this would reduce the kitchen expenses and increase the revenue by $1000 (approx.)
  • Reduce the cost of advertisement by half; this would increase the revenue by 500
  • Order in bulk, so that bulk discount can be availed
  • Invite more volunteers rather than paying commission to students.      

Related Solutions

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...
I have homework on this but I am not sure how to solve it and which...
I have homework on this but I am not sure how to solve it and which formula to use in excel, can u please help me Rebecca is considering buying a 2019 Genesis G70 costing $37,900 and finds that the retaining values of the vehicle over the next four years are as follows: Percent of the total value retained after 24 months: 71% Percent of the total value retained after 48 months: 53% If her interest rate is 5% compounded...
I am stuck on this problem and I am not sure what the solution is. In...
I am stuck on this problem and I am not sure what the solution is. In C Write item.h and item.c. In item.h, typedef a struct (of type t_item) which contains the following information: t_item: char name[MAX_ITEM_NAME_STRING]; char description[MAX_ITEM_DESCRIPTION_STRING]; Make sure that MAX_ITEM_NAME_STRING and MAX_ITEM_DESCRIPTION_STRING are defined with suitable sizes in your item.h. Typical values are, 25 and 80, respectively. Add the following interface definition to item.h: int item_load_items(t_item items[], int max_items, char *filename); Returns the number of objects loaded...
I am not quite sure how to get this program working or how to start it...
I am not quite sure how to get this program working or how to start it in the first place. Write a full Java program and do the following: 1- Create a generic class and declare a one dim array as a private member. 2- Add a constructor to initialize the array. 3- A set method to set the array. 4- Sort method to sort the array. 5- Print method to print the array. 6- Reverse method to reverse the...
I am working on this problem for the company AT & T and am not sure...
I am working on this problem for the company AT & T and am not sure how to start it. Draw a chart of the main inter-organizational linkage mechanisms (e.g., long -term contacts, strategic alliances, mergers) that your organization uses to manage its symbiotic resource interdependencies. Using resource dependence theory and transaction cost theory, discuss why the organization to manage its interdependencies in this way. Do you think the organization has selected the most appropriate linkage mechanisms? Why or why...
I have a concept question that I am not sure how to answer: ABC Company is...
I have a concept question that I am not sure how to answer: ABC Company is in the process of preparing a budget for the upcoming year. The marketing department has just increased the number of units in the sales budget by a significant 50% as compared to the last sales budget that was prepared for the year. Explain the impact this change will have on the Cash Budget. Be specific about… how the components of the Cash Budget will...
I am calculating the expected cash flow for a project. However, I am not sure that...
I am calculating the expected cash flow for a project. However, I am not sure that I should use the net cash flow (after tax) or cash flows (before tax) to identify the payback period and the discounted payback period? Thank you
I just need 3 and 5. I am not sure what I am doing wrong. I...
I just need 3 and 5. I am not sure what I am doing wrong. I get different numbers every time. Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 4,800,000 $ 960,000 $ 1,920,000 $ 1,920,000 Cost of goods sold 2,640,000...
I am not quite sure what this question is asking, nor do I understand how to...
I am not quite sure what this question is asking, nor do I understand how to apply the lower-of-cost-or-NRV. The controller of Alt Company is applying the lower-of-cost-or-net realizable value basis of valuing its ending inventory. The following information is available: Cost Net Realizable Value Lawnmowers: Self-propelled $14,800 $17,000 Push type 19,000 18,000 Total 33,800 35,000 Snowblowers: Manual 29,800 31,000 Self-start 19,000 21,000 Total 48,800 52,000 Total inventory $82,600 $87,000 Compute the value of the ending inventory by applying the...
The question below is very long and I am not sure how to answer some of...
The question below is very long and I am not sure how to answer some of the questions. How much energy is needed for normal breathing? and How might this change with lung disease? how the ingredients in tobacco smoke damage/impair the respiratory system? What brain region controls respiration? What gas do the respiratory centers of the brain detect? How does this affect the respiration rate??
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT