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
Question
Chapter 8, Problem 23P
1.
To determine
To calculate: Expected cash collections for the month of April, May and June.
Introduction: A budget is a financial statement that includes the
2.
To determine
To prepare:
3.
To determine
To identify: Whether the loan can be repaid or not.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Saved
Help
其
You received no credit for this question in the prevlous attempt
Vie
Exercise 13-35 (Algo) Estimate Cash Collections (LO 13-5)
Minot Corporation is preparing its cash budget for August. The following information is availlable concerning its accounts receivable:
Estimated credit sales for August
Actual credit sales for July
Estimated collections in August for credit sales in August
Estimated collections in August for credit sales in July
Estimated collections in August for credit sales prior to July
Estimated write-offs in August for uncollectible credit sales
Estimated provision for bad debts in August for credit sales in August
$ 80,000
$ 60,000
25%
70%
$6,000
$ 4,000
$2,700
Required:
What is the estimated amount of cash receipts from accounts receivable collections in August?
Estimated cash receipts
$ 71,000
Schedule of Expected Cash Collections; Cash Budget
The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used:
a. On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible.
b. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never…
**Please answers questions 2-4**You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of earrings, but all are sold for the same price - $10 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):
January (actual)..... 20,000
June (budget)..... 50,000
February (actual)..... 26,000
July (budget)..... 30,000
March (actual)..... 40,000
August (budget)..... 28,000
April (budget)..... 65,000…
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
- 8. STRACO Cash Budget Friendly Freddie’s is an independently owned major appliance and electronics discount chain with seven stores located in a Midwestern metropolitan area. Rapid expansion has created the need for careful planning of cash requirements to ensure that the chain is able to replenish stock adequately and meet payment schedules to creditors. Fred Ferguson, founder of the chain, has established a banking relationship that provides a $200,000 line of credit to Friendly Freddie’s. The bank requires that a minimum balance of $8,200 be kept in the chain’s checking account at the end of each month. When the balance goes below $8,200, the bank automatically extends the line of credit in multiples of $1,000 so that the checking account balance is at least $8,200 at month-end. Friendly Freddie’s attempts to borrow as little as possible and repays the loans quickly in multiples of $1,000 plus 2 percent monthly interest on the entire loan balance. Interest payments and any principal…arrow_forwardQuestion 1Ming Chung Limited is applying for additional bank overdraft finance to enable thecompany to make the plant and machinery purchase described below. The directorshave has asked you to draw up a cash budget for the 6 months to 30 June 2020 toprove to the bank that that overdraft finance will be repaid by 30 June 2020. Thecompany provides you with the following financial information:Month Sales Purchases Wages Overheads£ £ £ £November 2019 (actual) 45,800 18,400 9,600 6,000December 2019 (actual) 34,600 13,900 9,800 14,000January 2020 (budgeted) 42,200 16,800 10,500 7,000February 2020 (budgeted) 44,000 17,600 11,200 7,500March 2020 (budgeted) 54,000 21,600 13,500 18,800April 2020 (budgeted) 57,600 23,000 14,400 8,000May 2020 (budgeted) 61,800 24,700 15,300 9,200June 2020 (budgeted) 63,700 25,500 15,900 9,800Notes♦ The bank balance at 1 January 2020 is expected to be £25,000.♦ 60% of sales are for cash with the other 40% being on credit. 70% of creditsales pay in the month…arrow_forward2 POINTS Problem: Cash Over (Short) JWU Bookstore has one cash register. On a recent day, the cash register tape reported sales in the amount of $453.70. Actual cash in the register (after deducting the $20 starting balance) was 450.70, which was deposited in the Company's bank account. Prepare a journal entry to record these cash collections. Account Name Debit Creditarrow_forward
- Problem 1. The Head of the Agency approves the establishment of a P30,000 petty cash fund. Here are the following information for the monthly petty expenses as well as the cash count: Coins and Currencies 7,800 Office Supplies Expense 3,400 Fuel and Oil 10,500 Postage and Courier Expenses 1,900 Maintenance and Operating Expenses 4,000 A. The journal entries if the PCF is closed. B. How much is the cash shortage(overage)? C. How is the shortage or overage accounted? D. The journal entries for the cash shortage(overage).arrow_forwardQuestion 3 Mischa Furniture Stores (“MFS”) is a company that specialises in office furniture based in Windhoek. Due to the effects of Covid-19, it has become very imperative for the company to manage its cash flows effectively. The owner of MFS knows of your skills in management accounting and has requested your service in the preparation of the forth coming quarter’s cash budget. Upon interviews with different departments at MFS, you have ascertained the following information: Budget information for January, February and March 2023 is as follows: January February March N$ N$ N$ Sales 590 000 650 000 750 000 Production costs 300 000 350 000 420 000 Sales and Administration costs 150 000 170 000 200 000 Purchase of non-current assets…arrow_forward4. Question Content Area Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.70 per check; the amount per check averages $85. “Bad” checks that Rosita cannot collect make up 2 percent of check revenue. During a typical month, Rosita's has sales of $47,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows: April $36,000 May 47,000 June 56,000 Required: Prepare a schedule of cash receipts for May and June. Round your intermediate computations and final answers to the nearest whole dollar. Rosita's Mexican RestaurantSchedule of Cash ReceiptsFor the Months of May and June May June Cash sales: $fill in the blank 1 $fill in the blank 2 Checks fill in the blank 3 fill in the blank 4 Total $fill in the blank 5 $fill in the blank 6arrow_forward
- s Problem 7-1 (Algo) Cost-benefit analysis of cash management [LO7-2] City Farm Insurance has collection centers across the country to speed up collections. The company also makes its disbursements from remote disbursement centers, so the firm's checks will take longer to clear the bank. Collection time has been reduced by three days and disbursement time increased by two days because of these policies. Excess funds are being invested in short-term instruments yielding 4 percent per annum. a. If City Farm has $4.45 million per day in collections and $3.80 million per day in disbursements, how many dollars has the cash management system freed up? Note: Enter your answer in dollars not in millions (e.g., $1,234,567). Freed-up funds b. How much can City Farm earn in dollars per year on short-term investments made possible by the freed-up cash? Note: Enter your answer in dollars not in millions (e.g., $1,234,567). Interest on freed-up casharrow_forwardCh. 8 Expected Ending Cash Balance Please solve and explain the following problem Madison Coroporation's beginning expected cash balance is $35,000. Cash collections are budgeted at $50,000 and cash disbursements are estimated to be $80,000. The minimum required cash balance is $20,000 and the company can borrow as much as needed in increments of $10,000. Calculate the expected ending cash balance for the month.arrow_forwardPrime Products hopes to borrow $79,000 on April 1 and repay it plus interest of $1,140 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $16,500. Accounts receivable on April 1 will total $190,400, of which $163,200 will be collected during April and $21,760 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April May $ 312,000 $ 204,000 $ 24,000 $ 24,800 $ 79,200 $ 428,000 $ 162,000 $ 24,000 $ 24,800 $ 79,200 $ 17,200 $ 17,200 c. Merchandise purchases…arrow_forward
- Problem 9.6A (Static) Preparing a bank reconciliation statement and journalizing entries to adjust the cash balance. LO 9-5, 9-6, 9-7 On August 1, 20X1, the accountant for Midwest Imports downloaded the company’s July 31, 20X1, bank statement from the bank’s website. The balance shown on the bank statement was $28,750. The July 31, 20X1, balance in the Cash account in the general ledger was $14,183. Ann Chen, the accountant for Midwest Imports, noted the following differences between the bank’s records and the company’s Cash account in the general ledger: An electronic funds transfer for $14,300 from Fabien Ricard, a customer located in France, was received by the bank on July 31. Check 1422 was correctly written and recorded for $1,200. The bank mistakenly paid the check for $1,240. The accounting records indicate that Check 1425 was issued for $69 to make a purchase of supplies. However, examination of the check online showed that the actual amount of the check was for $99. A…arrow_forwardProblem 1: The company sells a 2/10, n/30 basis. Internet control quite weak, so the senior accountant in charge of the examination of the company's financial statements asked you to make a careful review of the Cash Receipts Book for the month of July, 2020, which is reproduced below. You are asked to compute the cash short or over. Cash Receipts Cash Accounts Date Account Cash P 784 588 Item Sales Discount Receivable 7/5 7/10 Carrie Bart 6/24 invoice P 16 800 6/30 invoice 12 600 7/11 Cash Sales 25 25 7/12 Bart 7/13 Cash Sales 7/14 Antonio 7/15 Cash Sales 7/16 Bart 7/18 Cash Sales 7/20 Carrie 7/20 Cash Sales 7/27 Bart 7/1 invoice 294 6. 300 32 32 713 invoice 877 23 900 38 38 7/1 686 14 700 30 30 7/9 invoice 578 12 600 27 27 7/16 invoice 490 10 500 P 4,439 P 142 103 P 4,400arrow_forwardQUESTION 4 REQUIRED Use the information provided below to prepare the following for Xpanda Limited for February and March 2022: 4.1 Debtors Collection Schedule 4.2 Cash Budget. INFORMATION The following budgeted information was made available by Xpanda Limited for 2022: 1. An overdrawn bank balance of R125 000 is expected on 31 January 2022. 2. Forty percent (40%) of all sales are for cash; the balance is on credit. Sales for January and February 2022 (excluding discounts) are expected to be R640 000 and R900 000 respectively. Sales are expected to increase by 10% during March 2022. Twenty percent (20%) of the cash sales are to wholesalers and they are entitled to a discount of 10%. Thirty percent (30%) of the sales on credit is expected to be collected in the month of the sale for a cash discount of 5%. The balance is expected to be collected one month later. 3. Xpanda Limited sells its goods at cost plus 60%. All goods that are sold each month are replaced in the same month. Fifty…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY