Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Randall Company is a merchandising company that sells a single product. The company's inventories, production, and sales in units for the next three months have been forecasted as follows:


October November December
  Beginning inventory 20,000    20,000    20,000   
  Merchandise purchases 58,000    68,000    33,000   
  Sales 58,000    68,000    38,000   
  Ending inventory 20,000    20,000    15,000   

Units are sold for $13 each. One fourth of all sales are paid for in the month of sale and the balance are paid for in the following month. Accounts receivable at September 30 totaled $464,000.

Merchandise is purchased for $7 per unit. Half of the purchases are paid for in the month of the purchase and the remainder are paid for in the month following purchase. Selling and administrative expenses are expected to total $134,000 each month. One half of these expenses will be paid in the month in which they are incurred and the balance will be paid in the following month. There is no depreciation. Accounts payable at September 30 totaled $304,000 includes selling and administrative payables.

Cash at September 30 totaled $94,000. A payment of $314,000 for purchase of equipment is scheduled for November, and a dividend of $214,000 is to be paid in December.

Required:
a.

Prepare a schedule of expected cash collections for each of the months of October, November, and December. (Omit the "$" sign in your response.)

Schedule of Expected Cash Collections

October November December
  Sales $    $    $   
  September accounts receivable $   

  October sales    $   
  November sales
   $   
  December sales

  




  Total cash collections $    $    $   





b.

Prepare a schedule showing expected cash disbursements for merchandise purchases and selling and administrative expenses for each of the months October, November, and December. (Omit the "$" sign in your response.)

Schedule of Expected Cash Disbursements

October November December
  Merchandise purchases $    $    $   
  Selling and administrative expenses         




  Total incurred $    $    $   




  Disbursements, previous month $    $    $   
  Disbursements, current month         




  Total $    $    $   





c.

Prepare a cash budget for each of the months October, November, and December. There is no minimum required ending cash balance.  (Input all amounts as positive values. Omit the "$" sign in your response.)

Randall Company
Cash Budget

October November December
  Beginning cash balance $    $    $   
  Add cash receipts         




  Total cash available $    $    $   




  Disbursements


       Accounts payable         
       Payment for equipment
  
       Payment for dividend

  




  Total disbursements         




  Ending cash balance $    $    $   




Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M9949270

Have any Question?


Related Questions in Accounting Basics

Question competenciesbullevaluate the reasons business

Question: Competencies • Evaluate the reasons business combinations occur and the accounting implications of such transactions. • Critique the development of International Accounting Standards and the implications for US ...

Question - 1 paid 20000 cash to purchase equipment costing

Question - 1. Paid $20,000 cash to purchase equipment costing $80,000. The remaining amount was recognized as a one year note payable with interest rate of 9%. 2. A major dental machine in our office is broken beyond rep ...

Question - stellar company manufactures equipment stellars

Question - Stellar Company manufactures equipment. Stellar's products range from simple automated machinery to complex systems containing numerous components. Unit selling prices range from $200,000 to $1,500,000 and are ...

Question - what is the present value of 7160 to be received

Question - What is the present value of $7,160 to be received at the end of each of 18 periods, discounted at 5% compound interest?

Question - this is an accounting problem that appears on

Question - This is an accounting problem that appears on McGraw Hill. Please help with recording the advance collection and revenue earned on the general journal. Thank you. The University of Michigan football stadium, b ...

Question - richard and pauline jackson have a small mowing

Question - Richard and Pauline Jackson have a small mowing and gardening business in which they have been working for the last eight years. As it is only the two of them in the business they operate as a partnership. The ...

Question - applying managerial accounting concepts to the

Question - Applying Managerial Accounting Concepts to the Service Industry Many of the concepts in managerial accounting were first developed for the manufacturing environment. Do you think the same concepts, such as var ...

Question -what is financial statement fraudhow is it

Question - What is financial statement fraud? How is it different from embezzlement and misappropriation? Why might senior management overstate or understate business performance?

Question - in 2002 the executives at telecommunications

Question - In 2002, the executives at telecommunications giant WorldCom perpetrated accounting fraud that led to the largest bankruptcy in US history. The company improperly booked about $4 billion as capital expenditure ...

Corporate accounting assignment -assessment task - select

Corporate Accounting Assignment - Assessment task - Select two public limited companies listed on the Australian Securities Exchange (ASX) that are in the same industry. Go to the website of your selected companies. Then ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As