Survey Of Accounting
5th Edition
ISBN: 9781259631122
Author: Edmonds, Thomas P.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 14, Problem 3E
a)
To determine
Determine the cash receipts and fill the missing amounts.
b)
To determine
Determine the amount of accounts receivable the company reports on the 3rd quarter pro forma
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Exercise 7-3A (Algo) Preparing a schedule of cash receipts LO 7-2
The budget director of Heather's Florist has prepared the following sales budget. The company had $132,600 in accounts receivable
on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale.
Required
a. Complete the schedule of cash receipts by filling in the missing amounts.
b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.
Complete this question by entering your answers in the tabs below.
Required A Required B
Complete the schedule of cash receipts by filling in the missing amounts.
Sales Budget
Cash sales
Sales on account
Total budgeted sales
Schedule of Cash Receipts
Current cash sales
Plus: Collections from accounts receivable
$
July
70,000 $
97,000
$ 167,000 $
$
August
70,000 $
+
September
82,000 $
116,000
198,000
82,000
78,000
132,600
$ 210,600
$ 78,000
aw
The budget director of Heather's Florist has prepared the following sales budget. The company had $320,000 in accounts receivable
on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale.
Required
a. Complete the schedule of cash receipts by filling in the missing amounts.
b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.
Complete this question by entering your answers in the tabs below.
Required A Required B
Complete the schedule of cash receipts by filling in the missing amounts.
July
August
Sales Budget
Cash sales
Sales on account
Total budgeted sales
Schedule of Cash Receipts
Current cash sales
Plus: Collections from accounts receivable
Total budgeted collections
$
September
62,000 $ 84,000 $
95,000 102,000
$ 157,000 $ 186,000
85,000
124,600
$209,600
$ 382,000 $ 179,000 $ 187,000
Problem 7-17A (Algo) Preparing a sales budget and schedule of cash receipts LO 7-2
Thornton Pointers Corporation expects to begin operations on January 1, year 1, it will operate as a specialty sales company that sells
laser pointers over the Internet. Thornton expects sales in January year 1 to total $400,000 and to increase 20 percent per month in
February and March. All sales are on account. Thornton expects to collect 66 percent of accounts receivable in the month of sale, 24
percent in the month following the sale, and 10 percent in the second month following the sale.
Required
a. Prepare a sales budget for the first quarter of year 1.
b. Determine the amount of sales revenue Thornton will report on the year 1 first quarterly pro forma income statement.
c. Prepare a cash receipts schedule for the first quarter of year 1.
d. Determine the amount of accounts receivable as of March 31, year 1.
Complete this question by entering your answers in the tabs below.
Required A Required B…
Chapter 14 Solutions
Survey Of Accounting
Ch. 14 - Prob. 1QCh. 14 - Prob. 2QCh. 14 - 3.What are the three levels of planning? Explain...Ch. 14 - 4.What is the primary factor that distinguishes...Ch. 14 - 5.What is the advantage of using a perpetual...Ch. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - 8. Ken Shilov, manager of the marketing...Ch. 14 - Prob. 9QCh. 14 - 10.What is the normal starting point in developing...
Ch. 14 - 11. How does the level of inventory affect the...Ch. 14 - 12.What are the components of the cash budget?...Ch. 14 - 13.The primary reason for preparing a cash budget...Ch. 14 - 14.What information does the pro forma income...Ch. 14 - 15.How does the pro forma statement of cash flows...Ch. 14 - Exercise 7-1A Budget responsibility Teresa...Ch. 14 - Exercise 7-2A Preparing a sales budget Parliament...Ch. 14 - Prob. 3ECh. 14 - Exercise 7-4A Preparing sales budgets with...Ch. 14 - Exercise 7-5A Determining cash receipts from...Ch. 14 - Exercise 7-6A Using judgment in making a sales...Ch. 14 - Exercise 7-7A Preparing an inventory purchases...Ch. 14 - Exercise 7-8A Preparing a schedule of cash...Ch. 14 - Exercise 7-9A Determining the amount of expected...Ch. 14 - Exercise 7-10A Preparing inventory purchases...Ch. 14 - Exercise 7-11A Preparing a schedule of cash...Ch. 14 - Prob. 12ECh. 14 - Exercise 7-13A Preparing a cash budget The...Ch. 14 - Exercise 7-14A Determining amount to borrow and...Ch. 14 - Prob. 15ECh. 14 - Problem 7-16A Behavioral impact of budgeting...Ch. 14 - Prob. 17PCh. 14 - Problem 7-18A Preparing an inventory purchases...Ch. 14 - Prob. 19PCh. 14 - Problem 7-21A Preparing a cash budget Fayette...Ch. 14 - Prob. 21PCh. 14 - Problem 7-22A Preparing budgets with multiple...Ch. 14 - Problem 7-23A Preparing a master budget for retail...Ch. 14 - ATC 7-1 Business Applications Case Preparing and...Ch. 14 - ATC7-2 Group Assignment Master budget and pro...Ch. 14 - ATC 7-4 Writing Assignment Continuous budgeting...Ch. 14 - Ethical Dilemma Bad budget system or unethical...
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
- b. a. Prepare a schedule of cash payments for Fein Company for the month of August. OBJECTIVE 3 C. Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. b. Actual sales for April and May are as follows: d. F. a. April May Cash sales R180,000 Credit sales to 00 R530,000 Total sales R389,000 c. Credit sales are collected over a three-month period: R 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total B sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000…arrow_forwardQuestion 2 A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: June RM Cash sales Credit sales Total sales 10,200 26,100 36,300 July RM 14,700 33,900 48,600 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest…arrow_forward(過) 11 %24 00 关 %24 %24 %23 The budget director of Heather's Florist has prepared the following sales budget. The company had $250,000 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required a. Complete the schedule of cash receipts by filling in the missing amounts. b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Complete the schedule of cash receipts by filling in the missing amounts. July August September Sales Budget $ 000৮৪ 122,600 Cash sales 86,000 $ 000'0 0000 $154,000 $ 183,000 Sales on account 0000 Total budgeted sales 208,600 2$ Schedule of Cash Receipts Current cash sales Plus: Collections from accounts receivable Total budgeted collections $ 320,000 $ 168,000 $4 185,000 ( Required A Required B > 37°F re to search ( f10…arrow_forward
- Problem 6 Tomtom store seeks your assistance to develop cash and other budget information for May, June, and July 2009. On April 30, 2009, the company had cash balance of Php5,500. The budget is based on the following assumptions: A. Sales 1. Each month's sales are billed on the last day of the month 2. Customers are allowed 3% discount if payment is made within 10 days after the billing date. Accounts receivable are booked gross. 3. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month where discount period is allowed, 9% are collected by the end of the end second month, and 6% prove uncollectible. B. Purchases 1. 54% of all purchases of materials and selling, general and administrative expenses are paid at the month purchased and the remainder in the following month. 2. Each month's unit of ending inventory is equal to 130% of the month's units of sales. 3. The cost of each unit of inventory is P20. 4. Selling, general and…arrow_forwardExercise 13-40 (Algo) Estimate Cash Collections (LO 13-4) All sales at Alaska Company are on credit. The company is preparing a cash budget for November. The following information on accounts receivable collections is available from customer payment history: Percent of current month's sales collected this month Percent of prior month's sales collected this month Percent of sales two months prior to current month collected this month Percent of sales three months prior to current month collected this month The remaining 4 percent is not collected and is written off as bad debts. Sales to date are as follows: November (estimated) October September August $ 280,000 600,000 250,000 670,000 Required: What are the estimated cash receipts from accounts receivable collections in November? Estimated cash receipts 25% 60 8 3 Karrow_forwardSchedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February $58,900 $71,700 $79,400 4,900 5,400 6,400 45,400 49,500 54,500 $109,200 $126,600 $140,300 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Salaries Utilities Other operating expenses Total Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations…arrow_forward
- Question 1 The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 - An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale -Expected purchases include monthly cash purchases of 5%. All other purchases are on Accounts payable are settled as follows,…arrow_forwardQuestion 1 The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 - An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale -Expected purchases include monthly cash purchases of 5%. All other purchases are on Accounts payable are settled as follows,…arrow_forwardQuestion 1 The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 - An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale -Expected purchases include monthly cash purchases of 5%. All other purchases are on Accounts payable are settled as follows,…arrow_forward
- sh On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following infor- mation has been provided by Spicer's management. Month January February March April May Credit Sales Collections in the month of the sale Collections one month after the sale Collections two months after the sale Uncollectible accounts ary. The company's collection activity on credit sales historically has been as follows. $300,000 (actual) 400,000 (actual) 600,000 (estimated) 700,000 (estimated) 800,000 (estimated) 50% 30 15 5 Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Compute Spicer's budgeted cash balance at the ends of March, April, and May.arrow_forwardQuestion 1 The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 - An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale -Expected purchases include monthly cash purchases of 5%. All other purchases are on Accounts payable are settled as follows,…arrow_forwardAssume a merchandising company provides the following information from its master budget for the month of May: Sales Cost of goods sold Selling and administrative expenses Accounts receivable, May 1st Accounts receivable, May 31st If all of the company's sales are on account, what is the amount of cash collections from customers included in the cash budget for May? Multiple Choice $109,000 $106,000 $129,000 $ 125,000 $ 90,000 $ 24,000 $ 16,000 $ 35,000 $125,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub