Regal Company finds that typically 30% of sales are for cash. Payments on accounts receivable are 60% in the month of sale and 38% in the following month. Total budgeted sales are:
|
June |
$110,000 |
|
July |
$150,000 |
|
August |
$130,000 |
How much total cash is expected to be received in July?
Question 6 options:
|
$139,400 |
|
|
$137,260 |
|
|
$147,820 |
|
|
$152,000 |
Answer- Total cash is expected to be received in July =$137260.
Explanation- Total cash received in July month= ($110000*70%*38%)+($150000*30%)+($150000*70%*60%)
= $29260+$45000+$63000
= $137260
Regal Company finds that typically 30% of sales are for cash. Payments on accounts receivable are...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale Percent paid in the second month after the sale Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 300,000 August Required:...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services firm. All sales of legal services are billed to the dient (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next 5 months, the following sales billings are expected: May $84,000 June...
Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 5,000 $ 800,000 May (actual) 2,000 320,000 June (budgeted) 5,500 880,000 July (budgeted) 4,500 879,000 August (budgeted) 4,000 640,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale, 44% in the month after the sale, 26% in the second month after the sale, and 4% proves to be uncollectible....
Prepare a schedule of budgeted cash collections from sales for
May, June, and July. Include a three-month summary of estimated
cash collections.
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,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...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,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 1...
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...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,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 1...
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.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....
8
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 Percent paid in the month after the sale Percent paid in the second month after the sale 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 $275,500 May...
Beginning cash balance on July 1: $30,000.
Cash receipts from sales: 30% is collected in the month of
sale, 50% in the next month, and 20% in the second month after sale
(uncollectible accounts are negligible and can be ignored). Sales
amounts are: May (actual), $1,032,000; June (actual), $720,000; and
July (budgeted), $840,000.
Payments on merchandise purchases: 60% in the month of purchase
and 40% in the month following purchase. Purchases amounts are:
June (actual), $258,000; and July (budgeted), $600,000....