Question: A dashboard should summarize key performance indicators (KPI).Answers will vary. This question is designed to require students to incorporate concepts and information introduced in this
What-If Questions
1. What would be the impact on net profit if the average attendance per seminar increased to 45?
2. What would be the impact on net profit if the average attendance dropped to 35?
3. What would be the impact on net profit if parking fee is reduced to $3?
4. What would be the impact on net profit if the speaker’s fee increased to $550 per seminar?
5. What would be the impact on net profit of increasing the marketing expense per seminar to $350, resulting in an increase in average attendance per seminar to 50?
6. What would be the impact on net profit of an increase in room rental per seminar to $300?
7. If Bora can negotiate a room rental fee of $160 per seminar, how much will net profit increase?
8. If technical support is included in the room rental per seminar, what is net profit?
Goal Seek Questions
(i). Given the expenses and variables presented in the figure, how many attendees per seminar are required to generate a net profit of $5,500?
(ii). What parking fee results in a net profit of $4,150?
(iii). What registration fee per attendee results in a net profit of $5,750?
Step by Step Solution
3.47 Rating (163 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat00220022 00000220022 00000220022 00220022 msostylenameCurrency msostyleid4 style18 color464646 fontsize... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
385-B-A-I-S (6182).xlsx
300 KBs Excel File
