Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
6th Edition
ISBN: 9781260848700
Author: William N. Lanen Professor, Shannon Anderson Associate Professor, Michael W Maher
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
thumb_up100%
Chapter 3, Problem 72IC
Financial Modeling
Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customers—food from the restaurant segment and freshly brewed beer from the beer production segment. Both segments are typically in the same building, which allows customers to see the beer-brewing process.
After months of research, the owners created a financial model that showed the following projections for the first year of operations:
In the process of pursuing capital through private investors and financial institutions, RBC was approached with several questions. The following represents a sample of the more common questions asked:
- What is the break-even point?
- What sales dollars will be required to make $200,000? To make $500,000?
- Is the product mix reasonable? (Beer tends to have a higher contribution margin ratio than food, and therefore product mix assumptions are critical to profit projections.)
- What happens to operating profit if the product mix shifts?
- How will changes in price affect operating profit?
- How much does a pint of beer cost to produce?
It became clear to the owners of RBC that the initial financial model was not adequate for answering these types of questions. After further research, RBC created another financial model that provided the following information for the first year of operations:
Required
- a. What were potential investors and financial institutions concerned with when asking the questions listed in the case?
- b. Why was the first financial model prepared by RBC inappropriate for answering most of the questions asked by investors and bankers? Be specific.
- c. If you were deciding whether to invest in RBC, how would you quickly check the reasonableness of RBC’s projected operating profit?
- d. Why is the question “How much does a pint of beer cost to produce?” difficult to answer?
- e. Perform a sensitivity analysis by answering the following questions:
- 1. What is the break-even point in sales dollars for RBC?
- 2. What is the margin of safety for RBC?
- 3. Why can’t RBC find the break-even point in units?
- 4. What sales dollars would be required to achieve an operating profit of $200,000? $500,000? What assumptions are made in this calculation?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customers—food from the restaurant segment and freshly brewed beer from the beer production segment. Both segments are typically in the same building, which allows customers to see the beer-brewing process.
After months of research, the owners created a financial model that showed the following projections for the first year of operations.
Sales
Beer sales
$
882,000
Food sales
921,200
Other sales
156,800
Total sales
$
1,960,000
Less cost of sales
456,484
Gross margin
$
1,503,516
Less marketing and administrative expenses
1,056,400
Operating profit
$
447,116
In the process of pursuing capital through private investors and financial institutions, RBC was approached with several questions. The following represents a sample of the more common questions asked:
What is the…
After working for years as a regional manager for a retail organization, Scott Parry opened his own business with Susan Gonzalez, one of his district managers, as his partner. They formed Scott and Susan (S&S) to sell appliances and consumer electronics. S&S pursued a “clicks and bricks” strategy by renting a building in a busy part of to`wn and adding an electronic storefront. S&S invested enough money to see them through the first six months. They will hire 15 employees within the next two weeks – three to stock the shelves, four sales representatives, six checkout clerks, and two to develop and maintain the electronic storefront. S&S will host its grand opening in five weeks. To meet that deadline, they have to address the following important issues:
17. What decisions do they need to make to be successful and profitable?
18. What information do S&S need to make those decisions?
Party-Time T-Shirts sells T-shirts for parties at the local college. The company com plated the first year of operations, and the shareholders are generally pleased with operating results as shown by the following income statement:
Bill Hildebrand, the controller, is considering how to expand the business. He proposes two ways to increase profits to $100,000 during 2018.
a. Hildebrand believes he should advertise more heavily. He believes additional advertising costing 320,000 will increase net sales by 30% and leave administrative expense unchanged. Assume that Cost of Goods Sold will remain at the same percentage of net sales as in 2017, so if net sales increase in 2018, Cost of Goods Sold will increase proportionately.
b. Hildebrand proposes selling higher-margin merchandise, such as party dresses, in addition to the existing product line. An importer can supply a minimum of 1,000 dresses for $40 each; Party-Time can mark these dresses up 100% and sell them for $80. Hildebrand…
Chapter 3 Solutions
Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
Ch. 3 - Write out the profit equation and describe each...Ch. 3 - What are the components of total costs in the...Ch. 3 - How does the total contribution margin differ from...Ch. 3 - Compare cost-volume-profit (CVP) analysis with...Ch. 3 - Fixed costs are often defined as fixed over the...Ch. 3 - Prob. 6RQCh. 3 - What is the margin of safety? Why is this...Ch. 3 - Prob. 8RQCh. 3 - Write out the equation for the target volume (in...Ch. 3 - How do income taxes affect the break-even...
Ch. 3 - Why is it common to assume a fixed sales mix...Ch. 3 - What are some important assumptions commonly made...Ch. 3 - Prob. 13CADQCh. 3 - Prob. 14CADQCh. 3 - The typical cost-volume-profit graph assumes that...Ch. 3 - The assumptions of CVP analysis are so simplistic...Ch. 3 - Prob. 17CADQCh. 3 - Consider a class in a business school where volume...Ch. 3 - Prob. 19CADQCh. 3 - Prob. 20CADQCh. 3 - Consider the Business Application,...Ch. 3 - Consider the Business Application,...Ch. 3 - Prob. 23CADQCh. 3 - Profit Equation Components Identify each of the...Ch. 3 - Profit Equation Components Identify the letter of...Ch. 3 - Basic Decision Analysis Using CVP Anus Amusement...Ch. 3 - Basic CVP Analysis The manager of Dukeys Shoe...Ch. 3 - CVP AnalysisEthical Issues Mark Ting desperately...Ch. 3 - Basic Decision Analysis Using CVP Derby Phones is...Ch. 3 - Prob. 30ECh. 3 - Basic Decision Analysis Using CVP Warner Clothing...Ch. 3 - Basic Decision Analysis Using CVP Refer to the...Ch. 3 - Prob. 33ECh. 3 - Prob. 34ECh. 3 - Analysis of Cost Structure Spring Companys cost...Ch. 3 - CVP and Margin of Safety Bristol Car Service...Ch. 3 - CVP and Margin of Safety Caseys Cases sells cell...Ch. 3 - Prob. 38ECh. 3 - Prob. 39ECh. 3 - Refer to the data for Derby Phones in Exercise...Ch. 3 - Refer to the data for Warner Clothing in Exercise...Ch. 3 - CVP with Income Taxes Hunter Sons sells a single...Ch. 3 - CVP with Income Taxes Hammerhead Charters runs...Ch. 3 - Prob. 44ECh. 3 - Prob. 45ECh. 3 - Prob. 46ECh. 3 - Prob. 47ECh. 3 - CVP Analysis and Price Changes Argentina Partners...Ch. 3 - Prob. 49PCh. 3 - CVP AnalysisMissing Data Breed Products has...Ch. 3 - Prob. 51PCh. 3 - Prob. 52PCh. 3 - CVP AnalysisSensitivity Analysis (spreadsheet...Ch. 3 - Prob. 54PCh. 3 - Prob. 55PCh. 3 - Extensions of the CVP ModelSemifixed (Step) Costs...Ch. 3 - Prob. 57PCh. 3 - Extensions of the CVP ModelTaxes Odd Wallow Drinks...Ch. 3 - Prob. 59PCh. 3 - Prob. 60PCh. 3 - Extensions of the CVP ModelTaxes Toys 4 Us sells...Ch. 3 - Extensions of the CVP AnalysisTaxes Eagle Company...Ch. 3 - Extensions of the CVP ModelMultiple Products...Ch. 3 - Extensions of the CVP ModelMultiple Products...Ch. 3 - Prob. 65PCh. 3 - Prob. 66PCh. 3 - Prob. 67PCh. 3 - Prob. 68PCh. 3 - Extensions of the CVP ModelMultiple Products and...Ch. 3 - Extensions of the CVP ModelTaxes With Graduated...Ch. 3 - Prob. 71PCh. 3 - Financial Modeling Three entrepreneurs were...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Refer to Exercise 10.7 for data. At the end of Year 2, the manager of the Houseware Division is concerned about the divisions performance. As a result, he is considering the opportunity to invest in two independent projects. The first is called the Espresso-Pro; it is an in-home espresso maker that can brew regular coffee as well as make espresso and latte drinks. While the market for espresso drinkers is small initially, he believes this market can grow, especially around gift-giving occasions. The second is the Mini-Prep appliance that can be used to do small chopping and dicing chores that do not require a full-sized food processor. Without the investments, the division expects that Year 2 data will remain unchanged. The expected operating incomes and the outlay required for each investment are as follows: Jarriots corporate headquarters has made available up to 500,000 of capital for this division. Any funds not invested by the division will be retained by headquarters and invested to earn the companys minimum required rate of return, 9 percent. Required: 1. Compute the ROI for each investment. 2. Compute the divisional ROI (rounded to four significant digits) for each of the following four alternatives: a. The Espresso-Pro is added. b. The Mini-Prep is added. c. Both investments are added. d. Neither investment is made; the status quo is maintained. Assuming that divisional managers are evaluated and rewarded on the basis of ROI performance, which alternative do you think the divisional manager will choose?arrow_forwardService Organization Income Statement Healing Hands Massage Hut offers high-end, specialized massages and grooming services, including manicures, pedicures, facials, and full-body massages. Healing Hands is a new startup service organization that generates monthly sales of 200,000. As a startup organization, Healing Hands spends 5,000 a month on advertising in local newspapers and on social media sites. In addition, each month Healing Hands spends 100,000 to pay its team of highly specialized massage therapists, and 10,000 to a technology company (to handle the companys website, massage appointment scheduling activities, and customer communications). Further, the company incurs a 15,000 monthly expense to rent its hut space in a hip new retail market. Finally, Healing Hands incurs 20,000 of monthly administrative expenses. Required: 1. Prepare an income statement for Healing Hands for the past month. 2. Briefly explain why Healing Hands income statement has no line item for cost of goods sold.arrow_forwardEthics and professional conduct in business Erin Haywood was recently hired as a cost analyst by Wind River Medical Supplies Inc. Oneof Erin’s first assignments was to perform a net present value analysis for a new warehouse.Et-in performed the analysis and calculated a present value index of 0.8. The plant manager.ZuhairBarbat, is very intent on purchasing the warehouse because he believes that more storage space is needed. Zuhair asks Erín into his office and the following conversation takes place: ZubairErín, you’re new here, aren’t you? EHii: Yes, sir. Zubair: V.dl, Erin, let me tell you something. ¡m not at all pleased with the capital investment analysis that you performed on this new warehouse. T need that warehouse for my production. If I dont get it, where am I going to place our output? Erín: Hopefully with the customer, sir. Zithair: Now don’t get smart with me. Erín: No, really. I was being serious. My analysis does not support constructing a new ware- house. The numbers don’t lie: the warehouse does not meet our investment return targets. In fact, it seems to me that purchasing a warehouse dots not add much value to the business. We need to be producing product to satisfy customer orders, not to fill a warehouse. Zubair Listen, you need to understand sonwthing. The headquarters people will not allow mv to build the warehouse if the numbers dont add up. You know as well as I that many assump tions go into your net present value analysis. Why don’t you relax some of your assumptions so that the f́nancial savings will offset the cost? Erín: I’m willing to discuss my assumptions with you. Maybe I overlooked something. Zubafr Good. Here’s what I want you to do. 1 see in your analysis tha you don’t project greater sales as a result of the warehouse. It seems to me, if we can store more goxLs, then will have more to sell. Thus, logically, a larger warehouse translates into more sales. If you incorporate this into your analysis, I think you’ll see that the numbers will work out. Why don’t you work it through and come back with a new analysis? I’m really counting on you on this one. Let’s get off to a good start together and see if we can get this project accepted. What is your advice to Erin?arrow_forward
- After working for years as a regional manager for a retail organization, Scott Parry opened his own business with Susan Gonzalez, one of his district managers, as his partner. They formed S&S to sell appliances and consumer electronics. Scott and Susan pursued a “clicks and bricks” strategy by renting a building in a busy part of town and adding an electronic storefront. Scott and Susan invested enough money to see them through the first six months. They will hire 15 employees within the next two weeks – three to stock the shelves, four sales representatives, six checkout clerks, and two to develop and maintain the electronic storefront. Scott and Susan will host S&S’s grand opening in five weeks. To meet that deadline, they have to address the following important issues: 16. What business processes are needed, and how should they be carried out? 17. What functionality should be provided on the website?arrow_forwardPart A A software company is considering launching a new product in the market. To record consumer behavior, the company participated in two domestic software fairs in Athens and Thessaloniki that costed €7,000. The results showed that there are two Scenarios (A and B) whose probabilities of occurrence are 60% and 40% respectively, based on consumers’ willingness to buy the new product. To start production, €100,000 is required for new machinery, plus another €2,000 for transport costs and €1,000 for installation costs. This is a state-of-the-art technology machinery, thus, its economic life is only two years. The new machinery will be fully depreciated at the end of its economic life and the company applies the straight-line depreciation method. Table 1 shows the estimated figures on sales, variable costs, selling price, management and distribution costs and working capital needs. At the end of the second year the working capital will be recovered. Table 1: Estimated financial data…arrow_forwardLet us look at brewary Ipana Oy's operating systems. Ipana Oy has found some potential long-time partners in the restaurant business. To optimize the supply chain, the company is negotiating for contracts that would allow all production in the coming years to be sold to these partners. The contracts aim to shift production to 20 liter barrels of beer, which would become the sole product of Ipana Oy. In case the negotiations are successful, Ipana Oy estimates its typical year would look as follows: the quantity shipped to the customer is 18000 units at a price of 300 €/unit. The gross profit percentage is 40 % and the yearly fixed costs are 1500000 €. 1. Calculate the variable cost per unit [€/unit] for products that would be produced in the scenario above.( ) 2.Calculate the critical sales price in the estimate [€/product]. ( ) 3.Calculate the EBITDA (earnings before interests, taxes, depreciations and amortizations) of a typical year. Give your answer to the nearest thousand…arrow_forward
- A young entrepreneur founded a packaged beverage company in early 2022. Based on information gathered from consumers, the young entrepreneur plans to increase sales of packaged drinks in 2023, by producing packaged drinks with new flavors.Revenue in 2022 is $500,000 and is expected to reach $1,500,000 in 2023. Each bottled beverage will sell for $5, and the bottled beverage costs $2 per bottle to produce. Administrative costs including the young entrepreneur’s salary, salary of one accountant and three clerks, are estimated at $200,000 and marketing costs such as posters, advertisements in local newspapers, are estimated at $350,000 in 2023. Then, investment in special equipment and renovation of Warehouses accounts for $562,500 and $62,500 in inventory, which was done in 2022. Moreover, an additional $150,000 in equipment investment is expected to be needed in early 2023 to increase the production volume of their bottled beverage. Currently, the old machine is still capable of…arrow_forwardSuppose that you have been given a summer job as an intern at Issac Aircams, a company that manufacturessophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which isprivately owned, has approached a bank for a loan to help it finance its growth. The bank requires financialstatements before approving such a loan. You have been asked to help prepare the financial statements andwere given the following list of costs:1. Depreciation on salespersons’ cars.2. Rent on equipment used in the factory.3. Lubricants used for machine maintenance.4. Salaries of personnel who work in the finished goods warehouse.5. Soap and paper towels used by factory workers at the end of a shift.6. Factory supervisors’ salaries.7. Heat, water, and power consumed in the factory.8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.)9. Advertising costs.10. Workers’ compensation insurance for factory employees.11. Depreciation on chairs…arrow_forwardDirection. Read and understand the given situation. Solve the problem using the given methods of evaluation. A man is considering P500,000 to open a semi-automatic auto washing business in a city of 400,000 population. The equipment can wash on the average of 12 cars per hour., using two men to operate it and to do small amount of hand work. The man plans to hire two men, in addition to himself and operate the station on an 8 hour basis, 6 days/week, 50weeks/year. He will pay his employees P25 per hour. He expects to charge P25.00 for a car wah out of pocket miscellaneous cost would be P8500/month. He would pay his employees for 2 weeks for vacation each year. Because of the length of his lease, he must write off his investment with 5 years. His capital now is earning 15% and he is employed at a steady job that pays P25,000/month. he desires a rate of return of at least 20% on his investment. Would you recommend the investment? Use the Present Worth Methodarrow_forward
- Direction. Read and understand the given situation. Solve the problem using the given methods of evaluation. A man is considering P500,000 to open a semi-automatic auto washing business in a city of 400,000 population. The equipment can wash on the average of 12 cars per hour., using two men to operate it and to do small amount of hand work. The man plans to hire two men, in addition to himself and operate the station on an 8 hour basis, 6 days/week, 50weeks/year. He will pay his employees P25 per hour. He expects to charge P25.00 for a car wah out of pocket miscellaneous cost would be P8500/month. He would pay his employees for 2 weeks for vacation each year. Because of the length of his lease, he must write off his investment with 5 years. His capital now is earning 15% and he is employed at a steady job that pays P25,000/month. he desires a rate of return of at least 20% on his investment. Would you recommend the investment? Use the following method Present Worth Methodarrow_forwardDirection. Read and understand the given situation. Solve the problem using the given methods of evaluation.A man is considering P500,000 to open a semi-automatic auto washing business in a city of 400,000 population. The equipment can wash on the average of 12 cars per hour., using two men to operate it and to do small amount of hand work. The man plans to hire two men, in addition to himself and operate the station on an 8 hour basis, 6 days/week, 50weeks/year. He will pay his employees P25 per hour. He expects to charge P25.00 for a car wah out of pocket miscellaneous cost would be P8500/month. He would pay his employees for 2 weeks for vacation each year. Because of the length of his lease, he must write off his investment with 5 years. His capital now is earning 15% and he is employed at a steady job that pays P25,000/month. he desires a rate of return of at least 20% on his investment. Would you recommend the investment? Use the Future Worth Methodarrow_forwardNow let us look at Ipana Oy's operating systems from another perspective. Ipana Oy has found some potential long-time partners in the restaurant business. To optimize the supply chain, the company is negotiating for contracts that would allow all production in the coming years to be sold to these partners. The contracts aim to shift production to 20 liter barrels of beer, which would become the sole product of Ipana Oy. In case the negotiations are successful, Ipana Oy estimates its typical year would look as follows: the quantity shipped to the customer is 18000 units at a price of 300 €/unit. The gross profit percentage is 40 % and the yearly fixed costs are 1500000 €. Additional information: The variable cost per unit [€/unit] for products that would be produced in the scenario above: 180 €/unit The critical sales price in the estimate: 264 €/product The EBITDA (earnings before interests, taxes, depreciations and amortizations) of a typical year : 660000 € Question: Calculate the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License