Design a spreadsheet to show the following.
a raffle, the prize being a 4.5kg Toblerone block of chocolate. Each member (50) has been asked to sell a book of raffle tickets but as usual, some are eager and others refuse.
Design a Spreadsheet to show how many books need to be sold to make target.
Each book has 10 raffle tickets in it. Each ticket is valued at $1.Target profit is $400. Cost of prize $121
I can easily do the maths in my head but I have no idea how to show it in a spreadsheet for 50 members.
thank you
Information
Each book has 10 raffle tickets in it.
Each ticket is valued at $1
Target profit is $400
Cost of prize $121
a raffle, the prize being a 4.5kg Toblerone block of chocolate. Each member (50) has been asked to sell a book of raffle tickets but as usual, some are eager and others refuse.
Design a Spreadsheet to show how many books need to be sold to make target.
Each book has 10 raffle tickets in it. Each ticket is valued at $1.Target profit is $400. Cost of prize $121
I can easily do the maths in my head but I have no idea how to show it in a spreadsheet for 50 members.
thank you
Information
Each book has 10 raffle tickets in it.
Each ticket is valued at $1
Target profit is $400
Cost of prize $121
