Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need solution in excel solver with pictures thanks. Ali is the new procurement manager of nekopants company that makings pants made with organic fabric
I need solution in excel solver with pictures thanks.
Ali is the new procurement manager of nekopants company that makings pants made with organic fabric and organic dyes. nekoPants purchases 8 different types of fabrics from a group of trusted suppliers to create their unique designs. Ali has been looking at the procurement number recently and believes that their current procurement is not optimized. Help Ali to build a model to minimize the total procurement cost for nekopants using the data provided below. Table 1. Meters of each type of fabric needed by nekoPants (per month). Fabric type Meters required (per month) Fabric 1 475 Fabric 2 235 Fabric 3 321 13 Fabric 4 Fabric 5 67 Fabric 6 15 53 Fabric 7 Fabric 8 25 Table 2. Price per type of fabric per supplier (in Indian Rupees per meter). Fabric type Supplier A Supplier B Supplier c supplier D Supplier E Supplier F Fabric 1 167 154 70 56 a3 85 Fabric 2 63 1196 1170 87 92 109 Fabric 3 93 151 165 73 53 73 Fabric 4 148 136 72 64 164 174 189 1106 1195 125 94 130 Fabric 5 Fabric 6 Fabric 7 1146 77 134 167 67 158 167 123 57 113 166 156 Fabric 8 109 63 1175 124 149 50 Table 3. Supplier capacity (in meters of fabric per month). Capacity Supplier A 500 Supplier B 300 Supplier C 400 Supplier D 600 Supplier E 150 Supplier F 80 Part A: What is the minimum total procurement cost for nekoPants? Ali presented the results from his model to her boss, and she pointed out that there is a set up cost to be paid to a supplier when placing an order. This set up cost should be taken into account. Table 4. Set-up cost per supplier (in Indian Rupees per month). Set-up cost Supplier A 1500 Supplier B 1800 Supplier 800 Supplier D 1200 Supplier E 2000 Supplier 950 | Considering the set-up costs, what is the new minimum total procurement cost for NekoPants? Part C NekoPants tries to be a very sustainable company, therefore they are considering to concentrate their purchases in just three suppliers, in order to reduce CO2 emissions associated with the transportation of components. Suppliers have agreed not to charge the set-up cost if they are selected as one of these three preferred suppliers. Considering that nekoPants will be ordering from just three suppliers (and that constraints from Part A still apply), what is the minimum total procurement cost for nekoPants? Part D Thomas The sustainability manager at NekoPants, has met with Ali. He would like to explore an alternative sustainability policy. He would like Ali to build a model in which all fabrics are bought from local Indian suppliers. Disregard the policy tested in Part C to answer this question. Table 5. Suppliers' location. Location Supplier A india Supplier B india Supplier c Abroad Supplier D India Supplier E india Supplier F Abroad Considering this new requirement (and that only constraints from Part A apply), what is the minimum total procurement cost for NekoPants? Ali is the new procurement manager of nekopants company that makings pants made with organic fabric and organic dyes. nekoPants purchases 8 different types of fabrics from a group of trusted suppliers to create their unique designs. Ali has been looking at the procurement number recently and believes that their current procurement is not optimized. Help Ali to build a model to minimize the total procurement cost for nekopants using the data provided below. Table 1. Meters of each type of fabric needed by nekoPants (per month). Fabric type Meters required (per month) Fabric 1 475 Fabric 2 235 Fabric 3 321 13 Fabric 4 Fabric 5 67 Fabric 6 15 53 Fabric 7 Fabric 8 25 Table 2. Price per type of fabric per supplier (in Indian Rupees per meter). Fabric type Supplier A Supplier B Supplier c supplier D Supplier E Supplier F Fabric 1 167 154 70 56 a3 85 Fabric 2 63 1196 1170 87 92 109 Fabric 3 93 151 165 73 53 73 Fabric 4 148 136 72 64 164 174 189 1106 1195 125 94 130 Fabric 5 Fabric 6 Fabric 7 1146 77 134 167 67 158 167 123 57 113 166 156 Fabric 8 109 63 1175 124 149 50 Table 3. Supplier capacity (in meters of fabric per month). Capacity Supplier A 500 Supplier B 300 Supplier C 400 Supplier D 600 Supplier E 150 Supplier F 80 Part A: What is the minimum total procurement cost for nekoPants? Ali presented the results from his model to her boss, and she pointed out that there is a set up cost to be paid to a supplier when placing an order. This set up cost should be taken into account. Table 4. Set-up cost per supplier (in Indian Rupees per month). Set-up cost Supplier A 1500 Supplier B 1800 Supplier 800 Supplier D 1200 Supplier E 2000 Supplier 950 | Considering the set-up costs, what is the new minimum total procurement cost for NekoPants? Part C NekoPants tries to be a very sustainable company, therefore they are considering to concentrate their purchases in just three suppliers, in order to reduce CO2 emissions associated with the transportation of components. Suppliers have agreed not to charge the set-up cost if they are selected as one of these three preferred suppliers. Considering that nekoPants will be ordering from just three suppliers (and that constraints from Part A still apply), what is the minimum total procurement cost for nekoPants? Part D Thomas The sustainability manager at NekoPants, has met with Ali. He would like to explore an alternative sustainability policy. He would like Ali to build a model in which all fabrics are bought from local Indian suppliers. Disregard the policy tested in Part C to answer this question. Table 5. Suppliers' location. Location Supplier A india Supplier B india Supplier c Abroad Supplier D India Supplier E india Supplier F Abroad Considering this new requirement (and that only constraints from Part A apply), what is the minimum total procurement cost for NekoPantsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started