Excel reverse financials - Toy Story
80 % naar komma getal zetten: 80/100 = 0,8
Required before-tax profits & return on sales zijn gegeven.
Required revenue = Required before-tax profits / return on sales
Allowable costs = Required revenue – Required before-tax profits
Average price per item wordt gegeven
Number of items required to be sold = Required revenue / Average price per item
Average items per transaction wordt gegeven
Required transactions = (Required revenue / Average price per item) / 2
Weeks during peak season wordt gegeven
Required transactions per peak week = (0,8 * Required transactions) / 10 (800 transactions moeten gebeuren binnen 10 peak weeks)
Revenue per week = Average price per item * Average items per transaction * Required transactions per peak week
1
, Advertising tot hours per week worden gegeven
Staff expense per week per staff person = Staff expense per hour * Hours per week * Number of staff
Expense per year per staff person = Staff expense per week per staff person * Weeks in the year
2
80 % naar komma getal zetten: 80/100 = 0,8
Required before-tax profits & return on sales zijn gegeven.
Required revenue = Required before-tax profits / return on sales
Allowable costs = Required revenue – Required before-tax profits
Average price per item wordt gegeven
Number of items required to be sold = Required revenue / Average price per item
Average items per transaction wordt gegeven
Required transactions = (Required revenue / Average price per item) / 2
Weeks during peak season wordt gegeven
Required transactions per peak week = (0,8 * Required transactions) / 10 (800 transactions moeten gebeuren binnen 10 peak weeks)
Revenue per week = Average price per item * Average items per transaction * Required transactions per peak week
1
, Advertising tot hours per week worden gegeven
Staff expense per week per staff person = Staff expense per hour * Hours per week * Number of staff
Expense per year per staff person = Staff expense per week per staff person * Weeks in the year
2
