Question

 Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here

and the following information in its preparation.​

Sales: February

$514,000​;

March

$489,000​;

April

$550,000​;

May

$586,000​;

June

$663,000​;

July $668,000​Purchases: Purchases are calculated as

57%

of the next​ month's sales,

11%

of purchases are made in​ cash,

46%

of purchases are paid for 1 month after​ purchase, and the remaining

43%

of purchases are paid for 2 months after purchase.​Rent: The firm pays rent of

$7,960

per month.Wages and​ salaries: Base wage and salary costs are fixed at

$5,800

per month plus a variable cost of

7.4%

of the current​ month's sales.​Taxes: A tax payment of

$54,300

is due in June.Fixed asset​ outlays: New equipment costing

$75,200

will be bought and paid for in April.Interest​ payments: An interest payment of

$29,500

is due in June.Cash​ dividends: Dividends of

$12,400

will be paid in April.

Principal repayments and​ retirements: No principal repayments or retirements are due during these months.

Complete the cash disbursements schedule for Maris​ Brothers, Inc.​ below: ​ (Round to the nearest​ dollar.)

Schedule of Projected Cash Disbursements for Maris Brothers, Inc.
	Feb		Mar		Apr		May		Jun		Jul
Sales	$	514000	$	489000	$	550000
Disbursements
Purchases	$		$		$
Cash					$
1 month delay					$
2 month delay					$
Rent					$
Wages and salary
Fixed					$
Variable					$
Taxes					$
Fixed assets					$
Interest					$
Cash dividends					$
Total Disbursements					$

Enter any number in the edit fields and then click Check Answer.

How do I get total disbursements?

Answer 1

Answer:

Total disbursements for the months of April, May, and June are calculated and given below (highlighted yellow):

The above excel with 'show formula' is as below: