Question

Fill in the missing amounts (there are six numbers that you need to find…labeled as (A)...

Fill in the missing amounts (there are six numbers that you need to find…labeled as (A) through (F)) in the following Cash receipt schedule. Enter ONLY the number (NO dollar sign). Round your answer to the nearest digit. Sales in the month of March = $192,000    Half of each month's sales are on account.  60%of credit sales is collected in the month of sale.    40%of credit sales is collected in the following month.                               April May June    Sales $256,000 $192,000 $289,200    Cash receipts:          From cash sales$(A)$(B) $144,600    From sales on Account$(C) $108,800$(D)    Total cash receipts$(E)$(F) $269,760                Required:(A) Cash sales in the month of April (B) Cash sales in the month of May (C) Cash receipts in April from Credit sales in the months of March and April (D) Cash collected in June from credit sales in the months of May and June (E) Total cash receipts in April (F) Total cash receipts in May

Homework Answers

Answer #1

a) Cash sales in the month of April = 256000*50% = 128000

b) Cash sales in the month of May = 192000*50% = 96000

c) Cash receipt in April from credit sales in the month of March = 192000*50%*40% = 38400

Cash receipt in April from credit sales in the month of April = 256000*50%*60% = 76800

d) Cash collected in June from credit sales in the month of May = 192000*50%*40% = 38400

Cash collected in June from credit sales in the month of June = 289200*50%*60% = 86760

e) Total Cash receipt in April = 128000+38400+76800 = 243200

f) Total Cash receipt in May = 96000+108800 = 204800

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
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1, 2016. Projected sales for...
PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1, 2016. Projected sales for each of the first three months of operations are as follows: March $390,000 April 550,000 May 750,000 The company expects to sell 10% of its merchandise for cash. Of sales on account, 55% are expected to be collected in the month of the sale, 41% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
Schedule of Cash Collections PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1,...
Schedule of Cash Collections PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1, 2016. Projected sales for each of the first three months of operations are as follows: March $170,000 April 240,000 May 350,000 The company expects to sell 10% of its merchandise for cash. Of sales on account, 51% are expected to be collected in the month of the sale, 44% in the month following the sale, and the remainder in the second month following the...
Jasper Company has sales on account and for cash. Specifically, 61% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 61% of its sales are on account and 39% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $519,000 for April, $529,000 for May, and $554,000 for June. The beginning balance of Accounts Receivable is $292,800 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 39% Sales on...
Jasper Company has sales on account and for cash. Specifically, 57% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 57% of its sales are on account and 43% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $532,000 for April, $542,000 for May, and $567,000 for June. The beginning balance of Accounts Receivable is $302,100 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 43% Sales on...
Exercise 20-18 Budgeted cash receipts LO P2 Jasper Company has sales on account and for cash....
Exercise 20-18 Budgeted cash receipts LO P2 Jasper Company has sales on account and for cash. Specifically, 62% of its sales are on account and 38% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $528,000 for April, $538,000 for May, and $563,000 for June. The beginning balance of Accounts Receivable is $308,900 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April...
Jasper Company has sales on account and for cash. Specifically, 64% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 64% of its sales are on account and 36% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $518,000 for April, $528,000 for May, and $553,000 for June. The beginning balance of Accounts Receivable is $293,500 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June Answer is not complete. April May June Cash...
Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier,...
Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $184,000 June 192,000 July 201,000 All sales are on account. Sixty percent of sales are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
CAT Co. had forecasted sales as follows: -April: $406,000 -May: $452,000 -June: $496,000 Sales are 30%...
CAT Co. had forecasted sales as follows: -April: $406,000 -May: $452,000 -June: $496,000 Sales are 30% credit and 70% cash. 50% of the credit sales are collected in the month of the sale, 30% in the month following the sale, and 20% in the following month. Total sales for the months of February and March were $950,000 with February having $500,000 credit sales and March $400,000. Prepare a sales budget schedule and a cash collections budget schedule for the months...
April May June Sales* $264,000 $198,000 $298,800 Cash receipts: From cash sales $132,000 $99,000 $149,400 From...
April May June Sales* $264,000 $198,000 $298,800 Cash receipts: From cash sales $132,000 $99,000 $149,400 From sales on account† 280,500 112,200 Total cash receipts $412,500 $211,200 *Half of each month’s sales are on account. March sales amounted to $198,000. †60% of credit sales is collected in the month of sale; 40% is collected in the following month.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT