INF10003 Introduction to Business Information Systems

Added on - Mar 2020

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. 

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 4 of 13 pages
[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 TYPEPRODUCT 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,0002015 $ 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

This report explored the performance data of Balogne Company that sells sugar products in Queensland. It explored the data of 2015 and the inflation figures prevailing to forecast sales and earnings of the company for three years. Based on the analyses, some recommendations have been made for the company. To learn that subscribe to Desklib.com.

Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access