Order for this Paper or similar Assignment Help Service

Fill the order form in 3 easy steps - Less than 5 mins.

Posted: December 28th, 2022

Linear Programming — Leadership in Business

Assignment Task
Linear Programming — Leadership in Business
Alex Matteo is a forma partner of a professional accounting firm who values education. Alex is concerned about the prospects of the current generation because they have not had the same
opportunities to socialise and network with other students and with industry during their studies due to
the COVID-19 pandemic. Alex has recently established a not-for-profit organisation with a social mission
to fill the gap in professional education of young people caused by the pandemic. The organisation is
called Leadership in Business and its rust major event will be a conference, primarily, for high school
students. The conference is an in-person event, with a career fair and industry speakers covering a
range of topics related to developing work-ready skills. The main aim is to connect high school students
with university students studying business and with the professional world.
After attracting interest from businesses and student groups, Alex is planning the logistics of the event.
The event will be held on a Saturday and Sunday from 10am to 5pm. The venue will only allow 300
attendees per day. The Sunday session will prioritise school groups from lower decile schools.
Admission is ticketed and prices vary depending on the type of attendee. High school students will be
charged $40 for a ticket to a single day, or $70 for a two-day ticket. A special rate of $20 for attendees
from a list of lower decile schools (pm-purchased and student ID required) will be available for the
Sunday only. University students and corporate guests will be charged $20 and S30, respectively, for a
single day ticket. While they are not the main targets, university students and corporate members would
like to ‘give back’ to help high school students and they also benefit from the chance to network.
Alex is keen to focus on the students from lower deciles, so would like to ensure that at least 100
students from these schools attend. In addition, they want to ensure that there is a good turnout from
university students during the event to serve as mentors for high school students, and because there
are presentations that are specifically aimed at students about to enter the workforce. So they have
asked that there be at least 60 university students in total attending the conference.
Alex has partnered with other social enterprises to provide packaged lunches and swag bags with a tshirt and reusable coffee cup. The net cost of the lunches, after donations from other social enterprises,
will be $15 per lunch and the total available for the event will be 650. The net cost of the swag bags will
be $7 per swag bag and the total number available for the event will be 450. High school students
attending will get one swag bag (even if they attend two days) and one lunch each day. University and
corporate guests will only get lunch.
Coffee and juice will also be available as part of the ticket price. High scholars can have two juices per
day. University students can get one coffee and one juice. Corporate guests can get two coffees. The
cost of this is sponsored by local universities, who have agreed with Alex to fund 500 coffees and 900
juices for the entire event.
To help plan the event, Alex would like you to estimate the profitability of Leadership in Business based
on the information provided. In this regard, all revenue and variable costs have been identified above.
Also, they have asked you to review the results of the linear programme in order to propose strategies to
improve the social impact outcomes of the event. You decide that a linear programme would be useful
for this.
Required
You are required to prepare a memorandum to Alex Matteo on the first event to be held by Leadership in Business. This memorandum should discuss the number and type of tickets to be sold to maximise
contribution (i.e. total revenue less total variable costs). Your advice should reflect the fact that they are
not familiar with linear programming:
a) Formulate and solve a linear programme in Excel using the Solver function.
b) Review the results of the linear programme to identify ways to improve capacity utilisation and social impact outcomes.
• Propose one area where further investment would help to improve the capacity utilisation for the
event. Refer to the linear programming results to justify your selection and describe the potential
impact.
• Propose one way to further improve the social objective outcomes of the event. This should refer tofacts in the case where possible.

Order | Check Discount

Tags: Linear Programming — Leadership in Business

Assignment Help For You!

Special Offer! Get 20-30% Off on Every Order!

Why Seek Our Custom Writing Services

Every Student Wants Quality and That’s What We Deliver

Graduate Essay Writers

Only the finest writers are selected to be a part of our team, with each possessing specialized knowledge in specific subjects and a background in academic writing..

Affordable Prices

We balance affordability with exceptional writing standards by offering student-friendly prices that are competitive and reasonable compared to other writing services.

100% Plagiarism-Free

We write all our papers from scratch thus 0% similarity index. We scan every final draft before submitting it to a customer.

How it works

When you opt to place an order with Nursing StudyBay, here is what happens:

Fill the Order Form

You will complete our order form, filling in all of the fields and giving us as much instructions detail as possible.

Assignment of Writer

We assess your order and pair it with a custom writer who possesses the specific qualifications for that subject. They then start the research/write from scratch.

Order in Progress and Delivery

You and the assigned writer have direct communication throughout the process. Upon receiving the final draft, you can either approve it or request revisions.

Giving us Feedback (and other options)

We seek to understand your experience. You can also peruse testimonials from other clients. From several options, you can select your preferred writer.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00