Question

Blue Corporation is projecting a cash balance of $36,450 in its December 31, 2016, balance sheet. Blue’s schedule of expected collections from customers for the first quarter of 2017 shows total collections of $224,775. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $52,245. Other information gathered for the first quarter of 2017 is sale of equipment $3,645; direct labor $85,050, manufacturing overhead $42,525, selling and administrative expenses $54,675; and purchase of securities $17,010. Blue wants to maintain a balance of at least $30,375 cash at the end of each quarter.

Prepare a cash budget for the first quarter.

Answer 1

Answer and Explanation:

The Preparation of cash budget for the first quarter is following below:-

Cash Budget

Particulars Amount

Cash balance Beginning $36,450

Add: Receipts

Total Collection $224,775

Sale of equipment $3,645

Total receipts $228,420

Total cash available $265,870

Less: Disbursements

Direct material $52,245

Direct labor $85,050

Manufacturing overhead $42,525

Selling and

administrative overhead $54,675

Purchase of securities $17,010

Total Disbursements $251,535

Available excess available

cash over disbursements $14,335

Financing

Add: Purchase of securities $17,010

Less: Repayments -

Cash balance at ending $31,345

So, to reach at ending balance we simply added the purchase of securities and ending cash balance.