You have been invited to participate in an accounting competition. Your team will be making a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been invited to participate in an accounting competition. Your team will be making a presentation to Michelle and Vishayla who are sister's-in-law who have recently opened a bakery specializing in cakes. They realized their love of baking after they married brothers, Josh and Cody. For a few years they created cakes for family and friends. The demand for their cakes had grown to the point where they could no longer use their kitchens as their "bakery." They rented a store front on the Boulevard in Colonial Heights that used to be a diner. It had a kitchen that was converted into a bakery with large ovens, mixing bins, and prep/decorating area. The owner made all the conversions for the bakery. They currently sell to individuals, area local stores, and event centers for parties/weddings. To get their growing business off the ground they hired a supervisor and two wage employees who work as orders are received. The rest of their payroll includes a financial accountant and one office staff who prepare invoices and does other office duties. They have also hired a sales person who is paid based on the number of cakes sold. Of the store front they have rented, 80% is used as the bakery and 20% is used as office space. Your assignment is two-fold: 1. They have asked your team to prepare managerial accounting data of their current operation. They know the amount of ingredients in each cake but do not know how much labor to add to the cost and the amount of overhead to allocate to each cake. The accountant they have hired is good at preparing financial statements they need to give to the bank and prepare taxes and payroll but is not a managerial accountant and is not able to help. They need to know the cost per cake in order to be able to calculate their cost of goods sold. A list of the calculations they would like for you to prepare for them, as well as, information concerning next period's operations is on the following page. 2. Michelle and Vishayla are thinking of expanding their operations. They want to build a new bakery that will allow them to expand their operation. The new building will allow them to add more ovens, larger prep and decoration stations, and be able to open a retail store in the front of the building. A piece of land is available close to Fort Lee which will give them greater access to military and civilian personnel. They want your team to determine the feasibility of this new venture. The needed calculations and relevant datal are on the following pages. Task 1 Michelle and Vishayla need to know the cost per cake so they can be sure they are charging enough for each cake. They also need this to calculate the cost of goods sold. They feel that direct labor hour is the best cost driver for allocating manufacturing overhead. They pay their wage employees $10.00 per hour. Due to the type of production that they have, they believe job order costing is the best costing system. Here is the estimated data for 2020: Type of cake 1 tier wedding cake 2 tier wedding cake 3 tier wedding cake Large sheet cake Medium sheet cake Small sheet cake Expense Raw materials Bakery wages and salary Administrative salaries Michelle and Vishayla's salary Salesman's salary Supplies Utilities (electric) Utilities (Gas) for ovens Water Repairs and maintenance Rent expense Expected Annual sales 125 300 325 500 600 850 Selling Price per cake Cost behavior Variable Mixed Fixed Fixed Variable Variable Variable Variable Variable Fixed Fixed $200 $350 $400 $125 $90 $65 Estimated annual amount Raw Ingredient cost per cake $40 $55 $85 $25 $15 $10 Direct Labor Hour per cake 4 6 8 4 $1.750 All for bakery All for bakery $600 $2,300 All for bakery $12,000 3 1.5 Additional information All are purchased as needed to avoid spoilage and to have the freshest ingredients $79,125 $129.750 The supervisor does not do of the baking $65.000 The accountant and office worker $40.000 Consider themselves CEO and COO $18.000 $1.500 $2.600 All used in the bakery 85% is for the bakery and 15% is for the administrative office. 80% is for the bakery and 20% is for the administrative office Telephone and internet Fixed *This total includes the supervisor's salary which is a fixed cost. (Hint: Calculate direct labor based on the number of cakes. The difference between the amount calculated and the annual amount above is the supervisor's salary) $1,200 All for administrative office Requirements: 1) Calculate the cost per cake 2) Create a budgeted Traditional Income Statement and a Contribution Income Statement 3) Calculate the breakeven point in dollars 4) Calculate a target profit in dollars for a profit of $125,000. Task 2 They believe it will cost them $250,000 to purchase the land near Fort Lee and to build a bakery and storefront. Your task is: 1) Calculate Return on Investment if the expected increase in net income, due to opening the new location near Ft. Lee, is $35,000, 2) Calculate Asset Turnover Rate and Margin if the expected sales increased to $450,000 3) Calculate Residual Income if the required rate of return is 15%. Your team will prepare a three page paper that should include your recommendations and calculations. The team will also present to Michelle and Vishayla a PowerPoint presentation of your findings and suggestions. The presentation should be 10 minutes long with all members presenting equally. A winner will be selected and each team member will receive a prize. You have been invited to participate in an accounting competition. Your team will be making a presentation to Michelle and Vishayla who are sister's-in-law who have recently opened a bakery specializing in cakes. They realized their love of baking after they married brothers, Josh and Cody. For a few years they created cakes for family and friends. The demand for their cakes had grown to the point where they could no longer use their kitchens as their "bakery." They rented a store front on the Boulevard in Colonial Heights that used to be a diner. It had a kitchen that was converted into a bakery with large ovens, mixing bins, and prep/decorating area. The owner made all the conversions for the bakery. They currently sell to individuals, area local stores, and event centers for parties/weddings. To get their growing business off the ground they hired a supervisor and two wage employees who work as orders are received. The rest of their payroll includes a financial accountant and one office staff who prepare invoices and does other office duties. They have also hired a sales person who is paid based on the number of cakes sold. Of the store front they have rented, 80% is used as the bakery and 20% is used as office space. Your assignment is two-fold: 1. They have asked your team to prepare managerial accounting data of their current operation. They know the amount of ingredients in each cake but do not know how much labor to add to the cost and the amount of overhead to allocate to each cake. The accountant they have hired is good at preparing financial statements they need to give to the bank and prepare taxes and payroll but is not a managerial accountant and is not able to help. They need to know the cost per cake in order to be able to calculate their cost of goods sold. A list of the calculations they would like for you to prepare for them, as well as, information concerning next period's operations is on the following page. 2. Michelle and Vishayla are thinking of expanding their operations. They want to build a new bakery that will allow them to expand their operation. The new building will allow them to add more ovens, larger prep and decoration stations, and be able to open a retail store in the front of the building. A piece of land is available close to Fort Lee which will give them greater access to military and civilian personnel. They want your team to determine the feasibility of this new venture. The needed calculations and relevant datal are on the following pages. Task 1 Michelle and Vishayla need to know the cost per cake so they can be sure they are charging enough for each cake. They also need this to calculate the cost of goods sold. They feel that direct labor hour is the best cost driver for allocating manufacturing overhead. They pay their wage employees $10.00 per hour. Due to the type of production that they have, they believe job order costing is the best costing system. Here is the estimated data for 2020: Type of cake 1 tier wedding cake 2 tier wedding cake 3 tier wedding cake Large sheet cake Medium sheet cake Small sheet cake Expense Raw materials Bakery wages and salary Administrative salaries Michelle and Vishayla's salary Salesman's salary Supplies Utilities (electric) Utilities (Gas) for ovens Water Repairs and maintenance Rent expense Expected Annual sales 125 300 325 500 600 850 Selling Price per cake Cost behavior Variable Mixed Fixed Fixed Variable Variable Variable Variable Variable Fixed Fixed $200 $350 $400 $125 $90 $65 Estimated annual amount Raw Ingredient cost per cake $40 $55 $85 $25 $15 $10 Direct Labor Hour per cake 4 6 8 4 $1.750 All for bakery All for bakery $600 $2,300 All for bakery $12,000 3 1.5 Additional information All are purchased as needed to avoid spoilage and to have the freshest ingredients $79,125 $129.750 The supervisor does not do of the baking $65.000 The accountant and office worker $40.000 Consider themselves CEO and COO $18.000 $1.500 $2.600 All used in the bakery 85% is for the bakery and 15% is for the administrative office. 80% is for the bakery and 20% is for the administrative office Telephone and internet Fixed *This total includes the supervisor's salary which is a fixed cost. (Hint: Calculate direct labor based on the number of cakes. The difference between the amount calculated and the annual amount above is the supervisor's salary) $1,200 All for administrative office Requirements: 1) Calculate the cost per cake 2) Create a budgeted Traditional Income Statement and a Contribution Income Statement 3) Calculate the breakeven point in dollars 4) Calculate a target profit in dollars for a profit of $125,000. Task 2 They believe it will cost them $250,000 to purchase the land near Fort Lee and to build a bakery and storefront. Your task is: 1) Calculate Return on Investment if the expected increase in net income, due to opening the new location near Ft. Lee, is $35,000, 2) Calculate Asset Turnover Rate and Margin if the expected sales increased to $450,000 3) Calculate Residual Income if the required rate of return is 15%. Your team will prepare a three page paper that should include your recommendations and calculations. The team will also present to Michelle and Vishayla a PowerPoint presentation of your findings and suggestions. The presentation should be 10 minutes long with all members presenting equally. A winner will be selected and each team member will receive a prize.
Expert Answer:
Answer rating: 100% (QA)
Heres the Cost of Goods Sold calculation 1 tier wedding cake 2 tier wedding cake ... View the full answer
Related Book For
Engineering Economy
ISBN: 978-0132554909
15th edition
Authors: William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Posted Date:
Students also viewed these accounting questions
-
On July 15, 2018, Capstick Inc. will be making a $40,000,000 bond issue to public investors. The bond matures in seven years on July 14, 2025, has a coupon rate of 4 percent, and pays interest...
-
On December 1, 2017, Exlou Inc. will be making a $15,000,000 bond issue to public investors. The bond matures in 12 years on November 30, 2029 and pays interest annually on November 30. The effective...
-
As an investment analyst, you have been invited to address a group of workers who are almost left with almost 20 years to go on retirement. Explain at least three investment opportunities to them...
-
__________ is the process that occurs when a job applicant does research on an organization and concludes there is enough of a fit between themselves and a job opening to warrant submitting their...
-
Indicate whether each of the following statements is true or false and explain why. A. Constant returns to scale and constant input prices are the only requirements for a total cost function to be...
-
Outline the brainstorming approach to decision making and explain how it differs from the nominal group technique? How would you decide which of the two approaches to use in a particular situation?
-
A snowplow mounted on a truck clears a path \(12 \mathrm{ft}\) through heavy wet snow, as shown in Figure P5.80. The snow is 8 in. deep and its density is \(10 \mathrm{lbm} / \mathrm{ft}^{3}\). The...
-
Scotwood Industries, Inc., sells calcium chloride flake for use in ice melt products. Between July and September 2004, Scotwood delivered thirty-seven shipments of flake to Frank Miller & Sons, Inc....
-
A sales budget is given below for one of the products manufactured by the Key Co: January-20 000 units, February-35 000 units, March-60 000 units, April - 40 000 units. The inventory of finished...
-
As of December 31, Cookie Creations' year-end, the following adjusting entry data are provided. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. A count reveals that $45 of brochures and posters (supplies) were used....
-
I had 29 marbles, some red and some blue, but Billy stole most of them from me! Billy took 3/4 of the red marbles and 2/3 of the blue marbles. Now I only have 9 marbles. Did Billy take more red...
-
A cyclist gets on his bike. He pushes relatively hard on the pedal and begins his trip. Once he begins moving, he doesn't have to push quite so hard to move faster. For a while, he coasts without...
-
For a safe reentry into Earth's atmosphere, the pilots of a space capsule must reduce their speed from 2.60 10 4 m/s to 1.10 10 4 m/s. The rocket engine produces a backward force on the capsule of...
-
To use the value-at-risk (VAR) model to compute market risk, an analyst must know all of the following except: a. Expected return. O b. Z-score. O c. Standard deviation. Od. Opportunity cost.
-
How to get an A in this class? O Actively participate in the class O Study hard throughout the semester Think critically and creatively of the course materials O All of the above
-
You made an investment over the past year, and your nominal return was 8 . 4 % . Over the same year, the rate of inflation was 3 . 6 % . What was the real rate of return for this investment? .
-
A Singaporean law firm is hired by a Malaysian company to help that company deal with a complicated issue of international law. The Malaysian company communicates with its Singaporean lawyers via...
-
When the concentration of a strong acid is not substantially higher than 1.0 10-7 M, the ionization of water must be taken into account in the calculation of the solution's pH. (a) Derive an...
-
A high-quality filter for tap water and a 3 reusable drinking container cost $75 and typically will last for three years. If a family drinks an average of eight cups of water per day (one cup is 8...
-
Consider the data from Problem 14-10. The purchasing department requires that non-dimensional scaling be applied to make their decision. Rate the individual attributes using Equations (14-1) and...
-
Assume the stamping machine will now be used for only three years, owing to the company's losing several government contracts. The MV at the end of year three is $50,000. What is the income tax owed...
-
In 2018, Bert Richards transferred a \(\$ 100,000\) savings account to his wife in trust. The terms of the trust are that income is to be distributed annually to his wife, Mary Beth, the remainder to...
-
In 2018, Mr. Colburn created a trust for the benefit of his five adult children and transferred \(\$ 300,000\) to it. The trustee may decide how much income to pay to each child each year. The trust...
-
In problem 49, when does the estate's taxable year end? problem 49, John Henry died on May 1, 2018. When does his final 1040 have to be filed?
Study smarter with the SolutionInn App