Lee Elrina Nguyen Inga Vogel How did your team use SOLVER? List the details of EACH solver model you created including: Objective, Changing Cells, and Constraints (if any). Do not list cell references – describe the variables used in the solver model. At least one working solver model MUST be used in your Excel file and the Excel file you turn in must demonstrate one meaningful, working solver model. Team TT used solver to determine the optimal prices for each product per DC. We began by setting
Words: 4877 - Pages: 20
use WACC as a tool to value a project. If the project is below WACC, it will not generate enough return for the Investor. 3. How does Beta influence the WACC? Beta represents the measure of risk of the company. When using the capital asset pricing model, the beta coefficient is an index of risk. When the risk increases, the investor will expect a higher rate of return. So when the beta increases, it will cause the WACC to increase as well. 4. How does the Risk Free Rate influence the WACC
Words: 369 - Pages: 2
often criticized, and Midland division presidents and controllers sometimes challenged specific assumptions and inputs. The case uses comparable companies to estimate asset and beta for each individual division, and must comply the capital asset pricing model for calculating the cost of capital. Midland was conservative compared to some of its large competitors, but it has a group of trader in- house who actively managed currency. Interest rate and commodity risks within a set of guideline approved
Words: 305 - Pages: 2
Fixed costs do not vary with the scale of operations, and will be incurred even if the flight is cancelled. Examples of fixed cost are the rental cost of leased planes, which is time- but not operations-sensitive, and general administrative costs such as salaries. Constant costs, which cease if the flight is cancelled but are invariant to the volume of traffic carried, are also high. Examples of constant costs are the subsistence allowance paid to the cabin crew, and landing fees, which do not depend
Words: 13887 - Pages: 56
STRATEGY 1 The planning process 1 Position analysis 2 Product Life Cycle 4 Internet strategy 6 Pricing 9 Mergers and acquisitions -- Strategic aspects 16 Strategy THE PLANNING PROCESS There are 2 theories about where the planning process should start: Accountancy led Where objectives are set independently
Words: 2989 - Pages: 12
calculations used is the Capital Asset Pricing Model (Exhibit 1). This model was used to calculate the required rate of return for an investor in Coca Cola. In this calculation, Beta was set at 1.24, and the risk free rate was set at the 30-year government bond rate of 6.22%. The market risk premium was set at the stated 6.00% rate, resulting in a required rate of return of 13.66%. Once this required rate of return was calculated, the Dividend Discount Model (Exhibit 2) was used to calculate a forecasted
Words: 702 - Pages: 3
• Question 1 © 0 out of 2 points Customer-driven pricing may depress profits because _____. Answer Selected Answer: customers will only pay so much for a product Correct Answer: pricing for short term sales objectives often undermines perceived value by customers • Question 2 2 out of 2 points Cost-plus pricing is effectively opposite of a prudent pricing strategy because _____. Answer Selected Answer: it leads to overpricing in weak markets and underpricing
Words: 32682 - Pages: 131
Introduction The variables in a marketers strategic tool box is the 4P’s which make up the elements of marketing mix. The numerous competitors that Caltex compete for market share are BP, Coles Express, Mobil, Shell Woolworths and United Petroleum in the retail environment, Product A product can be a physical object, services, persons, places organisations and ideas. The nature of a product can be tangible for instance a vehicle, and non tangible, a service. A product has the capability
Words: 1952 - Pages: 8
White Paper Rate Optimization: Enhancing Your Hotel’s Pricing Strategy For many hotels, developing effective pricing strategies remains a complex issue for revenue managers. Their goal, ultimately, is to maximize companywide revenue and profits while building strong hotel partner relationships within their marketplace. The emergence of rate optimization has made strides to demystify pricing practices and help revenue managers understand the demand characteristics of their products, understand
Words: 2045 - Pages: 9
18/04/2013 Individual assessment declaration: This assessment item is my own work, except where acknowledged, and is not the result of collaboration with others. Signature / Student ID Date Group assessment declaration: * This work is the result of collaboration amongst all members of the group listed below and no others. All members of the group have contributed to the assessment. Family name Given name Signature/Student ID
Words: 2704 - Pages: 11