Prepare a cash budget for the months of july and august and

Reference no: EM13592534

The Gannon Company has budgeted sales revenues as follows:

JUNE JULY AUGUST
Credit sales $27,000 $29,000 $18,000
Cash sales 18,000 51,000 39,000
Total sales $45,000 $80,000 $57,000

Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month.

Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are:

June $60,000
July 50,000
August 21,000

Other cash disbursements budgeted: (a) selling and administrative expenses of $9,500 each month, (b) dividends of $22,700 will be paid in July, and (c) purchase of a computer in August for $5,000 cash.

The company MUST maintain a minimum cash balance of $10,000 at the end of each month. The company borrows money from the bank at 9% per year interest if necessary to maintain the minimum cash balance of $10,000. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on July 1 was $10,000 of which none is borrowed.

Instructions:
Prepare a cash budget for the months of July and August and Prepare separate schedules for expected collections from customers and expected payments for purchases of inventory.

Reference no: EM13592534

Questions Cloud

Last year jason company had a net income of 310000 income : last year jason company had a net income of 310000 income tax expense of 84000 and interest expense of 40000. the

Hewtex electronics manufactures two products tape recorders : hewtex electronics manufactures two products tape recorders and electronic calculators and sells them nationally to

Red inc applies overhead producation at a predetermined : red inc applies overhead producation at a predetermined rate of 70 based non direct labor cost. job no.200 the only job

Given the following information determine the cost of goods : given the following information determine the cost of goods manufactured and the cost of goods sold for the year ended

Prepare a cash budget for the months of july and august and : the gannon company has budgeted sales revenues as follows june july august credit sales 27000 29000 18000 cash sales

One side of a triangular lot is 150 ft and the angel : one side of a triangular lot is 150 ft and the angel oppiste this side is 55 degrees. another angel is 63 degrees.

In september carter company receives a special order for : carter company manufactures cappuccino makers. for the first eight months of the year the company reported the

The distance between the points where the wires are fixed : a flagpole is secured on opposite sides by two guy wires each of which is 5ft longer than the pole. the distance

The expected direct labor cost totals 600000 which : java source inc. jsi is a processor and distributor of a variety of blends of coffee. the company buys coffee beans

User Account

All Pages