Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started