Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 442 Weeks Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 13 Jun 2017 My Price 7.00

Ridenour Ltd. is preparing its first-quarter monthly cash budget for 2011

28.     LO.4 (Cash collections) Ridenour Ltd. is preparing its first-quarter monthly cash budget for 2011. The following information is available about actual 2010 sales and expected 2011 sales:

Excel

 

November

December

January

February

March

$83,000

$76,000

$79,000

$88,000

$59,000

 Tracing collections from prior year monthly sales and discussions with the credit man- ager helped develop a profile of collection behavior patterns.

Of a given month’s sales, 40 percent is typically collected in the month of sale. Because the company terms are 1 percent (end of month) net 30, all collections within the month of sale are net of the 1 percent discount. Of a given month’s sales, 30 percent is collected in the month following the sale. The remaining 30 percent is collected in the second month following the month of the sale. Bad debts are negligible and should be ignored.

a.     Prepare a schedule of cash collections for Ridenour Ltd. for January, February, and March 2011.

b.    Calculate the Accounts Receivable balance at March 31, 2011.

Answers

Alpha Geek
(8)
Status NEW Posted 13 Jun 2017 05:06 AM My Price 7.00

-----------

Attachments

file 1497332449-1319864_1_636329135966406006_Cash-collection-Budget.xlsx preview (239 words )
13-----------198-----------64&-----------amp-----------;am-----------p;i-----------nfo-----------Id=-----------513-----------439-----------28.----------- ----------- ----------- -----------LO-----------.4-----------(C-----------ash----------- co-----------lle-----------cti-----------ons-----------) -----------Rid-----------eno-----------ur -----------Ltd-----------. i-----------s p-----------rep-----------ari-----------ng -----------its----------- -----------rs-----------t-q-----------uar-----------ter----------- mo-----------nth-----------ly -----------cas-----------h b-----------udg-----------et -----------for----------- 20-----------11.----------- Th-----------e f-----------oll-----------owi-----------ng -----------inf-----------orm-----------ati-----------on -----------is -----------ava-----------ila-----------ble----------- ab-----------out----------- ac-----------tua-----------l 2-----------010----------- sa-----------les----------- an-----------d e-----------xpe-----------cte-----------d 2-----------011----------- sa-----------les-----------:No-----------vem-----------ber-----------Dec-----------emb-----------erJ-----------anu-----------ary-----------Feb-----------rua-----------ryM-----------arc-----------h$T-----------rac-----------ing----------- co-----------lle-----------cti-----------ons----------- fr-----------om -----------pri-----------or -----------yea-----------r m-----------ont-----------hly----------- sa-----------les----------- an-----------d d-----------isc-----------uss-----------ion-----------s w-----------ith----------- th-----------e c-----------red-----------it -----------man------------ a-----------ger----------- he-----------lpe-----------d d-----------eve-----------lop----------- a -----------pro-----------fi-----------le -----------of -----------col-----------lec-----------tio-----------n b-----------eha-----------vio-----------r p-----------att-----------ern-----------s.O-----------f a----------- gi-----------ven-----------
Not Rated(0)