Komal has been appointed the new president of the Student$$s Club in Management Institute

of Tikiliki $($MIT$).$ Her responsibilities include organizing student engagement events in the

Tikiliki campus throughout the year. These events may include sports day, quizzing events,

celebrations of important festivals, drama competitions, and the like. Based on experience,

her faculty mentor, Dr$.$ Lili suggests that Komal should restrict the number of events to

only $12$ a year as these events take up a lot of time and funds to organize. The size of the

student body in Tikiliki campus is $200$ at present but may increase in near future as MIT is

about to introduce new post$-$graduate programmes. About $60\%$ of the students are campus

residents, while the remaining are day scholars meaning that they travel to the campus

daily, except for weekends and public holidays. Again, this number may change as new

programmes are introduced and new hostel facilities are built. MIT has decided to increase

its emphasis on student engagement activities in coming years as more students stay on

campus to keep them well$-$motivated and offer a healthy and creative atmosphere in the

campus. The events are partially funded by students themselves and partially by MIT.

Generally, the expenses incurred for an event would include those on buying prizes,

food$/$beverages$,$ local conveyance, decorations, and dais arrangements, etc.

Komal has categorized the events into three types: $1)$ Large$-$scale which have expenses

between Rs$.10,000$ and Rs$.20,000$; $2)$ Mid$-$scale which have expenses between Rs$.5,000$

and Rs$.10,000$ and $3)$ Small$-$scale which have expenses less than Rs$.5,000.$ Dr$.$ Lili has

advised her not to spend beyond Rs$.20,000$ in any event and try to reduce expenses

wherever possible.

Now, Komal must decide how much to charge each student per month to meet the expenses

of the events. She is also faced with the question on whether to charge the students residing

in the campus and the day scholars equally, since many day scholars may not take part in

events organized in the evenings or weekends and public holidays. Dr$.$ Lili has promised

that whatever funds will be collected from students, MIT will be putting in an equivalent

amount to help meet the expenses. For example, if in a year the fund collected from students

total to Rs$.50,000,$ then MIT will also contribute an additional Rs$.50,000$ for the year.

Additionally, for large$-$scale events like celebration of Independence Day and sports day,

MIT administration is willing to spend additional sum, based on requirements. For

example, for sports day, MIT administration has promised to take care of refreshments for

student participants.

Dr$.$ Lili suggests that Komal must think of saving at least $10\%$ of the collected funds for

the next year. Students do not earn, so they cannot be charged a lot. They may end up not

contributing at all if they are charged exorbitantly. However, if they are charged too less,

then event expenses cannot be met, and the objective of student engagement cannot be

achieved.

Komal has never used spreadsheets for such decision$-$making activities. Dr$.$ Lili has advised

her to take your help. Her main task is to see that the expenses are met, and at least $10\%$

savings are possible, for whatever amount she decides to charge the students.

Based on the Excel model you have created for Komal, perform the following what$-$if

analysis to help her.

a$.$ In coming years, due to the introduction of new undergraduate and postgraduate

programs, the total number of students enrolled in MIT will increase. However, event

expenses will also go up in coming years. Help Komal perform a what$-$if analysis to

understand the effect of these two factors on her savings in the coming years.

b$.$ Dr$.$ Lili wonders whether it will always be possible for MIT to keep its promise of

contributing an amount equivalent to the funds raised from students. Similarly, MIT

may not always be able to contribute any additional amount for large$-$scale events. At

the same time, there may still be a pressure from the administration to conduct more

events in a year. Therefore, she suggests Komal to consider the effect of the following

three scenarios on her savings. Will she be able to meet the target savings of $10\%$ in all

scenarios? Note that Komal cannot charge exorbitant amounts from the students just to

meet the savings target.

Scenario MIT$$s contribution

$(\%$ of total student

contribution$)$

No$.$ of Events Additional

contribution from

MIT $(\%$ of largescale event expense$)$

Best Case $120\%1050\%$

Likely Case $100\%1210\%$

Worst Case $50\%140\%$

You can make necessary modifications to your Excel model to perform the above whatif analyses. Make necessary assumptions and state them.MIT administration is willing to spend additional sum, based on requirements. For

example, for sports day, MIT administration has promised to take care of refreshments for

student participants.

Dr$.$ Lili suggests that Komal must think of saving at least $10\%$