A new company Line is producing a new line of Ski boots and the past sales numbers in dollars are shown in the table below. Sales (in Month dollars) 1 47293 2 59990 3 59343 4 44024 5 43291 6 16300 7 12051 8 3483 9 2475 10 14938 11 26881 12 69145 13 90596 14 121463 15 260497 16 142354 17 141315 18 44242 19 43327 20 15418 21 10343 22 71321 23 171288 24 314840 25 453541 26 510018 27 805696 28 530590 29 516820 30 161634 31 32 182891 43406 Currently, the company is producing 3 different Ski Boots, The SRACE 130 which retails for $40, SRACE 130 RACE which retails for $60 and SRACE 130 CARBON which retails for $80. The company estimates that 40% of sales come from The SRACE 130,35% of SRACE 130 RACE and 25% of SRACE 130 CARBON. The bill of material for every ski boot is presented next: Ski Boot Shell (1) 1 week Strap (3) 1 week Flex (1) 1 week Buckles Footbed (4) (1) 1 week 1 week All the ingredients of the boots are identical except the flex. Buckles costs $1 per unit, Footbed costs $5 per unit, Strap cost $1 each. The Flex for SRACE 130 costs $10 per unit, the Flex for SRACE 130 RACE costs $15 per unit and the one for SRACE 130 CARBON costs $20 per unit. Any production run for any component (the Ski Boot included) is a $100 per run. The company uses a holding cost of 20% per year of the components values. Since the competition is fierce, the company decided to put a penalty cost of a $100 per unit per week on lost sales. For simplicity assume that every month has 20 working days where each day consist of 7 hours of regular time and up to 3 hours of overtime. 100 workers are currently employed at the company where they are paid on a monthly basis 1000$ if they don't work overtime. An overtime hour costs 10$ for the company. Hiring a worker cost 400$ for training and firing a worker costs 3000$ dollars. Every Worker can assemble 2 ski-boots per hour. The company wants to plan its production schedule for the next 2 years. All the parts come from a manufacturing facility nearby. Formulate and describe a plan to minimize the company's cost. Purpose The purpose of the project is for you to apply the knowledge used in this course and formulate a plan to minimize a company's cost. This is a group activity Instructions Please download the Project Instructions document. Read the project carefully and start solving it. You should a submit a report that includes your findings. A new company Line is producing a new line of Ski boots and the past sales numbers in dollars are shown in the table below. Sales (in Month dollars) 1 47293 2 59990 3 59343 4 44024 5 43291 6 16300 7 12051 8 3483 9 2475 10 14938 11 26881 12 69145 13 90596 14 121463 15 260497 16 142354 17 141315 18 44242 19 43327 20 15418 21 10343 22 71321 23 171288 24 314840 25 453541 26 510018 27 805696 28 530590 29 516820 30 161634 31 32 182891 43406 Currently, the company is producing 3 different Ski Boots, The SRACE 130 which retails for $40, SRACE 130 RACE which retails for $60 and SRACE 130 CARBON which retails for $80. The company estimates that 40% of sales come from The SRACE 130,35% of SRACE 130 RACE and 25% of SRACE 130 CARBON. The bill of material for every ski boot is presented next: Ski Boot Shell (1) 1 week Strap (3) 1 week Flex (1) 1 week Buckles Footbed (4) (1) 1 week 1 week All the ingredients of the boots are identical except the flex. Buckles costs $1 per unit, Footbed costs $5 per unit, Strap cost $1 each. The Flex for SRACE 130 costs $10 per unit, the Flex for SRACE 130 RACE costs $15 per unit and the one for SRACE 130 CARBON costs $20 per unit. Any production run for any component (the Ski Boot included) is a $100 per run. The company uses a holding cost of 20% per year of the components values. Since the competition is fierce, the company decided to put a penalty cost of a $100 per unit per week on lost sales. For simplicity assume that every month has 20 working days where each day consist of 7 hours of regular time and up to 3 hours of overtime. 100 workers are currently employed at the company where they are paid on a monthly basis 1000$ if they don't work overtime. An overtime hour costs 10$ for the company. Hiring a worker cost 400$ for training and firing a worker costs 3000$ dollars. Every Worker can assemble 2 ski-boots per hour. The company wants to plan its production schedule for the next 2 years. All the parts come from a manufacturing facility nearby. Formulate and describe a plan to minimize the company's cost. Purpose The purpose of the project is for you to apply the knowledge used in this course and formulate a plan to minimize a company's cost. This is a group activity Instructions Please download the Project Instructions document. Read the project carefully and start solving it. You should a submit a report that includes your findings