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
Textbook Question
Chapter 9, Problem 24E
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales.
70 percent collected in the month of sale.
15 percent collected in the first month after sale.
10 percent collected in the second month after sale.
4 percent collected in the third month after sale.
1 percent uncollectible.
The sales on account have been budgeted for the last seven months as follows:
Required:
- 1. Compute the estimated total cash collections during October from credit sales.
- 2. Compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter.
- 3. Build a spreadsheet: Construct an Excel spreadsheet to solve both of the preceding requirements. Show how the solution will change if the following information changes: sales in June and July were $50,000 and $65,000, respectively.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Emerald Service anticipates the following sales revenue over
a five-month period
Its collection history indicates that credit sales are
collected as follows
E (Click the icon to view the sales data )
The company's sales are 40% cash and 60% credit
O (Click the icon to view the collections data)
How much cash will be collected in January? In
February? In March? For the quarter in total?
Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in
total. (Round your answers to the nearest whole dollar)
Emerald Service
Cash Collections Budget
For the Months of January through March
January
Cash sales
6,080
Collection of credit sales
25% Month of sale
2,280
50% Month after
15% Two months after
Total cash collections
Cloudy Company had the following historical collection pattern for its credit sales:
70% collected in the month of sale
12% collected in the first month after month of sale
10% collected in the second month after month of sale
5% collected in the third month after month of sale
3% uncollectible
The sales on open account (credit sales) have been budgeted for the last six months of the year as
shown below:
July
August
September
October
November
December
The estimated cash collection by Cloudy Company during September from credit sales in July,
August, and September is:
Multiple Choice
$83,840.
$100,160.
$90,880.
$ 92,000
$ 104,000
$ 116,000
$ 128,000
$ 140,000
$ 122,000
$64,400.
West Company budgeted the following credit sales during the current year: September, $75,000; October, $108,000; November, $90,000; December, $96,000.Experience has shown that cash from the credit sales is received as follows:10% in the month of sale, 50% in the first month after sale, 35% in the second month after sale, and 5% is uncollectible. All collections in the month of sales are subject to 2 percent cash discount.Â
Â
Required:Â How much cash can West Company expect to collect in November?
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...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Ravenna Candles recently purchased candleholders for resale in its shops. Which of the following costs would be...
Financial Accounting (12th Edition) (What's New in Accounting)
The managers of an organization are responsible for performing several broad functions. They are ______________...
Principles of Accounting Volume 2
Fundamental and Enhancing Characteristics. Identify whether the following items are fundamental characteristics...
Intermediate Accounting
Bank loan; accrued interest LO132 On October 1, Eder Fabrication borrowed 60 million and issued a nine-month, ...
Intermediate Accounting
Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements Koontz Comp...
Introduction To Managerial Accounting
Discussion Analysis A13-41 Discussion Questions 1. How do managers use the statement of cash flows? 2. Describ...
Managerial Accounting (4th Edition)
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
- Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?arrow_forwardMy Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?arrow_forwardHalifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?arrow_forward
- Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?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 collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?arrow_forward
- Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?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_forwardJustin Company's budget includes the following credit sales for the current year: September, $42,000; October, $53,000; November, $47,000; December, $49,000. Credit sales are collected as follows: 10% in the month of sale, 65% in the first month after sale, 23% in the second month after sale, and 2% is uncollectible. How much cash can Justin expect to collect in November as a result of current and past credit sales? Multiple Choice $47,000. $51,610. $37,410. $48,810. $46,210.arrow_forward
- Schedule of Cash Collections on Accounts Receivable and Cash BudgetBennett Inc. found that about 15% of its sales during the month were forcash. Bennett has the following accounts receivable collectionexperience: Percent collected in the month of sale Percent collected in the month after the sale Percent collected in the second month after the sale 25 68 5 Bennett's anticipated sales for the next few months are as follows: AprilMayJuneJulyAugust $250,000290,000280,000295,000300,000 (Note: Round all amounts to the nearest dollar.) Required:1. Calculate credit sales for May, June, July, and August.2. Prepare a schedule of cash receipts for July and August.arrow_forwardMaraa Company's budget includes the following credit sales for the current year: August, $25,000; September, $36,000; October, $30,000; November, $32,000. Experience has shown that payment for the credit sales is received as follows: 15% in the month of sale, 60% in the first month after sale, 20% in the second month after sale, and 5% is uncollectible. How much cash can Marra expect to collect in October as a result of current and past credit sales? Group of answer choices 1)$19,700. 2)$30,000. 3)$31,100. 4)$28,500. 5)$33,900.arrow_forwardJasper Company has sales on account and for cash. Specifically, 61% of its sales are on account and 39% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $526,000 for April, $536,000 for May, and $561,000 for June. The beginning balance of Accounts Receivable is $299,400 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 39% Sales on account 61% Total sales $ O $ JASPER COMPANY Schedule of Cash Receipts For April, May, and June April May June Cash receipts from: Cash sales Collection of accounts receivable Total budgeted cash receiptsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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