Assessment 1 Part 2 – CVP Analysis

You are assisting management consider different cost and pricing strategies. Consider

the following data and report to management your findings.

1. The cocktail bar in the Le Cordon Bleu hotel currently has sales revenue of

$650,000.00 per year. Beverage costs amount to 40% and other variable costs at

this level of revenue amount to 10%. Fixed costs are $170,000pa.

You are required to show all relevant formula and calculations using a professional

layout as explained during class tutorial sessions. Use Excel and use whole

numbers. Percentages where shown should be 1 decimal place ie xx.x%.

Please read the questions and information carefully.

1.1 What is the annual net profit (before tax)? (4)

1.2 The owner wants to increase the manager’s salary by $12,000 per year.

What is the new sales revenue needed to provide this additional salary and

maintain the current level of net profit? Show the equation you used to arrive at this

answer. (2)

(Any added sales revenue will come from increasing seat turnover by

improving/increasing the efficiency of customer service).

1.3 Instead of increasing sales revenue by increasing seat turnover and customer

service, the owner decides to increase menu prices by 5%.

The owner believes the price increase can be made without losing any customers

and without increasing the cost of sales or other variable costs. The original variable

cost dollar values and the manager’s salary increase still apply. Hint calculate the

new SR based on the original Sale Revenue.

Show the new VC%’s.

What will the bar’s net profit (before tax) be? (4)

Hospitality Financial Management (HFM)

2 © Le Cordon Bleu, Ryde

2. The restaurant in the Le Cordon Bleu hotel currently has a cover sale price of $65

with a variable unit cost of $21, Fixed costs are $80,000.

The owner wants to increase the manager’s salary by $12,000.00 per year.

2.1) Calculate the total number of covers to BE and meet the managers salary

increase. (3)

2.2) The owner has also been advised by his supplier, the cost of raw materials is

about to increase by 2.6%.

Calculate the number of covers for the increased salary and increased costs.

Show the new VCu, CMu in $xx.cc (3)

2.3) How many more covers are required to meet the increased Variable Cost

increase? (2)

3) Using this data, create a table and then use the graphical method of analysis to

display:

Units sold in 1000 increments,

Total Sales Revenue,

Fixed Costs,

Variable Costs,

Total Costs

Answered Same DayNov 11, 2019Swinburne University of Technology

Answer 1.1:

Sales revenue

650000

100.00%

Variable costs - Beverages

260000

40.00%

Other variable costs

65000

10.00%

Total variable costs

325000

50.00%

Contribution margin

325000

Fixed cost

170000

Profit before tax

155000

Answer 1.2:

Sales revenue to have the profit of $155000

Expected sales =

(Fixed cost + target profit) / CM ratio

=

(170000+12000)/(40%+10%)

=

364000

Answer 1.3:

Old

New

Sales revenue

650000

100.00%

682500

100.00%

Variable costs - Beverages

260000

40.00%

260000

38.10%

Other variable costs

65000

10.00%

65000

9.52%

Total variable costs

325000

50.00%

325000

47.62%

Contribution margin

325000

357500

Fixed cost

170000

182000

Profit before...

Sales revenue

650000

100.00%

Variable costs - Beverages

260000

40.00%

Other variable costs

65000

10.00%

Total variable costs

325000

50.00%

Contribution margin

325000

Fixed cost

170000

Profit before tax

155000

Answer 1.2:

Sales revenue to have the profit of $155000

Expected sales =

(Fixed cost + target profit) / CM ratio

=

(170000+12000)/(40%+10%)

=

364000

Answer 1.3:

Old

New

Sales revenue

650000

100.00%

682500

100.00%

Variable costs - Beverages

260000

40.00%

260000

38.10%

Other variable costs

65000

10.00%

65000

9.52%

Total variable costs

325000

50.00%

325000

47.62%

Contribution margin

325000

357500

Fixed cost

170000

182000

Profit before...

SOLUTION.PDF## Answer To This Question Is Available To Download

- ACC 556 financial accounting for managersTargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$65,300$417,000Cost of goods sold45,000301,000Selling and administrative...SolvedMar 21, 2022
- Chipotle Name: You are a senior financial analyst for Chipotle and the new VP of Finance has asked for you to develop a high- level analysis of performance for the past two years (2019 vs 2018)...SolvedMar 20, 2022
- ACCT 7080Spring 2022Project Submission #220 PointsUsing the Word document provided answer the questions below. Project Submission #2 is due on 3/31/2022 by 11:59 pm. Upload this document to...SolvedMar 16, 2022
- Ivey Business CaseYou will use the case titled 'High Performance Tire' for the group project. To purchase the case, please click on the link...SolvedMar 13, 2022
- ASSIGNMENT INSTRUCTIONS Assessment e.g. Analytical report (use terms used in MDF) Assessment code: 010/011/012 (delete as appropriate – code appears on MDF) Academic Year: 2021/2022...SolvedMar 13, 2022
- Capital Budgeting ProblemsBUS3062 Week 5 Assignment TemplateCapital BudgetingSolve the following problems. Create appropriate formulas using the supplied values in the corresponding cells so...SolvedMar 13, 2022
- Risk and ReturnBUS3062 Week 4 Assignment TemplateRisk and returnSolve the following problems and answer the last question. Create appropriate formulas using the supplied values in the...SolvedMar 08, 2022
- Please read through the types of (depreciation methods) applicable in the business world.When a business acquired "assets" tangible or intangible form, they must access which is most benefical during...SolvedMar 08, 2022
- Directions – Chapter 6 HOMEWORK Please try your best on these answers. The more you work on these the better off you will be for the test! THERE WILL BE VARIATION IN YOUR ANSWERS TO WHAT I HAVE...SolvedMar 07, 2022
- InputStatements Date7/31/21Current MonthJULStatements Year2021Beginning of the Current Month7/1/21For the Month Ended Jul 31, 2021Jul 31, 2021List of...SolvedMar 07, 2022

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.