Verified Document

Break Even Analysis And Modeling Essay

Excel Modeling: Sports Feet Manufacturing Planning and Implementing the Model

The first step in this modeling exercise was to plan for the variables that will later be used in the desired calculations. Annual fixed cost ($52,000), unit variable cost ($9), and unit selling price ($25) need to be utilized as inputs for calculations on outputs such as annual revenue, annual total cost, and annual profit / loss (). This data was then placed in a Spreadsheet model for the Profit / Loss analysis. Calculations an outputs used Excel calculations to calculate annual revenue (unit sales*quantity sold), annual variable cost (quantity sold*unit variable cost), annual total cost (annual revenue+annual fixed cost), and annual profit/loss (annual revenue-annual total cost). The model is shown below with the appropriate calculations as well as on the original spreadsheet.

Profit / Loss for Sports Feet Manufacturing

Inputs

Unit Sales Price

$25.00

Annual Fixed Cost

$52,000

Unit Variable Cost

$9.00

Quantity Made and Sold

Caculations and Outputs

Annual Revenue

$62,500.00

Annual Variable Cost

$22,500.00

Annual Fixed Cost

$52,000.00

Annual Total Cost

$74,500

Annual Profit (Loss)

($12,000.00)

Break Even Point

$3,250.00

The next step in the modeling of the Profit / Loss analysis was to repeat the calculation of the outputs, but this time...

Parts of this document are hidden

View Full Document
svg-one

The same Break Even Point was calculated using this feature, showing how it is another viable option for calculating the Break Even Point. The following image is a screen shot of the finished Goal Seek calculation on Excel.
Adding Data Tables

After the original Profit / Loss analysis was conducted, the next step in the Spreadsheet modeling was to add more data tables. Data tables help provide numerous data sets that follow the relationship of the function defined in the first steps. This will help provide a more comprehensive picture of how the company sees profits or losses based on the number of units sold, given the quantitative relationships established through the Break Even analysis. Using Excel, a Data Table was completed to show profit as a function of quantity, which could later be used for graphing purposes. The results of these Data Tables are provided below.

Data Table to Show Profit as Function of Quantity

Sales Quantity

Profit

($12,000.00)

0

-52000

-44000

-36000

-28000

2000

-20000

-12000

-4000

12000

20000

28000

36000

44000

52000

60000

68000

76000

Data Graphing

Finally, the last step of the Spreadsheet modeling process was to plot the data points provided in the Data Table step. Using the outputs calculated by Excel, the Chart Wizard was used to…

Cite this Document:
Copy Bibliography Citation

Related Documents

Healthcare Break Even Analysis Break Even Analysis
Words: 369 Length: 1 Document Type: Essay

Healthcare Break Even Analysis Break Even Analysis BREAKEVEN ANALYSIS VARIABLE COSTS Weekly Groceries Dining Out Gasoline and auto repairs Total FIXED COSTS Rent or Mortgage Phone Repairs & Maintenance Utilities Car Payment Insurance Taxes (Real Estate, Etc.) Other (Specify) Miscellaneous Expenses Total $1,555 BREAKEVEN SALES LEVEL Transition from ICD9 to ICD The transition from ICD9 to ICD10 is definitely a complicated process that must be accomplished with a certain degree of reliability in order to ensure that there is a smooth roll out of ICD10. This process has to be successful by

Break Even Analysis and Planning
Words: 1062 Length: 3 Document Type: Case Study

Costing Case Study The managers at Pringly Division need to make a decision regarding the pricing of a new product. There are two strategies suggested; the first is for the product to be sold at $170, the second strategy is to increase the marketing and increase the price. In both cases, the firm has a requirement that they will make a $4,000,000 profit. In order to assess which is likely

Break Even Planning and Analysis
Words: 1228 Length: 4 Document Type: Case Study

assist the Pringly Division to set up the appropriate pricing for the new product. To achieve this objective, the paper carries out the break-even analysis that will assist the company to fix the appropriate pricing and quantity for the new product. The company had not been able to achieve its sales target in the past making the company to lose some profits. Thus, the company has decided to reduce its

Break Even Point Evaluation
Words: 566 Length: 2 Document Type: Essay

Break Even Point Analysis Using the "Front Lines" case study, various Break Even points can be calculated with the given data provided. In order to calculate these Break Even Points for Total Fixed Costs, Average Net Revenue, and Average Variable Costs, the following equations will need to be used: Break Even TFC= V x (ANR-AVC) Break Even ANR= AVC + (TFC / V) Break Even AVC= ANR-(TFC / V) Exercise Operation Total Average Payment $2,000 Fixed Costs of Overhead $360,000 Fixed Costs

Break Even Analysis and Planning
Words: 898 Length: 3 Document Type: Essay

Flexible Budgeting Flexible Budget Levels (in millions) Competitor Corporate Economic 10% Rate 9% Rate % Rate Revenue Company Operating Stores Licensed Stores CPG, food service, & other Total Revenue Cost of Sales Total Operating Expenses Total Cost Income from equity investees Operating Income Interest Income Interest Expense Earnings Before Tax Income Tax Net Earnings This flexible budget was done for Starbucks Corporation and is an annual budget for the year 2012. Caribou Coffee is one of Starbucks Corporation's largest competitors. Caribou Coffee's annual projected sales growth for 2012 is 10%. (Caribou Coffee Reports Fourth

Pricing, Production, and Break-Even Analysis
Words: 1330 Length: 4 Document Type: Research Paper

Leadership within the movie "We Were Soldiers Once and Young" Perhaps due to the very nature of the United States military, it regularly provides examples for some of the most salient concepts associated with leadership and the roles that supervisors must play while guiding others in an organization. This fact explains why there is a reoccurrence of military themed movies to populate the U.S. filmmaking market -- these films are about

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now