Topic: Operational Performance Analytics – knitkorp

Group Project:  KnitKorp

Purpose:

The purpose of this project is for you to work in teams, to practice the skills you learned during the course and to demonstrate your knowledge.  The project is to be completed in groups of 4.  Project work will be completed outside of class.

General Instructions:

You have been hired by KnitKorp to create performance measures and reports for their supply chain processes and to create business recommendations.

1. Read the company description.
2. For Part 1 (worth 30 points), submit (in D2L) a written presentation and MS Excelfile based on the requirements below by the end of week 5.
3. For Part 2 (worth 90 points), submit (in D2L) a written presentation and Excel file based on the requirements below by the beginning of week 13.
   13. Present your findings in Week 13. Each group member should have a role in the presentation.  You have 20 minutes to present.
4. Submit (in D2L) the peer evaluation form at the end of the project (worth 20 marks).

 

Company Description:

KnitKorp Inc has been successful at producing and selling knitwear for 10 years in Canada.  Annual sales are now at $41MM and increasing on average 2.3% per year.  KnitKorp is a wholesaler, with a stable customer base of 50 customers across Canada, 5 of which are major sports and department stores.  The target market is 18-45 year olds (men and women) with an interest in sports, outdoor activities and casual fashion.  This market has consistently demonstrated a willingness to spend more for quality products.  The bread and butter product categories are knit hats (including winter, winter sports and sports team embellished goods), mitts/gloves (same), winter scarves (same), socks (esp hiking, winter socks and sport team embellished goods).  The company has recently expanded to knit fashion accessories like scarves, shawls and wraps (light and heavy) as well as knit slippers and house socks.  In addition to finished wearable goods, KnitKorp also produces a small amount of wool yarn for the growing fibre crafts industry, where the customers are boutique style yarn shops.  So far the company has stayed away from knit sweaters and other larger clothing but continues to analyze the market possibilities.

 

In total, the company has around 5000 SKUs.  KnitKorp buys raw wool as well as finished yarn (esp for the sports embellished goods) and processes (by dyeing and spinning) the wool into yarn and further machine knitting the yarn into finished wearable products.  The company has one manufacturing centre in Calgary, a 300 000 sq ft facility in the southeast.  The company delivers the goods to the customers using rail to the east and west and trucks to major centres.  KnitKorp has steady orders throughout the year, with a seasonal spike of shipments in July/August for winter orders as well as a smaller spike in February/March for the start of hiking season.  The orders are usually placed 1 month before shipping, as KnitKorp stocks the yarn and produces finished goods as required.  A small amount of a subset of finished goods (biggest sellers) is available for emergency orders.  KnitKorp is analyzing the possibility of changing this strategy to stock finished goods in order to significantly reduce the lead time to its customers.  This will require a closer relationship with the customer base, that includes sharing of forecasts and planned orders.

 

KnitKorp has limited measurement and reporting capabilities and is looking for a good basis to expand their capabilities.

Part 1: Finished

Part 2: Presentation and Data Work (90 marks)

You have been asked to collect company data and to create a final written presentation based on your analysis of the data and the performance measures and reports you have created.  You will be presenting your work to the KnitKorp executives and you will have 20 min to present.  Make sure to include the following:

Description of Requirements		Marks
1.    Analyze the data in the database.  Identify and describe the types of data (eg master, transactional).Identify and describe data hierarchies and the data relationships. Marks will be given based on relevance, organization and your explanation.		10
2.    Create at least three new summariesof the data.  Marks will be given based on relevance and your explanation of the summaries.		10
3.    Measure and report on each Procurement process using the data provided.  This should include at least one performance measure (slide) for each of the two processes.  Marks will be given for the correct use of formulas and a clear message for the report.		10
4.    Measure and report on each Operations process using the data provided.  This should include at least one performance measure (slide) for each of the two processes.  Marks will be given for the correct use of formulas and a clear message for the report.		10
5.    Measure and report on each Logistics process using the data provided.  This should include at least one performance measure (slide) for each of the two processes.  Marks will be given for the correct use of formulas and a clear message for the report.		10
6.    Create an executive level scorecardsummarizing all performance measures above (feel free to make up targets).  Createone dashboardon one of the six major supply chain processes using the data provided and the measurements that you created.  Marks will also be given for a clear objective/action for the dashboard and scorecard.		10
7.    Create three business recommendations for the company, based on your measurements and reports.  Marks will be given based on the relevance and explanation of the recommendations.		10
8.    Present the data, summaries, measurements, reports, dashboard, scorecard and recommendations in class.  Each group member should have a role in the presentation. a.    Group marks will be given for the written presentation based on a clear message and logical flow of the overall presentation. b.    Individual marks will be given for the effective use of the presentation material.		10   10
Submit:  One PowerPoint presentation and one Excel file required.	Due: April 18, 2021 (if not stated otherwise)

Use the rubric below as a guideline.

 

Part 1 Rubric: Written Presentation and Database

Requirement	Excellent	Good	Fair	Poor	Total
1.    Supply Chain Systems	All required systems are relevant and clearly described.	Most required systems and clearly described, all systems are relevant.	Most required systems and clearly described, some systems are not relevant.	Systems are poorly described or not relevant.	/5
	5 marks	4 marks	3 marks	1-2 marks
