Answered step by step
Verified Expert Solution
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
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