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...
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…
Kudler Fine Foods Case Analysis Kudler Fine Food Case Business Proposal to Enable Greater Innovative Thinking and Contributions Creating greater levels of innovating thinking and contributions throughout the company will lead to a broader base of potential next-generation products to select from, an increase in the number of concepts and ideas to reduce costs, and most importantly, deliver greater value and responsiveness to customers. These and other benefits can be realized when frameworks
break out of war in Afghanistan and Iraq propelled alarming forecasts about its most likely psychiatric effects. The chief of recuperation or readjustment therapy services at the Department of Veterans Affairs (VA) asserted that as high as 30% of soldiers deployed to Iraq may establish posttraumatic tension ailment (PTSD) (Dentzer, 2003), a disorder that can arise following experience of gruesome, dangerous occasions, such as battle, natural catastrophes, and rape.
Obesity Prevention Program: Project Planning Stakeholder identification Childhood obesity-prevention demonstration projects The ANGELO process Socio-cultural contextual analyses Stakeholder engagement Engagement workshops Action plan formulation The Budget Financial Analysis Evaluation methods The Trans-theoretical model The evaluation plan Economic evaluation Obesity prevention is best carried out through community-based arrangements. This paper provides a guide on the setting of priorities, with regard to the prevention of childhood obesity among the culturally and socially diverse populations of Pinole, Laurel Park and Marina Bay. The literature offers a report
Netflix in India Product Product mix Strengths and Weakness of Product Product Life Cycle Management and New Product Development Brand Name, Brand Image and Brand Equity The Augmented Product Price Pricing Objectives Pricing Method Pricing Strategy Discounts and Allowances Price Elasticity and Customer Sensitivity Break Even Analysis at Various Prices India is one of the emerging markets for digital business. It is also a lucrative market for companies dealing in digital content. It is crucial for many digital content companies to have a presence
Behavioral Finance and Analysis of American Financial Crisis Financial theories are the cornerstone of the modern corporate world. They lay the foundation for most tools used in areas like asset pricing and investment banking. Most theoretical concepts like general equilibrium analysis and information economics are planted in the field of microeconomics. There are several different financial theories based on both consumer behavior, as well as how they impact decisions made by
Multiple Levels of Analysis Models for single-level and multi-level research Multiple levels of analysis in organizational research: Advantages and disadvantages to using this approach Given today's increasingly complex organizational structures, equally nuanced levels of organizational research are required to ensure a full and comprehensive portrait of the environment. Different approaches have been created to deal with the need for organizational complexity. Two dominant approaches are that of multilevel and comparative approaches, both of which