1. Schedule of expected cash collections
July | August | September | Quarter | |
Cash sales | $9,400 | $15,400 | $11,400 | $36,200 |
Credit sales: | ||||
May | 5,920 | 5,920 | ||
June | 24,080 | 6,880 | 30,960 | |
July | 3,760 | 26,320 | 7,520 | 37,600 |
August | 6,160 | 43,120 | 49,280 | |
September | 4,560 | 4,560 | ||
Total cash collections | $43,160 | $54,760 | $66,600 | $164,520 |
Explanation:
July | August | September | |
Cash sales (20%) | $47,000×20% | $77,000×20% | $57,000×20% |
Credit sales: | |||
May | 37,000×80%×20% | ||
June | 43,000×80%×70% | 43,000×80%×20% | |
July | 47,000×80%×10% | 47,000×80%×70% | 47,000×80%×20% |
77,000×80%×10% | 77,000×80%×70% | ||
57,000×80%×10% |
2 a. Merchandise purchase budget
July | August | September | |
Cost of goods sold | $26,800 | $44,800 | $32,800 |
Add: Desired Ending inventory | 33,600 | 24,600 | 22,350 |
Total needs | 60,400 | 69,400 | 55,150 |
Less: beginning inventory | (21,500) | (33,600) | (24,600) |
Merchandise purchase | $38,900 | $35,800 | $30,550 |
* Beginning inventory is next month 75% of sale
*Beginning inventory is the previous month Ending inventory
2 b. Schedule of expected cash disbursements
July | August | September | Quarter | |
Accounts payable | $15,200 | |||
July purchase | 19,450 | 19,450 | ||
August purchase | 17,900 | 17,900 | ||
September purchase | 15,275 | |||
Total cash disbursements | $34,650 | $37,350 | $33,175 | $105,175 |
3. Cash Budget
July | August | September | Quarter | |
Beginning cash | $8,700 | $9,410 | $9,170 | $8,700 |
Total cash collections | 43,160 | 54,760 | 66,600 | 164,520 |
Total cash available | 51,860 | 64,170 | 75,770 | 173,220 |
Less: Disbursements for merchandise purchase | 34,650 | 37,350 | 33,175 | 105,175 |
Selling expenses | 9,300 | 13,100 | 9,200 | 31,600 |
Administrative expense | 3,650 | 5,550 | 4,450 | 13,650 |
Purchase of land | 4,850 | - | - | 4,850 |
Dividends paid | - | - | 1,350 | 1,350 |
Total disbursements | 52,450 | 56,000 | 48,175 | 156,625 |
Excess (Deficiency) of cash | (590) | 8,170 | 27,595 | 16,595 |
Finance: | ||||
Borrowing | 10,000 | 1,000 | - | 11,000 |
Interest | (320) | (320) | ||
Repayment | (11,000) | (11,000) | ||
Total Finance | 10,000 | 1,000 | (11,320) | (320) |
Ending balance | $9,410 | $9,170 | $16,275 | $16,275 |
*Interest paid =$10,000×3% +$1,000×2% =$320
* Cash paid for administrative expense= Administrative expense- Depreciation expense
____×____
Please do support
Any doubt comment below
Where did you get the 1,000 borrowing at the month of august?
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...
Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Managrial accounting Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 72,000 Accounts receivable 128,000 Inventory 60,900 Plant and equipment, net of depreciation 218,000 Total assets $ 478,900 Liabilities and Stockholders’ Equity Accounts payable $ 79,000 Common stock 308,000 Retained earnings 91,900 Total liabilities and stockholders’ equity $ 478,900 Beech’s managers...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 72,000 128,000 60,900 218,000 $ 478,900 $ 79,000 308,000 91,900 $ 478,900 Beech's managers...