Fill This Form To Receive Instant Help
Homework answers / question archive / Problem 10-2 The results of operations for the Marx Bug Spray Manufacturing Company for the fourth quarter of 2017 were as follows (in thousands): $460,000 257,600 202,400 Sales of bug spray Less variable cost of goods sold Contribution margin Less fixed bug removal costs Less fixed selling and administrative expenses Income before taxes Less taxes on income Net income $64,400 27,600 92,000 110,400 44,160 $66,240 Note: Marx uses the variable costing method
Problem 10-2 The results of operations for the Marx Bug Spray Manufacturing Company for the fourth quarter of 2017 were as follows (in thousands): $460,000 257,600 202,400 Sales of bug spray Less variable cost of goods sold Contribution margin Less fixed bug removal costs Less fixed selling and administrative expenses Income before taxes Less taxes on income Net income $64,400 27,600 92,000 110,400 44,160 $66,240 Note: Marx uses the variable costing method. Thus, only variable costs are included in the cost of goods sold. Fixed costs are charged to expense in the period incurred. The company's balance sheet as of the end of the fourth quarter of 2017 was as follows (in thousands): $ 26,400 230,000 256,400 Assets: Cash Accounts receivable Total current assets Fixtures and equipment $130,000 Less accumulated depreciation 75,000 To Total assets Liabilities and owners' equity: Accounts payable Retained earnings Common stock Total liabilities and owners' equity 55,000 $311,400 $ 51,520 152,580 107,300 $311,400 Additional information: 1. Sales and variable costs of sales are expected to increase by 4 percent in the next quarter. 2. All sales are on credit with 50 percent collected in the quarter of sale and 50 percent collected in the following quarter. 3. Variable cost of sales consists of 40 percent materials, 38 percent direct labor, and 22 percent variable overhead. Materials are purchased on credit. 50 percent are paid for in the quarter of purchase, and the remaining amount is paid for in the quarter after purchase. There is no inventory. Also, direct labor and variable overhead costs are paid in the quarter the expenses are incurred. 4. Fixed bug removal costs (other than $5,300 of depreciation expense) are expected to increase by 2.00 percent. Fixed bug removal costs requiring payment are paid in the quarter they are incurred. 5. Fixed selling and administrative costs (other than $3,040 of depreciation expense) are expected to increase by 2 percent. Fixed selling and administrative costs requiring payment are paid in the quarter they are incurred. 6. The tax rate is expected to be 40 percent. All taxes are paid in the quarter they are incurred. 7. No purchases of fixtures or equipment are expected in the first quarter of 2018.
Prepare a budgeted statement of cash budget for the first quarter of 2018. Marx Bug Spray Manufacturing Company Cash Budget For the First Quarter, 2018
Prepare a budgeted balance sheet as of the end of the first quarter of 2018. (List assets in order of liquidity.) Marx Bug Spray Manufacturing Company Budgeted Balance Sheet For the Quarter Ended March 31, 2018 Assets Liabilities and Stockholders' Equity $ Click if you would like to Show Work for this question: Open Show Work
Answer:
Note :1 | |||||
INCOME STATEMENT | |||||
Particulars | Q4 of 2017 | Q1 of 2018 | Explanation | ||
Sales of bug spray | $ 460,000 | $ 478,400 | 4% Increase. Therefore 460000+ 460000 X 4% | ||
Less: | Variable Costs | $ 257,600 | $ 267,904 | 4% Increase. Therefore 257600+ 257600 X 4% | |
Contribution Margin | $ 202,400 | $ 210,496 | |||
Less: | Fixed bug Removal Costs | $ 59,100 | $ 60,282 | 2% Increase. Therefore 59100+ 59100 X 2% | |
Less: | Fixed bug Removal Costs-Depreciation | $ 5,300 | $ 5,300 | ||
Less: | Fixed Selling and Admin Expenses | $ 24,560 | $ 25,051 | 2% Increase. Therefore 24560+ 24560 X 2% | |
Less: | Fixed Selling and Admin Expenses-Depreciation | $ 3,040 | $ 3,040 | ||
Income before Taxes | $ 110,400 | $ 116,823 | |||
Less: | Taxes on Income | $ 44,160 | $ 46,729 | Tax Rate @40% | |
Net Income | $ 66,240 | $ 70,094 |
Note :2 | |||
Variable Costs break up: | |||
Direct Material @40% | $ 103,040 | $ 107,162 | |
Direct Labour @ 38% | $ 97,888 | $ 101,804 | |
Variable Overhead @22% | $ 56,672 | $ 58,938 | |
Total | $ 257,600 | $ 267,904 |
Marx Bug Spray Manufacturing Company | |||
CASH BUDGET | |||
For the First Quarter,2018 | |||
Particulars | Amount | Reason | |
Opening Cash Balance | 26,400.00 | ||
Add : | Accounts receivable -opening Balance | 230,000.00 | 50% of Q4 -2017 Sales received in Q1 of 2018 (460000/2) |
Add : | Cash received- 50% Sales of Q1-2018 | 239,200.00 | 50% of Q1 -2018 Sales received in Q1 of 2018 (478400/2).Therefore Accounts receivable at Q1-2018 end is 239200 |
495,600.00 | |||
Less: | Accounts payable-Opening Balance | 51,520.00 | 50% of Q4 -2017 Direct Material cost paid in Q1 of 2018 (103040/2) |
Less: | Direct Material Cost-50% of Direct Material of Q1-2018 | 53,581.00 | 50% of Q1 -2018 Direct Material cost paid in Q1 of 2018 (107162/2).Therefore Accounts payable at Q1-2018 end is 53581 |
Less: | Direct Labour payment | 101,804.00 | |
Less: | Variable Overhead payment | 58,938.00 | |
Less: | Fixed bug Removal Costs | 60,282.00 | |
Less: | Fixed Selling and Admin Expenses-Depreciation | 25,051.00 | |
Less: | Taxes on Income | 46,729.00 | |
Closing Balance of Cash | 97,695.00 |
Marx Bug Spray Manufacturing Company | ||
Budgeted Balance Sheet | ||
For the Quarter ended March 31,2018 | ||
Particulars | Amount | Amount |
Assets | ||
Cash | $ 97,695 | |
Accounts receivable | $ 239,200 | |
Total Current Assets | $ 336,895 | |
Fixtures and Equipment | $ 130,000 | |
Less: Accumulated Depreciation (75000+5300+3040) | $ 83,340 | $ 46,660 |
Total Assets | $ 383,555 | |
Liabilities and Stockholders Equity | ||
Accounts Payable | $ (53,581) | |
Retained Earnings (152580+70094) | $ 222,674 | |
Common Stock | $ 107,300 | |
Total Liabilities and Owners equity | $ 276,393 |
1. I prepared with working notes. Please comment, if you need further clarification. Please rate for my