You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information

You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the companys operations: a. The cash balance on December 1 is $41,200. b. Actual sales for October and November and expected sales for December are as follows: October November December $75,400 82,400 $ 97,200 490,000 544.000 629,000 Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale. 60% collected in the month following sale, and 18% collected in the second month follow ng sale. The remaining 2% is uncollectible c. Purchases of inventory will total $366,000 for December. Thirty percent of a months inventory purchases are paid during the month of purchase. The accounts payable remaining from Novembers inventory purchases total $183,000, all of which will be paid in December d. Selling and administrative expenses are budgeted at $472,000 for December. Of this amount, $60,000 is e. A new web server for the Marketing Department costing $96,000 will be purchased for cash during for depreciation. December, and dividends totaling $11,500 will be paid during the month. f The company maintains a minimum cash balance of $20,000. An open line of credit is available from the companys bank to bolster the cash position as needed Required 1. Prepare a schedule of expected cash collections for December. Schedule of Expected Cash Collections December cash sales Collections on account: October sales November sales December sales Total cash collections 2 Prepare a schedule of expected cash disbursements for merchandise purchases t for December Schodule of Fxnected Cash Dishursement 學20170918-15411 jpeg n, 20170918_15405 ..jpeg 20170918 15405...jpeg Ae 20170918 1541...peg

media%2F6fe%2F6feb14e6-8559-4091-8513-74

Please I need help with this problem. thank you

You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company’s operations: a. The cash balance on December 1 is $41,200. b. Actual sales for October and November and expected sales for December are as follows: October November December $75,400 82,400 $ 97,200 490,000 544.000 629,000 Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale. 60% collected in the month following sale, and 18% collected in the second month follow ng sale. The remaining 2% is uncollectible c. Purchases of inventory will total $366,000 for December. Thirty percent of a month’s inventory purchases are paid during the month of purchase. The accounts payable remaining from November’s inventory purchases total $183,000, all of which will be paid in December d. Selling and administrative expenses are budgeted at $472,000 for December. Of this amount, $60,000 is e. A new web server for the Marketing Department costing $96,000 will be purchased for cash during for depreciation. December, and dividends totaling $11,500 will be paid during the month. f The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company’s bank to bolster the cash position as needed Required 1. Prepare a schedule of expected cash collections for December. Schedule of Expected Cash Collections December cash sales Collections on account: October sales November sales December sales Total cash collections 2 Prepare a schedule of expected cash disbursements for merchandise purchases t for December Schodule of Fxnected Cash Dishursement 學20170918-15411 jpeg n, 20170918_15405 ..jpeg 20170918 15405…jpeg Ae 20170918 1541…peg

Expert Answer

 

1)
Schedule of Expected cash collecton
December cash sales $      97,200
Collection on account:
October Sales (490000*18%) $      88,200
November sales (544000*60%) $   3,26,400
December Sales (629000*20%) $   1,25,800
Total cash collection $   6,37,600
2)
Schedule of Expected cash disbursement
Payment to supplier:
November Purchase $   1,83,000
December Purchase (366000*30%) $   1,09,800
Total cash payment $   2,92,800
3)
Ashton Company
Cash Budget
For the Month of December
Beginning cash balance $      41,200
Add:collection from customer $   6,37,600
Total cash available a $   6,78,800
Less:cash disbursement:
Payment to supplier for inventory $   2,92,800
Selling and administrative expenses (472000-60000) $   4,12,000
Ne web Server $      96,000
Dividend paid $      11,500
Total cash disbursement b $   8,12,300
Excess(deficiency) of cash available over disbursement c=a-b $ -1,33,500
Financing:
Borrowing $   1,53,500
Repayment 0
Interest 0
Total financing d $   1,53,500
Ending cash balance c+d $      20,000
Buy Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Help Me Write My Essay - Reasons:

Best Online Essay Writing Service

We strive to give our customers the best online essay writing experience. We Make sure essays are submitted on time and all the instructions are followed.

Our Writers are Experienced and Professional

Our essay writing service is founded on professional writers who are on stand by to help you any time.

Free Revision Fo all Essays

Sometimes you may require our writers to add on a point to make your essay as customised as possible, we will give you unlimited times to do this. And we will do it for free.

Timely Essay(s)

We understand the frustrations that comes with late essays and our writers are extra careful to not violate this term. Our support team is always engauging our writers to help you have your essay ahead of time.

Customised Essays &100% Confidential

Our Online writing Service has zero torelance for plagiarised papers. We have plagiarism checking tool that generate plagiarism reports just to make sure you are satisfied.

24/7 Customer Support

Our agents are ready to help you around the clock. Please feel free to reach out and enquire about anything.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

HOW OUR ONLINE ESSAY WRITING SERVICE WORKS

Let us write that nagging essay.

STEP 1

Submit Your Essay/Homework Instructions

By clicking on the "PLACE ORDER" button, tell us your requires. Be precise for an accurate customised essay. You may also upload any reading materials where applicable.

STEP 2

Pick A & Writer

Our ordering form will provide you with a list of writers and their feedbacks. At step 2, its time select a writer. Our online agents are on stand by to help you just in case.

STEP 3

Editing (OUR PART)

At this stage, our editor will go through your essay and make sure your writer did meet all the instructions.

STEP 4

Receive your Paper

After Editing, your paper will be sent to you via email.

× How can I help you?