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 Influence Diagram and Blackbox that you have already created for Komal.create the model design and the Excel model for her.

Can you send me the solution using excel?