You are the owner of your own cookie company. Fast growth and the need to expand...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are the owner of your own cookie company. Fast growth and the need to expand have made it necessary for you to seek financing from a local bank. However, you need to show the banker your plans for the coming year. Using your own, unique data, you will prepare a comprehensive budget and proforma financial statements to show the banker your projected earnings and financial position. Good luck getting that bank loan! INTRODUCTION you knew they were good, but you never thought Grandma's old cookie recipe would bring you this far! It all started about three years ago when you began using your Grandma's cookie recipe to bake, what most people consider, the "best tasting cookies they have ever put in their mouth." After finishing college, you started baking cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has been great! People love the cookies, and you are making a little extra money. Your fast sales growth has negatives in addition to positives. The volume of business has grown so much that you can no longer keep up with demand. Your desire to grow this hobby into a full-fledged business has led you to explore expanding. You have been investigating new facilities and equipment, and checking into the requirements of hiring a few employees. However, there is one problem; you don't have the money to expand! On the advice of a friend, you meet with a local banker. You share your dreams and ideas, and your need to borrow some money. The banker is encouraging and helpful. However, she states that the bank cannot lend you any money without a business plan that describes your financial results, marketing strategy, and projections for the future. You show the banker your income statement and balance sheet as of the most recent year-end, and the banker is impressed! "Looks very promising," she states. "But what I really need to see is what you plan to do with the money that I will lend you and what your business will look like next year." When you return home after the meeting, you pull out your old college accounting textbook. You realize that this is a master budget problem just like you did in college. After reviewing your class notes and reading the textbook, you settle in to produce a plan for next year. EXHIBIT 1 Sales Price, Cost of Ingredients, Manufacturing Overhead, and Operating Expenses Sales Price: Mark-up on total variable cost Cost of Raw Materials: Direct Materials Flour - per cup Eggs -per egg Butter, Shorting, Oil - per cup* Chips/Nuts, etc. - per cup White / Brown Sugar- per cup 1 stick of butter = ½ cup Utilities Other indirect materials and labor * Maintenance Depreciation Supervision Totals Direct Labor Costs: Information regarding direct labor costs is not maintained because your facility is highly automated. Direct labor is included as a part of manufacturing overhead. Manufacturing Overhead: Operating Expenses: Sales Commission Shipping Costs Salaries Depreciation Unit Cost $0.15 $0.10 $0.05 $0.75 $0.15 Variable Cost (per dozen) $0.65 $0.85 Variable Cost (per dozen) $1.50 $0.55 $1.05 125% Fixed Cost (per month) $520 $2,010 $2,550 $5,080.00 Fixed Cost (per month) $50,100 $215 $1,795 Other Totals $1.60 $52.110.00 Includes any ingredients not listed above. Please list what you think belongs under this cost when reporting costs. PART 1 You immediately realize that you must gain an understanding of your cost structure and of the relationship between your revenues, costs, and profits. You pull out Grandma's recipe to see what ingredients it takes to make a dozen cookies. Next, you go to your invoice files to determine the cost of each of the ingredients. You brainstorm to develop a list of the new costs that you must incur when you expand your operations. After analyzing all of this data you are able to break out your costs into several categories. You realize that some costs are for raw materials while others are related to manufacturing overhead or operating expenses. You also realize that some costs appear to be fixed while other costs are variable. Now you have sufficient information to determine how much money you can make when you sell these cookies. Requirements for Part 1: 1. Think of your favorite cookie. Search the Internet and find a recipe for this type of cookie. This recipe should not rely on one of the ingredients being another manufactures product, i.e. boxed mixes. This recipe will be your "Grandma's recipe" that you make and sell in your business. Insert this recipe on the page under the Recipe tab. To be considered a recipe & need quantity and type of ingredients as well as how you are going to make the cookies for one dozen cookies. You are working in excel so I will expect you to enter your data into excel. I will not accept any copy and pasted recipes nor will I accept a link to a website. You must consult your recipe to determine the amount of ingredients required for one dozen cookies. You also must consult Exhibit 1 for information regarding the costs of ingredients, manufacturing overhead, and operating expenses. If your cookies have ingredients that are not included in Exhibit 1, these ingredients are considered part of overhead. 2. Calculate the costs of the cookies in a cost sheet format. You are not just answering the questions. Think of how you would prepare this as precursor for your budget. The more detail given the better budget you will be able to construct. You are working in excel so I will expect you to enter your data into excel. I will not accept any copy and pasted recipes nor will I accept a link to a website. (a) Total variable costs per dozen cookies. (b) Sales price per dozen cookies using "markup on variable costs." (c) Contribution margin per dozen cookies. (d) Breakeven point for the quarter (three months) in dollars and in units. You are the owner of your own cookie company. Fast growth and the need to expand have made it necessary for you to seek financing from a local bank. However, you need to show the banker your plans for the coming year. Using your own, unique data, you will prepare a comprehensive budget and proforma financial statements to show the banker your projected earnings and financial position. Good luck getting that bank loan! INTRODUCTION you knew they were good, but you never thought Grandma's old cookie recipe would bring you this far! It all started about three years ago when you began using your Grandma's cookie recipe to bake, what most people consider, the "best tasting cookies they have ever put in their mouth." After finishing college, you started baking cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has been great! People love the cookies, and you are making a little extra money. Your fast sales growth has negatives in addition to positives. The volume of business has grown so much that you can no longer keep up with demand. Your desire to grow this hobby into a full-fledged business has led you to explore expanding. You have been investigating new facilities and equipment, and checking into the requirements of hiring a few employees. However, there is one problem; you don't have the money to expand! On the advice of a friend, you meet with a local banker. You share your dreams and ideas, and your need to borrow some money. The banker is encouraging and helpful. However, she states that the bank cannot lend you any money without a business plan that describes your financial results, marketing strategy, and projections for the future. You show the banker your income statement and balance sheet as of the most recent year-end, and the banker is impressed! "Looks very promising," she states. "But what I really need to see is what you plan to do with the money that I will lend you and what your business will look like next year." When you return home after the meeting, you pull out your old college accounting textbook. You realize that this is a master budget problem just like you did in college. After reviewing your class notes and reading the textbook, you settle in to produce a plan for next year. EXHIBIT 1 Sales Price, Cost of Ingredients, Manufacturing Overhead, and Operating Expenses Sales Price: Mark-up on total variable cost Cost of Raw Materials: Direct Materials Flour - per cup Eggs -per egg Butter, Shorting, Oil - per cup* Chips/Nuts, etc. - per cup White / Brown Sugar- per cup 1 stick of butter = ½ cup Utilities Other indirect materials and labor * Maintenance Depreciation Supervision Totals Direct Labor Costs: Information regarding direct labor costs is not maintained because your facility is highly automated. Direct labor is included as a part of manufacturing overhead. Manufacturing Overhead: Operating Expenses: Sales Commission Shipping Costs Salaries Depreciation Unit Cost $0.15 $0.10 $0.05 $0.75 $0.15 Variable Cost (per dozen) $0.65 $0.85 Variable Cost (per dozen) $1.50 $0.55 $1.05 125% Fixed Cost (per month) $520 $2,010 $2,550 $5,080.00 Fixed Cost (per month) $50,100 $215 $1,795 Other Totals $1.60 $52.110.00 Includes any ingredients not listed above. Please list what you think belongs under this cost when reporting costs. PART 1 You immediately realize that you must gain an understanding of your cost structure and of the relationship between your revenues, costs, and profits. You pull out Grandma's recipe to see what ingredients it takes to make a dozen cookies. Next, you go to your invoice files to determine the cost of each of the ingredients. You brainstorm to develop a list of the new costs that you must incur when you expand your operations. After analyzing all of this data you are able to break out your costs into several categories. You realize that some costs are for raw materials while others are related to manufacturing overhead or operating expenses. You also realize that some costs appear to be fixed while other costs are variable. Now you have sufficient information to determine how much money you can make when you sell these cookies. Requirements for Part 1: 1. Think of your favorite cookie. Search the Internet and find a recipe for this type of cookie. This recipe should not rely on one of the ingredients being another manufactures product, i.e. boxed mixes. This recipe will be your "Grandma's recipe" that you make and sell in your business. Insert this recipe on the page under the Recipe tab. To be considered a recipe & need quantity and type of ingredients as well as how you are going to make the cookies for one dozen cookies. You are working in excel so I will expect you to enter your data into excel. I will not accept any copy and pasted recipes nor will I accept a link to a website. You must consult your recipe to determine the amount of ingredients required for one dozen cookies. You also must consult Exhibit 1 for information regarding the costs of ingredients, manufacturing overhead, and operating expenses. If your cookies have ingredients that are not included in Exhibit 1, these ingredients are considered part of overhead. 2. Calculate the costs of the cookies in a cost sheet format. You are not just answering the questions. Think of how you would prepare this as precursor for your budget. The more detail given the better budget you will be able to construct. You are working in excel so I will expect you to enter your data into excel. I will not accept any copy and pasted recipes nor will I accept a link to a website. (a) Total variable costs per dozen cookies. (b) Sales price per dozen cookies using "markup on variable costs." (c) Contribution margin per dozen cookies. (d) Breakeven point for the quarter (three months) in dollars and in units.
Expert Answer:
Answer rating: 100% (QA)
ANSWER Company Name Cost Sheet Description Opening Stock Raw Material Add Purchas... View the full answer
Related Book For
Fraud examination
ISBN: 978-0538470841
4th edition
Authors: Steve Albrecht, Chad Albrecht, Conan Albrecht, Mark zimbelma
Posted Date:
Students also viewed these economics questions
-
You are the owner of Automated Systems, Inc., which sells Apple computers and related data processing equipment. You are currently trying to decide whether to continue selling the Apple computer line...
-
You are the owner of a privately owned, moderate sized company. The business was founded over 20 years ago and has experienced impressive growth and profitability. The only frustrating thing,...
-
You are the owner of a car rental business. If gasoline prices increase, your car rental revenues will decline. How can you hedge your car rental revenue risk using futures contracts? Is this a...
-
Delivery Service purchased a commercial umbrella policy with a $10 million liability limit and a $100,000 self-insured retention. The umbrella insurer required Delivery Service to carry a $1 million...
-
If you save $25 at the beginning of each month, and interest is 4% compounded quarterly, how much will you accumulate in 30 years?
-
Find the transform \(F\) ( \(s\) ) from the pole-zero diagram of Figure P9=32. \(K\) is 5 .
-
Casey Deesel is a sports agent negotiating a contract for Titus Johnston, an athlete in the National Football League (NFL). An important aspect of any NFL contract is the amount of guaranteed money...
-
A new CEO was hired to revive the floundering Champion Chemical Corporation. The company had endured operating losses for several years, but confidence was emerging that better times were ahead. The...
-
The income statement disclosed the following items for the year: Depreciation expense Gain on disposal of equipment Net income $40,000 23,330 344,100 The changes in the current asset and liability...
-
What is lock de-escalation, and under what conditions is it required why is it not required if the unit of data shipping is an item?
-
Discuss the legal procedure of a labor union becoming the certified representative for a group of employees, the Federal Statutes that apply to each stage of the procedure and the relationship...
-
You have forecast pro forma earnings of $1,089,000. This includes the effect of $206,000 in depreciation. You also forecast a decrease in working capital of $90,000 that year. What is your forecast...
-
Revise each of the following sentences to replace negative words with positive ones. Be sure to keep the meaning of the original sentence. 1. You will lose the account if you make a mistake and the...
-
On 5 February 2022, N Wayne sold goods on credit to H Garden for $1199 ($1090 + $109 GST). On 14 February, he received a cheque from H Garden for $1199. However, on 17 February N Waynes bank advised...
-
Use Pitts Corporation data to compute its FCFF for the next three years. Assume that growth in FCFF remains at the historical levels of 15 percent a year. The answer is (in millions): 2012 Actual...
-
Design a highpass filter satisfying the specification below using the frequency sampling method: \[\begin{aligned}M & =40 \\\Omega_{\mathrm{r}} & =1.0 \mathrm{rad} / \mathrm{s} \\\Omega_{\mathrm{p}}...
-
Find the the following in Maybelin product. - Regulations & Labour laws - Misleading Advertisements - Unionized Employees - Lawsuits for aircraft failure - Safety Standards - Quality Standards
-
What is the shape of the exponential distribution?
-
(True and False) 1. The purpose of civil laws is to right a wrong or send someone to jail or have them pay fines, whereas the purpose of criminal laws is to seek monetary remedies or recover stolen...
-
(Multiple Choice) 1. The formula to calculate funds from unknown sources is: a. Assets Liabilities Prior Years Net Worth + Living Expenses Funds from Known Sources. b. Assets Liabilities Prior...
-
Why are accurate fraud statistics hard to find?
-
In a perfectly contestable market, inefficiency does not exist. Explain why.
-
A perfectly competitive market is by definition perfectly contestable, but a perfectly contestable market is not necessarily a perfectly competitive market. Comment on this statement.
-
Why is it important to be clear about how costs can be classified to consider the degree of contestability of a market?
Study smarter with the SolutionInn App