INF10003 Introduction to Business Information Systems
13 Pages2535 Words234 Views
Swinburne University of Technology
Business Information System (INF10003)
Added on 2020-03-07
About This Document
INF10003 - This report studies the financial performance of Balogne Pty. Ltd using Microsoft Excel Business Intelligence modelling to explore sales and earnings trends based on which forecasts are made. Based on the data analysis some recommendations on improvements have been made.
INF10003 Introduction to Business Information Systems
Swinburne University of Technology
Business Information System (INF10003)
Added on 2020-03-07
ShareRelated Documents
[Name]Business Information Systems
Business Information SystemsExecutive summaryBalogne Pty. Ltd., a mill and refinery from Mackay, Queensland sells a range of sugarproducts including raw sugar, white sugar, brown sugar, icing sugar, etc., as well as goldensyrup and treacle. This report studies the financial performance of the company usingMicrosoft Excel Business Intelligence modelling to explore sales and earnings trends basedon which forecasts are made. Based on the data analysis some recommendations onimprovements have been made.2
Business Information SystemsTable of ContentsIntroduction................................................................................................................................3Forecast......................................................................................................................................3Earning.......................................................................................................................................5Contemporary issues in technology and business......................................................................51. Knowledge management and business intelligence (BI)....................................................52. Porter’s Five Forces model.................................................................................................83. Security...............................................................................................................................9Conclusions and overall recommendations................................................................................9References................................................................................................................................103
Business Information SystemsIntroductionBalogne Pty. Ltd. Is a mill and refinery from Mackay, Queensland that was founded by aformer Cane Sugar farmer named Louis Hape, a former Cane Sugar farmer? The businessgrew over the years into a multi-million dollar business selling a range of sugar productsincluding raw sugar, white sugar, brown sugar, icing sugar, etc., as well as golden syrup andtreacle. This report is created to study the financial performance of the company for whichMicrosoft Excel modelling has been used and the information on sales trends is presentedwith forecasts based on trends[ CITATION Bil03 \l 16393 ].ForecastEARNINGS FORECAST TABLEPRODUCT TYPE PRODUCT DESCRIPTION2015 $ REVENUE2015 $ COST2015 $ EARNING2016 $ REVENUE2016 $ COST2016 $ EARNING2017 $ REVENUE2017 $ COST2017 $ EARNING3 YEARS EARNING% EARNINGRAWRAW SUGAR1,03,15,500.00$ 67,62,500.00$ 35,53,000.00$ 12,14,313.75$ 7,63,588.29$ 4,50,725.46$ 15,63,428.95$ 9,00,198.62$ 6,63,230.33$ 46,66,955.79$ 17%WHIWHITE SUGAR57,57,500.00$ 37,15,000.00$ 20,42,500.00$ 5,94,125.00$ 3,89,125.03$ 2,04,999.97$ 7,09,434.25$ 4,24,735.81$ 2,84,698.44$ 25,32,198.41$ 9%BROBROWN SUGAR1,26,17,500.00$ 61,70,000.00$ 64,47,500.00$ 11,37,290.00$ 5,57,050.05$ 5,80,239.95$ 8,60,540.45$ 4,04,971.25$ 4,55,569.20$ 74,83,309.15$ 27%ICIICING SUGAR14,17,500.00$ 8,19,500.00$ 5,98,000.00$ 16,17,131.25$ 8,62,418.79$ 7,54,712.47$ 25,21,151.33$ 12,31,124.74$ 12,90,026.58$ 26,42,739.05$ 9%CASCASTER SUGAR28,03,300.00$ 13,37,500.00$ 14,65,800.00$ 26,96,648.50$ 11,97,383.53$ 14,99,264.97$ 24,79,605.91$ 10,27,822.95$ 14,51,782.96$ 44,16,847.94$ 16%CUBSUGAR CUBES14,78,150.00$ 11,48,750.00$ 3,29,400.00$ 21,77,126.25$ 15,32,911.87$ 6,44,214.38$ 34,89,626.35$ 22,34,532.78$ 12,55,093.56$ 22,28,707.95$ 8%GOLGOLDEN SYRUP34,65,000.00$ 30,58,000.00$ 4,07,000.00$ 38,32,059.00$ 30,79,021.14$ 7,53,037.86$ 42,22,255.65$ 31,00,189.43$ 11,22,066.23$ 22,82,104.08$ 8%TRETREACLE23,75,000.00$ 16,56,000.00$ 7,19,000.00$ 16,20,795.00$ 10,53,605.09$ 5,67,189.92$ 14,70,854.22$ 8,87,537.95$ 5,83,316.27$ 18,69,506.19$ 7%The table above shows the forecast of the earnings received by the company against the saleof all its products in 2015. Based on the figures of 2015 and the rate of inflation, the forecastshave been made for the years 2016 and 2017[ CITATION Pet094 \l 16393 ].RAWWHIBROICICASCUBGOLTRE$- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 2015 $ EARNING2016 $ EARNING2017 $ EARNINGProduct TypesDollarsThe graph above shows the earning trend of each product sold by the company over the threeyears 2015, 2016 and 2017. The trend shows that the earnings have slowed down for RawSugar, White Sugar and Brown Sugar, increased for Icing sugar, Sugar Cubes, and Goldensyrup while remained constant for Caster sugar and treacle[ CITATION OLU03 \l 16393 ]. 4
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Business Data Analysis of Balognelg...
|14
|2480
|69