Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Paper Companies Group Paper Companies Group has grown through acquisitions from a single mill base to a multinational group. It is now producing 1 million
Paper Companies Group Paper Companies Group has grown through acquisitions from a single mill base to a multinational group. It is now producing 1 million tonnes paper with over 1000 employees. The Paper Companies Group consists four companies: Corp A, B, C and D. Their core values and spirit are the things, which set the companies apart from and will enable to surpass the performance of their competitors. The spirit is to constantly challenge the limit, and strive for victory. The group companies believe they will be victorious when they become and remain the lowest cost, highest efficiency, and most profitable companies in their industry. The organization has acquired paper mills throughout Canada, France and US. Most acquired mills are in operation for over 50 years. The equipment of the mills are aged. They require extensive repair and maintenance to have stabled production. The workforce in the mills are unionized with high manpower cost. The production process for these mills are similar and the paper products follow the same industry standards. This year, the mills have been focusing on maintaining the reliability of the production and reducing the cost. The group has an incentive program based on mill profitability as well as productivity performance. To facilitate the performance monitoring, the management has requested to set up a dashboard to track operation reliability on monthly basis. The results will also be used as part of the incentive calculation. The objective of the dashboard is to monitor all four mills performance. It should include production volume, quality, as well as production efficiency analysis. The planned downtime refers to the loss time that mill has to cease production in order to perform preventative maintenance on certain equipment. The unplanned downtime refers to the time loss when production has to stop because of the unforeseen issues. The OEE is overall equipment efficiency which measures the production based on machine capacity and availability. Requirement: Help the management design a one page Dashboard including at least 5 KPI, which has to include OEE. Your group needs to present the dashboard in class. Each group has 10 minutes. You need to submit your Tableau file and your Excel file for marking. Month Availablety OEE Jan Feb Corp Corp Mar Corp A 95.65 Apr May Corp B 95 Jun Corp C Jul Corp D Aug 89.90 09% 20% 10% 60% 80% 100% Sep 90 Oct Net Time Availability Nov Net OEE 85.34 Dec 85 Production Perfomance Average OEE Year 80 True ACTUAL 76.17 Actual Vs Tageted Availa.. Corp 2022 True Corp A 93.99 Corp A Corp B Corp C Corp D Corp B 92.72 Net Perfomance Corp C 104.61 Production Quality 89.98 104.61 Corp D 89.98 Corp Average Production Quali.. IFalse 100% Year ACTUAL 2021 Manpower Productivity 50% ACTUAL 2022 BUGET 2022 Corp 0% 80 Net Average Good Produce * Manpower Effectiveness .. True 50% 60 Net Employee Productivity 40 -100% 20 150% 0 Corp B Corp C Corp D Corp A Corp B Corp D Corp A Corp C
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started