MBA5004 Managing Decision Making Process Report 2 Sample

MBA 5004 Managing Decision Making Process Report 2

Management – Report

Task

The organisational decisions you make in relation to this assessment must be made with regards to the following:

1. Reduction of Staff overhead by 30%

2. Increased sales by 20%

3. Improved Staff Morale by 20% on the previous year

4. Improved Customer Experience by 30% on the previous year

5. Retention of Customer Service Staff

6. A merger with another company of similar size

7. Increased occupancy by 15%

8. Other specific targets...

This is an individual assessment and you must choose one of the above targets that relate to your organisation or another organisation of your choice. You need to research all the data that will inform management in such a way that they will have sufficient data and information that they are able to make the decisions appropriately. You also need to analyse the data interpret data and report your findings.. To analyse the data, you need to decide what analysis you should use, how to model it and how to report it. Once you have decided this, you need to build your analysis on MS excel format and create a dashboard that interpret the information with representation of the different visual data summary options for the management decisions. That means you need to take into consideration that if the original data changes, how will this change the final data that you present to your management for decision making. You required to set up the MS Excel dashboard to assist any user to make decisions. You are to provide decision making outcomes for the organization by using these tools and validate the importance of specific analysis and interpretation for the management decisions. Next, add at least 4 recommendations panel that has suggestions for each of the decisions that the management may make including risks and investments, losses of reputation or revenue, etc...

You will be assessed as follows:

a. Structure of the written report: Background information is relevant, issues are logically ordered, recommendations clearly relate to the issues.

b. Identify main issues: Prioritize choices, justify and prioritize issues chosen.

c. Analyse the issues: Each issue is discussed using relevant concepts and principles, insight is shown in analyzing the information.

d. Demo of the recommendations panel: Identify recommendations from the case study, show decisions that you have captured for the recommendations to be put into practice.

e. Write clearly and concisely: Arguments are explicit and succinct, appropriate headings are used, grammar and spelling are accurate.

Solution

Introduction

Excel's information assessment tool can be used by organizations to try to make decisions based on information. In this scenario, will look at BHP's revenue data, which includes information on profit margin, growth, and amortization expense. BHP is a global mining company that focuses on the mining and processing of resources.  As per the MBA Assignment Expert overview, To begin the review, relevant deals data for BHP Organization will be gathered, which may include item marketing projections, deals pay, deals volume, customer socioeconomics, and used deals stations. Using Excel's several options and features, anyone with access to the data can analyse and visualize it. It can make certain groups of data that are crucial to the investigation stand out by organizing and filtering the data. For organizing a lot of data into a table that is easy to understand, PivotTables is a powerful tool. consequently, simplifying it to find models and associations. within the data. Charts and outlines can help people understand how things relate to each other and visualize information. Breaking down BHP Group's income data can help find problems and changes, make better decisions all around, and make a deal more likely.

Selected organization

This study's organization of choice was BHP. BHP is an Australian organization that has done extraordinarily well in the financial year 2022 thanks to powerful cost control and useful creation results. One of the primary factors in selecting this company for this study was the increase in its sales over the past five years. This organization has been picked as the most appropriate association for data analysis and evaluation because of the way that the objective variable in this research is increased sales by 20%. The company is one of the biggest mining companies in the world and has operations in a number of countries, according to the BHP Business Organization's financial report for 2022. Because of its size and level of complexity, an integrating case study would be ideal.

Data Source

The data comes from the official BHP Company website's financial section. The BHP Restricted page's financial section is an excellent information hotspot for dissecting the company's deal sizes (BHP, 2023). The financial section of the BHP Corporation website contains financial publications such as annual reports, intermediate accounts, and investor conferences. A reliable source of information for analysis is these reports, which are frequently provided on an ongoing basis.

Data Analysis

Figure 1: Development of BHP over the most recent 5 years
(Source: Self-Created using Excel)

The data visualization is created in the graph above. Every one of the information of the past 5 years is examined in this undertaking. Every one of the deals-related information is shown according to long periods of deals. In order to analyse BHP Company's development over the past five years, researchers can use Excel data visualization tools to create graphs and tables that show significant developments and trends in information.

Figure 2: BHP sales details in 2021
(Source: Self-Created using Excel)

Additionally, a graph based on the BHP company's data is present. In this section of the study, all of the information is visualized in the year 2021. The trend in sales revenue from year to year is shown using a line chart. The y-axis represents sales income, and the x-axis represents months. This sort of realism is perfect for spotting occasional or year-to-year varieties in deals. Excel allows users to visualize information regarding BHP Company's revenue in 2021 using a variety of graph formats (Susanto, 2021). Prior can use the perceptions it worked in Succeed to dissect BHP The association's deals measurements for the year 2021.

Figure 3: BHP sales details in 2020
(Source: Self-Created using Excel)

The specifics of the sales are examined in this section of the graph. A bar plot is a useful tool for imagining BHP Organization's revenue in 2020. This method can be used to obtain information regarding the organization's deal execution using a Succeed-created bar diagram. To get things started, data on BHP Company's revenue in 2020 must be gathered.

Figure 4: BHP sales details in 2019
(Source: Self-Created using Excel)

It is anticipated that deal income data will be available in 2019. A bar diagram for BHP's sales data in 2020 and a bar plot for BHP's sales data in 2019 can both be created using Excel. Customers can create a bar plot with the help of the Succeed diagramming wizard to gain additional insight into BHP Organization's 2019 deals results. After that, it will select various pieces of information and a gathered diagram with segments as a kind of perception.

Figure 5: BHP sales details in 2018
(Source: Self-Created using Excel)

