Question

The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000...

The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale.

Required

  1. Complete the schedule of cash receipts by filling in the missing amounts.

July August September
Sales Budget
Cash sales $72,000 $68,000 $86,000
Sales on account 86,000 107,000 121,600
Total budgeted sales $158,000 $175,000 $207,600
Schedule of Cash Receipts
Current cash sales
Plus: Collections from accounts receivable
Total budgeted collections $442,000 $154,000 $193,000
  1. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

Accounts Receivable ______

Homework Answers

Answer #1
  • Requirements

July

August

September

Sales Budget

Cash sales

$72,000

$68,000

$86,000

Sales on account

$86,000

$107,000

$121,600

Total budgeted sales

$158,000

$175,000

$207,600

Schedule of Cash Receipts

Current cash sales

$72,000

$68,000

$86,000

Plus: Collections from accounts receivable

$370,000

$86,000

$107,000

Total budgeted collections

$442,000

$154,000

$193,000

  • Accounts receivables at the end of Third Quarter
    = 100% of September’s sales on account
    = 100% of $ 121600
    = $ 121,600 [Answer]
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
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. 1. July August September Sales Budget Cash sales $67,000 $67,000...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding the cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2 percent...
The Westwood Cycle Company expects to start operations on July 1, 2020 and will sell bicycles...
The Westwood Cycle Company expects to start operations on July 1, 2020 and will sell bicycles out of its store that it recently leased in the town center. Westwood Cycle has budgeted sales for the month of July to be $12,000 of which 30 percent will be cash sales and 70 percent will be sales on account. Westwood Cycle expects a 15 percent increase in sales per month for August and September with the ratio of cash sales to sales...
Dubai Trade Corporation has prepared the following 2020 sales budget:                         Month      &nbs
Dubai Trade Corporation has prepared the following 2020 sales budget:                         Month                     Cash Sales      Credit Sales                         May                               $16,000             $68,000                         June                                20,000               80,000                         July                                 18,000               74,000                         August                            24,000               92,000                         September                       22,000               76,000 Collections are 40% in the month of sale, 45% in the month following the sale, and 10% two months following the sale. The remaining 5% is expected to be uncollectible. The company also made sure that all outstanding balances owed by customers from November...
James, Inc. makes a product that has peak sales in September of each year. The company...
James, Inc. makes a product that has peak sales in September of each year. The company has prepared a sales budget for the third quarter as shown below: Month Budgeted Sales July $ 200,000 August 400,000 September 600,000 The company is in the process of preparing a cash budget for the third quarter and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on Sales In month of sale 60 %...
The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit...
The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit Sales May $59,000 $283,000 June $43,000 $236,000 July $33,000 $205,000 August $47,000 $268,000 September $46,000 $197,000 Additional information to be used determining the expected cash collections each month that will be used in preparing the cash budget: Collections on Credit sales: 50% in month of sale 20% in month following sale 30% in second month following sale The Accounts Receivable balance on May 1...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
apes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are...
apes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at $370,000 for November, $380,000 for December, and $360,000 for January. Collections are expected to be 45% in the month of sale and 55% in the month following the sale. The cost of goods sold is 70% of sales. The company desires an ending merchandise inventory equal to 25% of the cost of goods sold in the following month. Payment for merchandise is...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...