The following information is available to assist you in preparing a company's cash budget. a. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $47,600. b. Actual sales for May and June and expected sales for July are as follows: Cash sales Sales on account June May July $78,800 $ 74,400 $ 89,600 $ 405,000 $ 615,000 $628,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% is uncollectible. c. Purchases of inventory will total $351,000 for July. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $194,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $512,000 for July. Of this amount, $81,400 is for depreciation. e. A new web server for the Marketing Department costing $104,000 will be purchased for cash during July, and dividends totaling $11,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: 1. Calculate the expected cash collections for July. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month. The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $47,600. b. Actual sales for May and June and expected sales for July are as follows: Cash sales Sales on account June May July $78,800 $ 74,400 $ 89,600 $ 405,000 $ 615,000 $628,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% is uncollectible. c. Purchases of inventory will total $351,000 for July. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $194,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $512,000 for July. Of this amount, $81,400 is for depreciation. e. A new web server for the Marketing Department costing $104,000 will be purchased for cash during July, and dividends totaling $11,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: 1. Calculate the expected cash collections for July. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month.
Expert Answer:
Answer rating: 100% (QA)
1 Expected cash collections for July May sales 405000 20 81000 collected in J... 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
-
The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31, 2010: a. The balance on the May 31, 2010, bank statement is $8,432.11. b. Not...
-
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Karens Catering on March 31, 2010: a. The balance on the March 31, 2010, bank statement...
-
In the figure shown the block is given along the block Small of the displacement 's motion system is lying on table). of the a spring 3.. Equation_
-
In January 2014, Tongo Inc., a branding consultant, had the following transactions. Indicate the accounts, amounts, and direction of the effects on the accounting equation under the accrual basis....
-
The comparative balance sheet of Merrick Equipment Co. for Dec. 31, 2014 and 2013, is: The income statement for the year ended December 31, 2014, is as follows: Additional data obtained from an...
-
In Exercises 1 to 4, it may be helpful to draw a figure such as Figure 5.5. Figure 5.5. Using the normal curve table, determine the area of the standard normal distribution that is greater than the...
-
The following selected transactions occurred during 2018 and 2019 for Baltic Importers. The company ends its accounting year on September 30. 2018 Jul. 1 Loaned $16,000 cash to Bud Shyne on a...
-
Whitney received $ 7 6 , 1 0 0 of taxable income in 2 0 2 3 . All of the income was salary from her employer. What is her income tax liability in each of the following alternative situations?
-
Show the contents in hexadecimal of registers PC, AR, DR, IR, and SC of the basic computer when an ISZ indirect instruction is fetched from memory and executed. The initial content of PC is 7FF. The...
-
What forms of relationship have appeared via online connections?
-
Pearl owns 60 percent of Gorman Corp.'s stock. During 2015, Pearl contributed property with an adjusted basis of $20,000 and a fair market value of $15,000 to Gorman Corp. in a transaction qualifying...
-
Sell Corporation has 400 shares of its only class of stock outstanding. Mr. Church owns 60 shares, his wife owns 80 shares, his son owns 200 shares, and his sons daughter owns 60 shares. Under the...
-
During the current year, a corporation distributed property with an adjusted basis of $100,000 and a fair market value of $140,000 to its shareholders. Its earnings and profits for the year were...
-
James owns 100 shares of Price Company which are Section 306 stock. He also owns 300 shares of its common stock. He wants to dispose of these shares in 2019 and is considering several options....
-
Larry owns 90 of the 100 outstanding shares of EDP Corporation. Larry acquired the 90 shares in 2008 for $15,000. He also owns 70 of the 100 outstanding shares of EDT Corporation. Larry acquired the...
-
Psari's, a company that sells fishing nets, provides the following information about its product Targeted operating income Sales price per unit Variable cost per unit Total fixed costs $52,000 8.00...
-
(a) How far away can a human eye distinguish two ear headlights 2.0 m apart? Consider only diffraction effects and assume an eye pupil diameter of 5.0 mm and a wavelength of 550 nm. (b) What is the...
-
Refer to the data in Exercise 9-8. Auto Lavage's actual level of activity was 8,100 cars. The actual revenues and expenses for October are given below Required 1. Prepare a flexible budget...
-
Ace Mining Tools Ltd. of Calgary makes specialty tools used in the mining industry. The company uses an ABC system for internal decision making. The company has four activity cost pools, as listed...
-
Rest Easy produces two types of mattresses: Regular and Heavenly. Budgeted and actual data for 2018 were as follows: Market Data for 2019: Expected total market unit sales of mattresses: Regular...
-
What are a manager's resources?
-
What are the three levels of management?
-
What is the glass ceiling?
Study smarter with the SolutionInn App