Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help with this. Thanks!!! Carla Vista Company expects to have a cash balance of $136,800 on January 1, 2020. Relevant monthly budget data for
need help with this. Thanks!!!
Carla Vista Company expects to have a cash balance of $136,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: Collections from customers: January $246,000, February $436,200. Payments for direct materials: January $155,200, February $243,100 Direct labor: January $91,600, February $132,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $62,600, February $76,400. These costs include depreciation of $5,100 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $44,200, February $60,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $36,200 in cash. Carla Vista Company has a line of credit at the local bank that enables it to borrow up to $74,400. The company wants to maintain a minimum monthly cash balance of $59,900. Prepare a cash budget for January and February. Carla Vista Company Cash Budget For the Months Ending February 2020 January February Beginning Cash Balance Add . Receipts Collections from Customers Sale of Securities Total Receipts Total Receipts Total Available Cash Less . Disbursements Direct Materials Direct Labor Manufacturing Overhead Selling and Administrative Expenses Total Disbursements Excess (Deficiency) of Available Cash over Cash Disbursements Financing Add . Borrowings Less . Repayments Including Interest Ending Cash Balance $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