Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sunland Company expects to have a cash balance of $44,900 on January 1, 2022. Sunland has budgeted the following for the first two months of

Sunland Company expects to have a cash balance of $44,900 on January 1, 2022. Sunland has budgeted the following for the first two months of the year 2022:

1. Collections from customers: January $90,800; February $110,200.
2. Payments to suppliers: January $40,400; February $50,200.
3. Direct labour: January $30,200; February $34,900. Wages are paid in the month they are incurred.
4. Manufacturing overhead: January $25,200; February $29,700. Overhead costs are paid as incurred.
5. Selling and administrative expenses: January $15,800; February $21,900. These costs do not include depreciation and they are paid as incurred.
6. Sales of investments in January are expected to realize $9,900 in cash. Sunland Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed.

Prepare a cash budget for January and February.

SUNLAND COMPANY Cash Budget For 2022

January

February

select an opening cash budget item Financing borrowing needsBeginning cash balanceEnding cash balanceTotal cash disbursementsTotal receiptsCash receiptsCash disbursementsExcess of cash over cash disbursementsTotal cash available

$enter a dollar amount $enter a dollar amount

select between addition and deduction AddLess: select an opening name for section one Beginning cash balanceTotal cash disbursementsEnding cash balanceFinancing borrowing needsTotal cash availableExcess of cash over cash disbursementsTotal receiptsCash receiptsCash disbursements

select a cash budget item Purchase of landPurchase of equipmentLabourCollections from customersManufacturing overheadSale of investmentsPayment to suppliersSelling and administrative expensesCollection of notes receivable

enter a dollar amount enter a dollar amount

select a cash budget item Collections from customersSelling and administrative expensesPurchase of equipmentPurchase of landPayment to suppliersCollection of notes receivableSale of investmentsLabourManufacturing overhead

enter a dollar amount enter a dollar amount

select a summarizing line for the first part Cash disbursementsBeginning cash balanceExcess of cash over cash disbursementsCash receiptsTotal receiptsEnding cash balanceTotal cash disbursementsTotal cash availableFinancing borrowing needs

enter a total amount for the first part enter a total amount for the first part

select between addition and deduction AddLess: select an opening name for section two Cash disbursementsEnding cash balanceBeginning cash balanceTotal cash disbursementsFinancing borrowing needsCash receiptsTotal cash availableTotal receiptsExcess of cash over cash disbursements

select a cash budget item Purchase of landSelling and administrative expensesManufacturing overheadSale of investmentsLabourCollections from customersCollection of notes receivablePurchase of equipmentPayment to suppliers

enter a dollar amount enter a dollar amount

select a cash budget item Sale of investmentsPayment to suppliersCollections from customersLabourManufacturing overheadCollection of notes receivablePurchase of equipmentPurchase of landSelling and administrative expenses

enter a dollar amount enter a dollar amount

select a cash budget item Collection of notes receivableCollections from customersPurchase of equipmentManufacturing overheadLabourSale of investmentsSelling and administrative expensesPurchase of landPayment to suppliers

enter a dollar amount enter a dollar amount

select a cash budget item Sale of investmentsPurchase of landManufacturing overheadCollections from customersLabourPurchase of equipmentPayment to suppliersCollection of notes receivableSelling and administrative expenses

enter a dollar amount enter a dollar amount

select a closing name for section two Cash receiptsBeginning cash balanceFinancing borrowing needsCash disbursementsTotal cash availableTotal receiptsEnding cash balanceExcess of cash over cash disbursementsTotal cash disbursements

enter a total amount for section two enter a total amount for section two

select a summarizing line for the second part Financing borrowing needsCash disbursementsCash receiptsTotal cash disbursementsTotal receiptsEnding cash balanceBeginning cash balanceExcess of cash over cash disbursementsTotal cash available

enter a total amount for the second part enter a total amount for the second part

select a cash budget item Financing borrowing needsBeginning cash balanceTotal cash availableExcess of cash over cash disbursementsTotal receiptsCash receiptsCash disbursementsEnding cash balanceTotal cash disbursements

enter a dollar amount enter a dollar amount

select a closing cash budget item Ending cash balanceBeginning cash balanceExcess of cash over cash disbursementsTotal receiptsTotal cash availableTotal disbursementsFinancing borrowing needsCash disbursementsCash receipts

$enter a total amount for the cash budget $enter a total amount for the cash budget

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions