Purchase Solution

Revenue Management: Finding the Best Combination of Price/Supply

Not what you're looking for?

Ask Custom Question

The following is an extract from a company's accounts.
Price 4
Supply 29000
Unitcost 0.45
fixed cost 45,000
Revenue ?
variable cost 13050
Profit ?

Set up a spreadsheet to calculate revenue and profit of the company. Also perform sensitivity analysis for the following cases and find out the right combination of price and supply which yields better revenue:
i) Vary the price between 1 and 6 (in steps of 0.5)
ii) Vary the supply between 25,000 and 50,000 ( in steps of 5000)
iii) Simultaneously varying both price and supply (Two variable sensitivity analysis)

Purchase this Solution

Solution Summary

Here is a solution using excel spread sheet for Revenue Management.

Solution provided by:
Education
  • BPharm, Mumbai ,India
  • MMS, Mumbai, India
  • PhD, Madras, India
Recent Feedback
  • "Thank you so much"
  • "GREAT JOB...THANK YOU"
  • "GREAT JOB...THANK YOU"
  • "great job"
  • "thank you"
Purchase this Solution


Free BrainMass Quizzes
Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Motivation

This tests some key elements of major motivation theories.