April | May | June | ||
Cash sales | 41% | 217710 | 221810 | 232060 |
Sales on account | 59% | 313290 | 319190 | 333940 |
Total sales | 531000 | 541000 | 566000 | |
Schedule of Cash Receipts | ||||
For April, May, and June | ||||
April | May | June | ||
Cash receipts from: | ||||
Cash sales | 217710 | 221810 | 232060 | |
Collections of accounts Receivable | 292400 | 313290 | 319190 | |
Total budgeted cash receipts | 510110 | 535100 | 551250 | |
Formulas used: | ||||
April | May | June | ||
Cash sales | =531000*41% | =541000*41% | =566000*41% | |
Sales on account | =531000*59% | =541000*59% | =566000*59% | |
=217710+313290 | =221810+319190 | =232060+333940 |
Jasper Company has sales on account and for cash. Specifically, 59% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 59% of its sales are on account and 41% 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 $296,100 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. Jasper Company has sales on account and for...
Jasper Company has sales on account and for cash. Specifically, 70% of its sales are on account and 30% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $525,000 for April, $535,000 for May, and $560,000 for June. The beginning balance of Accounts Receivable is $400,000 on April 1 Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 30% Sales on...
Jasper Company has sales on account and for cash. Specifically, 58% of its sales are on account and 42% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $522,000 for April, $532,000 for May, and $557,000 for June. The beginning balance of Accounts Receivable is $301,600 on April 1 Prepare a schedule of budgeted cash receipts for April, May, and June April May June Cash sales 42% Sales on...
Jasper Company has sales on account and for cash. Specifically, 63% of its sales are on account and 37% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $516,000 for April, $526,000 for May, and $551,000 for June. The beginning balance of Accounts Receivable is $290,400 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 37% Sales on...
Jasper Company has sales on account and for cash. Specifically, 65% of its sales are on account and 35% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $534,000 for April, $544,000 for May, and $569,000 for June. The beginning balance of Accounts Receivable is $301,000 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June April May June 35% Cash sales Sales on...
Jasper Company has sales on account and for cash. Specifically 60% of its sales are on account and 40% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $526,000 for April, $536,000 for May, and $561,000 for June. The beginning balance of Accounts Receivable is $290,400 on April 1 Prepare a schedule of budgeted cash receipts for April, May, and June. May June April Cash sales 40% 60% Sales...
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 $520,000 for April, $530,000 for May, and $555,000 for June. The beginning balance of Accounts Receivable is $295,800 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales Sales on account...
Jasper Company has sales on account and for cash. Specifically, 55% of its sales are on account and 45% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $522,000 for April, $532,000 for May, and $557,000 for June. The beginning balance of Accounts Receivable is $293,900 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. UUT Jueu l'ally, 55% of its sales are...
Jasper Company has sales on account and for cash. Specifically, 63% of its sales are on account and 37% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $522,000 for April, $532,000 for May, and $557,000 for June. The beginning balance of Accounts Receivable is $305,000 on April 1 Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 37% Sales on...
Jasper Company has sales on account and for cash. Specifically, 70% of its sales are on account and 30% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $525,000 for April, $535,000 for May, and $560,000 for June. The beginning balance of Accounts Receivable is $400,000 on April 1 Prepare a schedule of budgeted cash receipts for April, May, and June Prepare a schedule of budgeted cash receipts for...