ABC Company requests you to prepare a budget for the third quarter ending September 30 2020. You are required to prepare the following budgets:

Sales

Sales receipt schedule

Production

Purchases

Materials payment schedule

Labor

Overheads

General admin and selling

Capital

Cash

Sales Budget

Budgeted sales of the company's product for the month of June was 28,000 units at $5/unit:

It is anticipated that sales units will grow by 5% monthly from the previous month's level, to end August 2020 then stay unchanged for the rest of the calendar year.

There will be a single unit price increase of 20% from 7/01/2020 to December 2020. Sales will be 10% cash and 90% credit.

Schedule of Cash Collection for Sales

The company collects 70% of credit sales in the month of sale; 25% in the month following sale; and the remaining 5% is uncollectible, written off at point of sale.

The accounts receivable balance on 6/30 was $35,000. All of this balance was collectible.

Production Budget

The company desires to have monthly ending inventory of finished goods of 20% of the following month's budgeted sales.

On 6/30, inventory of finished goods was 5,500 units.

Direct Materials Budget

5 pounds of material are required per unit of product.

Management desires to have month ending materials inventory of 10% of following month's production needs.

Beginning materials inventory for the quarter was 13,000 pounds.

Material cost is $0.40 per pound.

Schedule of Cash Disbursement for Materials

50% of materials monthly purchase are paid for in the month of purchase; the balance is paid for in the following month.

The accounts payable balance on June 30 was $12,000.

Direct Labor Budget

Each unit of product requires 0.05 hour of direct labor at the rate of $12 per hour. There will be no overtime budgeted.

Manufacturing Overhead Budget

Variable manufacturing overhead is $8 per direct labor hour.

Fixed manufacturing overhead is $25,500 per month; which includes $4,500 depreciation.

Selling and Admin Expenses Budget

Variable selling and administrative expenses are $0.50 per unit sold.

Fixed selling and administrative expenses are $15,000 per month and include $5,000 in depreciation.

Cash Budget

Available line of credit up to $50,000, in multiples of $10,000.

All borrowings will be at beginning of month and repayments at end of calendar quarter.

Interest paid for short term funding is 3% per month.

Company desires minimum monthly cash balance of $30,000. Ending cash balance 6/30 was $36,500

Cash dividends of $40,000 are to be paid to stockholders in July.

The company plans equipment purchase of $70,000 during the period, to be paid $30,000 in July, $40,000 in August, The equipment will not become operational until October, when depreciation expense will kick in.

Please use following format!

X LE Custom Times New Roman - 12 AA 29. Wrap Text BIUTA EEE Merge & Center Paste $ % 938-98 Conditional Fom Formatting Tal Style Clipboard Font is Alignment 15 Number E20 fr Sale D July Art September M dy Rural September Julie Sept. Uniprice Sake me R Ontoler Body to Sept Nensfraz Onde Durcleber hos Variable overhead pinnate Total bead botad Fand Total Le Der Caled Cash Collection from Accoule Cashes Cash froes Cross Total cathollectie Total meditel 1 Co Sellung der Bad Variable based on its sold Fund Total the Depression Chelst Ending balance Total secu Bebe) Production Unit materials and the Total acuerdos Chiar sara) Capital Brompton Daddad Endnu malas balance Matte) Trinkwati (Beeting and Red purchase() Cost pe Total bodried cost of pachase CASH BOOK BUDGET R Bible Prompt fro Tosare Ca Duterte payable Cel purchases Monday Production Laborto per un Label and it Pem Material pech Det er Manado Selle costs March Didend Cubo Receptes Tankt) Loans Los Total NON Sheet1 Sheet2 Sheet3