The cash balance on December 1 is $51,200. Actual sales for October and November and expected...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The cash balance on December 1 is $51,200. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 74,200 $ 455,000 November $ 79,600 $ 550,000 December $ 83,600 $ 673,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% are uncollectible. c. Purchases of inventory will total $346,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $177,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $473,000 for December. Of this amount, $75,000 is for depreciation. e. A new web server for the Marketing Department costing $72,000 will be purchased for cash during December, and dividends totaling $17,500 will be paid during the month. f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company's bank to increase its cash balance as needed. Required: For December: 1. Calculate the expected cash collections. 2. Calculate the expected cash disbursements for merchandise purchases. 3. Prepare a cash budget. Indicate in the financing section any borrowing needed during the month. Assume any interest will not be paid until the following month. The cash balance on December 1 is $51,200. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 74,200 $ 455,000 November $ 79,600 $ 550,000 December $ 83,600 $ 673,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% are uncollectible. c. Purchases of inventory will total $346,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $177,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $473,000 for December. Of this amount, $75,000 is for depreciation. e. A new web server for the Marketing Department costing $72,000 will be purchased for cash during December, and dividends totaling $17,500 will be paid during the month. f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company's bank to increase its cash balance as needed. Required: For December: 1. Calculate the expected cash collections. 2. Calculate the expected cash disbursements for merchandise purchases. 3. Prepare a cash budget. Indicate in the financing section any borrowing needed during the month. Assume any interest will not be paid until the following month.
Expert Answer:
Answer rating: 100% (QA)
1 Expected Cash Collections Month Cash Sales Sales on Account Total Sales Collections ... View the full answer
Related Book For
Managerial Accounting
ISBN: 9781259275814
11th Canadian Edition
Authors: Ray H Garrison, Alan Webb, Theresa Libby
Posted Date:
Students also viewed these accounting questions
-
Write an essay:(300-400) on the following topics: What is the purpose of a small grocery store that sells goods and household items. What is the mission of a small grocery store that sells goods and...
-
Today, I am presented with the case of Jared. A 5-year-old in kindergarten. When the child is frustrated, he becomes very angry, curses, and hits the teachers and other students. Recently he has had...
-
It is sometimes important to "dig down" and see what the research methodology is underlying a report's findings. This helps determine how valid the findings are., discuss what the report's research...
-
Define a passive portfolio construction strategy and briefly discuss how reasonable it might be for an investor to pursue a passive strategy. Explain the role of risk aversion in the construction of...
-
What is the difference between a conventional mortgage and a high ratio mortgage? What is a vendor take-back mortgage? How does it work?
-
Calculate the number of vacancies per cubic meter in iron at 850C. The energy for vacancy formation is 1.08 eV/atom. Furthermore, the density and atomic weight for Fe are 7.65 g/cm3 and 55.85 g/mol,...
-
A grocer buys a delivery van from Homer Motors for 9,000 by cheque. The entries to be made in the grocer's accounting system are: a. Debit Delivery van, Credit Bank b. Debit Purchases, Credit Bank c....
-
On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: During January 2021, the following transactions occur: 1. January 2 Provide services to...
-
Use the image to answer the question. Alarm Clock Set 5:00 a.m. 5:30 6:00 6:30 7:00 Calculate the mean and median of the given data. Round your answers to the nearest half-ho increment as needed (1...
-
Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 to 5 Req 6 Prepare a contribution format income statement. Todrick Company Contribution Format Income Statement...
-
An organization requires all candidates for a specific position to fill out a personality assessment instrument as part of the application process. What best explains why they would have candidates...
-
Evaluate tan (4) without using a calculator Evaluate 4 sec (20) - 4 tan (20) without using a calculator Evaluate cos(30) sin(60) without using a calculator Find the amplitude of f(x) = 9 sin (3x+)...
-
You are the Financial Manager of C&C Corporation and are evaluating to launch a new product that requires an initial cash outlay of $220,000 to purchase a new machine. It is expected to generate net...
-
Review and research this Guard RFID product technology. Real-Time Visibility of Your Staff, Patients, and Assets - GuardRFIDA Real-Time Location System (RTLS) is a precise positioning system that can...
-
Fedex and UPS Documentary YouTubeLinks to an external site. Please Post Your Detailed Answers to the Following Questions: 1. What are the shipping performance measures of Fedex and UPS? 2. What...
-
Step 1 You'll start the cabling layout with the administrative building and the inspection garage. The team determines that approximately 11,500 feet of cabling will be required. The cabling will...
-
You've been asked to take over leadership of a group of paralegals that once had a reputation for being a tight-knit, supportive team, but you quickly figure out that this team is in danger of...
-
Dominiques Frozen Food Company makes frozen dinners and sells them to retail outlets near London. Dominique has just inherited 10,000 and has decided to invest it in the business. She is trying to...
-
Bastille Corporation produces two grades of wine from grapes that it buys from California growers. It produces and sells roughly 3,000,000 liters per year of a low-cost, high-volume product called...
-
Metro Hospital has been under pressure to keep costs down. Indeed, the hospital administrator has been managing various revenue-producing centres to maximize contributions to the recovery of the...
Study smarter with the SolutionInn App