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 Net operating income *Includes $15,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. April $ 450,000 315,000 May $ 980,000 686,000 June $ 430,000 301,000 July $ 330,000 231,000 135,000 294,000 129,000 99,000 87,000 93,000 54,000 33,000 41,500 55,200 33,800 31,000 128,500 148,200 87,800 64,000 $ 6,500 $ 145,800 $ 41,200 $ 35,000 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 $155,000, and March's sales totaled $215,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 $91,700. 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 $63,000. f. Dividends of $23,000 will be declared and paid in April. g. Land costing $31,000 will be purchased for cash in May. h. The cash balance at March 31 is $45,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 The company's president is interested in knowing how reducing inventory levels and collecting accounts receivable sooner will impact the cash budget. He revises the cash collection and ending inventory assumptions as follows: a. Sales continue to be 20% for cash and 80% on credit. However, credit sales from April, May, and June are collected over a three- month period with 25% collected in the month of sale, 65% collected in the month following sale, and 10% in the second month following sale. Credit sales from February and March are collected during the second quarter using the collection percentages specified in the main section. b. The company maintains its ending inventory levels for April, May, and June at 15% of the cost of merchandise to be sold in the following month. The merchandise inventory at March 31 remains $63,000 and accounts payable for inventory purchases at March 31 remains $91,700. Required: 1. Using the president's new assumptions in (a) above, prepare a schedule of expected cash collections for April, May, and June and for the quarter in total. 2. Using the president's new assumptions in (b) above, 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. Using the president's new assumptions, prepare a cash budget for April, May, and June, and for the quarter in total. 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 Net operating income *Includes $15,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. April $ 450,000 315,000 May $ 980,000 686,000 June $ 430,000 301,000 July $ 330,000 231,000 135,000 294,000 129,000 99,000 87,000 93,000 54,000 33,000 41,500 55,200 33,800 31,000 128,500 148,200 87,800 64,000 $ 6,500 $ 145,800 $ 41,200 $ 35,000 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 $155,000, and March's sales totaled $215,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 $91,700. 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 $63,000. f. Dividends of $23,000 will be declared and paid in April. g. Land costing $31,000 will be purchased for cash in May. h. The cash balance at March 31 is $45,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 The company's president is interested in knowing how reducing inventory levels and collecting accounts receivable sooner will impact the cash budget. He revises the cash collection and ending inventory assumptions as follows: a. Sales continue to be 20% for cash and 80% on credit. However, credit sales from April, May, and June are collected over a three- month period with 25% collected in the month of sale, 65% collected in the month following sale, and 10% in the second month following sale. Credit sales from February and March are collected during the second quarter using the collection percentages specified in the main section. b. The company maintains its ending inventory levels for April, May, and June at 15% of the cost of merchandise to be sold in the following month. The merchandise inventory at March 31 remains $63,000 and accounts payable for inventory purchases at March 31 remains $91,700. Required: 1. Using the president's new assumptions in (a) above, prepare a schedule of expected cash collections for April, May, and June and for the quarter in total. 2. Using the president's new assumptions in (b) above, 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. Using the president's new assumptions, prepare a cash budget for April, May, and June, and for the quarter in total.
Expert Answer:
Answer rating: 100% (QA)
To solve this problem we need to prepare the following 1 A schedule of expected cash collections for April May and June and for the quarter in total using the new collection assumptions 2 A merchandis... 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
-
POI Pty. Ltd. purchases comic books from publishers and resells them to customers. The company has a perpetual inventory system and assigns the cost of goods sold on a FIFO basis. The company has the...
-
What would you say to this person about their statement below and what question would you ask? Union organizations began in this country in the 18th century and looked very different from todays...
-
In Exercises find the indefinite integral. sech(2x1) dx
-
Find the sum-of-products expansion of the Boolean function F(w, x, y, z) that has the value 1 if and only if an odd number of w, x, y, and z have the value 1.
-
Using the phrase structure rules given below, a) CP (C) TP b) TP {NP/CP} (T) VP c) VP (AdvP+) V (NP) ({NP/CP}) (AdvP+) (PP+) (AdvP+) d) NP (D) (AdjP+) N (PP+) (CP) e) PP P (NP) f) AdjP (AdvP)...
-
A beam of electrons, a beam of protons, and a beam of oxygen atoms each pass at the same speed through a 1-,m-wide slit. Which will produce the widest central maximum on a detector behind the slit?...
-
The Robotics Corporation produces cuddly toys using only computer-driven robots. The quantity of toys (T) produced per year is given by T = 10R where R is the number of robots used during each year...
-
Solve the inequality:-n
-
1. Marybeth and Anneal Yao are beginning to contemplate retirement. They are each forty-five years of age and have saved a total of $500,000 for retirement. Marybeth and Anneal realize that they have...
-
Under what circumstances does the bidirectional movement of substances across the cellular membrane occur without necessitating the input of energy?
-
Tad and Audria, who are married filing a joint return, have AMTI of $1,256,000 for 2021. Calculate their AMT exemption. A
-
Girl Power Corporation employs purely women. It installed a lactation station at a total cost of P350,000 and secured a "Working Mother-Baby- Friendly Certificate" from the Department of Health....
-
A rocket using hydrogen-oxygen as the fuel-oxidizer combination has a specific impulse of 360s. Calculate the ratio of propellant mass to initial mass required to achieve a burnout velocity equal to...
-
Interactive Investments has one of its new clients, Jason Todd, recently sign up with the firm to manage his portfolio. Jason recently came into an inheritance of $1,250,000 that he wants to have...
-
Multiple Choice Questions: 1. An information system that supports a particular area of an organization, such as production or marketing, is called a: a. distributed data processing system. b....
-
Juarez worked for Westarz Homes at construction sites for five years. Bever was a superintendent at construction sites, supervising subcontractors and moving trash from sites to landfills. He...
-
Find the position of the first minimum for a single slit of width 0.04 \(\mathrm{mm}\) on a screen of \(2 \mathrm{~m}\) distance, when light from a He-Ne laser \(\lambda=\) 6328 is shone on the slit.
-
A diffraction grating is a closely spaced array of apertures or obstacles forming a series of closely spaced slits. The simplest type in which an incoming wave front meets alternating opaque and...
-
(a) Determine the coherence area for a mercury arc lamp at 6330 at a distance of \(1 \mathrm{~m}\) from the source. Assume that the output aperture is \(3 \mathrm{~mm}\) and that the beam is...
Study smarter with the SolutionInn App