S&P Enterprises has provided data from the first three months of the year. The Controller has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Data Actual January and February and expected March sales: Cash sales Sales on account Total Sales Accounts Receivable Collections: Month of sale Month following sale Second month following sale Uncollectible Accounts payable for inventory purchases, March 1 balance Budgeted inventory purchases in March Inventory payments: Month of purchase Month following purchase Total budgeted selling & administrative expenses in March (including depreciation) Budgeted depreciation in March (included in total selling and admin exp) Other budgeted cash disbursements in March January February $ 1,600 25,000 $ 26,600 $ 3,750 30,000 $ 33,750 $ 12,500 $ 3,200 15% 60% 22% 3% $ 10,500 $ 23,500 60% 40% March $ 5,100 40,000 $ 45,100 Equipment purchases $ 14,000 Dividends to be paid $ 2,000 Minimum cash balance to be maintained $ 10,000 $ 11,500 March 1 outstanding borrowings $ 0 $ 0 March 1 cash balance March 1 interest due The company has a line of credit available to bolster the cash balance as needed. Required: Click the Schedules and Cash Budget tab to prepare the following: a. Schedule of expected cash collections for March. b. Schedule of expected cash disbursements for inventory purchases for March. c. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be paid until the following month. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Data Actual January and February and expected March sales: Cash sales Sales on account Total Sales Accounts Receivable Collections: Month of sale Month following sale Second month following sale Uncollectible Accounts payable for inventory purchases, March 1 balance Budgeted inventory purchases in March Inventory payments: Month of purchase Month following purchase Total budgeted selling & administrative expenses in March (including depreciation) Budgeted depreciation in March (included in total selling and admin exp) Other budgeted cash disbursements in March January February $ 1,600 25,000 $ 26,600 $ 3,750 30,000 $ 33,750 $ 12,500 $ 3,200 15% 60% 22% 3% $ 10,500 $ 23,500 60% 40% March $ 5,100 40,000 $ 45,100 Equipment purchases $ 14,000 Dividends to be paid $ 2,000 Minimum cash balance to be maintained $ 10,000 $ 11,500 March 1 outstanding borrowings $ 0 $ 0 March 1 cash balance March 1 interest due The company has a line of credit available to bolster the cash balance as needed. Required: Click the Schedules and Cash Budget tab to prepare the following: a. Schedule of expected cash collections for March. b. Schedule of expected cash disbursements for inventory purchases for March. c. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be paid until the following month. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
A crossover trial is a type of experiment used to compare two drugs. Subjects take one drug for a period of time, then switch to the other. The responses of the subjects are then compared using...
-
Scott's Cycles sells merchandise on credit terms of 3/15, n/30. A sale invoiced at $2,700 (cost of sales $2,310) was made to Shannon Allen on February 1. The company uses the gross method of...
-
You are given the task of forecasting demand for the ski outfit collection of Snowful Wear Inc. As anticipated, you observe that demand is highly seasonal. The following table gives the quarterly...
-
Find and draw y(t) for the system below X(t)-21tl and h(t) as below h(t)
-
Vernal Equinox wishes to borrow $10,000 for three years. A group of individuals agrees to lend him this amount if he contracts to pay them $16,000 at the end of the three years. What is the implicit...
-
In one-way ANOVA we define the sum of squares SS& and SS. Prove the identity s s - = xij -nm*2 - -SSb i j
-
Most current debates about human resource management in general focus on the extent and nature of the responses needed in the face of developments in the business environment. L01
-
Officials of the Oakbrook Hills Golf and Tennis Club are in the process of preparing a budget for the year ending December 31. Because the club treasurer has had difficulty with two expense items,...
-
The following inventory transactions took place for Cullumber Ltd. for the year ended December 31, 2020: Date Event Quantity Cost/ Selling Price Jan 1 opening inventory 19,920 $38.95 Jan 5 sale 5,840...
-
Kaplan Computers manufactures high end computer systems for the graphics design industry. At the present time, the company makes three computers with the following characteristics: Computer 1...
-
T. M. Maxwell owns a retail business and made the following sales on account during the month of July 20--. There is a 5% sales tax on all sales. July Transactions: July1Sale No. 101 to Saga, Inc.,...
-
How do pilots interpret sustainable practices to improve workforce development and diversity, increase quality and efficiency while reducing costs in aviation and aerospace operations.
-
Develop a program model for training and development for nee line middle managers in healthcare organizations.
-
Describe each of the following in relation to policy development and implementation in the early childhood sector Codes ofpractice Duty ofcare Humanrights Privacy, confidentiality anddisclosure...
-
Martinez Ltd. had the following 2023 income statement data: Revenues $110,000 Expenses 50,900 $59.100 In 2023, Martinez had the following activity in selected accounts: Accounts Receivable Allowance...
-
Write the sequential representation for this binary tree B D A E C G H LL F remember, there are no spaces
-
Masks R Us Pty Ltd is now trading unprofitably as a result of the actions of Tom and Dick stated above (in question 5). The company now has difficulty in paying its debts and is falling behind in its...
-
The figure shows six containers, each of which is filled from the top. Assume that water is poured into the containers at a constant rate and each container is filled in 10 seconds. Assume also that...
-
(p. 164), you learned that according to the 2020 Breast Cancer Statistics, one in eight women in the United States will develop breast cancer in her lifetime. Consider a random sample of three...
-
Computer technician. Sean is a computer repair technician who works on a freelance basis. A company hires him for a month to troubleshoot issues affecting its computer systems and networks. Sean...
-
Solar energy cells. According to Energy Trend (January 2019), 38% of the solar energy cells manufactured worldwide are sold to China. Consider a random sample of five solar energy cells and let x...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App