E1Input the information and data from the case scenario below, using computer accounting software (e.g. MYOB or MS Excel).

Your cash flow forecast will predict the bank balance at the end of each month for each month of the year.

The event management company has on its books four major events to run which will take place in March, May, August and October.

The total of $265,000 of tickets sales will be earned in the months that the events are held. The March event will earn $65,000, and the other events in May, August and October will earn $55,000, $75,000 and $70,000 respectively.

Expenditures on casual wages of $10, 000, travel and transport of $60, 000, and venue hire of $24,000 will occur only in the months in which the four events take place. These expenditures will be the same for each event. An extra amount of $2000 will also occur in April and November evenly, for travel and transport and for casual wages respectively,

Salaries and Office administration expenses respectively of $180,000 and $36,000 will occur evenly every month.

The company's opening balance on 1 January is $10,000.

The company will receive a government grant of $40,000 in July.

The company will make a small income of total $6500 from Merchandising during the months in which the four events are staged. The event in March will earn $1,500 merchandising income, and the other events in May, August and October will earn $1,600, $1,800 and $1,600 respectively.