Question: I really need help with this assignment. I have no idea where to start and what to do. Please help. Analyst Master An01 Andrea Morris
I really need help with this assignment. I have no idea where to start and what to do. Please help.





Analyst Master
| An01 | Andrea Morris | 403-555-4053 |
| An02 | Catherine Parker | 403-555-5317 |
| An03 | Debra Powell | 403-555-3029 |
| An04 | Doris Hernandez | 403-555-4615 |
| An05 | Ernest Murphy | 403-555-3161 |
| An06 | Jane Turner | 403-555-5345 |
| An07 | Martin Price | 403-555-2000 |
| An08 | Paula Jones | 403-555-1026 |
Buyer Master
| Bu01 | Brett Moss | 403-555-2464 |
| Bu02 | Geraldine Carroll | 403-555-3158 |
| Bu03 | Grant Patterson | 403-555-8884 |
| Bu04 | Jason Schmidt | 403-555-5737 |
| Bu05 | Jennifer Bennett | 403-555-2115 |
| Bu06 | Karla Wilkerson | 403-555-6242 |
| Bu07 | Melanie Hampton | 403-555-1130 |
| Bu08 | Randolph Myers | 403-555-5906 |
Style Master
| Style | CatID | Season | Wool type | Retail |
| winter socks 01 M | 1 | W | Wool 4 | 25.09 |
| winter socks 01 W | 1 | W | Wool 4 | 22.69 |
| winter socks 02 M | 1 | W | Wool 2 | 22.99 |
| winter socks 02 W | 1 | W | Wool 2 | 21.09 |
| winter socks 03 M | 1 | W | Wool 1 | 23.19 |
| winter socks 03 W | 1 | W | Wool 1 | 21.49 |
| winter socks 04 M | 1 | W | Wool 3 | 21.49 |
| winter socks 04 W | 1 | W | Wool 3 | 19.29 |
| winter socks 05 M | 1 | W | Wool 1 | 21.09 |
| winter socks 05 W | 1 | W | Wool 1 | 19.29 |
| winter socks 06 M | 1 | W | Wool 4 | 32.39 |
Style master goes on for many more entries.
Vendor Master
| Vend01 | Standard Wool Inc | Chad Dunn | 403-555-0194 | Red Deer, AB |
| Vend02 | Speciality Wool Ltd | Roman Greene | 250-555-0186 | Vernon, BC |
| Vend03 | Premier Wool Co | Carrie Lawson | 403-555-0131 | Black Diamond, AB |
| Vend04 | Logo Yarns Inc | Marcos Lyons | 519-555-0108 | Orangeville, ON |
Wool Master
| Wool 1 | Rosalee | Vend01 | $0.80 | |
| Wool 2 | Marina | Vend02 | $0.90 | |
| Wool 3 | Florentina | Vend01 | $1.00 | |
| Wool 4 | Jeannetta | Vend03 | $1.10 | |
| Wool 5 | Vivienne | Vend03 | $1.20 | |
| Wool 6 | Logo | Vend04 | $1.30 | Logo Only |
Sales by Style by Week
| SalesYear | SalesWeek | Style | Sales |
| 2020 | 1 | winter hats 02 W | 265 |
| 2020 | 1 | winter hats 03 M | 265 |
| 2020 | 1 | winter hats 03 W | 273 |
| 2020 | 1 | winter hats 04 M | 409 |
| 2020 | 1 | winter hats 04 W | 366 |
| 2020 | 1 | winter hats 05 M | 287 |
| 2020 | 1 | winter hats 05 W | 275 |
| 2020 | 1 | winter hats 06 M | 280 |
| 2020 | 1 | winter hats 06 W | 272 |
| 2020 | 1 | winter mitts 01 M | 416 |
| 2020 | 1 | winter mitts 01 W | 320 |
| 2020 | 1 | winter mitts 02 M | 365 |
| 2020 | 1 | winter mitts 02 W | 431 |
| 2020 | 1 | winter mitts 03 M | 277 |
| 2020 | 1 | winter mitts 03 W | 294 |
| 2020 | 1 | winter mitts 04 M | 335 |
| 2020 | 1 | winter mitts 04 W | 362 |
| 2020 | 1 | winter mitts 05 M | 424 |
sales go on for 25000 plus entries.
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.2% 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 1845 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, shaws 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 300000sq 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. You have been asked to collect company data and to create an initial written presentation based on vour breliminarv analvsis of the data. Make sure to include the followina: 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 20min to
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
