Business Data Analysis A Group essay

Download this essay in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from essay:

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).…[continue]

Cite This Essay:

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

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

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

Other Documents Pertaining To This Topic

  • Business Mentoring Is a Critical Job and

    Business Mentoring Mentoring is a critical job and is important for the one providing it as well as the party seeking it. The business parties seeking mentoring are normally those that are beginners and they wish to avoid problems by seeking expert advice. On the other hand the mentor's credibility and business experience is proved when he offers mentoring and advice. Theft and fraud are two most common issues faced by

  • Data Warehouse a Strategic Weapon of an Organization

    Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to

  • Business Ethics Issues a Company s

    On the other hand, applicable laws do have authority and under the concept of moral relativism, it may be justified that any duly passed law be complied with (Svensson & Wood, 2008). One lesson from this case might be that laws between entities in different sovereign nations can be much harder to enforce than laws between entities within the same nation. In the future, Pakistan and other nations might want

  • Business Cycle Analysis Overview From the End

    Business Cycle Analysis Overview- From the end of World War II to the early 1970s, China was relatively isolated from the global landscape. It was a part of the Soviet Communist Bloc, but remained inwardly focused on improving its own infrastructure and economy, all the while poised for rapid modernization. Openness towards the West began around 1978 with increased trade, a small amount of additional transparency internally, and at least the

  • Business Plan for a Multi National Enterprise That

    Business plan for a Multi-National Enterprise that conducts Foreign Direct Investment Description of the MNE Paradise Baby Food Company (PBFC) proposes to invest in a factory in India, one of the countries where Foreign Direct Investment (FDI) is growing at a momentous pace, and from there not only create its unique product but also have access to a growing market that is interested in western products. PBFC intends to develop a complete

  • Business Case Analysis for Diabetes

    Requiring the patient to come to the Clinic or the doctor's office for regular follow-up visits is also an expensive way to ensure compliance. While some office and clinic visits are necessary and desirable, extending the it tools available to at-home diabetes monitoring can extend the expertise of the clinic at a relatively low cost, allowing the Clinic to concentrate its resources on patients who become seriously ill (Eli

  • Data Warehouse a Strategic Weapon of an Organization

    Growth Aided by Data Warehousing Adaptability of data warehousing to changes Using existing data effectively can lead to growth Uses of data warehouses for Public Service Getting investment through data warehouse Using Data Warehouse for Business Information Ongoing changes in Data Warehousing The Origin of Data Warehousing and its current importance Relationship between new operating system and data warehousing Developing Organizations through Data Warehousing Telephone and Data Warehousing Choose your own partner Data Warehousing for Societal Causes Updating inaccessible data Data warehousing for investors Usefulness


Read Full Essay
Copyright 2016 . All Rights Reserved