just answer schedule 3.cache budget G Gmail Grading Rubric 1.x × G on the follow
ID: 2544207 • Letter: J
Question
just answer schedule 3.cache budget
G Gmail Grading Rubric 1.x × G on the followin G Check my work x Hill yard Compa × Google Translat x KCSecure https://newconnect.mheducation.com/flow/connect.html Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not ind Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter 5 points a. As of December 31 (the end of the prior quarter), the company's general ledger showed.the following account balances Cash Accounts receivable Inventory Buildings and equipment Accounts payable Common stock Retained earnings 50,000 208,000 59,250 360,000 (net) $ 88,125 500,000 89,125 677250s 677250 Actual sales for December and budgeted sales for the next four months are as b follows December(actual) $260,000 Next > Mc Graw Hill Prey 1 of 1Explanation / Answer
Particulars
January
February
March
Quarter
Salaries and wages
25000
25000
25000
75000
Advertising
65000
65000
65000
195000
Shipping (5% of sales)
19750
29600
15300
64650
Other expenses (3% of sales)
11850
17760
9180
38790
Cash disbursement for selling and administrative expense
121600
137360
114480
373440
Cash Budget
Particulars
January
February
March
Quarter
Beginning cash balance
50000
30000
35615
115615
Add: cash collections
287000
434400
534800
1256200
Total cash available
337000
464400
570415
1371815
Less: Cash disbursements
221400
289425
240225
751050
Purchases of inventory
121600
137360
114480
373440
Selling and administrative expense
Purchase of equipment
2000
75000
77000
Cash dividends
45000
45000
Total cash disbursements
388000
428785
429705
1246490
excess (deficiency) of cash
-51000
35615
140710
125325
Financing
81000
81000
Borrowings
81000
81000
Repayments
2430
2430
Interest
Total financing
81000
83430
164430
Ending cash balanace
30000
35615
57280
122895
Particulars
January
February
March
Quarter
Salaries and wages
25000
25000
25000
75000
Advertising
65000
65000
65000
195000
Shipping (5% of sales)
19750
29600
15300
64650
Other expenses (3% of sales)
11850
17760
9180
38790
Cash disbursement for selling and administrative expense
121600
137360
114480
373440
Cash Budget
Particulars
January
February
March
Quarter
Beginning cash balance
50000
30000
35615
115615
Add: cash collections
287000
434400
534800
1256200
Total cash available
337000
464400
570415
1371815
Less: Cash disbursements
221400
289425
240225
751050
Purchases of inventory
121600
137360
114480
373440
Selling and administrative expense
Purchase of equipment
2000
75000
77000
Cash dividends
45000
45000
Total cash disbursements
388000
428785
429705
1246490
excess (deficiency) of cash
-51000
35615
140710
125325
Financing
81000
81000
Borrowings
81000
81000
Repayments
2430
2430
Interest
Total financing
81000
83430
164430
Ending cash balanace
30000
35615
57280
122895
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.