The BHP Company is visualizing the sales data. All of the sales data is displayed in 2018 After that, it can personalize the chart by adding titles, axis packaging, and a commentary (Mudhar, 2019). The sensor may also be utilized for isolating the compensation produced using plans of different classes of things. For example, one could take a gander at how much cash iron oxide and items connected with fuel make for organizations.

Figure 6: BHP sales details in 2017
(Source: Self-Created using Excel)

The graph above provides a definition for each and every presentation of sales data for the BHP Company. The whole meaning of the 2017 deal benefits can be tracked down in this information.

By breaking down sales information, BHP can make better decisions and improve overall execution. Deals data can be dissected by businesses to discover patterns in customer behaviour and product implementation. This can assist them with changing their advancing and bargains frameworks along these lines (Alam et al., 2020). Moreover, separating bargains information can assist organizations with further developing their exactness estimation, which can be utilized to make creation plans, staffing necessities, and stock levels. Also, taking apart arrangement information can help organizations in improving assessment methodology, perceiving assessment limits, bundling items, and changing costs because of market revenue. Lastly, analysing transaction data can assist BHP in remaining serious in their respective business sectors and provides important insights into business execution.

Figure 7: Correlation Analysis
(Source: Self-Created using Excel)

A statistical method known as relationship examination is used to determine the degree and direction of a connection between two unmistakable factors. Regardless of whether the two variables are mathematically explicit, they should be evaluated on a scale that is either microscopic or ascending.

Figure 8: Analysis of moving average
(Source: Self-Created using Excel)

Moving average analysis is a typical genuine technique for breaking down and assessing Succeeds longitudinal information. It involves averaging a predetermined number of past data points to produce an improved average that can be used to smooth the data and locate patterns (Alam et al., 2020). Excel should arrange the information about the time sequence so that the values for the time frames are in one column and the time frames in another. The number of previous points of information that the mean minus variance calculation will take into account can be determined by specifying the measurement of the window.

Figure 9: Dashboard
(Source: Self-Created using Excel)

All of the previously generated graphs are combined into a single graph in the graph above. As a result, refer to this as the Dashboard of the entire data analysis process.

Findings

Without admittance to the income information for each BHP Organization, making exact inferences is unimaginable. Nevertheless, the following generalizations can be drawn from the BHP company's sales data analysis: The organization's deals design over a more drawn-out timeframe, for example, occasional swings, longer-term drifts, or repeating patterns, might be uncovered by the deal’s patterns study (Pavlenchyk et al., 2021). It can utilize this information to come to informed conclusions about deals methodology and arranging. Revenue performance evaluations in a variety of locations, product lines, and client categories can demonstrate BHP Company's sales performance. This data can be used to find areas that could benefit from growth and development.

Recommendations

Based on the data from the BHP The Business Sales study, here are some possible suggestions. Alter deals procedure to plan for occasional swings, up patterns, or repeating patterns utilizing deals pattern research. For instance, BHP Company might alter pricing or increase promotion during times of high sales activity (Edwards et al., 2023). Making exact determinations without admittance to specific BHP Organization income data is hard. Nevertheless, based on an analysis of BHP, the following are some generalizations that may be drawn. BHP could be found by looking at sales statistics. The company's pattern of long-term sales may include seasonal swinging items, longer-term patterns, or recurrent trends. This data might be utilized to arrive at smart conclusions about deals plans and systems.

Conclusion

Consequently, it is possible to conclude that BHP Company's sales-related data analysis may offer significant insights into the effectiveness of sales, customer behaviour, and other aspects of the company's success. As a result of the review, the company is able to develop well-informed benefits and revenue goals. It can also pinpoint growth potential, improve deal procedures, and identify growth areas. The organization may be able to make important decisions with the assistance of the results of the information analysis, which include deal patterns, income execution, client behaviour, deal figures, and deal efficiency. BHP Organizations might build their general productivity and stay serious inside the business by applying these tips and using the experiences gained through their data analysis. 

Reference List

BHP, (2022). Annual report 2022. Bhp.com. Retrieved from:  https://www.bhp.com/investors/annual-reporting/annual-report-2022 Retrieved on: [15/03/2023]

Mudhar, D. (2019). The meaning of'associate': An analysis of the outcomes of'Commissioner of Taxation v BHP Billiton'(2019). Revenue Law Journal, 26(1), 1-12. Retrieved from: https://rlj.scholasticahq.com/article/12179.pdf Retrieved on [29/04/2023]

Susanto, Y. (2021). SWOT Analysis of Education, Training, and Systems Apparatus Career Development: Study at Regional Financial and Asset Management Agency, Musi Rawas District. Jurnal Bina Praja: Journal of Home Affairs Governance, 13(1), 183-194. Retrieved from: http://jurnal.kemendagri.go.id/index.php/jbp/article/download/789/448  Retrieved on [29/04/2023]

Alam, M. J., Dostie, B., Drechsler, J., & Vilhuber, L. (2020). Applying data synthesis for longitudinal business data across three countries. Statistics in Transition New Series, 21(4), 212-236. Retrieved from: https://sciendo.com/article/10.21307/stattrans-2020-039 Retrieved on [29/04/2023]

Pavlenchyk, N., Horbonos, F., Pavlenchyk, A., Skrynkovskyy, R., & Pawlowski, G. (2021). Increasing the competitiveness of enterprises based on the use of marketing management tools. Agricultural and Resource Economics: International Scientific E-Journal, 7(1868-2021-1455), 77-89. Retrieved from: https://ageconsearch.umn.edu/record/314165/files/5_Pavlenchyk_article.pdf Retrieved on [29/04/2023]