ABC Company has the monthly sales budget for the quarter as following:

April May June The Quarter

Unit sales 67,500 54,000 60,750 182,250

Unit selling price $6,200 $6,200 $6,200 $6,200

Total Sales $418,500,000 $334,800,000 $376,650,000 $1,129,950,000

Additional information:

April May June

Toal Manufacturing Overhead Costs $151,844,460.00; $153,360,540.00; $ 170,037,420.00

Total selling and Admin expenses $87,075,000.00 $69,660,000.00 $78,367,500.00 $

Cash on hand at opening $3,375,000

Annual interest rate on borrowing 6%

Cash Sales $0

Received in month of sale 80%

Received in month after sale 18%

Balance of accounts receivables at the start of the month $82,863,000

Dividends paid in June $1,194,750

Land purchased in May $185,100,000

QUESTION: Prepare the monthly Cash Budget for the Quarter