代写ACCTG331 Revenue and Cost Management

100%原创包过,高质代写&免费提供Turnitin报告--24小时客服QQ&微信：120591129

ACCTG331 Revenue and Cost Management 2016

Assignment 2

Due date: Thursday 15 September 2016, 4.00 p.m.

Length: Maximum THREE A4 pages for the Memo

(Excluding LP formulation, Excel outputs, and references)

12 point font, 1.5 spacing

Weighting: 7% Coursework

All assignments must be submitted as follows:

1. Hardcopy: Assignment Centre, Level 0 (OGGB), on the due date by 4.00 pm.

2. Digital copy: Turnitin via Canvas, on the due date by 4.00 pm.

Turnitin is now accessed via your Canvas account:

Assignments -> Written Assignments -> Written Assignment 2

Your assignment must be submitted to Turnitin for us to mark it.

If you have any problems submitting your assignment, you should email

acctg331@auckland.ac.nz – before the due date for the assignment.

Learning objectives

• Demonstrate proficiency in linear programming and Excel within a contextual setting

• Develop and apply strategies to refine the estimates used in linear programming

• Exercise professional skill in writing reports

Linear Programming – Cooper’s Retreat

You have offered to help organise Cooper’s Retreat, an event designed to bring students and

corporate workers together in a casual environment to unwind after a busy work day, as well

as an opportunity to mingle and network. Hugh Cooper, the organiser of this event, is an

internationally renowned business speaker who is planning to tour New Zealand universities.

The Auckland event is the first and will be held on a Friday evening during the University of

Auckland’s mid-semester break. Cooper’s Retreat will feature live music from local bands

and bar service to be held in a ‘pop-up’ marquee that will be set-up in an otherwise unused

space around the campus. As an unlicensed event, they plan to offer complimentary freshly

squeezed juice and premium soft-drinks.

ACCTG331

After attracting interest from businesses and student groups, Hugh is planning the logistics of

the event. The event will be held from 4pm to 10pm. The marquee and location will only

allow 250 attendees.

Admission is ticketed and attendees buy tickets for three-hour time sessions. The afternoon

session is from 4pm to 7pm and the evening session from 7pm to 10pm. Students will be

charged $22 for a ticket to a single session, or $40 for a ticket to both sessions. Corporate

guests will be charged $29 for a ticket to a single session, or $50 for a ticket to both sessions.

When asked about expected numbers of attendees, Hugh replies:

“Err… I’m really not that sure. It’s the first event. So it could be quiet. There has

been a good response from companies and I think it’d be a cheap time out for

students. It being a Friday would also help… let’s just say 80 people for each

ticket type and we can play around with that figure later.”

Discussing the event further with Hugh you estimate that, over the course of three hours, a

student will have three soft drinks and one juice, while a corporate guest will have one soft

drink and two juices. Kitchen space is limited. There will only be enough refrigerator space

for 800 soft drinks for the whole event. The juicing area is also a concern as staff will need to

prepare fruit and vegetables, juice them to order, and serve customers. You expect to be able

to provide 350 servings of juice in the afternoon session as staff can prepare servings ahead

of time. This estimate will decrease to 250 servings for the evening session when staff have

to prepare juice during the evening. The cost of providing each soft drink is $2, and $3 for

each juice.

During his initial talks with businesses and student groups about the event, Hugh is

approached by Trajectory, a local business organisation, who would like to run a competition

in the month leading up to the event. For each day in August, Trajectory are looking to offer

a prize for one full event corporate pass (a corporate ticket to both afternoon and evening

sessions). Hugh views this as good advertising for the event and the necessary tickets will be

presold, and Trajectory will pay the full price for these tickets.

To help plan the event, Hugh would like you to estimate the profitability of Cooper’s Retreat

based on the information provided. Further, Hugh has also asked you to investigate the likely

demand for the event by ticket type, and examine the effect this is likely to have on the

event’s profitability. You decide that a linear programme would be useful for this.

Required

You are required to prepare a memo to Hugh Cooper on Cooper’s Retreat that discusses the

tickets to be sold to maximise their profit. Your advice should reflect the fact that Hugh is

not familiar with linear programming:

a) Formulate and solve the linear programme in Excel using the Solver function. Attach as

appendices to your memo copies of your:

• Linear programme equation showing the objective function and constraints, together

with your variable definitions. This can be hand-written or printed.

• Excel spreadsheet containing the linear programme.

• Excel Answer Report and Sensitivity Report.

ACCTG331

b) Develop and apply strategies to refine the demand estimates provided by Hugh. You

anticipate there would be a maximum demand of 100 for any given ticket (representing

“peak” demand), with a minimum demand of 30 for any ticket (“quiet” demand).

• Develop two strategies you would use to investigate and refine the demand estimates

for the event. Your strategies may use experiential or empirical approaches.

• Apply at least one of the strategies you described to refine the demand estimates.

Re-solve the linear programme under these different conditions to explore how

changes in demand will affect the profitability of the event.

c) Prepare a memo for Cooper’s Retreat that discusses the following areas:

• A brief overview of your linear programme and its role in solving the business

problem. This should include a description of the linear programme’s objectives as

well as the role of explicit and implicit constraints.

• The results of your linear programme in Part A. This should include details of the

maximum revenue that could be earned, what the final values represent, which

constraints are binding, and what the shadow prices mean.

• An overview of the strategies you employed in Part B to refine the demand estimates

for the LP. For each strategy, describe the methods to be used, data sources, and the

likely accuracy of the results. Briefly discuss the insights from the results you

observe when re-solving the linear programme.

Additional submission instructions

• Turnitin.com submission: Only include your memo for Part C in your Turnitin

submission; exclude the LP formulation and Excel outputs for Turnitin.

• Hardcopy submission: Your submission to the assignment centre must include the

memo for Part C with the LP formulation and Excel outputs as appendices (marks

will be lost if these reports are missing)