Sunland Corporation is projecting a cash balance of $35,700 in its December 31, 2019, balance sheet. Sunlands schedule of expected collections from customers for the first quarter of 2020 shows total collections of $220,150. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $51,170. Other information gathered for the first quarter of 2020 is sale of equipment $3,570; direct labor $83,300, manufacturing overhead $41,650, selling and administrative expenses $53,550; and purchase of securities $16,660. Sunland wants to maintain a balance of at least $29,750 cash at the end of each quarter. Prepare a cash budget for the first quarter.

SUNLAND CORPORATION Cash Budget March 31, 2020For the Quarter Ended March 31, 2020For the Month Ended March 31, 2020
Manufacturing OverheadRepaymentsBorrowingsExcess of Available Cash Over Cash DisbursementsReceiptsTotal ReceiptsTotal DisbursementsEnding Cash BalanceSelling and Administrative ExpensesDirect LaborFinancingCollections from CustomersPurchase of SecuritiesDisbursementsDirect MaterialsBeginning Cash BalanceTotal Available CashSale of Equipment		$
AddLess: Excess of Available Cash Over Cash DisbursementsCollections from CustomersBeginning Cash BalanceRepaymentsPurchase of SecuritiesSale of EquipmentTotal ReceiptsTotal DisbursementsDisbursementsManufacturing OverheadSelling and Administrative ExpensesFinancingTotal Available CashReceiptsEnding Cash BalanceBorrowingsDirect LaborDirect Materials
Collections from CustomersReceiptsSelling and Administrative ExpensesManufacturing OverheadBeginning Cash BalanceBorrowingsFinancingTotal ReceiptsExcess of Available Cash Over Cash DisbursementsSale of EquipmentTotal Available CashTotal DisbursementsDirect MaterialsEnding Cash BalanceDisbursementsDirect LaborRepaymentsPurchase of Securities
Total Available CashRepaymentsReceiptsBorrowingsEnding Cash BalancePurchase of SecuritiesBeginning Cash BalanceTotal DisbursementsDirect LaborExcess of Available Cash Over Cash DisbursementsTotal ReceiptsSelling and Administrative ExpensesDirect MaterialsFinancingManufacturing OverheadSale of EquipmentDisbursementsCollections from Customers
Selling and Administrative ExpensesManufacturing OverheadTotal ReceiptsReceiptsFinancingRepaymentsCollections from CustomersExcess of Available Cash Over Cash DisbursementsDisbursementsEnding Cash BalanceDirect LaborBeginning Cash BalanceTotal DisbursementsDirect MaterialsPurchase of SecuritiesSale of EquipmentBorrowingsTotal Available Cash
Total DisbursementsDirect MaterialsEnding Cash BalanceSale of EquipmentBeginning Cash BalanceCollections from CustomersFinancingTotal Available CashManufacturing OverheadPurchase of SecuritiesDirect LaborBorrowingsDisbursementsSelling and Administrative ExpensesExcess of Available Cash Over Cash DisbursementsRepaymentsReceiptsTotal Receipts
AddLess: Sale of EquipmentTotal DisbursementsFinancingPurchase of SecuritiesBeginning Cash BalanceRepaymentsDisbursementsBorrowingsManufacturing OverheadExcess of Available Cash Over Cash DisbursementsDirect MaterialsDirect LaborEnding Cash BalanceTotal Available CashCollections from CustomersTotal ReceiptsSelling and Administrative ExpensesReceipts
Total Available CashFinancingTotal ReceiptsCollections from CustomersPurchase of SecuritiesExcess of Available Cash Over Cash DisbursementsEnding Cash BalanceRepaymentsTotal DisbursementsReceiptsDisbursementsDirect MaterialsDirect LaborSale of EquipmentSelling and Administrative ExpensesBorrowingsManufacturing OverheadBeginning Cash Balance
BorrowingsSale of EquipmentRepaymentsExcess of Available Cash Over Cash DisbursementsManufacturing OverheadSelling and Administrative ExpensesEnding Cash BalanceDirect LaborDisbursementsReceiptsBeginning Cash BalanceFinancingTotal DisbursementsPurchase of SecuritiesTotal ReceiptsTotal Available CashDirect MaterialsCollections from Customers
Collections from CustomersFinancingManufacturing OverheadDisbursementsSelling and Administrative ExpensesReceiptsEnding Cash BalanceBeginning Cash BalanceRepaymentsExcess of Available Cash Over Cash DisbursementsTotal ReceiptsSale of EquipmentPurchase of SecuritiesDirect LaborTotal DisbursementsTotal Available CashDirect MaterialsBorrowings
DisbursementsCollections from CustomersReceiptsEnding Cash BalanceTotal ReceiptsRepaymentsPurchase of SecuritiesManufacturing OverheadDirect LaborBorrowingsSale of EquipmentExcess of Available Cash Over Cash DisbursementsFinancingSelling and Administrative ExpensesTotal DisbursementsTotal Available CashBeginning Cash BalanceDirect Materials
Selling and Administrative ExpensesDirect LaborDirect MaterialsDisbursementsBeginning Cash BalanceBorrowingsCollections from CustomersEnding Cash BalanceTotal ReceiptsFinancingRepaymentsTotal DisbursementsManufacturing OverheadReceiptsTotal Available CashSale of EquipmentExcess of Available Cash Over Cash DisbursementsPurchase of Securities
FinancingReceiptsSale of EquipmentManufacturing OverheadTotal ReceiptsTotal DisbursementsExcess of Available Cash Over Cash DisbursementsBorrowingsDisbursementsPurchase of SecuritiesDirect MaterialsBeginning Cash BalanceEnding Cash BalanceTotal Available CashDirect LaborRepaymentsCollections from CustomersSelling and Administrative Expenses
Total DisbursementsPurchase of SecuritiesDirect LaborBorrowingsDisbursementsReceiptsFinancingCollections from CustomersExcess of Available Cash Over Cash DisbursementsDirect MaterialsRepaymentsTotal ReceiptsBeginning Cash BalanceEnding Cash BalanceTotal Available CashManufacturing OverheadSale of EquipmentSelling and Administrative Expenses
BorrowingsManufacturing OverheadPurchase of SecuritiesSelling and Administrative ExpensesTotal DisbursementsTotal ReceiptsTotal Available CashReceiptsDirect MaterialsExcess of Available Cash Over Cash DisbursementsRepaymentsBeginning Cash BalanceDirect LaborCollections from CustomersFinancingEnding Cash BalanceSale of EquipmentDisbursements
AddLess: Excess of Available Cash Over Cash DisbursementsBeginning Cash BalanceReceiptsTotal Available CashFinancingRepaymentsDirect LaborDirect MaterialsTotal ReceiptsBorrowingsManufacturing OverheadTotal DisbursementsCollections from CustomersEnding Cash BalancePurchase of SecuritiesSale of EquipmentDisbursementsSelling and Administrative Expenses
AddLess: Sale of EquipmentEnding Cash BalanceSelling and Administrative ExpensesTotal ReceiptsRepaymentsTotal Available CashFinancingDisbursementsDirect LaborReceiptsBorrowingsPurchase of SecuritiesBeginning Cash BalanceDirect MaterialsTotal DisbursementsExcess of Available Cash Over Cash DisbursementsManufacturing OverheadCollections from Customers
Purchase of SecuritiesDirect MaterialsSelling and Administrative ExpensesExcess of Available Cash Over Cash DisbursementsTotal DisbursementsSale of EquipmentEnding Cash BalanceManufacturing OverheadDirect LaborReceiptsFinancingBorrowingsTotal Available CashCollections from CustomersDisbursementsRepaymentsTotal ReceiptsBeginning Cash Balance		$