Case Analysis Content Cypress Grove Chevre (https://www.cypressgrovecheese.com/)
Case Analysis Content
Cypress Grove Chevre (https://www.cypressgrovecheese.com/) has been producing award-winning goat cheese for over twenty years. The company, located in California, offers more than a dozen varieties of primarily French-style goat-milk cheeses. An important managerial duty is to balance the workloads of the employees on the various jobs required to process the cheese. In order to do this, management needs to analyze the raw labor data to determine the time required for each task so that work is evenly distributed throughout the process and the total time needed to process an order can be predicted. The client has already collected the raw data and now needs you to prepare the data for analysis. The client is interested in the average quantity produced per hour for each task and the range of time per task.
1. By clicking on the question, you will receive one data set with five (5) unique sets of information to analyze. Each data set has five task codes (a02. etc). View the table in the data set and the tasks. Each assigned task code should be analyzed. 2. For each task code do the following:
Develop a set of descriptive statistics (mean, standard deviation, etc.).
Generate one or more charts for each task such as a histogram, scatterplot, or Pareto chart for the data. You are expected to demonstrate competency using all three types of charts in some fashion. See the Labor Data Example.xlsx (attached) .
Write a brief summary for each task with analysis and interpretation.
Provide conclusions or recommendations for each task based upon the data.
3. Use this template (attached) to write your analysis and include the following:
Title page
Brief introduction of the case
Descriptive statistics (such as mean, median, range, standard deviation, and variance) for each task
One or more of the seven quality control tools as needed (e.g., histograms, Pareto charts, etc.) with analysis and interpretation for each task
Conclusions and recommendations for each task
4. Complete the analysis as described. Submit your document.
Question 1
100 Points
Analyze Data Set 4.xlsx (attached)t o determine the time required for each task so that work is evenly distributed throughout the process and the total time needed to process an order can be predicted. The client has already collected the raw data and now needs you to prepare the data for analysis. The client is interested in the average quantity produced per hour for each task and the range of time per task.
For each task code do the following:
Develop a set of descriptive statistics (mean, standard deviation, etc.).
Generate one or more charts for each task such as a histogram, scatterplot, or Pareto chart for the data. You are expected to demonstrate competency using all three types of charts in some fashion.
Write a brief summary for each task with analysis and interpretation.
Provide conclusions or recommendations for each task based upon the data.
Use this template (attached) to write your analysis and include the following:
Title Page
Brief introduction of the case
Descriptive statistics (such as mean, median, range, standard deviation, and variance) for each task
One or more of the seven quality control tools as needed (e.g., histograms, Pareto charts, etc.) with analysis and interpretation for each task
Summary with analysis and interpretation for each task
Conclusions and recommendations
Complete the Case Analysis as described. Submit your completed case as a Word document.
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to are specific needs and instructions
