Construct a model for the total revenue

Assignment Help Business Management
Reference no: EM132992898

The MacDonald sells two popular packages of breakfast all-day-long: Mac A and Mac B . The sales of these products are not independent of each other (in economics, we call these substitutable products, because if the price of one increases, sales of the other will increase).

The store wishes to establish a pricing policy to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold ( Q ) and prices ( P ) of each model:

QA = 20 - 0.62PA + 0.30PB

QB = 29 + 0.10PA - 0.60PB

a. Construct a model for the total revenue and implement it on a spreadsheet.

b. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue.

c. Use "Solver" to find the optimal prices.

Solver is a Add-on feature that you can download from Excel Home. You will need to show your formular and Solver in Excel spreadsheets.

Reference no: EM132992898

Questions Cloud

Describe the four stages of group development : -List and describe the steps conducted in a rational decision-making approach. Then, compare it to a recent project or undertaking from your professional life.
What is the value of the upper fence : Considering the Member satisfaction scores for Bronze ticket holders only, to detect potential unusual values, if we rely on the Empirical rule, what is the val
It play in getting value from analytics : Business analytics has become a very hot topic do you think that business analytics can live up to the hype that it is receiving? What role does IT play in gett
Consequence of decreased globalisation for developed country : The global pandemic has led to a decrease in globalisation across the world. What are the consequences of decreased globalisation for developed countries and fo
Construct a model for the total revenue : The MacDonald sells two popular packages of breakfast all-day-long: Mac A and Mac B . The sales of these products are not independent of each other (in economic
Evaluate organization external and internal environments : and select a sample strategic ESPN. Be sure it includes the various components of a typical strategic plan. Reference Figure 1.1 "Identifying a Company's Strat
Americans with disabilities act : Under the Americans with Disabilities Act (ADA), reasonable accommodations must be provided to allow a qualified employee to perform the essential functions of
Standardized monetary tightening : One of the reforms conducted by BIS touched output and price in responses to a standardized monetary tightening.
Characteristics in choosing an individual incentive plans : Individual employee is paid incentive on the basis of individual performance or output. Compare two (2) organizational characteristics in choosing an individual

Reviews

Write a Review

Business Management Questions & Answers

  How business intelligence do bigger roles in corporate

Describe the sizes, scoping, and time of the business Be sure to defining the corporate plannings as it relates to your responses.

  Skills the manager feels recent graduates

What key skills the manager feels recent graduates bring with them to the workplace?

  Selecting a prospective expatriate

What key characteristics would you look for in selecting a prospective expatriate?

  Leader-s challenge and personal potential in organization

The leader's challenge is to help individuals grow and fulfill their personal potential while advancing the organization's goals'.

  Evaluate the adequacy of the policy

Task 1In this task you will provide an overview of your chosen organisation.

  Current assets of an acquired firm

What procedure is used to record current assets of an acquired firm?

  Employment in security services

Workplace Security - what are the prerequisites for employment in security services?

  Game theory of money and banking

A person is a Vice-President of a Bank, serving as the head of Commercial Lending. They receive a substantial bonus based on the volume and profitability of their department. The department both makes loans and collects the loans. Answer the fo..

  Suggest the best software development method

Giving reasons for your answer. Suggest the best software development method that might be used in developing the following systems.

  What profit do you get per year

Annual costs to operate the complex is $1M. If the vacancy rate is 5%, what profit do you get per year? (Chapter 2)

  Compare with a transformational leader

How do the behaviors of a charismatic leader compare with a transformational leader? Does charisma always has a positive influence on followers?

  Describe what a socialization program

Describe what a socialization program might look like if management desired employees who were innovative and individualistic. At least 100 words for a discussion post.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd