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...
-
Determine the crystal structure for the following: (a) A metal with a0 = 4.9489 , r = 1.75 and one atom per lattice point; and (b) A metal with a0 = 0.42906 nm, r = 0.1858 nm, and one atom per...
-
Is China experiencing a net capital inflow or outflow? Use the following balance of payments data for China (Mainland) from the IMF to answer this problem. Assumptions (million US$) 2000 2001 2002...
-
A variation of the indicator dilution method (see preceding problem) is used to measure total blood volume. A known amount of a tracer is injected into the bloodstream and disperses uniformly...
-
Problem 17-1A Comparing costs using ABC with the plantwide overhead rate LO P1, P3, A1, A2 The following data are for the two products produced by Tadros Company. Product A $20 per unit 0.5 DLH per...
-
CAR-71690 company purchases battery powered bikes from a manufacturer for $1,515 per unit and then sells them to its customers for $2,900 each. The company's monthly selling and administrative costs...
-
What is the difference between overall planned audit risk and the individual audit risks?
-
The Institute for Women s Policy Research (2012) found that the ratio of women s to mens median weekly full-time earnings rose by 1 percentage point since 2010 and reached a high of 82.2 percent....
-
The 2011 Deloitte Volunteers Impact Survey found that 56 percent of millennials (ages twenty-one to thirty-five) who participate in a companys sponsored volunteer activities are more likely to rate...
-
Identify several major internal audit activities.
-
In planning an audit and evaluating audit evidence what consideration must be coupled with materiality?
-
After completing this week s reading and video assignments, create one compelling chart from your project data results to post on the discussion board to share with your classmates. Include the...
-
Explain what is meant by vicarious liability and when it is available?
-
Show how the share price of a very profitable company which invests at a rate of return that is higher than the required rate of return can still drop.
-
What is a conglomerate discount? How can it be avoided?
-
A company that is close to insolvency carries out a capital increase. Is this a signal? Why? What criteria can you identify as being necessary for a decision to be described as a signal?
Study smarter with the SolutionInn App