Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please I need help for this budget assigment thank you Data Section 5 5 3 0 Actual and Budgeted Unit Sales May June July August

please I need help for this budget assigment thank you image text in transcribed
image text in transcribed
image text in transcribed
Data Section 5 5 3 0 Actual and Budgeted Unit Sales May June July August September October 1,400 1,000 1,600 1,400 1,500 1,200 1 2 3 4 5 Balance Sheet, June 30 5 Cash 7 Accounts receivable 3 Merchandise inventory (640 units) Fixed assets (net) Total assets $12,480 239,120 70,400 130,000 $452,000 Accounts payable (merchandise) Owner's equity Total liabilities & equity $136,400 315,600 $452,000 $196 $110 40% Other Data Average selling price Average purchase cost per unit Desired ending inventory (% of next month's unit sales) Collections from customers: Collected in month of sale Collected in month after sale Collected two months after sale Projected cash payments: Variable expenses Fixed expenses (per month) Depreciation per month 20% 50% 30% 25% of sales $40,000 $2,000 0 1 Sales Budget July August September Total 2 3 Units 4 Sales Price 5 Dollars July August September Total July August September 6 7 8 Unit Purchases Budget 9 Desired ending inventory o Current month's unit sales 1 Total units needed 2 Beginning inventory 3 Purchases (units) 4 5 Purchases (dollars) 5 7 3 Cash Budget Cash balance, beginning Cash receipts: Collections from customers: From May sales From June sales From July sales From August sales From September sales Total cash available 3 Cash disbursements: Merchandise Variable expenses Fixed expenses Interest paid Total disbursements Cash balance before financing Less: Desired ending balance Excess (deficit) of cash over needs Excess (deficit) of cash over needs Financing Borrowing Repayment Total effects of financing Cash balance, ending Forecasted Income Statement For Quarter Ended September 30 Sales Cost of goods sold Gross profit Expenses: Variable expenses Fixed expenses Depreciation expense Interest expense Total expenses Net income Forecasted Balance Sheet as of September 30 Assets: Cash Accounts receivable 3 Merchandise inventory 4 Fixed assets (net) 5 Total assets 6 7 Liabilities & equity: 8 Accounts payable 9 Loans payable 0 Owner's equity 1 Total liabilities & equity 2

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

Introduction To Government And Not For Profit Accounting

Authors: Martin Ives, Joseph R. Razek, Gordon A. Hosch

5th Edition

0130464147, 978-0130464149

More Books

Students also viewed these Accounting questions