VIEW THE STEP-BY-STEP SOLUTION TO:

BSBCUE608 Manage customer engagement operational costs ASSESSMENT TASK 2- CASE STUDY ANALYSIS Preparation and Presentation of budget STUDENT...

• You have successfully unlocked this question.

BSBCUE608 Manage customer engagement operational costs

ASSESSMENT TASK 2- CASE STUDY ANALYSIS

Preparation and Presentation of budget

STUDENT INSTRUCTIONS:

For this Assessment Task 2, you are required to analysis the given case study and answer the questions given below.

Case Study: Have your flu shot!

The Flu Shot department at The Hospital will soon enter flu season.

To prepare, the department is stocking up on Band-Aids-regular and glow-in-the-dark. A regular Band-Aid is budgeted at $1, while a glow-in-the-dark Band-Aid is budgeted at $2. The net revenue for a flu shot is $20/patient.

During last year's flu season, the department saw 400 adults and 700 children. Children always request glow-in-the-dark Band-Aids.

You are required to answer the following questions:

a)Statistical budget, in a tabular format.

b)Calculate the revenue and operating budget to find out the total profit or loss.

c)Present the result in a graphical format.

The Hospital's flu season campaign brings forth additional patients resulting in actual patients as 300 adults and 1000 children. Perform a variance analysis and answer the following questions.

d)How does volume change affect budgeted revenue and expenses?

e)How does change in patient mix affect the department's finances?

ASSESSMENT TASK 3 - SCENARIO ANALYSIS

Break-even Analysis

STUDENT INSTRUCTION:

For this Assessment Task 3, students are required to analysis the given scenarios and answer the given questions related to Break-even Analysis.

Scenario Analysis

Scenario A - break-even point problem

CAC student, including you, are planning to organize a movie show function in CT theatre for fundraising to help victims of recent earthquake in Timbuktu. Your team is worried about the cost involved and expected revenue from this function. The team has asked you to determine the number of tickets to be sold to ensure that the program is at least break-even.

The data you need to make your calculation is as follows:

Total Fixed Cost: $10,080

Variable Cost per Participant: $2.00

Ticket Price Participant: $20

Scenario B - Variation of the basic break-even point problem

This problem is much the same problem as in Scenario A except that you are given the number of participants and you must work out what is the minimum price that spectators must be charged.

The data you need to make your calculation is as follows:

Total fixed Costs: $10,000

Variable Cost per Participant: $5.00

Number of Participant Required: 500

Scenario C - Award evening

The club committee are putting on an awards evening in the clubhouse. The ticket price will be $30 per person and it is expected that 100 people will attend. The committee will spend 41500 on entertainment and prizes.

What is the maximum cost of the meal per person that can be afforded, if the event is not to make a loss?

Scenario D - Calculating the break-even point of three possible venues for an event

The committee of a sport organisation is considering three different venues to stage a major fundraising event.

Venue A has a maximum seating capacity of 500 people and cost $1,200 to hire.

Venue B has a maximum capacity of 1000 and cost $1,200 to hire.

Venue C has a maximum capacity of 2000 and cost $9,000.

If the variable cost for each participant is $5.20, which venue would be the most profitable at maximum capacity, if the price per person is $10?

To solve this problem you will need three separate spread sheets, one for each venue.