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 | $ | 510,000 | $ | 710,000 | $ | 410,000 | $ | 310,000 |
| Cost of goods sold | 357,000 | 497,000 | 287,000 | 217,000 | ||||
| Gross margin | 153,000 | 213,000 | 123,000 | 93,000 | ||||
| Selling and administrative expenses: | ||||||||
| Selling expense | 71,000 | 91,000 | 52,000 | 31,000 | ||||
| Administrative expense* | 40,500 | 53,600 | 32,600 | 29,000 | ||||
| Total selling and administrative expenses | 111,500 | 144,600 | 84,600 | 60,000 | ||||
| Net operating income | $ | 41,500 | $ | 68,400 | $ | 38,400 | $ | 33,000 |
*Includes $13,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; 80% collected in the first month following the month of sale; and the remaining 10% collected in the second month following the month of sale. February’s sales totaled $145,000, and March’s sales totaled $205,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 $93,100.
-
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 $71,400.
-
Dividends of $21,000 will be declared and paid in April.
-
Land costing $29,000 will be purchased for cash in May.
-
The cash balance at March 31 is $43,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.
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.
Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total.
|
|
|
Prepare the following for merchandise inventory, a merchandise purchases budget for April, May, and June.
|
|
|
Prepare the following for merchandise inventory, a schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total.
|
|
|
Prepare a cash budget for April, May, and June as well as in total for the quarter. (Cash deficiency, repayments and interest should be indicated by a minus sign.)
|
|
|
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps
- The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $836. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. Inventory purchases average 66% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner. Rent is $5,100 per month. Taxes to be paid in June are $6,780. The owner also tells you that he…arrow_forwardPeters Products, a distributor of organic beverages, needs a cash budget for September. The following information is available: The cash balance at the beginning of August is 9,000€. Contribution margin is 50% (COGS are 50% of sales) Actual sales for July and expected sales for August, September and October are as shown below. Some customers pay in cash (Cash sales) and others in account as described in the figure below. Customers that pay in account, make the payment the month after. Purchases of inventory (company just resells what they buy) must be done so that the end of month inventory must cover 20% of next month sales. Initial inventory in July was 5.300€. 100% of a month’s inventory purchases are paid for during the month of purchase. Prepare a schedule of expected cash collections for August, September & October. Prepare a merchandise purchases budget for July, August, and September. Prepare a schedule of expected cash flow (cash in minus cash out) for August, and…arrow_forwardCarol's Chocolate Company has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,700 $47,000 Cash payments: Purchases of direct materials 31,000 21,400 17,000 Operating expenses 12,200 8,700 11,700 Capital expenditures 13,100 24,400 0 The cash balance on June 30 is projected to be $5,500. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 4%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the ending projected cash balance before financing for August.arrow_forward
- Ivanhoe Design provided the following budgeted information for April through July: April May June July Projected sales $112320 $132840 $124200 $142560 Projected merchandise purchases $88560 $99360 $84240 $71280 The cash balance on June 1 is $12960. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $33480 per month of which depreciation is $3240 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $4320 per month of which $648 is interest and the remainder is principal. How much are budgeted cash disbursements for June? $111024. $127872. $93312. $68256.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_forwardKayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.arrow_forward
- Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 174,000 $ 264,000 87,000 132,000 87,000 132,000 $ 214,000 107,000 107,000 21,400 17,400 26,400 $ 69,600 $ 85,600 $ 105,600 Historically, cost of goods sold is about 50 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare…arrow_forwardGarden 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 cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July is: April May June July Sales $ 500,000 $ 700,000 $ 400,000 $ 300,000 Cost of goods sold 350,000 490,000 280,000 210,000 Gross margin 150,000 210,000 120,000 90,000 Selling and administrative expenses: Selling expense 70,000 90,000 51,000 30,000 Administrative expense* 40,000 52,800 32,000 28,000 Total selling and administrative expenses 110,000 142,800 83,000 58,000 Net operating income $ 40,000 $ 67,200 $ 37,000 $ 32,000 *Includes $12,000 of depreciation each month. Sales are 20% for cash and…arrow_forwardMusic World reports the following budgeted sales: August, $170,000; and September, $200,000. Cash sales are 40% of total sales, and all credit sales are collected in the month following the sale. Prepare a schedule of cash receipts from sales for September. MUSIC WORLD Schedule of Cash Receipts from Sales Sales Cash receipts from: Total cash receipts September $ 200,000arrow_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