A
Interpretation: Using a preference matrix, the total weighted score for each supplier is to be calculated.
Concept Introduction: Based on the required performance criteria, using the preference matrix, the companies are allowed to choose their best alternative.
B
Interpretation: The suppliers that survived the total score hurdle based on the scores they obtained in the score hurdle.
Concept Introduction: Based on the required performance criteria, using the preference matrix, the companies are allowed to choose their best alternative.
C
Interpretation: The advantages the company can entertain with the proposed new policy, over the current policy.
Concept Introduction: Based on the required performance criteria, using the preference matrix, the companies are allowed to choose their best alternative supplier.
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
OPERATIONS MANAGEMENT CUSTOM ACCESS
- Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 1,100 valves; order cost is $10 per order; and annual inventory holding costs are $7.55 per unit. D D Vendor A Quantity 1-14 15-24 25-99 100-199 200-399 400+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor C Vendor D Vendor A D Vendor B Vendor B Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 MacBook Air O Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00 Nextarrow_forwardPlease provide answers to subparts d to J: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: • Annual demand: 1000 phones • Phone cost: $1,214 each • Phone RRP: $1,349 each • Net weight: 163 g each • Tare weight: 277 g each • Annual inventory holding cost: 15% • Cost per order to replenish inventory: $75 • Annual in-transit holding cost: 10% • Freight rate: $8.10 per kg • Time to process order for freight: 1 days • Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings: d. The total cost for holding the inventory e. The total cost for transportation f. The total cost for holding the phones during transit g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit from this inventory planarrow_forwardOne of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 400,000 parts in one year1. 500,000 in year 2; 700,000 in year 3. shipping and handling of parts from the supplier’s factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.006 per unit. Finally, administrative costs are estimated at $30 per month. Although your plant can continue producing the part, the plant would need to invest in another molding machine, which would cost $20,000. Direct materials can be purchased for $0.06 per unit. Direct labor is estimated at $0.05 per unit plus a 50% surcharge for benefits and, indirect labor is estimated at $0.008 per unit plus 50% benefit. Up-front engineering and design costs will amount to $40,000. Finally, management has insisted that overhead be allocated if the parts are made in-house at a rate of 100%…arrow_forward
- K Horizon Cellular manufactures cell phones for exclusive use in its communication network. Management must select a circuit board supplier for a new phone soon to be introduced to the market. The annual requirements (D) are 50,000 units and Horizon's plant operates 250 days per year. The data for three suppliers are in the following table. Supplier Abbott Baker Carpenter Annual Freight Costs Shipping Quantity (Q) Annual Price/Unit Holding Cost/Unit (P) $31 $30 $29 Using and a shipping quantity of Horizon Cellular of $ (Enter your response as an integer.) 4 10,000 20,000 $12,000 $9,000 $8,000 $5,000 $9,000 $6,000 Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular? (H) $6.20 Lead Time (L) (days) 5 $6.00 $5.80 7 6 Annual Administrative Cost $12,000 $8,000 $9,000 units is the lowest cost alternative, with annual total costs toarrow_forwardChris Sandvig Irrigation, Inc., has summarized theprice list from four potential suppliers of an underground controlvalve. See the accompanying table on the next page. Annual usageis 2,400 valves; order cost is $10 per order; and annual inventory holding costs are $3 .33 per unit.Which vendor should be selected and what order quantity isbest if Sandvig Irrigation wants to minimize total cost?arrow_forwardCompany B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information:• Annual demand: 800 phones• Phone cost: $1,093 each• Phone RRP: $1,249 each• Net weight: 169 g each• Tare weight: 111 g each• Annual inventory holding cost: 25%• Cost per order to replenish inventory: $70• Annual in-transit holding cost: 10%• Freight rate: $8.10 per kg• Time to process order for freight: 1 days• Freight transit time: 2 daysSolve this problem using a non-linear programming (NLP) model to determine the followings:g. The total cost for this inventory planh. The number of ordersi. Ordering pointj. The profit from this inventory plan need answer for g to j along with excel solver solutionarrow_forward
- Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 800 valves; order cost is $7 per order; and annual inventory holding costs are $2.15 per unit. D Vendor A units at a time from Vendor C Vendor B Quantity 1-14 15-24 25-99 100-199 200-399 400+ Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order (enter your response as a whole number). Vendor A Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor D Vendor B Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00arrow_forwardGreat American Inc. (GA), a California based construction company, has been buying wooden floor plate from Davidson Supply (DS) for the last 3 years. Mr. Gordon Shuttle, the GA Purchasing Director, so far, is satisfied with DS services, including product quality and on-time delivery services. Due to the keen competition in the industry in recent year, GA management decided to review DS’s overall supply performance.a) What kinds of challenges that GA should consider? b) If GA decides not to use DS’s supply in future, what will be GA’s otheroptions? c) What kinds of risks GA may face if taking such options?arrow_forwardDefine safety stock and service level? How these two are related to each other?arrow_forward
- Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: • Annual demand: 1000 phones • Phone cost: $1,214 each • Phone RRP: $1,349 each • Net weight: 163 g each • Tare weight: 277 g each • Annual inventory holding cost: 15% • Cost per order to replenish inventory: $75 • Annual in-transit holding cost: 10% • Freight rate: $8.10 per kg • Time to process order for freight: 1 days • Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings:d. The total cost for holding the inventory e. The total cost for transportation f. The total cost for holding the phones during transit g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit from this inventory planarrow_forwardCompany B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: • Annual demand: 1000 phones • Phone cost: $1,214 each • Phone RRP: $1,349 each • Net weight: 163 g each • Tare weight: 277 g each • Annual inventory holding cost: 15% • Cost per order to replenish inventory: $75 • Annual in-transit holding cost: 10% • Freight rate: $8.10 per kg • Time to process order for freight: 1 days • Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings: a. Economic order quantity for the phone in units and in kg b. The total cost for purchasing the phones c. The total cost for ordering d. The total cost for holding the inventory e. The total cost for transportation f. The total cost for holding the phones during transit g. The total cost for this inventory plan…arrow_forwardCompany B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: Annual demand: 1000 phones• Phone cost: $1,214 each• Phone RRP: $1,349 each• Net weight: 163 g each• Tare weight: 277 g each• Annual inventory holding cost: 15%• Cost per order to replenish inventory: $75• Annual in-transit holding cost: 10%• Freight rate: $8.10 per kg• Time to process order for freight: 1 days• Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings:a. Economic order quantity for the phone in units and in kgb. The total cost for purchasing the phonesc. The total cost for orderingd. The total cost for holding the inventorye. The total cost for transportationf. The total cost for holding the phones during transitg. The total cost for this inventory planh. The number of…arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning