Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Accounting For Payroll

Authors: Steven M. Bragg

1st Edition

0471251089, 9780471251088

More Books

Students also viewed these Accounting questions

Question

What are the organizations task goals on this issue?

Answered: 1 week ago