Question

Clinton Retailers expects to make inventory purchases in the next quarter as follows: April $58,400 May...

Clinton Retailers expects to make inventory purchases in the next quarter as follows:

April $58,400
May 69,800
June 95,500


Prior experience has shown that 80 percent of a month’s purchases are paid in the month of purchase and 20 percent are paid in the month following purchase. March purchases were $52,300.

Estimate cash disbursements related to purchases for April, May, and June.

Cash disbursements for purchases April May June
Payment of March purchases $ $ $
Payment of April purchases
Payment of May purchases
Payment of June purchases
$ $ $

Homework Answers

Answer #1

Answer:

Cash disbursements for purchases April May June
Payment of March purchases $10,460
Payment of April purchases $46,720 $11,680
Payment of May purchases $55,840 $13,960
Payment of June purchases $76,400
Total cash disbursements $57,180 $67,520 $90,360

Calculations:

Cash disbursements for purchases Credit purchase % of payment April May June
Payment of March purchases $52,300 20% $10,460
Payment of April purchases $58,400 80% $46,720
20% $11,680
Payment of May purchases $69,800 80% $55,840
20% $13,960
Payment of June purchases $95,500 80% $76,400
Total $57,180 $67,520 $90,360
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
Beca Retailers expects credit sales in the next quarter as follows: April $79,100 May 84,800 June...
Beca Retailers expects credit sales in the next quarter as follows: April $79,100 May 84,800 June 101,000 Prior experience has shown that 64 percent of a month’s sales are collected in the month of sale, 20 percent are collected in the month following sale, and the remaining 16 percent are collected in the second month following sale. February and March sales were $82,200 and $110,000, respectively. Estimate budgeted cash receipts for April, May, and June. Collection of credit sales April...
Ridgewood Retailers expects credit sales in the next quarter as follows: April $63,300 May 96,200 June...
Ridgewood Retailers expects credit sales in the next quarter as follows: April $63,300 May 96,200 June 113,000 Prior experience has shown that 61 percent of a month’s sales are collected in the month of sale, 18 percent are collected in the month following sale, and the remaining 21 percent are collected in the second month following sale. February and March sales were $82,200 and $107,000, respectively. Estimate budgeted cash receipts for April, May, and June. Collection of credit sales April...
The Lawn Antique Mall expects to make purchases in the first quarter of 2018 as follows:...
The Lawn Antique Mall expects to make purchases in the first quarter of 2018 as follows: January $87,700 February 99,000 March 82,000 Purchases in December 2017 are expected to be $91,000. The company expects that 55 percent of a month’s purchases will be paid in the month of purchase and 45 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2018. Cash disbursements for purchases January February...
The Warrenburg Antique Mall expects to make purchases in the first quarter of 2018 as follows:...
The Warrenburg Antique Mall expects to make purchases in the first quarter of 2018 as follows: January $95,000 February 120,000                               March      85,000 Purchases in December 2017 are expected to be $92,000. The company expects that 50 percent of a month's purchases will be paid in the month of purchase and 50 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2018.
Here are some important figures from the budget of Cornell, Inc., for the second quarter of...
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2016: April May June   Credit sales $ 318,000 $ 298,000 $ 358,000   Credit purchases 126,000 149,000 174,000   Cash disbursements     Wages, taxes, and expenses 43,800 11,300 62,800     Interest 10,800 10,800 10,800     Equipment purchases 78,000 146,000 0 The company predicts that 5 percent of its credit sales will never be collected, 20 percent of its sales will be collected in the month of the sale, and...
Here are some important figures from the budget of Marston, Inc., for the second quarter of...
Here are some important figures from the budget of Marston, Inc., for the second quarter of 2016:    April May June Credit sales $ 415,000 $ 364,000 $ 452,000 Credit purchases 192,000 180,000 213,000 Cash disbursements Wages, taxes, and expenses 81,000 76,500 105,200 Interest 10,700 10,700 10,700 Equipment purchases 39,500 12,000 160,000    The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 12600 16800 14400 43800 Selling price per unit x $60 x $60 x $60 Sales revenue $756000 $1008000 $864000 $2628000 All of the sales are on credit. Quagmire collects from customers as follows: 45% of sales in the month of sale 25% in the month following the sale, and 30% in the second month following...
Zisk Co. purchases raw materials on account. Budgeted purchase amounts are April, $92,000; May, $122,000; and...
Zisk Co. purchases raw materials on account. Budgeted purchase amounts are April, $92,000; May, $122,000; and June, $132,000. Payments are made as follows: 70% in the month of purchase and 30% in the month after purchase. The March 31 balance of accounts payable is $34,000. Prepare a schedule of budgeted cash payments for April, May, and June.
Kovarik Company has the following sales forecast for the next quarter: April, 4,000 units; May, 4,800...
Kovarik Company has the following sales forecast for the next quarter: April, 4,000 units; May, 4,800 units; June, 5,600 units. Sales totaled 3,200 units in March. The March ending finished goods inventory was 1,000 units. End-of-month finished goods inventory levels are planned to be equal to 30 percent of the next month's planned sales. Calculate the number of units of inventory Kovarik needs to purchase for April?
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...