All integer, no validation or ranges needed. Although the user can enter whatever numbers they wish, for testing purposes you should consider a more ‘realistic’ scenario – see below.
INPUT:
All integer, no validation or ranges needed.
Although the user can enter whatever numbers they wish, for testing purposes
you should consider a more ‘realistic’ scenario – see below.
1. Input production cost:
The overall cost to set up the production.
Keep is sensible – maybe aim at maximum of £5000?
By the same argument, is a production costs of £100 realistic?
2. Input the cost of one seat in band-A
(band-A costs double band-B)
3. Input the cost of one seat in band-B
(band-B is half the cost of band-A)
Keep seat costs sensible – be realistic – don’t have the cost of a production at
£5000 and offer seats at £1000 each!
It may be difficult to sell seats costing more than, say, £50? – you decide for
testing purposes – but validation is not required.
PROCESS:
Part-1: Full house
a) How many days to break-even based on seat sales
Part-2: Part house
a) How many days for the production to break even based on seat sales
(Use a random function to randomly allocate seats and use this as the basis for
projection)
OUTPUT: (Dashboard design at your discretion)
Full house £
Production cost (£) = 3000
Band-A price = 20
Band-B price = 10
Revenue:
Band-A at £20.00
Band-A sales (10 seats) = 200
Band-B at £10.00
Band-B sales (10 seats) = 100
Total for the night = 300
Break-even (rounded up) = 3000 / 300 = 10 days
Part-house £
Production cost = 3000
Band-A price = 20
Band-B price = 10
Revenue:
Band-A at £20.00
Band-A sales (6 seats) = 120
Band-B at £10.00
Band-B sales (2 seats) = 20
Total for the night = 140
Break-even (rounded up) = 3000 / 140 = 21.42 = 22 day
Step by step
Solved in 2 steps with 1 images
