--- Please Show excel formulas, thanks---

Shamu Corporation is in the process of preparing its budget for next year. Cost of goods sold has

been estimated at 60 percent of sales. Merchandise purchases are to be made during the month

preceding the month of the sales. Button pays 60 percent in the month of purchase and 40

percent in the month following. Wages are estimated at 20 percent of sales and are paid during

the month of sale. Other operating costs amounting to 10 percent of sales are to be paid in the

month following the sale.

Month Sales Revenue

December $170,000

January 250,000

February 120,000

March 200,000

April 160,000

Prepare a schedule of cash disbursements for January, February, and March

--- Please Show excel formulas, thanks---