2.    Data	All data elements have been described correctly,including data types, issues, hierarchies and relationships.	A few data elements are missing or incorrect or are not described in the presentation.	More than 5 elements are missing or incorrect or are not described in the presentation.	Data is not described well.	/5
	5 marks	4 marks	3 marks	1-2 marks
3.    Summaries	Relevant summaries have been created with a clear explanation and message.	Summaries are relevant but are missing a clear explanation or message.	Summaries are partially relevant and are missing a clear explanation or message	Summaries are irrelevant and are missing explanations and message.	/5
	5 marks	4 marks	3 marks	1-2 marks
4.    Sales Forecast	A sales forecast for each Style for the next 16 weeks has been created.  All forecast elements exist and are reasonable. Data is complete and well-organized.	A sales forecast for each Style for the next 16 weeks has been created.  Most forecast elements exist and are reasonable. Data is mostly complete and well-organized.	A sales forecast for most Styles for the next 16 weeks has been created.  Some forecast elements exist and are reasonable. Data is mostly complete but poorly organized.	Some months for the sales forecast and numerous Styles for the next four months are missing. Few forecast elements exist or are not reasonable. Data is mostly incomplete and poorly organized.	/5
	5 marks	4 marks	3 marks	1-2 marks
5.    Written Presentation	Clear, concise message with a logical flow.  No grammar or spelling errors.  Neat, professional presentation.	Message is clear but may lack detail or have too much detail.  Mostly logical flow.  Minor grammar or spelling errors that do not impede meaning.  Neat, professional presentation.	Message is not always clear. Significantly too long or too short.  Several grammar or spelling errors that impede meaning. Neat, professional presentation.	Message is unclear Rambles with no logical flow or is too short.  Numerous grammar and spelling errors interfere with readability. Presentation is unprofessional.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
Total					30

Part 2 Rubric: Presentation and Database

 

Requirements	Excellent	Good	Fair	Poor	Total
1.    Data	All data elements have been described correctly, including data types, issues, hierarchies and relationships.	A few data elements are missing or incorrect or are not described in the presentation.	More than 5 elements are missing or incorrect or are not described in the presentation.	Data is not described well.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
2.    Summaries	Relevant summaries have been created with a clear explanation and message.	Summaries are relevant but are missing a clear explanation or message.	Summaries are partially relevant and are missing a clear explanation or message	Summaries are irrelevant and are missing explanations and message.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
3.    Procurement Processes	Correct formulas are used in the measurements. Message in the reports is clear and relevant.	Most formulas used in the measurements are correct. Message in the reports is clear and relevant.	Incorrect formulas are used.  Message for the reports is relevant or not clear.	Incorrect formulas are used. Message for the reports is unclear or irrelevant.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
4.    Operations Processes	Correct formulas are used in the measurements. Message in the reports is clear and relevant.	Most formulas used in the measurements are correct. Message in the reports is clear and relevant.	Incorrect formulas are used.  Message for the reports is relevant or not clear.	Incorrect formulas are used. Message for the reports is unclear or irrelevant.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
5.    Logistics Processes	Correct formulas are used in the measurements. Message in the reports is clear and relevant.	Most formulas used in the measurements are correct. Message in the reports is clear and relevant.	Incorrect formulas are used.  Message for the reports is relevant or not clear.	Incorrect formulas are used. Message for the reports is unclear or irrelevant.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
6.    Scorecard and Dashboards	Executive level scorecard and one dashboard using the data provided and the measurements created.  Explanation of objective/actions for the dashboard and scorecard are clear, relevant and well thought out.	Executive level scorecard and one dashboard using the data provided and the measurements created.  Explanation of objective/action are clear and relevant.	Executive level scorecard and one dashboard using the data provided and the measurements created.  Explanation of objective/action are unclear or weak.	Executive level scorecard or dashboard is missing. Objective and explanation for the dashboards and scorecards is missing or irrelevant or appropriate measurements are not used.	/10
7.    Recommendations	Three or more reasonable recommendations with thorough descriptions and solid reasoning based on the data.	Two reasonable recommendations with detailed descriptions and credible reasoning based on the data.	One reasonable recommendation with a clear description and reasoning based on the data.	One recommendation with a description. Reasoning is not fully supported by the data.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
8.    Written Presentation	Message is clearly and thoroughly presented with a logical flow.  Presentation materials adhere to visualization design principles, are professional and easy to read.	Message is presented clearly with only minor flow issues.  Presentation materials mostly adhere to visualization design principles. Sometimes not enough or too much text.	Message is presented but contains several flow issues.  Presentation materials mostly adhere to visualization design principles. Sometimes not enough or too much text.	Message is presented is not clear, flow is not evident.  Presentation materials do not adhere to visualization design principles. Often not enough or too much or irrelevant text.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
9.    Individual Presentation   This is an individual mark.	You have a role in the presentation.  You make excellent use of the presentation material.  You wear appropriate business attire and appear confident and well-rehearsed.	You have a role in the presentation.  You make good use of the presentation material.  You wear appropriate business attire. Some lapses, but overall confident appearance.	You have a role in the presentation.  You make fair use of the presentation material.  You wear appropriate business attire. Appear to have lacked rehearsal.	You do not have a role in the presentation or you do not make good use of the presentation material. You wear appropriate business attire. Numerous lapses and an overall lack of confidence.	/10
	10 marks	7-9 marks	5-6 marks	1-4 marks
Total					90