Melanie Inc. provides you with the following budgeted information for two months in year $2019$:

March April

Sales $$635,000$ $$705,000$

Manufacturing Costs $160,000300,000$

Capital Expenditures$*100,00025,000$

General and Administration Costs $($including amortization$)65,00085,000$

$*$includes training programs, machines and buildings

Expectations:

Cash sales represent $5\%$ of total sales

All sales on account are collected in the following month

$60\%$ of March$$s $$100,000$ worth of capital expenditures is to be paid at the end of March. The remainder is to be paid in the following month. April's capital expenditure will be paid in May.

Monthly amortization represents $25\%$ of general and administration costs

Manufacturing costs and general and administration costs are to be paid in the month in which they are incurred

Dividends of $$6,000$ are expected to be declared in March and paid in April

Melanie Inc. obtains the minimum financing needed to ensure at least a $$6,000$ cash balance at the end of the month through a bank loan. Assume that any amount taken out of the bank loan may be repaid only at year end.

As of March $1$

Cash $$26,000$

Accounts Receivable$*174,000$

Inventory $110,000$

Long$-$Term Assets $90,000$

Accumulated Depreciation $4,000$

Accounts Payable $15,000$

Dividends Payable $($in March$)3,000$

Notes Payable $265,000$

Stockholder's Equity $114,000$

$*$Comprised only of sales on account incurred in February

Do not enter dollar signs or commas in the input boxes.

Use the negative sign for negative values.

Prepare a cash budget for March and April.

Melanie Inc.

Cash Budget for March and April

March April

Opening Cash Balance $Answer

$Answer

Receipts:

Cash from sales $Answer

$Answer

Collection from customers $Answer

$Answer

Total cash available $Answer

$Answer

Disbursements:

Manufacturing costs $Answer

$Answer

General and admin. costs $Answer

$Answer

Capital Expenditures $Answer

$Answer

Dividend Payment $Answer

$Answer

Total Cash Payments $Answer

$Answer

Cash Excess $($Deficit$)$ $Answer

$Answer

Financing Requirements:

Notes Payable $Answer

$Answer

Loan Repayment

Ending Cash Balance $Answer

$Answer