Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses April $ 810,000 567,000 243,000 May $ 950,000 665,000 June $ 650,000 July $ 560,000 455,000 392,000 285,000 195,000 168,000 95,000 114,000 76,000 56,000 52,500 74,200 47,000 53,000 147,500 188,200 123,000 109,000 Net operating income $ 95,500 $ 96,800 $ 72,000 $ 59,000 *Includes $37,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10% collected in the month of sale; 70% collected in the first month following the month of sale; and the remaining 20% collected in the second month following the month of sale. February's sales totaled $305,000, and March's sales totaled $320,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month's inventory purchases are paid for in the month of purchase. The remaining 50% is paid in the following month. Accounts payable at March 31 for inventory purchases during March total $146,300. e. Each month's ending inventory must equal 20% of the cost of the merchandise to be sold in the following month. The merchandise inventory at March 31 is $113,400. f. Dividends of $44,000 will be declared and paid in April. g. Land costing $56,000 will be purchased for cash in May. h. The cash balance at March 31 is $66,000; the company must maintain a cash balance of at least $40,000 at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: 1. Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for April, May, and June. b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. 3. Prepare a cash budget for April, May, and June as well as in total for the quarter. Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses April $ 810,000 567,000 243,000 May $ 950,000 665,000 June $ 650,000 July $ 560,000 455,000 392,000 285,000 195,000 168,000 95,000 114,000 76,000 56,000 52,500 74,200 47,000 53,000 147,500 188,200 123,000 109,000 Net operating income $ 95,500 $ 96,800 $ 72,000 $ 59,000 *Includes $37,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10% collected in the month of sale; 70% collected in the first month following the month of sale; and the remaining 20% collected in the second month following the month of sale. February's sales totaled $305,000, and March's sales totaled $320,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month's inventory purchases are paid for in the month of purchase. The remaining 50% is paid in the following month. Accounts payable at March 31 for inventory purchases during March total $146,300. e. Each month's ending inventory must equal 20% of the cost of the merchandise to be sold in the following month. The merchandise inventory at March 31 is $113,400. f. Dividends of $44,000 will be declared and paid in April. g. Land costing $56,000 will be purchased for cash in May. h. The cash balance at March 31 is $66,000; the company must maintain a cash balance of at least $40,000 at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: 1. Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for April, May, and June. b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. 3. Prepare a cash budget for April, May, and June as well as in total for the quarter.
Expert Answer:
Answer rating: 100% (QA)
1 Schedule of Expected Cash Collections Month April Cash Sales 20 950000 20 190000 Collections from March Sales 10 320000 10 32000 Collections from February Sales 70 305000 70 213500 Total Cash Collec... View the full answer
Related Book For
Introduction to Managerial Accounting
ISBN: 978-1259105708
5th Canadian edition
Authors: Peter C. Brewer, Ray H. Garrison, Eric Noreen, Suresh Kalagnanam, Ganesh Vaidyanathan
Posted Date:
Students also viewed these accounting questions
-
a. How could aspirin be synthesized, starting with benzene? b. Ibuprofen is the active ingredient in pain relievers such as Advil®, Motrin®, and Nuprin®. How could ibuprofen be...
-
Differentiate the function. (a) f(x) = 240 (b) f(t) = 2 - 2/3t (c) f(x) = x3 - 4x + 6 (d) g(x) = x2 (1 - 2x)
-
Pharoah Company operates a small factory in which it manufactures two products: A and B. Production and sales results for this year were as follows: A B Units sold 9,200 18,300 Selling price per unit...
-
The drag characteristics of an airplane are to be determined by model tests in a wind tunnel operated at an absolute pressure of \(1300 \mathrm{kPa}\). If the prototype is to cruise in standard air...
-
A project that is expected to last six years will generate a profit and cash flow contribution before taxes and depreciation of $23,000 per year. It requires the initial purchase of equipment costing...
-
How are best fit and best practice HR practices similar and different, what are the benefits and limitations of each?
-
A fundamental constraint used in reporting accounting information is conservatism, generally speaking, when a choice is to be made the option that is least likely to overstate assets is the preferred...
-
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division's return on investment (ROI), which has been above 23% each of the last three...
-
Onshore Bank has $50 million in assets, with risk-adjusted assets of $30 million. Tier I capital is $2 million, and Tier II capital is $1.5 million. How will the following transactions affect the...
-
Current Attempt in Progress Sheridan Sales Company has sales of $1,250,000. If the company's management expects sales to grow 5.50 percent annually, how long will it be before sales double?
-
1. Information: Usage=20 cases/day Purchase cycle=4 days Lead time=1day Safety stock 20 cases You are asked to finish: II A. How many cases left should we make an order? B. How many cases to order?...
-
1)What is the difference between Exception and Error? 2) What is Exception? 3) What is try block? 4) what is catch block? Q)How to display exception details? 5)What is the difference between final,...
-
1. What is the archimate modelling tool set? 2. Identify and describe ways in which enterprise architecture can assist in increasing an organizations revenue and reducing costs. Support your answer...
-
Should we separate the debt and equity features of convertible debt? Team 1: Pro separation: Present arguments in favor of separating the debt and equity features of convertible debt. Team 2: Against...
-
For the attached flows over slender delta wings, show that at low angles of attack Eqs. 1.11 and 1.33 are identical. Eq 1.11 Eq 1.13 = 1 2 AR CL=
-
The ellipsoid given in Problem 2.3 is also undergoing a pulsative major axis change with the same period but with phase difference \(\phi\). Express the equation of surfaces. Problem 2.3 An oblate...
-
Express the components of stress tensor in generalized coordinates in terms ofvelocity gradients.
Study smarter with the SolutionInn App