Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 1E
Schedule of Expected Cash Collections LOB-2
Silver Company makes a product that is very popular as a Mother’s Day gift Thus, peak sales occur in May of each year, as shown in the company’s salesbudget for the second quarter given below:
From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another? 70% are collected in the monthfollowing sale, and the remaining 10% are collected in the second month following sale.
$230,000, and March sales totaled $260,000.
Required:
1. Using Schedule 1 as your guide, prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter.
2. What is the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Schedule of Expected Cash Collections
Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below:
From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000.
Required:
1. Using Schedule 1 as your guide, prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter.
2. What is the accounts receivable balance on June 30th?
Schedule of expected cash collections
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak
sales occur in May of each year. These peak sales are shown in the company's sales
budget for the second quarter given below:
April
$300,000
May
June
Total
eted Sales
$500,000
$200,000
$1,000,000
From past experience, the company has learned that 15% of the company's sales are for
cash. Credit sales are collected as follows: 20% are collected in the month of sale,
another 70% are collected in the month following the sale, and the remaining 10% are
collected in the second month following the sale. Bad debts are negligible and can be
ignored. February sales totaled $230,000, and March sales totaled $260,000.
A. Prepare a schedule of expected cash collections from sales, by month and in total,
for the second quarter.
B. Assume that the company will prepare a budgeted balance sheet as of June 30.
Compute the accounts receivable as of that date.
Problem 1. Jane McDonald, a financial analyst for Carroll Company, has prepared the following sales and cash
disbursement estimates for the period February to June of the current year.
Cash
disbursements
Month
Sales
February
$500
$400
March
600
300
April
400
600
May
200
500
June
200
200
McDonald notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the
sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending
balance in its cash account of $25. Balances above this amount would be invested in short-term government securities
(marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable).
The beginning cash balance at April 1 is $115.
a. Prepare cash budgets for April, May, and June.
b.
How much financing, if any, at a maximum would Carroll Company require to meet its obligations during this
3-month period?
c. A pro forma balance…
Chapter 8 Solutions
Introduction To Managerial Accounting
Ch. 8 - What is a budget? What is budgetary control?Ch. 8 - Prob. 2QCh. 8 - What is meant by the term responsibility...Ch. 8 - What is a master budget? Briefly describe its...Ch. 8 - Why is the sales forecast the starting point in...Ch. 8 - “As a practical matter, planning and control mean...Ch. 8 - Prob. 7QCh. 8 - What is a self-imposed budget? What are the major...Ch. 8 - How can budgeting assist a company in planning its...Ch. 8 - Prob. 10Q
Ch. 8 - The Excel worksheet form that appears below is to...Ch. 8 - The Excel worksheet form that appears below is to...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Prob. 2F15Ch. 8 - Prob. 3F15Ch. 8 - Prob. 4F15Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Prob. 6F15Ch. 8 - Prob. 7F15Ch. 8 - Prob. 8F15Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Prob. 11F15Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Schedule of Expected Cash Collections LOB-2 Silver...Ch. 8 - Down Under Products, Ltd., of Australia has...Ch. 8 - Direct Materials Budget LOB-4 Three grams of musk...Ch. 8 - Direct Labor Budget LOB-5 The production manager...Ch. 8 - Manufacturing Overhead Budget L.08—6 The direct...Ch. 8 - Weller Company’s budgeted unit sales for the...Ch. 8 - Cash Budget LOB—8 Garden Depot is a retailer that...Ch. 8 - Gig Harbor is the wholesale distributor of a small...Ch. 8 - The management of Mecca copy, a photocopying...Ch. 8 - Production and Direct Materials Budgets LO8—,...Ch. 8 - Cash Budget Analysis LOB—8 A cash budget, by...Ch. 8 - Prob. 12ECh. 8 - Schedules of Expected Cash Collections and...Ch. 8 - Sales and Production Budgets L08—2, L08—3 The...Ch. 8 - Direct Labor and Manufacturing Overhead Budgets...Ch. 8 - Direct Materials and Direct Labor Budgets LOB—4,...Ch. 8 - Cash Flows; Budgeted Income Statement and Balance...Ch. 8 - Cash Flows; Budgeted Income Statement and Balance...Ch. 8 - Cash Budget: Income Statement: Balance Sheet...Ch. 8 - Cash Budget; Income Statement: Balance Sheet;...Ch. 8 - Schedules of Expected Cash Collections and...Ch. 8 - Evaluating a Company’s Budget Procedures LOB—1...Ch. 8 - Prob. 23PCh. 8 - Cash Budget with Supporting Schedules L08-2,...Ch. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 8 - Prob. 28PCh. 8 - Completing a Master Budget LOB—2, LO8—4, LO8—7,...Ch. 8 - Prob. 30PCh. 8 - Completing a Master Budget LOB-2, LOB-4, LOB-7,...
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 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_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_forwardEarthies 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_forward
- Please answer the question What are the estimated cash receipts for March, if 20 percent of sales are cash, 40 percent are credit sales paid in the month after the sale, and 40 percent are credit sales paid 2 months after the sale? Answer it with complete solutions and explanations if needed. Thank youarrow_forwardCurrent Attempt in Progress The management of Riverbed Industries estimates that credit sales for August, September, October, and November will be $575,000, $700,000, $875,000, and $490,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and November. (Do not leave any field blank. Enter O for the amounts.) October November Collections from Customers August Sales September Sales October Sales November Sales 2$ $. Total budgeted collections eTextbook and Media Attempts: 0 of 3 used Submit Answer. Savetor La hp %24 %24arrow_forwardQuestion 2: Avril Company makes collections on sales according to the below schedule. The Treasury Manager conducts an analysis of the cash collection and determines that cash collection target for March should be $150,000. Evaluate whether the collection target for March is correct and summarize your recommendations. Month Expected Sales January $ 100,000 February $ 120,000 March $ 110,000 30% in the month of sale 60% in the month following sale 10% in the second month following salearrow_forward
- Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. Office Mart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $110,000 138,000 201,000 The Accounts Receivable balance on September 30 was $74,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales…arrow_forwardJ. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: September (actual) October November December Fourth Quarter Credit sales Collections: Experience has shown that 15 percent of sales are collected in the month of sale, 65 percent are collected in the following month, and 20 percent are never collected. Prepare a schedule of cash receipts for J. Lo's Clothiers covering the fourth quarter (October through December). In month of sales One month after sales $ 51,000 $ 41,000 36,000 61,000 Total cash receipts J. Lo's Clothiers September October November Decemberarrow_forwardCurrent Attempt in Progress Swifty Industries expects credit sales for January, February, and March to be $176,000, $208,000, and $240,000, respectively. It is expected that 75% of the sales will be collected in the month of sale, and 25% will be collected in the following month. Compute cash collections from customers for each month. Credit Sales January February March $ January Collections from Customers February Marcharrow_forward
- Ratchet Manufacturing anticipates total sales for August, September, and October of $300,000, $260,000, and $270,500 respectively. Cash sales are normally 20% of total sales and the remaining sales are on credit. All credit sales are collected in the first month after the sale. Compute the amount of cash received for September. Multiple Choice $240,000. $292,000. $208,000. $112,000. $448,000.arrow_forwardTreasure 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.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale 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 do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Donearrow_forwardPreparing a Short-Term Cash Forecast The Lyon Corporation is a merchandising company. Prepare a short-term cash forecast for July of Year 6 following the format of Exhibit 9A.4. Selected financial data from Lyon Corporation as of July 1 of Year 6 are reproduced below ($ thousands): Additional Information: Gross profit equals 20% of cost of goods sold. Lyon purchases all inventory on the second day of the month and receives it the following week. Lyon pays 75% of payables within the month of purchase and the balance in the following month. Lyons pays all remaining expenses in cash.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
The management of receivables Introduction - ACCA Financial Management (FM); Author: OpenTuition;https://www.youtube.com/watch?v=tLmePnbC3ZQ;License: Standard YouTube License, CC-BY