Hi guys, the topic is on business modelling using excel. the question is about a tour company that is optimising its resources and service providers to be cost efficient.

1) How do I answer question 2c?

pls find the qn: https://drive.google.com/file/d/1hhYoy3Tn4G2h4BecFAF_MZM9iqtEdL-5/view?usp=sharing

my current answer here:

https://drive.google.com/file/d/1RQUYZL8plphOuCM3nkj18Vc4yuAN4Xwy/view?usp=sharing

(.xlsx will be available upon request.)

2) How do I improve my answer for question 2b? (pls see working.jpg).

3) How do I describe the marketing method used by the company in this case (Ques 3 btw)?