Question

Worton Distributing expects its September sales to be 25% higher than its August sales of $153,000....

Worton Distributing expects its September sales to be 25% higher than its August sales of $153,000. Purchases were $103,000 in August and are expected to be $123,000 in September. All sales are on credit and are expected to be collected as follows: 40% in the month of the sale and 60% in the following month. Purchases are paid 20% in the month of purchase and 80% in the following month. The cash balance on September 1 is $13,000. The ending cash balance on September 30 is estimated to be

Homework Answers

Answer #1

The ending cashbalance on September 30 is estimated to be:

Ans:.$74,300

Explanation:

1)

Beginning cash balance (given) $ 13000
Cash receipts from credit sales made in August ($153,000 ×60%) $91,800
Cash receipts from credit sales made in September[ $153,000× 1.25 ]× 40% $76500
Cash disbursements from purchases made in August( $ 103,000 × 80%) ($82,400)
Cash disbursements from purchases made in September( $ 123,000 × 20%) ($24,600)
Ending cash balance $74,300
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Jeffs Distributing expects its September sales to be 25% higher than its August sales of $166,000....
Jeffs Distributing expects its September sales to be 25% higher than its August sales of $166,000. Purchases were $116,000 in August and are expected to be $136,000 in September. All sales are on credit and are expected to be collected as follows: 40% in the month of the sale and 60% in the following month. Purchases are paid 20% in the month of purchase and 80% in the following month. The cash balance on September 1 is $26,000. The ending...
Walter Enterprises expects its September sales to be 25% higher than its August sales of $200,000....
Walter Enterprises expects its September sales to be 25% higher than its August sales of $200,000. Purchases were $150,000 in August and are expected to be $170,000 in September. All sales are on credit and are collected as follows: 35% in the month of the sale and 65% in the following month. Merchandise purchases are paid as follows: 25% in the month of purchase and 75% in the following month. The beginning cash balance on September 1 is $7,900. The...
ABC Company was organized on August 1 of the current year. Projected sales for the next...
ABC Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August   $250,000 September     200,000 October     275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections for August, September, and October. ABC Company Schedule of Collections from Sales...
Felix Co. expects June sales to be $29,000, July sales to be $35,000, August sales to...
Felix Co. expects June sales to be $29,000, July sales to be $35,000, August sales to be $32,000, and September sales to be 33,000. 40% of sales are cash sales and remaining 60% are credit sales. Collection of credit sales are 50% in the month of sale, 40% in the month following sale and 5% two months following sale. The remaining 5% is uncollectible. What is the expected total cash collections in August?
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August,...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. 3. Each month’s ending inventory must equal 25%...
The Johann's Professional Service Company expects 80% of sales for cash and 20% on credit. The...
The Johann's Professional Service Company expects 80% of sales for cash and 20% on credit. The company collects 80% of its credit sales in the month following sale, 15% in the second month following sale, and 5% are not collected (that is, they are "bad debts"). Expected sales for June, July, and August are $55,000, $61,000, and $51,000, respectively. What are the company's expected total cash receipts in August?
Company B is a merchandising Company. Estimated sales for July, August, and September will be $200,000,...
Company B is a merchandising Company. Estimated sales for July, August, and September will be $200,000, $190,000, and $210,000, respectively. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The average gross profit ration is 60%. The company pays for 40% of its merchandise purchase in the month of purchase and the remaining 60% in the month following the purchase. 1. How much is the budgeted merchandise purchase in August? 2. How much is the...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were 190,000 and in June 180,000. 60% of sales are cash, 30% of sales are to be collected the next month, and the remaining 10% in 2 months. Budgeted purchases of the required materials for production are: July​​100,000 August​​105,000 September​95,000 Purchases in June were 90,000. 70% of purchases are cash and 30% should be paid the next month. Direct Labor is 35% of purchases Selling...
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business September, October, and November are $248,000, $316,000, and $424,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in October from accounts receivable are estimated to be a.$142,240...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months of 2016 are as follows: August $122,000...