Deitz corporation is projecting a cash balance of $30,000 in its december 31, 2016, balance sheet. deitz's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $185,000. the schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $43,000. other information gathered for the first quarter of 2017 is sale of equipment $3,000, direct labor $70,000, manufacturing overhead $35,000, selling and administrative expenses $45,000, and purchase of securities $14,000. deitz wants to maintain a balance of at least $25,000 cash at the end of each quarter. prepare a cash budget for the first quarter.

Cash Budget  

For the Quarter Ended March 31, 2016  

$30,000Beginning cash balance, December 31, 2016

$188,000Total receipts

$218,000Total available cash

-$207,000Total disbursements

$11,000Excess of available cash over disbursements

Financing  

$14,000Borrowings

$25,000Ending cash balance

Explanation:

Cash Budget  

For the Quarter Ended March 31, 2016  

$30,000Beginning cash balance, December 31, 2016

Add: Receipts  

$185,000Collections from customers

$3,000    Sale of equipment

$188,000Total receipts

$218,000Total available cash

Less: Disbursements  

-$43,000Direct materials

-$70,000Direct labor

-$35,000Manufacturing overhead

-$45,000Selling and administrative expense

-$14,000  Purchase of securities

-$207,000Total disbursements

$11,000Excess of available cash over disbursements

Financing  

$14,000Borrowings

$25,000Ending cash balance

2b2t

explanation:

2b2t

anjan should should report alteast 5000 on the first apyment and 10,000 each year

explanation: