EBK PRACTICAL MANAGEMENT SCIENCE
5th Edition
ISBN: 9780100655065
Author: ALBRIGHT
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 6, Problem 93P
This problem is based on Motorola’s online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply:
- There is an administrative cost of $5000 associated with setting up a supplier’s account. For example, if Motorola uses three suppliers, it incurs an administrative cost of $15,000.
- To ensure reliability, no supplier can supply more than 80% of Motorola’s demand for any product.
- A supplier must supply an integer amount of each product it supplies.
Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Intuition is both an emotional experience and a nonconscious analytic process. One problem, however, is that not all emotions signaling that there is a problem or opportunity represent intuition. Please in your Personal opinion how we would know if our “gut feelings” are intuition or not, and if not intuition, suggest what might be causing them.
A coworker suggests that the company where you both work would be much more effective if there were no organizational politics. Please in your personal and detailed opinion, What would you say to this person in reply?
What is a bottleneck?
Would you try to reduce a bottleneck? Why or why not?
Please provide a reference
Chapter 6 Solutions
EBK PRACTICAL MANAGEMENT SCIENCE
Ch. 6.3 - Prob. 1PCh. 6.3 - Prob. 2PCh. 6.3 - Solve Problem 1 with the extra assumption that the...Ch. 6.3 - Prob. 4PCh. 6.3 - Prob. 5PCh. 6.3 - Prob. 6PCh. 6.3 - Prob. 7PCh. 6.3 - Prob. 8PCh. 6.3 - Prob. 9PCh. 6.3 - Prob. 10P
Ch. 6.4 - Prob. 11PCh. 6.4 - Prob. 12PCh. 6.4 - Prob. 13PCh. 6.4 - Prob. 14PCh. 6.4 - Prob. 15PCh. 6.4 - Prob. 16PCh. 6.4 - Prob. 17PCh. 6.4 - Prob. 18PCh. 6.4 - Prob. 19PCh. 6.4 - Prob. 20PCh. 6.4 - Prob. 21PCh. 6.4 - Prob. 22PCh. 6.4 - Prob. 23PCh. 6.5 - Prob. 24PCh. 6.5 - Prob. 25PCh. 6.5 - Prob. 26PCh. 6.5 - Prob. 28PCh. 6.5 - Prob. 29PCh. 6.5 - Prob. 30PCh. 6.5 - In the optimal solution to the Green Grass...Ch. 6.5 - Prob. 32PCh. 6.5 - Prob. 33PCh. 6.5 - Prob. 34PCh. 6.5 - Prob. 35PCh. 6.6 - Prob. 36PCh. 6.6 - Prob. 37PCh. 6.6 - Prob. 38PCh. 6 - Prob. 39PCh. 6 - Prob. 40PCh. 6 - Prob. 41PCh. 6 - Prob. 42PCh. 6 - Prob. 43PCh. 6 - Prob. 44PCh. 6 - Prob. 45PCh. 6 - Prob. 46PCh. 6 - Prob. 47PCh. 6 - Prob. 48PCh. 6 - Prob. 49PCh. 6 - Prob. 50PCh. 6 - Prob. 51PCh. 6 - Prob. 52PCh. 6 - Prob. 53PCh. 6 - Prob. 54PCh. 6 - Prob. 55PCh. 6 - Prob. 56PCh. 6 - Prob. 57PCh. 6 - Prob. 58PCh. 6 - Prob. 59PCh. 6 - Prob. 60PCh. 6 - Prob. 61PCh. 6 - Prob. 62PCh. 6 - Prob. 63PCh. 6 - Prob. 64PCh. 6 - Prob. 65PCh. 6 - Prob. 66PCh. 6 - Prob. 67PCh. 6 - Prob. 68PCh. 6 - Prob. 69PCh. 6 - Prob. 70PCh. 6 - Prob. 71PCh. 6 - Prob. 72PCh. 6 - Prob. 73PCh. 6 - Prob. 74PCh. 6 - Prob. 75PCh. 6 - Prob. 76PCh. 6 - Prob. 77PCh. 6 - Prob. 78PCh. 6 - Prob. 79PCh. 6 - Prob. 80PCh. 6 - Prob. 81PCh. 6 - Prob. 82PCh. 6 - Prob. 83PCh. 6 - Prob. 84PCh. 6 - Prob. 85PCh. 6 - Prob. 86PCh. 6 - Prob. 87PCh. 6 - Prob. 88PCh. 6 - Prob. 89PCh. 6 - Prob. 90PCh. 6 - Prob. 91PCh. 6 - Prob. 92PCh. 6 - This problem is based on Motorolas online method...Ch. 6 - Prob. 94PCh. 6 - Prob. 95PCh. 6 - Prob. 96PCh. 6 - Prob. 97PCh. 6 - Prob. 98PCh. 6 - Prob. 99PCh. 6 - Prob. 100PCh. 6 - Prob. 1CCh. 6 - Prob. 2CCh. 6 - Prob. 3.1CCh. 6 - Prob. 3.2CCh. 6 - Prob. 3.3CCh. 6 - Prob. 3.4CCh. 6 - Prob. 3.5CCh. 6 - Prob. 3.6C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Your firm has been the auditor of Caribild Products, a listed company, for a number of years. The engagement partner has asked you to describe the matters you would consider when planning the audit for the year ended 31January 2022. During recent visit to the company you obtained the following information: (a) The management accounts for the 10 months to 30 November 2021 show a revenue of $260 million and profit before tax of $8 million. Assume sales and profits accrue evenly throughout the year. In the year ended 31 January 2021 Caribild Products had sales of $220 million and profit before tax of $16 million. (b) The company installed a new computerised inventory control system which has operated from 1 June 2021. As the inventory control system records inventory movements and current inventory quantities, the company is proposing: (i) To use the inventory quantities on the computer to value the inventory at the year-end (ii) Not to carry out an inventory count at the year-end (c)…arrow_forwardDevelop and implement a complex and scientific project for an organisation of your choice. please include report include the following: Introduction Background research to the project The 5 basic phases in the project management process Project Initiation Project Planning Project Execution Project Monitoring and Controlling Project Closing Conclusionarrow_forwardNot use ai pleasearrow_forward
- Sam's Pet Hotel operates 51 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.00 per bag. The following information is available about these bags: > Demand 95 bags/week > Order cost $52.00/order > Annual holding cost = 25 percent of cost > Desired cycle-service level = 80 percent >Lead time 4 weeks (24 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 95 bags is incorrect and actual demand averages only 75 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $ higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forwardSam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.50 per bag. The following information is available about these bags: > Demand = 95 bags/week > Order cost = $55.00/order > Annual holding cost = 35 percent of cost > Desired cycle-service level = 80 percent > Lead time = 4 weeks (24 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 95 bags is incorrect and actual demand averages only 75 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $ 10.64 higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) b. Suppose that actual demand is 75 bags but that ordering costs are cut to only $13.00 by using the internet to automate order placing. However, the buyer does…arrow_forwardBUS-660 Topic 4: Intege... W Midterm Exam - BUS-66... webassign.net b Answered: The binding c... × W Topic 4 Assignment - BU... how to get more chegg... b My Questions | bartleby + macbook screenshot - G... C Consider the following m... As discussed in Section 8.3, the Markowitz model uses the variance of the portfolio as the measure of risk. However, variance includes deviations both below and above the mean return. Semivariance includes only deviations below the mean and is considered by many to be a better measure of risk. (a) Develop a model that minimizes semivariance for the Hauck Financial data given in the file HauckData with a required return of 10%. Assume that the five planning scenarios in the Hauck Financial Services model are equally likely to occur. Hint: Modify model (8.10)-(8.19). Define a variable d for each 5 - scenario and let d≥ Ŕ – R¸ with d¸ ≥ 0. Then make the objective function: Min 1 5 Σας Let Min s.t. 15 FS = proportion of portfolio invested in the foreign…arrow_forward
- On a daily basis, the van is dispatched from Maplewood Hospital to pickup blood and platelet donations made at its local donation centers. The distances in miles between all locations may be found in the table below. Click the icon to view mileage data for Vampire Van. a. The van travels from the Hospital (A) to (B) to (C) to (D) to (E) and then returns to the Hospital (A). What is the total number of miles that the van must travel using this route? Route ABCDEA requires a total distance of miles. (Enter your response rounded to one decimal place.) More Info Maplewood City Center Westbrook Hospital (A) Donation Site (B) Donation Site (C) Municipal Park Donation Site (D) Valley Hills Donation Site (E) Maplewood 3.1 5.3 3.2 4.4 Hospital (A) City Center 3.1 6.7 2.2 4.3 Donation Site (B) Westbrook 5.3 Donation Site (C) 19 6.7 | 6.2 2.5 Municipal Park 3.2 2.2 6.2 | 4.6 Donation Site (D) Valley Hills 4.4 4.3 2.5 4.6 Donation Site (E) - ☑arrow_forwardThe Harvey Motorcycle Company produces three models: the Tiger, a sure-footed dirt bike; the LX2000, a nimble cafe racer; and the Golden, a large interstate tourer. The month's master production schedule calls for the production of 32 Goldens, 31 LX2000s, and 38 Tigers per 10-hour shift. What average cycle time is required for the assembly line to achieve the production quota in 10 hours? 0.099 hours per motorcycle. (Enter your response rounded to three decimal places.) If mixed-model scheduling is used, how many of each model will be produced before the production cycle is repeated? The greatest common divisor of the production requirements is Therefore, the Harvey Motorcycle Company will produce Goldens, LX2000s, and Tigers. (Enter your responses as integers.)arrow_forwardThe Harvey Motorcycle Company produces three models: the Tiger, a sure-footed dirt bike; the LX2000, a nimble cafe racer; and the Golden, a large interstate tourer. The month's master production schedule calls for the production of 32 Goldens, 31 LX2000s, and 38 Tigers per 10-hour shift. What average cycle time is required for the assembly line to achieve the production quota in 10 hours? hours per motorcycle. (Enter your response rounded to three decimal places.)arrow_forward
- The binding constraints for this problem are the second and third constraints are binding. Min x1 + 2x2 s.t. x1 + x2 ≤ 300 2x1 + x2 ≥ 400 2x1 + 5x2 ≥750 X1, X220 (a) Keeping the second objective function coefficient fixed at 2, over what range can the first objective function coefficient vary before there is a change in the optimal solution point? The first objective coefficient can from a low of to a high of (b) Keeping the first objective function coefficient fixed at 1, over what range can the second objective function coefficient vary before there is a change in the optimal solution point? The second objective coefficient can from a low of to a high of (c) If the objective function becomes Min 1.5x₁ + 2x2, what will be the optimal values of x1 and x2? x1 = X2 = What is the value of the objective function at the minimum? (d) If the objective function becomes Min 7x₁ + 6x2, what constraints will be binding? (Select all that apply.) First Constraint Second Constraint Third Constraint…arrow_forward[-16.66 Points] DETAILS MY NOTES CAMMIMS16 4.E.008. 0/1 Submissions Used A linear programming computer package is needed. ASK YOUR TEACHER PRACTICE ANOTHER The Clark County Sheriff's Department schedules police officers for 8-hour shifts. The beginning times for the shifts are 8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m. An officer beginning a shift at one of these times works for the next 8 hours. During normal weekday operations, the number of officers needed varies depending on the time of day. The department staffing guidelines require the following minimum number of officers on duty: Time of Day 8:00 A.M. Noon Noon - 4:00 P.M. Minimum Officers Time of Day on Duty 4 7 4:00 P.M. - 8:00 P.M. 11 8:00 P.M. Midnight 6 Midnight 4:00 A.M. 4:00 A.M. -8:00 A.M. 3 7 Determine the number of police officers that should be scheduled to begin the 8-hour shifts at each of the six times (8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m.) to minimize the total number…arrow_forwarddiscuss in detail the benefits of working in a teamarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License