Related questions
Concept explainers
Garden Sales, Inc., 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
-
Budgeted monthly absorption costing income statements for April–July are:
| April | May | June | July | |||||
| Sales | $ | 440,000 | $ | 970,000 | $ | 420,000 | $ | 320,000 |
| Cost of goods sold | 308,000 | 679,000 | 294,000 | 224,000 | ||||
| Gross margin | 132,000 | 291,000 | 126,000 | 96,000 | ||||
| Selling and administrative expenses: | ||||||||
| Selling expense | 85,000 | 92,000 | 53,000 | 32,000 | ||||
| Administrative expense* | 41,000 | 54,400 | 33,200 | 30,000 | ||||
| Total selling and administrative expenses | 126,000 | 146,400 | 86,200 | 62,000 | ||||
| Net operating income | $ | 6,000 | $ | 144,600 | $ | 39,800 | $ | 34,000 |
*Includes $14,000 of
-
Sales are 20% for cash and 80% on account.
-
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 $150,000, and March’s sales totaled $210,000.
-
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 $89,600.
-
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 $61,600.
-
Dividends of $22,000 will be declared and paid in April.
-
Land costing $30,000 will be purchased for cash in May.
-
The cash balance at March 31 is $44,000; the company must maintain a cash balance of at least $40,000 at the end of each month.
-
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
-
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.
-
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 $61,600 and accounts payable for inventory purchases at March 31 remains $89,600.
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.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
- The Guitar Shoppe reports the following budgeted sales: August, $150,000, and September, $170,000. For its total sales, 40% are immediately collected in cash, 55% are credit sales and collected in the month following sale, and the remaining 5% are written off as uncollectible. Prepare a schedule of cash receipts from sales for September. THE GUITAR SHOPPE Schedule of Cash Receipts from Sales Sales Cash receipts from Total cash receipts September $ 170,000arrow_forwardThe Guitar Shoppe reports the following budgeted sales: August, $140,000; and September, $250,000. For its total sales, 35% are immediately collected in cash, 50% are credit sales and collected in the month following sale, and the remaining 15% are written off as uncollectible. Prepare a schedule of cash receipts from sales for September. THE GUITAR SHOPPE Schedule of Cash Receipts from Sales Sales Cash receipts from: Total cash receipts September $ 250,000arrow_forwardplease solve all complete and accuratearrow_forward
- Can you help with Budget Drill #8?arrow_forwardGarden 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 $17,000 of depreciation each month. April $ 550,000 385,000 165,000 75,000 42,500 117,500 $ 47,500 May $ 750,000 525,000 225.000 95,000 56,800 151,800 $ 73,200 June $ 450,000 315,000 135,000 56,000 35,000 91,000 $ 44,000 July $ 350,000 245,000 105,000 35,000 33,000 68,000 $ 37,000 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with…arrow_forwardBustillo Incorporated is working on its cash budget for March. The budgeted beginning cash balance is $36,000. Budgeted cash receipts total $117,000 and budgeted cash disbursements total $111,000. The desired ending cash balance is $53,500. To attain its desired ending cash balance for March, the company needs to borrow: Multiple Choice $95,500 $11,500 $0 $53,500arrow_forward
- Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $400,000 for April and $480,000 for May. Cost of goods sold is expected to be 65% of sales. The company’s desired ending inventory is 20% of the following month’s cost of goods sold.Compute the required purchases for April. Moore WholesalersPurchases Budget $ : : $arrow_forwardDeschambault Inc. is working on its cash budget for December. The budgeted beginning cash balance is $14,000. Budgeted cash receipts total $127,000 and budgeted cash disbursements total $126,000. The desired ending cash balance is $40,000. To attain its desired ending cash balance for December, the company needs to borrow: A. $40,000 B. $55,000 C. $25,000 D. $0arrow_forwardAnnie’s Homemade Ice Cream is preparing a planning budget for August. Its budgeted revenue per serving is $5.00. It has identified two cost drivers—number of servings and number of labor-hours. The company expects to sell 10,800 servings and to staff 700 employee labor-hours in August. Data concerning the company’s cost formulas are shown below: Fixed Cost Per MonthCost per ServingCost per Labor-HourIngredients expense $ 1.25 Salaries and wages expense$ 7,000 $ 8.00Franchise fee $ 0.25 Credit card processing fees $ 0.09 Utilities expense$ 300$ 0.02 Rent expense$ 3,000 Equipment depreciation expense$ 1,750 Other expenses$ 4,200 In August, the company actually sold 11,200 servings of ice cream and staffed 780 employee labor-hours. It’s budgetedarrow_forward
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education