Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, if someone could just help me fill out the cash budget that would be wonderful thank you! The results of operations for the Marx
Hi, if someone could just help me fill out the cash budget that would be wonderful thank you!
The results of operations for the Marx Manufacturing Company for the fourth quarter of 2020 were as follows: Sales $ 473,000 Less variable cost of sales 285,000 Contribution margin 188,000 Less fixed production costs $ 102,000 Less fixed selling and administrative expenses 47,000 149,000 Income before taxes 39,000 Less taxes on income 15,600 Net income $ 23,400 Note: Marx Manufacturing uses the variable costing method. Thus, only variable production costs are included in inventory and cost of goods sold. Fixed production costs are charged to expense in the period incurred. The company's balance sheet as of the end of the fourth quarter of 2020 was as follows: The company's balance sheet as of the end of the fourth quarter of 2020 was as follows: Assets: Cash $ 137,000 Accounts receivable 188,000 Inventory 332,000 Total current assets 657,000 Property, plant, and equipment 379.000 Less accumulated depreciation 94,000 Total assets $ 942,000 Liabilities and owners' equity: Accounts payable $ 55,800 Common stock 465.000 Retained earnings 421,200 Total liabilities and owners' equity $ 942.000 Additional information: 1. Sales and variable costs of sales are expected to increase by 12 percent in the next quarter. 2. All sales are on credit with 60 percent collected in the quarter of sale and 40 percent collected in the following quarter. 3. Variable cost of sales consists of 40 percent materials, 40 percent direct labor, and 20 percent variable overhead. Materials are purchased on credit. Fifty percent are paid for in the quarter of purchase, and the remaining amount is paid for in the quarter after purchase. The inventory balance is not expected to change. Also, direct labor and variable overhead costs are paid in the quarter the expenses are incurred. 4. Fixed production costs (other than $ 7,000 of depreciation expense) are expected to increase by three percent. Fixed production costs requiring payment are paid in the quarter they are incurred. 5. Fixed selling and administrative costs (other than $5,000 of depreciation expense) are expected to increase by two percent. Fixed selling and administrative costs requiring payment are paid in the quarter they are incurred. 6. The tax rate is expected to be 20 percent. All taxes are paid in the quarter they are incurred. 7. No purchases of property, plant, or equipment are expected in the first quarter of 2021. Prepare a cash budget for the first quarter of 2021. Marx Manufacturing Company Cash Budget For the Quarter Ended March 31, 2021 V $ $ $ $ Total cash payments Beginning cash balance Cash collected from sales $ Payment of income taxes Cash receipts Payment of material Payment for fixed production costs Excess/(deficiency) of receipts over dis sen Cash payments Ending cash balance Depreciation of equipment Payment for fixed selling and admistration expense $ Payment for variable overhead Payment for labor $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