Purchase Solution

BASE CASE

Not what you're looking for?

Ask Custom Question

Please see attachments.

I have to analyze these for a job-related assignment and am under a time crunch. If I can just get an idea of the graphs and so forth I can build my report better.

The attachment named "Problems" are what needs to be analyzed
The PP is just directions and the Excel sheet is the generic tool

Attachments
Purchase this Solution
Solution Summary

Help to understand the association between revenue and cost is offered.

Solution Preview

Please refer to the attachment.

EXCEL PRICING TOOL INSTRUCTIONS

create a BASE CASE by inserting 5 data points (2 points on the demand curve [Q1-P1; Q2-P2], a price increment, variable cost, and fixed cost) into the appropriate cells of Excel Pricing Tool to perform a "modified" breakeven and price sensitivity analysis to determine an appropriate price for a hypothetical product.

Quantity:
Q1 Price:
P1 Quantity:
Q2 Price:
P2 Price
Increment Variable
Cost Fixed
Cost
11,881.00 $39.00 20,000.00 $6.00 $0.50 $4.00 $80,000.00

The prices in rows 34 - 37 and column F & G (P3 - P6) are not associated with product demand and do not affect spreadsheet calculations. They can be used to understand the association between revenue and cost as depicted on the chart labeled "Modified Breakeven."
Input the data points provided to you by your faculty member into the spreadsheet to perform this assignment.
Section #1:
employ data set and the spreadsheet to determine and discuss the issues in the section.
The incorporation of data set into the spreadsheet represents the hypothetical demand of a brand or firm in the firm's final consumer marketplace.
1. [Base Case]
• Determine an approximate profit maximizing price from spreadsheet.
From the sheet "Revenue and Profit", we find that the maximum profit is $2250 when 8500 units are produced. So the price is $15.50.
• Determine the location (price / quantity point) of the profit maximizing price on the demand curve.
Because the spreadsheet is protected by password and cannot be edited, I cannot show the position on the graph. However, the point (8500, 15.5) can be easily found on the demand curve.
• Determine revenue, variable costs, and total cost ...

Purchase this Solution
Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

View More Free Quizzes
Related BrainMass Solutions

  • Calculate Adjusted Present Value

    APV=base-case NPV - Issuance cost Base-case NPV=0 Issuance cost=15%*net proceeds=15%*(500,000-Issuance cost) So, Issuance cost=65,217 APV=base-case NPV - Issuance cost=0-65,217=-65,217 b. APV=base-case NPV + PV of tax shield=0+76,000=76,000

  • Recursion C++

    A base case is determined.

  • Nominal Versus Real GDP

    4*20) = 15 + 80 = 95 Real GDP = (Base Year Price of Coffee * Current Quantity of Coffee) + (Base Year Price of Milk * Current Quantity of Milk) = (1*10) + (2*20) = 10 + 40 = 50 2003, Case 2: Nominal GDP = (Current Price of Coffee * Current Quantity

  • An Example of Recursion Recursive Function in C++

    Identify the base case. Two base cases: if(u == 0) cout<(static_cast(v) + 1); b. Identify the general case. General case is funcRec(u - 1, v); c.

  • Coefficeint of variation of NPV

    The base case, best case, and worse case scenarios and probabilities are provided in the table below. What is my company's expected NPV, standard deviation of NPV, and coefficient of variation of NPV?

  • factory overhead read, underapplied, direct labor cost,

    (overapplied) factory overhead, Cost-allocation base, budgeted direct-labor cost, Direct labor cost incurred in two differrent case study.

  • Volume of a fish tank

    = 71 x 18 x 4 = 5112 cubic inches Case 3: 5 inch base of sand Height of base (H) = 5 inches Volume of the sand in the fish tank (V) = Length x Width x Height = 71 x 18 x 5 = 6390 cubic inches Case 4: 6 inch base of sand Height

  • CVP Analysis

    Construct the group's base case projected profit and loss statement.

  • Net Present Value Under Base Case and Alternative Case

    596240 Net Present Value Under Base Case and Alternative Case Scenario Analysis: Estimated Cash Flows for the Segway People Mover BaseCase Year0 Year1-12 BicycleScenario Year0 Year1-12 Investment

  • Investment Management

    option- B ANSWER 29 APV = base case NPV - flotation cost = -375 - (500000/94*6) = - $ 32290 Option- B ANSWER 30 APV = base case NPV + interest tax shield = -375 + (500000*11%*30%) PVIFA (7%, 4) = 55514 i.e

View More Related Solutions