Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Government and Not-for-Profit Accounting Concepts and Practices

Authors: Michael H. Granof, Saleha B. Khumawala, Thad D. Calabrese, Daniel L. Smith

8th edition

1119495814, 1119495857, 1119495819, 9781119495819 , 978-1119495857

More Books

Students also viewed these Accounting questions

Question

What are HTML document tags, and how are they used? AppendixLO1

Answered: 1 week ago

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago

Question

1. What do I want to achieve?

Answered: 1 week ago