Grade 7 Assignment 1: Organising a Music Event

You are going to organize a music event at AIS. You only have $100 dollars to spend on it and there are many costs to consider. However, you can earn extra money to pay for things by selling tickets and food for the event.

First: Design a spreadsheet that will calculate whether it is possible to hold the event. You will use functions and formula to calculate the totals. It must also help you decide on the prices of things such as tickets and food. Finally, it should show you if you can make a profit or not!

Costs
DJ (Hire) - $50
Music PA system (Hire) - $30
Lights (Hire) $30
Caretaker - $5
Cooks - $20

Second: Design an attractive poster which will advertise the music event. You should include ticket prices and the price of food available to buy.