Help with calculations
OK I have a challenge for someone...
I'm trying to develop an eLearning development calculator.
The idea is that me or the customer will enter in the approximate duration of the module, what is available in the way of a Storyboard or Graphics, which then produces a development cost.
See attached Storyline file.
The calculations are as follows:
Customer provides Storyboard and Graphics (I provide nothing) = £200 per minute
Customer provides Storyboard only (I provide Graphics) = £300 per minute
Customer provides graphics only (I provide Storyboard) = £350 per minute
Customer provides nothing (I provide Storyboard and Graphics) = £400 per minute
Once the tick boxes have been completed, then the minute rate is multiplied by the duration to get the total development cost.
Then I need to ask if voiceover is required?
If no - then there is no change in the cost.
If yes, then I need to add a total of £200 if the rate is £200; £250 for the £300 rate; £300 for the £350 rate and £350 for the £400 rate.
If anyone can work this out and can amend the Storyline file I'll be so grateful.