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.

I really need help with this assignment. I have no idea whereto start and what to do. Please help. Analyst Master An01 AndreaMorris 403-555-4053 An02 Catherine Parker 403-555-5317 An03 Debra Powell 403-555-3029 An04 DorisHernandez 403-555-4615 An05 Ernest Murphy 403-555-3161 An06 Jane Turner 403-555-5345 An07 MartinPrice 403-555-2000 An08 Paula Jones 403-555-1026 Buyer Master Bu01 Brett Moss 403-555-2464

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!