Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 28E
Sound Investments, Inc. is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of 20x2. Past experience has indicated that 75 percent of the store’s sales are cash sales. The collection experience for the sales on account is as follows:
80 percent during month of sale
15 percent during month following sale
5 percent uncollectible
The total sales for December 20x1 are expected to be $190,000. The controller feels that sales in January 20x2 could range from $100,000 to $160,000.
Required:
- 1. Demonstrate how financial planning can be used to project cash receipts in January of 20x2 for three different levels of January sales. Use the following columnar format.
- 2. How could the controller of Sound Investments, Inc. use this financial planning approach to help in planning operations for January?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Sound Investments, Inc. is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of 20x2. Past experience has indicated that 75 percent of the store’s sales are cash sales. The collection experience for the sales on account is as follows:
80 percent during month of sale15 percent during month following sale5 percent uncollectible
The total sales for December 20x1 are expected to be $190,000. The controller feels that sales in January 20x2 could range from $100,000 to $160,000.Required:
1. As attached
2. How could the controller of Sound Investments, Inc. use this financial planning approach to help in planning operations for January?
Ruhango, Incorporated, is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of 20x2. Past experience has indicated that 75 percent of the store’s sales are cash sales. The collection experience for the sales on account is as follows:
85 percent during month of sale
10 percent during month following sale
5 percent uncollectible
The total sales for December 20x1 are expected to be $212,000. The controller feels that sales in January 20x2 could range from $120,000 to $170,000.
Required:
1. Demonstrate how financial planning can be used to project cash receipts in January of 20x2 for three different levels of January sales. Use the following columnar format.
Total Sales
for
January 20x2
$120000
$150000
$170000
cash receipts in january 20x2
From December sales on accounts
From January cash sales
From January sales on account
Total cash receipts
Sound Investments, Inc., is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of
20x2. Past experience has indicated that 70 percent of the store's sales are cash sales. The collection experience for the sales on
account is as follows:
85 percent during month of sale
10 percent during month following sale
5 percent uncollectible
The total sales for December 20x1 are expected to be $203,000. The controller feels that sales in January 20x2 could range from
$113,000 to $173,000.
Required:
1. Demonstrate how financial planning can be used to project cash receipts in January of 20x2 for three different levels of January
sales. Use the following columnar format.
Cash receipts in January 20x2:
From December sales on account
From January cash sales
From January sales on account
Total cash receipts
Total Sales in January, 20x2
113,000 $
143,000 $
173,000
$
0 $
0 $
0
Chapter 9 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 9 - Explain how a budget facilitates communication and...Ch. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - What is meant by the term operational budgets?...Ch. 9 - How does activity-based budgeting explain the...Ch. 9 - Prob. 8RQCh. 9 - Give three examples of how the City of Boston...Ch. 9 - Describe the role of a budget director.
Ch. 9 - What is the purpose of a budget manual?Ch. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Define the term budgetary slack, and briefly...Ch. 9 - How can an organization help to reduce the...Ch. 9 - Prob. 16RQCh. 9 - Discuss this comment by a small-town bank...Ch. 9 - List the steps you would go through in developing...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Fill in the missing amounts in the following...Ch. 9 - Bodin Company budgets on an annual basis. The...Ch. 9 - Coyote Loco, Inc., a distributor of salsa, has the...Ch. 9 - Greener Grass Fertilizer Company plans to sell...Ch. 9 - The following information is from Tejas...Ch. 9 - Tanya Williams is the new accounts manager at East...Ch. 9 - Sound Investments, Inc. is a large retailer of...Ch. 9 - Handy Hardware is a retail hardware store....Ch. 9 - Prob. 30ECh. 9 - Spiffy Shades Corporation manufactures artistic...Ch. 9 - Western State University (WSU) is preparing its...Ch. 9 - Mary and Kay, Inc., a distributor of cosmetics...Ch. 9 - Prob. 34PCh. 9 - Alpha-Tech, a rapidly growing distributor of...Ch. 9 - Prob. 36PCh. 9 - Scholastic Furniture, Inc. manufactures a variety...Ch. 9 - Prob. 38PCh. 9 - Vista Electronics, Inc. manufactures two different...Ch. 9 - Prob. 40PCh. 9 - Toronto Business Associates, a division of Maple...Ch. 9 - FreshPak Corporation manufactures two types of...Ch. 9 - Healthful Foods Inc., a manufacturer of breakfast...Ch. 9 - We really need to get this new material-handling...Ch. 9 - City Racquetball Club (CRC) offers racquetball and...Ch. 9 - Patricia Eklund, controller in the division of...Ch. 9 - Jeffrey Vaughn, president of Frame-It Company, was...
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
- Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.arrow_forwardA companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_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
- Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.arrow_forwardPilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forwardCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forward
- One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.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_forwardLovely Wedding printing is budgeting sales of 32,000 units and already has 4,000 in beginning inventory. How many units must be produced to also meet the 6,000 units required in ending inventory?arrow_forward
- Artemis, Inc. has developed a specialized wholesale business selling archery equipment to sporting goods stores. The Artemis cost accountants are going through their quarterly budgeting process and have determined that • Sales (in dollars) are expected to be $260,000 for January, $270,000 for February, and $250,000 for March • The company expects to collect cash from credit sales according to this pattern: 60% in the month of sale and 40% in the month following the sale. Cost of goods sold is expected to be approximately 60% of sales. Artemis would like to have inventory at the end of each month equal to 40% of the cost of goods sold budgeted for the following month. When Artemis purchases archery equipment for its suppliers, they generally make payment in the month following the purchase. . . • At January 1, the beginning balance in the accounts receivable account is $61,000. At January 1, the beginning balance in the accounts payable account is $248,000. . Required: a. Prepare a…arrow_forwardSound Investments, Ic., is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of 20x2. Past experience has indicated that 70 percent of the store's sales are cash sales. The collection experience for the sales on account is as follows: 85 percent during month of sale 10 percent during month following sale 5 percent uncollectible The total sales for December 20x1 are expected to be $203,000. The controller feels that sales in January 20x2 could range from $113,000 to $173,000. Required: 1. Demonstrate how financial planning can be used to project cash receipts in January of 20x2 for three different levels of January sales. Use the following columnar format. Total Sales in January, 20x2 113,000 2$ 143,000 %2$ 173,000 Cash receipts in January 20x2: From December sales on account From January cash sales From January sales on account Total cash receipts 8 T G K C Narrow_forwardMunoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required a. October sales are estimated to be $340,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. b. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. c. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month's cost of goods sold. However, ending inventory of December is expected to be $12,900. Assume that all purchases are made…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
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
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