Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help with this question Your answer is partially correct. Windsor Company expects to have a cash balance of $46,000 on January 1, 2022. Relevant
Need help with this question
Your answer is partially correct. Windsor Company expects to have a cash balance of $46,000 on January 1, 2022. Relevant monthly budget data for the first two months of 2022 are as follows: 1. Collections from customers: January $100,000; February $161,000 2. Payments to suppliers: January $59,000; February $82,000 3. Direct labour: January $28,000; February $47,000. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,000; February $30,000. These costs include depreciation of $1,000 per month. All other overhead costs are paid as incurred. 5 . Selling and administrative expenses: January $13,000; February $19,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of marketable securities in January are expected to realize $9,000 in cash. Windsor Company has a line of credit at a local bank. It can borrow up to $31,000. The company wants to keep a minimum monthly cash balance of $31,000.Month Jan Feb Beginning cash balance V to 46000 $ Add Cash receipts V Collection from customers 101000 Sale of marketable securities 11000 Total receipts 112000 Total available cash V 158000 Less Disbursements V Direct materials V 61000 Direct labour V 29000 Manufacturing overhead 24000 i Selling and administrative expenses 16000 Total disbursements 130000 Excess of available cash over cash disbursements 28000 Total financing Repayment Borrowing Excess of available cash over cash disbursements i Ending cash balance to 28000Step 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