(Please provide an excel file)

Company Background

Juice-Perfect, a California-based juice manufacturing company, has 6 manufacturing plants around

the US that produce various sizes and flavor of juices and smoothies. In recent years, management

noticed that Juice-Perfect’s market share has been decreasing due to its inability to sustain the

level of expectations and market demands. A group of internal analysts conducted a thorough

investigation of the root causes of the performance decline and published a report that identified

problems in the production planning of Juice-Perfect’s manufacturing operations as the critical

factors.

In response, leadership at the company decided to contract a team to help identify improvement

areas in the production planning and propose a plan to reform the manufacturing processes across

all plants. Management has decided to pilot the changes on the packaging lines only at one of the

plants (that is the worst performing plant).

• Using internal performance metrics (Appendix A), Juice-Perfect want to identify the worst

performing plant in their network. Hence, analyse this data and identify the worst

performing plant.

• With an aim to boost the day-to-day operations of this plant, analyse the data in Appendix

B to enable Juice-Perfect to uncover specific problems faced within the plant’s

filling/packaging line and recommend improvement strategies that they would be able to

implement nationwide.

APPENDIX:

A. Yearly Performance Overview

B. Inventory Delays

EXPECTED OUTPUT

• A maximum of 20 minutes presentation detailing the comprehensive and systematic analysis of

the case study.

• Slides for the presentation must be detailed and informative. Additionally, excel files used in

the data analysis should be submitted.

• The presentation should highlight the details of the following but not limited to: an

introduction to the analyses, the aims and objectives, the analytical methodology employed,

results and analysis, recommendations and practical implications, conclusions