Fundamentals Of Cost Accounting (6th Edition)
6th Edition
ISBN: 9781259969478
Author: WILLIAM LANEN, Shannon Anderson, Michael Maher
Publisher: McGraw Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13, Problem 47E
Sensitivity Analysis
Sanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather
Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $25,000 plus $2 for every customer in excess of 20,000. The marketing and administrative costs are estimated to be $10,000 plus 3 percent of the gross margin.
Required
Use a spreadsheet to prepare an analysis of the possible operating income for Sanjana similar to that in Exhibit 13.15. What is the range of operating incomes?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Sanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following.
Gross Margin per Customer
Scenario
(Price – Cost of Goods)
Number of Customers
Good
$5
30,000
Fair
4
20,000
Poor
2
15,000
Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $25,000 plus $2 for every customer in excess of…
Sanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following.
Gross Margin per Customer
Scenario
(Price – Cost of Goods)
Number of Customers
Good
$6.7
47,000
Fair
5.7
37,000
Poor
1.9
32,000
Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $47,000 plus $2 for every customer in excess of…
Patricia Smith recently leased space in the Southside Mall and opened a new business, Smith's Coi Shop. Business has been good. but Smith frequently runs out of Cash. This has necessitated late payment on certain orders, which in turn is beginning to cause a problem with suppliers. Smith plans to borrow from the bank to have cash as needed. but first she needs a forecast of just how much she must borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high.
Sales are made on a cash basis only. Smith's purchases must be paid for during the month following the purchase. Smith pays herself a salary of $4,800 per month and the rent is $2,000 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $400, but Smith has agreed to maintain an average bank balance of $6,000 this is her target cash balance. (Disregard till cash, which is insignificant…
Chapter 13 Solutions
Fundamentals Of Cost Accounting (6th Edition)
Ch. 13 - Prob. 1RQCh. 13 - Prob. 2RQCh. 13 - Prob. 3RQCh. 13 - What role does the master budget play in the...Ch. 13 - What problems might arise if a firm relies solely...Ch. 13 - What is the coordinating role of budgeting?Ch. 13 - Prob. 7RQCh. 13 - Write out the inventory equation that is used to...Ch. 13 - What makes creating budgets for marketing and...Ch. 13 - Prob. 10RQ
Ch. 13 - Preparing a budget is a waste of time. The...Ch. 13 - In the Business Application feature, Using the...Ch. 13 - Prob. 13CADQCh. 13 - Would the budgeting plans for a company that uses...Ch. 13 - Government agencies are limited in spending by...Ch. 13 - What is the difference between the planning and...Ch. 13 - When might the master budget start with a forecast...Ch. 13 - In some organizations (firms, universities,...Ch. 13 - Our cash budget shows a surplus for the quarter,...Ch. 13 - Your boss asks for your estimate on the costs of a...Ch. 13 - The chapter identified four techniques used for...Ch. 13 - Role of Budgets and Plans
Cosmic Corporation is a...Ch. 13 - Human Element in Budgeting
Roller Partners is a...Ch. 13 - Estimate Sales Revenues Stubs-R-Us is a local...Ch. 13 - Estimate Sales Revenues Friendly Financial has 160...Ch. 13 - Estimate Sales Revenues Larson, Inc., manufactures...Ch. 13 - Estimate Production Levels Offenbach Son has just...Ch. 13 - Estimate Sales Levels Using Production Budgets...Ch. 13 - Estimate Inventory Levels Using Production Budgets...Ch. 13 - Estimate Production Levels: Capacity Constraints...Ch. 13 - Prob. 31ECh. 13 - Estimate Purchases and Cash Disbursements Midland...Ch. 13 - Estimate Purchases and Cash Disbursements Lakeside...Ch. 13 - Estimate Cash Disbursements Cascade, Ltd., a...Ch. 13 - Estimate Cash Collections Minot Corporation is...Ch. 13 - Estimate Cash Collections Ewing Company is...Ch. 13 - Estimate Cash Receipts Scare-2-B-U (S2BU)...Ch. 13 - Estimate Cash Receipts Varmit-B-Gone is a pest...Ch. 13 - Prepare Budgeted Financial Statements
Refer to the...Ch. 13 - Prepare Budgeted Financial Statements Cycle-1 is a...Ch. 13 - Prepare Budgeted Financial Statements Carreras Caf...Ch. 13 - Budgeting in a Service Organization Executive...Ch. 13 - Prob. 43ECh. 13 - Prob. 44ECh. 13 - Prob. 45ECh. 13 - Prob. 46ECh. 13 - Sensitivity Analysis Sanjanas Sweet Shoppe...Ch. 13 - Sensitivity Analysis Classic Limo, Inc., provides...Ch. 13 - Prob. 49ECh. 13 - Prob. 50ECh. 13 - Prepare Budgeted Financial Statements The...Ch. 13 - Prob. 52PCh. 13 - Prepare Budgeted Financial Statements Gulf States...Ch. 13 - Prob. 54PCh. 13 - Prob. 55PCh. 13 - Prepare a Production Budget Haggstrom, Inc.,...Ch. 13 - Sales Expense Budget SPU, Ltd., has just received...Ch. 13 - Budgeted Purchases and Cash Flows Mast Corporation...Ch. 13 - Prepare Budgeted Financial Statements HomeSuites...Ch. 13 - Prob. 60PCh. 13 - Comprehensive Budget Plan Brighton, Inc.,...Ch. 13 - Comprehensive Budget Plan Panther Corporation...Ch. 13 - Budgeted Financial Statements in a Retail...Ch. 13 - Cash Budgets and Sensitivity Analysis in a Retail...Ch. 13 - Prob. 66IC
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
- Ethical Behavior Consider the following scenario between Dave, a printer, and Steve, an assistant in the local universitys athletic department. Steve: Dave, our department needs to have 10,000 posters printed for the basketball team for next year. Heres the mock-up, and well need them in a month. How much will you charge? Dave: Well, given the costs I have for ink and paper, 1 can come in at around 5,000. Steve: Great, heres what I want you to do. Print me up an invoice for 7,500. Huts our budget. Then, when they pay you, you give me a check for 2,500. Ill make sure that you get the job. Required: CONCEPTUAL CONNECTION Is Steves proposal ethical? What should Dave do?arrow_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardDorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl’s Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl’s purchases must be paid for during the following month. Koehl pays herself a salary of $4,800 per month, and the rent is $2,000 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $400, but Koehl has agreed to maintain an average bank balance of $6,000—this is her target cash balance. (Disregard the amount in the cash register, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.) The estimated sales and purchases for December, January, and February are shown in the following table. Purchases during November amounted to $140,000. Prepare a cash budget for December, January, and February. Suppose that Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company’s loan requirements be at the end of December in this case? (Hint: The calculations required to answer this part are minimal.)arrow_forward
- Information for Budgeting, Ethics Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Norton’s account-ing staff and is interested in learning as much as possible about the company’s budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, productionmanager, Ford initiated the following conversation.FORD: “Since I’m new around here and am going to be involved with the preparation of the annual budget, I’d be interested in learning how the two of you estimate sales and productionnumbers.”ATKINS: “We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending.Then, we add that usual dose of intuition to come up with the best forecast we can.”GRANGER: “I usually take the sales projections as the basis for my projections. Of…arrow_forwardProblem 1 Glidden Company manufactures a line of chocolate bars that are sold in various department and grocery stores. The company’s controller has just received the sales forecast for the coming year for Glidden Company’s three products which are the High Protein, High Sugar and No Sugar chocolate bars. Glidden has experienced large fluctuations in sales volumes and variable costs over the past two years and the controller believes the sales forecast should be carefully evaluated from a CVP perspective. Preliminary budget information for 2023 is as follows: High Sugar High Protein No Sugar Unit sales 100,000 100,000 200,000 Unit selling price $ 48 $ 56 $ 68 Variable manufacturing cost per unit $ 11 $ 10 $ 21 Variable selling cost per unit $ 7 $ 6 $ 10 For 2023, Glidden’s fixed factory overhead is budgeted at $ 2,000,000 and the company’s fixed, selling and administrative expenses are forecasted to be $ 600,000. Glidden’s income tax rate is 40%. Required: (Show all calculations.…arrow_forwardThe management team at Nash Corporation is capitalizing on the trend for live-edge cedar fireplace mantels—beautiful, simple, organic. In fact, sales are so strong they are running out of inventory. This means that budgeting for next year will be extremely important, to ensure sure that Nash can source enough cedar.With budgeted sales as the starting point for the entire process, the management team agrees that the following levels present the most likely scenario for the first five months of the upcoming year. January February March April May Budgeted number of mantels to be sold 380 420 430 410 460 In addition to sales volume, many other specifics are required in order to complete the company’s operating budgets. Key details associated with prices, costs, and usage are as follows. ● Budgeted selling price is $500 per mantel. Each mantel measures 3 inches × 12 inches × 4 feet. ● Target ending inventory of finished mantels is 20% of…arrow_forward
- Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,800 per month, and the rent is $2,200 per month. In addition, she must make a tax payment of $13,000 in December. The current cash on hand (on December 1) is $700, but Koehl has agreed to maintain an average bank balance of $5,000 - this is her target cash balance. (Disregard the amount in the cash register, which is…arrow_forwardCASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.arrow_forwardNorton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)arrow_forward
- Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $40,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: The company budgeted sales at 12,000 units per month in February, April, and May and at 9,000 units in March. The selling price is $60 per unit. The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. The inventory of finished goods on February 1 was 2,400 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the…arrow_forwardJana and Cindy are planning to launch UP-PACK, a business that upcycles disposable masks into high quality packaging material. They think it can be a viable business but they need your advice; they want to make sure they aren't taking too big of a risk. Use the information below to create a 6 month cash budget. Based on their research of the industry, they plan to provide credit terms to their customers of 35% payment during the month of sale and 65% payment in the month following sale. Manufacturing supply costs are relatively low since they can get free used disposable masks from health care facilities but there are costs incurred to clean and upcycle the masks. They project their costs of goods sold (COGS) to be 24% of each month's sales. They anticipate having to pay 60% of these costs in the month of purchase and 40% in the month following purchase. Fortunately, Jana's brother has a large empty garage that they can operate in for the first year which saves them from renting…arrow_forwardShanice works in finance for a small manufacturing company and is working on next year’s budget. She has been doing research to compare the cost of outsourcing some upcoming jobs versus the cost of purchasing the equipment to keep the jobs in-house. In what step in financial planning is Shanice involved? Multiple Choice developing financial statements for outside investors forecasting short-term financial needs establishing financial controls and tax policy forecasting long-term financial needsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher: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...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY