Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you provide a different question as below ( Existing Question ) this with answer where we need to create the influence diagram and blackbox

  Can you provide a different question as below (Existing Question) this with answer where we need to create the influence diagram and blackbox diagram ,create the model design and the Excel model and what if analysis
Existing Question - Komal has been appointed the new president of the Students 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.
Create the influence diagram and blackbox diagram for Komal.
Based on the Influence Diagram and Blackbox that you have already created for Komal,
create the model design and the Excel model for her.
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 MITs contribution (% of total student contr

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

More Books

Students also viewed these Accounting questions

Question

Did Mill think about the distribution of wealth?

Answered: 1 week ago

Question

What was the diamonds vs. water paradox? How was it resolved?

Answered: 1 week ago