COST VOLUME PROFIT ANALYSIS

Evelyn has recently started her business as an event organizer and has 50th birth day party to plan for. Evelyn had not been given the exact number of guests that will be attending the party confirmed to her. Evelyn has come to you, her friend, as you are working as an accounts assistant. She wants you to create a spreadsheet with formulas that will allow her to enter the number of the guest and the spreadsheet will calculate how many cakes she needs to make, the cost she will incur and the total cost that she can quote to her potential clients. Evelyn's client, Nombulelo is making enquiries about the cost of providing birthday cake for all her guests. Evelyn has been advised that it may be a party for 40 guests, 72 guests, 103 guests, 135 guests, 180 guests, 240 guests or even 300 guests. Evelyn has told you that each cake can feed up to 8 people and it costs her R70to make each cake and ideally, she would like to sell each at cost plus a 45per cent profit.

1. produce a table based on the information provided about Nombulelo's guest numbers and calculate the number of cakes needed, the cost to make the cakes, the profit to be added and the final cost to be quoted to Nombulelo's. Hint: you cannot have half of a cake

2. Nobulelo has approached Evelyn for another quote. She wants to include drinks with her cake order. Evelyn wants to create a new table which is linked to the table from question 1. Evelyn can buy sparkling wine for R300 per bottle and this will fill 8 glasses. Wine will cost Evelyn R120 per bottle and will fill 6 glasses. Work out how many bottles are needed based on the guests drinking one glass of sparkling wine each and three glasses of wine each.

3. How many events (average of 150 guests per event) would be needed for the business to break even. Currently there is a fixed cos of R1000,000 per year and a budgeted sales revenue of R4000,000. They also stated that they would like to achieve a profit of approximately R400, 000