The scenario is that Star Events, an event management company, will be merchandising a number of products in conjunction with a forthcoming Triathlon championship. It is your task to design spreadsheet to work out the profit that will be earned.
A partially completed Excel worksheet is provided to assist you. It contains column headers and row labels but you must enter appropropriate formulae to find the answer to the total profit generated by the scenario.
Download the activity sheet for Budgeting Exercise 14
Download the Excel worksheet template for Budgeting Exercise 14
An important aspect about this exercise is that the learner will have the opportunity not only to develop a spreadsheet to work out an answer to this problem, but also an interactive tool. For example, changes can be easily made to cost price, quantity sold or mark-up percentage and the effect on total profit seen.