Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help with this Income statement and balance sheet at the end of this. The total Assets is suppose to equal $227,842 Please expain how you

Help with this Income statement and balance sheet at the end of this. The total Assets is suppose to equal $227,842

Please expain how you got your answers!

Balance Sheet, March 31, 2001
Cash $9,000
Accounts receivable 85,210
Raw material inventory 8,408
Finished goods inventory 11,450
Equipment (net) 125,000
Total assets $239,068
Accounts payable $8,520
Common stock 150,000
Retained earnings 80,548
Total liabilities & equity $239,068
Actual and Budgeted Unit Sales, 2001 Paddles Seats
January 1,900 1,300
February 2,000 1,400
March 2,700 1,300
April 2,400 1,100
May 2,600 1,300
June 2,300 1,000
July 2,900 900
August 3,000 1,000
Manufacturing Standards
Paddles Seats
Materials: Cost Quantity Quantity
Resin A $0.45 2 3
Hardner Q 0.70 5 2
Labor:
Dept. 1 $7.00 0.30 0.20
Dept. 2 8.00 0.20 0.20
Factory Overhead:
Dept. 1 $5.00 0.30 0.20
Dept. 2 11.00 0.20 0.20
Other Data
Selling price:
Paddles $20
Seats $14
Beginning inventories:
Paddles (units) 720
Seats (units) 330
Resin A (liters) 5,040
Hardner Q (liters) 8,772
Desired ending inventories (% of next month's sales):
Finished goods inventory (units) 30%
Raw material inventory (units) 60%
Collections from customers:
% Collected month of sale 15%
% Collected month after sale 45%
% Collected two months after sale 40%
Cash payments to suppliers:
% Paid in month of purchase 40%
% Paid in following month 60%
Selling and administrative expenses:
Variable (% of total sales) 7%
Fixed: Cash $24,000
Depreciation $1,000
Factory overhead depreciation rate (per hour) $1
Answer Section
Sales Budget
April May June
Canoe paddles $48,000 $52,000 $46,000
Toilet seats 15,400 18,200 14,000
Total $63,400 $70,200 $60,000
Production Budget (Units)
Canoe Paddles April May June
Desired ending inventory 780 690 870
This month's sales 2,400 2,600 2,300
Total needed 3,180 3,290 3,170
Beginning inventory 720 780 690
Production required (units) 2,460 2,510 2,480
Toilet Seats
Desired ending inventory 390 300 270
This month's sales 1,100 1,300 1,000
Total needed 1,490 1,600 1,270
Beginning inventory 330 390 300
Production required (units) 1,160 1,210 970
Purchases Budget
Resin A April May June
Desired ending inventory 5,190 4,722 5,190
Required for production 8,400 8,650 7,870
Total needed 13,590 13,372 13,060
Beginning inventory 5,040 5,190 4,722
Purchases required (units) 8,550 8,182 8,338
Purchases required (dollars) $3,848 $3,682 $3,752
Hardner Q
Desired ending inventory 8,982 8,604 9,906
Required for production 14,620 14,970 14,340
Total needed 23,602 23,574 24,246
Beginning inventory 8,772 8,982 8,604
Purchases required (units) 14,830 14,592 15,642
Purchases required (dollars) $10,381 $10,214 $10,949
Total purchases budgeted (dollars) $14,229 $13,896 $14,702
Direct Labor Budget
April May June
Labor hours needed for production:
Department 1 970 995 938
Department 2 724 744 690
Total 1,694 1,739 1,628
Cost of direct labor:
Department 1 $6,790 $6,965 $6,566
Department 2 5,792 5,952 5,520
Total $12,582 $12,917 $12,086
Factory Overhead Budget
April May June
Department 1 $4,850 $4,975 $4,690
Department 2 7,964 8,184 7,590
Total $12,814 $13,159 $12,280
Projected Cost of Goods Sold
Unit cost of canoe paddles $11.80
Unit cost of toilet seats $8.95
April May June
Canoe paddles $28,320 $30,680 $27,140
Toilet seats 9,845 11,635 8,950
Total cost of goods sold $38,165 $42,315 $36,090
Cash Budget
April May June
Cash balance, beginning $9,000 $9,000 $9,000
Cash receipts:
Collections from customers:
From February sales 23,840
From March sales 32,490 28,880
From April sales 9,510 28,530 25,360
From May sales 10,530 31,590
From June sales 9,000
Total cash available $74,840 $76,940 $74,950
Cash disbursements:
Raw material acquisitions:
From March purchases 8,520
From April purchases 8,537 8,537
From May purchases 5,559 8,338
From June purchases 5,881
Direct labor 12,582 12,917 12,086
Factory overhead 11,120 11,420 10,652
Selling and administrative 34,032 28,914 28,200
Interest paid 0 90 84
Total disbursements $74,791 $67,436 $65,241
Cash balance before financing $49 $9,504 $9,709
Less desired ending balance 9,000 9,000 9,000
Excess (deficit) of cash over needs ($8,951) $504 $709
Line of Credit:
Borrowing $8,951 $0 $0
Repayment 0 (504) (709)
Total effects of financing $8,951 ($504) ($709)
Cash balance, ending $9,000 $9,000 $9,000
Forecasted Income Statement
For Quarter Ended June 30, 2001
Sales $0
Cost of goods sold $0
Gross profit $0
Expenses:
Selling and administrative $0
Interest expense 174
Total expenses $0
Net income $0
Forecasted Balance Sheet
June 30, 2001
Assets
Cash $9,000
Accounts receivable $0
Raw material inventory $0
Finished goods inventory $0
Equipment (net) $0
Total assets $0
Liabilities and Equity
Accounts payable $0
Line of credit payable $0
Common stock 150,000
Retained earnings $0
Total liabilities & equity $0

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

More Books

Students also viewed these Accounting questions

Question

4. Devise an interview strategy from the interviewers point of view

Answered: 1 week ago