It provides clear information on what you need to do for this assessment. Importantly it includes the assessment criteria that will be used to mark your task. Please read/use the resources below to support the completion of your assessment task Produce your Final Research Report and Excel Data Analysis. BHP Steel which was later renamed as BlueScope. The corporate headquarters are located at 120 Collins Street, Melbourne. The company has 16,000 personnel. Its largest operating plant, an integrated steelworks, is located at Port Kembla, New South Wales. In October 2011, No.6 Blast furnace, one of two at Port Kembla, was shut down, reducing the plant’s production capacity by 50% after the company decided to exit the export market. Major products include steel slab, hot rolled coil, steel plate, automotive steel, galvanised steel, corrugated galvanised iron, Zincalume brand (55% aluminium, 43.5% zinc, 1.5% silicon) coated steel, and Colorbond brand pre-painted steel (“BlueScope”, 2022). BlueScope produce prefabricated products for the construction industry such as: House Posts Mezzanine Floors Stair Stringers Handrails Portal Frames Beams Screens Bollards Bulustrades Your Task BlueScope want to find efficiencies in their production process to reduce costs. They want to know which products are the main determinants of production costs in order to create cost reduction strategies. You are tasked with finding out: Which products can be used to predict production costs Based on those products, what are the likely production costs for the next 3 months (Oct 2022 – Dec 2022) The IT team have provided you with some sample data in the following spreadsheet: BlueScope-production-data-jun-2018-sep-2022.xlsx Management have asked that you put together a business analytics report so that they can use this design better strategies for controlling production costs. Your report will be structured around parts of the CRISP-DM framework and should follow the recommended report format linked above. Note: This dataset is not real data, nor is it from BlueScope. Any information in this case study is purely for academic purposes and any information about BlueScope included above is in the public domain. Citations BlueScope. (2022, September 22).
