Business Data Analysis A Group Assessment

  • Length: 10 pages
  • Sources: 10
  • Subject: Business
  • Type: Assessment
  • Paper: #86787581

Excerpt from Assessment :

The analysis of the scenario involves copying by hand devoid of utilizing excel formulae. The terminology 'What if ' scenarios mainly refer to the underlying base case of the numerical figures in the tables of the financial planning business model. It is significant to undertake checking of the entire changed cells that have altered back to their corresponding original numerical values prior to processing to a new 'What if '.

In order to aid Kitchenware Product in visualizing the underlying table that pertains to figures within the scenario 3,an individual require to draw a graph utilizing Excel's chart depicting the prevailing comparison of the corresponding profits for the diverse sales volumes taking note of the profit peak within year 3 (BARLOW, 2005, pp23-56). In the underlying report that pertains to every scenario's of net profit after tax is adequate. Nevertheless, in case there is complete spreadsheet details are demanded for a scenario, then the underlying Excel's Scenario Manger can then be utilized. When utilizing the Scenario Manger, which is activated through the Tool Scenario command, the corresponding Base Case scenario that ought to included in ensuring that the existing original BASE CASE cell numerical values are correctly restored (BOSLAUGH, 2012, pp202-267). Scenario 2 that entails the decision of selling three percent of the units every year accompanied by the escalation of the current selling price by ten percent every year, which mainly effecting the prevailing net profit after tax every year (Barlow, 2005, pp45-67). The analysis of this scenario mainly entails drawing of the results from the task set within the rows as depicted within the financial planning model. The results table will hold a lasting record of net profit after tax for every circumstance. It mainly entails copying of the underlying net profit-after tax figures from the corresponding worksheet as depicted on the Row 37 into the corresponding row 4. The analysis of the scenario involves copying by hand devoid of utilizing excel formulae. The terminology within the scenarios mainly refers to the underlying base case of the numerical figures in the tables of the financial planning business model (Barlow, 2005, pp45-67). It is significant to undertake checking of the entire changed cells that have altered back to their corresponding original numerical values prior to processing to a new 'What if '.

Similarly, scenario 3 which entails decision of the variation of the anticipated sales volumes over the existing range from the prevailing five percents of sales volumes to the corresponding ten percent within the initial assumption of the Kitchenware Products (BARLOW, 2005, pp23-56). The company demands to realize net profit after tax alteration as predictable sales volumes alteration. The analysis process mainly entails visualizing on the underlying table that pertains to figures within the scenario 3,an individual require to draw a graph utilizing Excel's chart depicting the prevailing comparison of the corresponding profits for the diverse sales volumes taking note of the profit peak within year 3. In the underlying report that pertains to every scenario's of net profit after tax is adequate (Barlow, 2005, pp45-67). Nevertheless, in case there is complete spreadsheet details are demanded for a scenario, then the underlying Excel's Scenario Manger can then be utilized. When utilizing the Scenario Manger, which is activated through the Tool Scenario command, the corresponding Base Case scenario that ought to included in ensuring that the existing original BASE CASE cell numerical values are correctly restored. Scenario 2 that entails the decision of selling three percent of the units every year accompanied by the escalation of the current selling price by ten percent every year, which mainly effecting the prevailing net profit after tax every year. The analysis of this scenario mainly entails drawing of the results from the task set within the rows as depicted within the financial planning model (BOSLAUGH, 2012, pp202-267). The results table will hold a lasting record of net profit after tax for every circumstance. It mainly entails copying of the underlying net profit-after tax figures from the corresponding worksheet as depicted on the Row 37 into the corresponding row 4.

Task 2

(a) the worst and best results obtained in a simulation of 1000 trials;

The determination of the worst accompanied by the best results about simulation purely computation of the likely value of the prevailing bottom-line performance measure and it is known as base-case scenario (BARLOW, 2005, pp33-66). Nevertheless, the underlying scenario grants us with no information concerning how far way the actual product valour from this corresponding anticipation. The solution to this situation entails computation f the prevailing values of the bottom-line performance measure utilizing either base-case or most optimistic accompanied by worst-case or corresponding most pessimistic. The values are normally uncertain input cells. The underlying extra scenarios depict the range of probable values that might to be unspecified through the bottom line presentation measure. In application of 1000 units instruments knowing the underlying range of the plausible results is extremely helpful in examining the risk entailing diverse options (Barlow, 2005, pp45-67). Nevertheless, the best case accompanied by worst-case results depicts nothing concerning distribution of probable values in the stipulated range. It does not depicts the underlying probability of either the scenario occurring. The depiction of numerous probability distributions is normally related with the corresponding numerical value of the underlying bottom-line performance measure within the granted range. Every probability distributions describes the prevailing describes that possess indistinguishable ranges accompanied by similar average numerical values. Nevertheless, every distribution is extremely diverse in terms of the corresponding risk that designates the prevailing decision maker. Moreover, the appeal of the best case accompanied by the worst-case analysis is normally easy to undertake. Its underlying weakness is that it displays nothing concerning the shape of the prevailing distribution related with the existing bottom-line performance apprise (BARLOW, 2005, pp23-56). The shape of the distribution in bottom-line is utilized in measuring performance of the fundamentally significant bottom-line aids in answering the number of the managerial question

Performance of simulation within a spreadsheet entails fist placing of random number generator (RNG) formula in every cell that designates either a random or corresponding uncertain accompanied by independent variable. Every random number generator (RNG) offers a sample observation from an appropriate distribution that depicts underlying range accompanied by frequency of probable numerical values for the variable. Once the corresponding random number generator (RNG) is put in place, the new sample values are produced automatically every time the spreadsheet is recomputed (Barlow, 2005, pp45-67). The recalculate process of the spreadsheet n times, where n designates suitable number of either replications or scenarios, accompanied by numerical value of the bottom-line performance measure will be stored (BOSLAUGH, 2012, pp202-267)

Bibliography

BARLOW, J. (2005). Excel Models for Business and Operations Management. Chichester, John Wiley & Sons. http://public.eblib.com/EBLPublic/PublicView.do?ptiID=241134userid=^u.

Barlow, J., 2005, Excel Models for Business and Operations Management, 2nd Ed. John Wiley & Sons

BOSLAUGH, S. (2012). Statistics in a nutshell. Sebastopol, CA, O'Reilly Media.

Kirca, O., Koksalan, M., 1996, "An Integrated Production and Financial

Laudon, K.C., Laudon, J.P., 2002,"Management Information Systems," 7th Ed. Prentice Hall, New Jersey.

FULLEN, S.L., & BROWN, D.R. (2004).…

Cite This Assessment:

"Business Data Analysis A Group" (2013, April 23) Retrieved February 7, 2017, from
http://www.paperdue.com/essay/business-data-analysis-a-group-90266

"Business Data Analysis A Group" 23 April 2013. Web.7 February. 2017. <
http://www.paperdue.com/essay/business-data-analysis-a-group-90266>

"Business Data Analysis A Group", 23 April 2013, Accessed.7 February. 2017,
http://www.paperdue.com/essay/business-data-analysis-a-group-90266