Prepare cash budget for month of June include supporting schedule f...

  1. Home
  2. Homework Library
  3. Business
  4. Accounting
  5. Prepare cash budget for month of June include supporting schedule f...

QuestionQuestion

Prepare cash budget for month of June include supporting schedule for cash collections and cash payments

A. Cash balance on June 1 is 736
B. Actual sales for April: cash sales- 10000 credit sales - 28900
                           May: cash sales - 18000 credit sales - 35000
C. Credit sales collected over 3 month period. 40% in first month of sale, 30% in second month, 20% in third month. The sales collected in third month are subject to a 2% late fee, which is paid for by those customers in addition to what they owe. The remaining sales are uncollected.
D. Inventory is 64% of months total sales. Of those purchases, 20% are paid in month of purchase and 80% paid for in following month.
E. Salaries and wages total 11750 per month, including a 4500 salary paid to the owner.
F. Rent is 4100 per month
G. Taxes to be paid in June are 67800

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

Cash Budget
June
Opening Cash Balance 736
Sales Cash 15900
Collection 35360
Late Fees 173,4
Total Receipt 51433,4
Cash Disbursements
Purchases 35276,8...

By purchasing this solution you'll be able to access the following files:
Solution.xlsx.

$15.00
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Accounting Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats