Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Accounting 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 12,000 12,000 12,000
Merchandise purchases 62,000 72,000 37,000
Sales 62,000 72,000 42,000
Ending inventory 12,000 12,000 7,000

Units are sold for $11 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 $452,000.

Merchandise is purchased for $6 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 $122,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 $292,000 includes selling and administrative payables.

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

Required:

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 $ $ $








 

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 $ $ $








 

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 $ $ $






 

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M91046477
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Financial Accounting

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

Case study - the athletes storerequiredonce you have read

Case Study - The Athletes Store Required: Once you have read through the assignment complete the following tasks in order and produce the following reports Part 1 i. Enter the business information including name, address ...

Assignment -part a -background saturn petcare australia and

Assignment - Part A - Background: Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since openin ...

Exercise 1 copying formatting and calculating sums and

EXERCISE 1: COPYING, FORMATTING, AND CALCULATING SUMS AND AVERAGES Let's assume that Groth Donut Company has three stores, only one of which is shown at the top of the sheet titled "p = r-­-e". The revenue and expenses f ...

Need slides need a one page executive summarybelow is the

Need slides. Need a one page executive summary. Below is the scenario: "Hi again. I've got news about our client. "ExxonMobil is looking to increase revenue by 10 percent and possibly reduce costs. Need an executive summ ...

Consider the following account starting balances and

Consider the following account starting balances and transactions involving these accounts. Use T-accounts to record the starting balances and the offsetting entries for the transactions. The starting balance of Cash is ...

Ha 3011 advanced financial accounting assignment

HA 3011 Advanced Financial Accounting Assignment - Assessment Task Part A - In an article entitled 'Unwieldy rules useless for investors' that appeared in the Australian Financial Review on 6 February 2012 (by Agnes King ...

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 ...

Assessment 1develop complex spreadsheetsthis is an

Assessment 1 Develop Complex Spreadsheets This is an assessment that may be worked on in study time and as homework. Assessment presentation should be completed in a manner that is appropriate to professional business re ...

Asset retirement obligation changes in estimate versus

Asset Retirement Obligation, Changes in Estimate versus Errors, Writing an Issues Memo Facts: Mega¬Corp's corporate headquarters, built in 1970, has asbestos in its insulation. The Company's financial statements reflect ...

  • 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