logo

Business Data Analysis of Balogne

14 Pages2480 Words69 Views
   

Added on  2020-04-07

About This Document

Introduction 1 Company’s Overview 2 Knowledge management 2 Purpose of BI 3 Porter’s five forces model 9 Analysis of Supplier power for Balogne 10 Data security in Balogne 10 Internal threat 11 External threats 12 Recommendation for securing data 13 References 13 Introduction In this report, we are going to analyze the financial performance of a company name Balogne. On the basis of these data we will drive the expected data of next year’s 2016 and 2017 in upcoming sections and in excel worksheet. Introduction 1

Business Data Analysis of Balogne

   Added on 2020-04-07

ShareRelated Documents
Executive summaryIn this business report, we are going to represent and analyze the business data of Balogne. The company has many outlets in Australia and dealing with sugar products. We are going to use Excel software for the preparation of charts and pivot tables for micro and macro analytic purpose. We have some resources available in form of case study, the data of previous two years 2014 and 2015. On the basis of these data we will drive the expected data of next year’s 2016 and 2017 in upcoming sections and in excel worksheet. Next we will assume inflation and deflation for the upcoming years and verify the impact of volume sold and overall earning year wise and product wise.Table of ContentsIntroduction...............................................................................................................................................1Company’s Overview.................................................................................................................................2Knowledge management...........................................................................................................................2Purpose of BI..............................................................................................................................................3Porter’s five forces model..........................................................................................................................9Analysis of Supplier power for Balogne...................................................................................................10Data security in Balogne..........................................................................................................................10Internal threat......................................................................................................................................11External threats....................................................................................................................................12Recommendation for securing data.........................................................................................................13References...............................................................................................................................................13IntroductionIn this report, we are going to analyze the financial performance of a company name Balogne.Financial analysis is a crucial part of any business organization from the decision makingperspective and future planning for business. The investors invest money in a company whichhas strong financial background with a handsome turnover. In order to analyze theperformance of any business organization we must need appropriate data and a software toanalyze it. In this report we will use Microsoft Excel for analyzing business data of Balogne. Thisproject report comprises of two parts: Part A is the analytic report and Part B is excelspreadsheet.1
Business Data Analysis of Balogne_1
Company’s OverviewBalogne Pvt. Ltd is a sugar product company situated in Mackay, Queensland. It was foundedin 1965 by Louis Hape. The company is dealing in refinery of sugar products of various types.Company is growing and has a strong financial turnover in the Australia. The company hasrequirement of analyzing the business trends in current scenario, the information ofdistributors and the data for the decision making process. In order to fulfill these requirementsand planning for strategic information we are preparing a report which will focus on all abovekey requirements.Knowledge managementKnowledge management is the systematic arrangement of resources of a company which canbe used to prepare the tactical and strategic planning of organization[ CITATION Bri15 \l 1033 ].Knowledge management has following key factors[ CITATION Mic12 \l 1033 ]:InitiationProcessesStrategic planningStorage systemSharing informationRefinement of knowledgeSustainabilityKnowledge can be categorized as explicit, tactic and implicit. Explicit knowledge which can beseen in tangible form. Implicit knowledge that is not in tangible form but can be convertible inexplicit form. Tactic knowledge which is difficult to express in tangible form. 2
Business Data Analysis of Balogne_2
Knowledge management is beneficial for any business organization because:It enhances the capability of organization to find out the solution of various problemsand meet the business challengesIt is used to understand the complexity of system which has people and the processes,procedures and the most importantly the information system of businessorganization[ CITATION Ste09 \l 1033 ].It improves the knowledge processing capability of business organizationPurpose of BIBusiness intelligence is a term used to represent the application, technology and efforts tocollect data, integrate this data and analyze the information[ CITATION Rob15 \l 1033 ]. The mainpurpose of business intelligence is to provide support in decision making process of anybusiness organization. We can say that it is data based decision support system. This process isvery useful for business forecasting and analyzing the data to support it. There are varioustools available which can be used for BI process. Some of them are: Microsoft Excel,SharePoint, SAP, Dundas BI etc.Analysis of DataAs per the data provided in case study, we have developed a chart as shown in the followingfigure. We have data of 2014 and 2015 of various types of sugar products. The data of year2015 is as:2015Variable cost per UnitFixed Cost(overhead)Sell price per unitVolumesold3
Business Data Analysis of Balogne_3
$1.95$35,000$2.993450000$1.50$40,000$2.352450000$2.50$45,000$5.152450000$1.75$32,000$3.15450000$1.35$28,000$2.89370000$5.35$48,000$7.99185000$7.15$55,000$8.25420000$4.25$41,000$6.25380000On the basis of this data we have calculated the data of year 2016 and 2017 as:2016Variable cost per unitFixed cost(Overhead)Sell price per unitVolumesold$2.05$36,050$3.143933000$1.58$41,200$2.472474500$2.63$46,350$5.412744000$1.84$32,960$3.31495000$1.42$28,840$3.03392200$5.62$49,440$8.39197950$7.51$56,650$8.66470400$4.46$42,230$6.564294002017Variable cost per unitFixed cost(Overhead)Sell price per unitVolume sold$2.11$37,492$3.304798260$1.62$42,848$2.592870420$2.70$48,204$5.682908640$1.89$34,278$3.47608850$1.46$29,994$3.193804344
Business Data Analysis of Balogne_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Tacit Knowledge and Explicit Knowledge
|6
|1377
|259

Prediction of Repurchase 5 - Variables Influencing the Purchase Decision
|15
|2699
|168

Recruitment and Selection Presentation for Lisa Grocery Company
|14
|974
|57

Literature Review on Graduate Employability
|3
|1194
|47

Financial Modeling Course & 3 Models Of Financial Statement
|29
|4909
|192

Accounting Principles Report 2022
|21
|4594
|23