Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A. Schedule of Expected Cash Collections July August September Quarter Account Receivable( June 30) $ 29,250 $ 29,250 July Sales $ 13,520 $ 38,480 $

A. Schedule of Expected Cash Collections
July August September Quarter
Account Receivable( June 30) $ 29,250 $ 29,250
July Sales $ 13,520 $ 38,480 $ 52,000
August Sales $ 14,560 $ 41,440 $ 56,000
September $ 15,600 $ 15,600
Total Cash Collections $ 42,770 $ 53,040 $ 57,040 $ 152,850
B. Merchandise Purchase Budget
July August September Quarter
Budgeted Sales Revenue $ 52,000 $ 56,000 $ 60,000 $ 168,000
Cost of Goods Sold (.77) $ 40,040 $ 43,120 $ 46,200 $ 129,360
Plus: Desired Ending Inventory(.35) $ 14,014 $ 15,092 $ 16,170 $ 45,276
Total Inventory Necessary $ 54,054 $ 58,212 $ 62,370 $ 174,636
Minus: Beginning Inventory $ (7,100) $ (14,014) $ (15,092) $ (36,206)
Inventory to Purchase $ 46,954 $ 44,198 $ 47,278 $ 138,430
C. Schedule of Expected Cash Disbursments - Merchandise Purchases
July August September Quarter
Acct. Payable(June30) $ 22,400 $ 22,400
July Purchases $ 22,538 $ 24,416 $ 46,954
August Purchases $ 21,215 $ 22,983 $ 44,198
September Purchases $ 22,693 $ 22,693
Total Cash Disbursements $ 44,938 $ 45,631 $ 45,676 $ 136,245
D. Schedule of Expected Cash Disbursments - Selling and Administrative Expenses
July August September Quarter
Commissions $ 9,000 $ 9,000 $ 9,000
Rent $ 1,200 $ 1,200 $ 1,200
Other Expenses(8%) $ 4,160 $ 4,480 $ 4,800
Total Cash for Expenses $ 14,360 $ 14,680 $ 15,000 $ 44,040
E. Cash Budget
July August September Quarter
Beginning Balance $ 4,000 $ 3,372 $ 3,101
Plus Cash Collections $ 42,770 $ 53,040 $ 57,040 $ 152,850
Total Cash Available $ 46,770 $ 56,412 $ 60,141
Minus Cash Disbursement
Merchandise Purchase $ 44,938 $ 45,631 $ 45,676 $ 136,245
Other Expenses $ 4,160 $ 4,480 $ 4,800 $ 13,440
Commissions & rent $ 10,200 $ 10,200 $ 10,200 $ 30,600
Equipment $ 2,100 $ 3,000 $ 5,100
Total Disbursements $ 61,398 $ 63,311 $ 60,676 $ 185,385
Deficiancy $ (14,628) $ (6,899) $ (535)
Borrowed $ 18,000 $ 10,000 $ 2,000 $ 30,000
Financing $ 18,000 $ 10,000 $ 2,000 $ 30,000
End Cash Balance $ 3,372 $ 3,101 $ 1,465 $ 1,465
F. Sunny and Clear, Inc.
Absorbtion Costing Income Statement
For the Quarter Ended September 30, 2020
Sales $ 168,000
Minus: Cost of Goods Sold $ 129,360
Gross Margin $ 38,640
Total Expenses $ 44,040
Depreciation $ 1,300
Net Income $ (6,700)
G.
Sunny and Clear, Inc.
Balance Sheet
September 30, 2020
Assets
Cash $ 1,465
Account Receivable $ 44,400
Ending Inventory $ 16,170
Building And Equipment $ 107,650
Depreciation $ (1,300)
Total Assets $ 168,385
Liability and Stockholder Equity
Accounts Payable
Note Payable $ 30,000
Capital Stock $ 99,000
Retained Earnings
Total Liabilities and Stockholders Equity

I'm struggling to find my accounts payable value and my retained earnings value. If you can help clarify that for me it would help a lot.

Current assets as of June 30:
Cash $4,000
Accounts receivable $29,250
Inventory $7,100
Buildings and equipment, net $102,550
Accounts payable $22,400
Capital stock $99,000
Retained earnings $21,500

These were the assets they gave me to begin the quarter. If you need any other information let me know. Thank you.

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

Managerial Accounting

Authors: Carl S Warren, James M Reeve, Jonathan Duchac

12th Edition

1133952402, 978-1133952404

More Books

Students also viewed these Accounting questions