Schedule of cash collection | |||||||
July | August | September | Quarter | ||||
Cash sales | 10600 | 16600 | 12600 | 39800 | |||
Sales on account | |||||||
May | 6880 | 6880 | |||||
June | 27440 | 7840 | 35280 | ||||
July | 4240 | 29680 | 8480 | 42400 | |||
August | 6640 | 46480 | 53120 | ||||
September | 5040 | 5040 | |||||
Total cash collections | 49160 | 60760 | 72600 | 182520 | |||
2a) | Merchandise purchase budget | ||||||
July | August | September | |||||
Budgeted cost of goods sold | 29,200 | 47,200 | 35,200 | ||||
Add:ending inventory | 35400 | 26400 | 24150 | ||||
total needs | 64,600 | 73,600 | 59,350 | ||||
Deduct:Beginning inventory | 24,500 | 35400 | 26400 | ||||
Required invnetory purchases | 40,100 | 38,200 | 32,950 | ||||
b) | Schedule of Cash disbursements | ||||||
July | August | September | Quarter | ||||
Accounts payable,June 30 | 18,200 | 18,200 | |||||
July purchases | 20050 | 20050 | 40100 | ||||
August purchases | 19100 | 19100 | 38200 | ||||
September purchases | 16475 | 16475 | |||||
Total cash disbursements | 38,250 | 39150 | 35575 | 112,975 | |||
c) | Cash Budget | ||||||
July | August | September | Quarter | ||||
Cash balance ,beginning | 9,300 | 9,310 | 10,770 | 9,300 | |||
Add collection from sales | 49160 | 60760 | 72600 | 182520 | |||
Total cash available | 58,460 | 70,070 | 83,370 | 191,820 | |||
less: disbursements | |||||||
for inventory purchases | 38,250 | 39150 | 35575 | 112,975 | |||
For selling expense | 11,100 | 14,300 | 9,800 | 35,200 | |||
for administrative expense | 3650 | 5850 | 4750 | 14250 | |||
for land | 5,150 | 5,150 | |||||
for dividends | 1,650 | 1650 | |||||
total disbursements | 58,150 | 59300 | 51775 | 169,225 | |||
Excess(Deficiency) | 310 | 10,770 | 31,595 | 22,595 | |||
financing: | |||||||
Borrowings | 9,000 | 0 | 0 | 9,000 | |||
Repayment | 0 | 0 | -9000 | -9000 | |||
interest | 0 | 0 | -270 | -270 | |||
total financing | 9,000 | 0 | -9270 | -270 | |||
cash balance,ending | 9,310 | 10,770 | 22,325 | 22,325 | |||
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is pl...
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...
solve question 1&2&3 please. as it is able, repay the loan plus accumulated interest at the end of the quarter. 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. (Leave no cells blank-be certain to enter "0" wherever required. Do not round intermediate calculations. Omit the "S" sign in your response.) Schedule of Expected Cash Collections Cash sales Sales on account: May June July August Total cash collections 2. Prepare...
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...