Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
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
Priceline.com is an online travel agency for finding discount rates for travel-related purchases such as airline tickets and hotel stays. The company facilitates the provision of travel services from its suppliers to its clients. Priceline's profit from the proceeds is the difference between the price suggested by a customer and the one charged by the service provider. It has also added a more traditional model, called Express Deals, where travelers have presented prices and a geographical perimeter within which the hotel will be located but are not told the name of the establishment.Determine in the above case how priceline.com will benefit most from different social networking platforms and tools?
You are the buyer for a major U.S. health care company. As buyer, your job is to procure and buy parts for the production of X-Ray machines. The buyer from your sister plant in Paris, France has contacted you to supply them with 5 center sections, (a major component used in the X-Ray tube), because they will run out of these parts within 3 days. The center section is procured from a single source supplier in England, weighs approximately 40 pounds, is made of lead and has a 6-week lead time, (the time your supplier requires to manufacture the center section). Based on this criterion, answer the following questions:
What mode of transportation is appropriate for shipping this part to Paris, France?
What carrier will you use?
Which carrier offers the best value?
A company in Wisconsin wants to export cold-pressed lemon oil to Lithuania for human consumption or usage. They have contacted your organization for export assistance.
The lemon oil is inspected and packaged in bottles for human consumption, all in Wisconsin. Each bottle of 4 fl ozs. costs $5.00.
The firm needs the information below to help them evaluate the requirements involved in exporting this product to Lithuania .
In terms of the US' HS Code for a product of this type, it would be best fit the description of essential oils of lemon which is in "Chapter 33 - Essential Oils and Resinoids; Perfumery, Cosmetic or Toilet Preparations." Its Schedule B Number is 3301.13.0000.
1. Presume it is an eligible product for import into Lithuania . Determine the import tariffs and value-added taxes imposed by Lithuania for an imported product of this type.
2. Provide a summary of the import documents required for packaged products for human consumption that the firm should check upon.…
Chapter 6 Solutions
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
- A company in Wisconsin wants to export cold-pressed lemon oil to Lithuania for human consumption or usage. They have contacted your organization for export assistance. The lemon oil is inspected and packaged in bottles for human consumption, all in YOUR STATE. Each bottle of 4 fl ozs. costs $5.00. The firm needs the information below to help them evaluate the requirements involved in exporting this product to Lithuania. In terms of the US' HS Code for a product of this type, it would be best fit the description of essential oils of lemon which is in "Chapter 33 - Essential Oils and Resinoids; Perfumery, Cosmetic or Toilet Preparations." Its Schedule B Number is 3301.13.0000. 1. Presume it is an eligible product for import into Lithuania. Determine the import tariffs and value-added taxes imposed by Lithuania for an imported product of this type. 2. Provide a summary of the import documents required for packaged products for human consumption that the firm should check upon.…arrow_forwardLester Field Insurance (LFI) offers insurance products covering individual and organisational assets. LFI allows individuals and organisations to transfer the risk or chance of loss to the insurance company. For example, LFI accepts the risk or probability of loss through a written contract and agrees to pay out a certain amount of money to restore your valuables. The type of insurance offered includes property insurance, car insurance, travel insurance, household insurance and income protection plan. The company is rated to have one of the lowest rates of fraud claims in the industry. Due to COVID-19, staff had to go on a rotational basis to accommodate social distancing. LFI IT team designed a website that assists customers to log their claims online. This solution has a significant impact on different stakeholders in the organisation. The business problem that LFI is currently facing is that the claims process is too slow. LFI project manager seeks to implement a strategy that…arrow_forwardLester Field Insurance (LFI) offers insurance products covering individual and organisational assets. LFI allows individuals and organisations to transfer the risk or chance of loss to the insurance company. For example, LFI accepts the risk or probability of loss through a written contract and agrees to pay out a certain amount of money to restore your valuables. The type of insurance offered includes property insurance, car insurance, travel insurance, household insurance and income protection plan. The company is rated to have one of the lowest rates of fraud claims in the industry. Due to COVID-19, staff had to go on a rotational basis to accommodate social distancing. LFI IT team designed a website that assists customers to log their claims online. This solution has a significant impact on different stakeholders in the organisation. The business problem that LFI is currently facing is that the claims process is too slow. LFI project manager seeks to implement a strategy that…arrow_forward
- This assignment is about focuses on the marketing areas of services, internet services, and pricing strategies within the context of travel sites. The following web site provides reviews of various travel bidding strategy sites for priceline and hotwire: http://biddingfortravel.yuku.com/ http://www.betterbidding.com/ Basically, priceline.com and hotwire.com are two travel sites that permit patrons to acquire unknown hotels, cars, and airline flights at a known discount price offered by the website. Only after the final purchase (e.g., accepting a website offer for discounted price), does the patron know the specifics of exactly what they have obtained (e.g., the Name of the Hotel). To simplify things, let's focus on hotels for this assignment. The two sites above (better bidding and bidding for travel) provide consumers information regarding how to bid more effectively and expected outcomes within both priceline.com and/or hotwire.com. Please examine all four of these websites…arrow_forwardConsider a fictional price index, the College Student Price Index (CSPI), based on a typical college student’s annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019. The cost of each item in the basket and the total cost of the basket are shown for 2017. Perform these same calculations for 2018 and 2019, and enter the results in the following table. **THE TABLE IS ATTACHED** Suppose the base year for this price index is 2017. In the last row of the table, calculate and enter the value of the CSPI for the remaining years. Between 2017 and 2018, the CSPI increased by_____%. Between 2018 and 2019, the CSPI increased by______%. Which of the following, if true, would illustrate why price indexes such as the CSPI might overstate inflation in the cost of going to college? Check all that apply. A. Energy drinks became increasingly popular on college campuses between…arrow_forwardWillow is habitually late in joining Zoom meetings for her job. Her boss and colleagues are distracted when she joins late and end up repeating information provided earlier in the meeting. Willow’s boss decides to establish a program where everyone who signs in on time for the Zoom meeting will be entered into a drawing for a $20 Starbucks gift card. A name is drawn at the end of the month (i.e., after two meetings). Willow starts joining the Zoom meetings on time. Which type of differential reinforcement is being used? Explain how you know it is the type of DR you identified:arrow_forward
- Suppose that a firm has the option to make or buy a part. Its annual requirement is 11,000 units. A supplier is able to supply the part at $6 per unit. The firm estimates that it costs $800 to prepare the contract with the supplier. To make the part, the firm must invest $29,000 in equipment, and the firm estimates that it costs $3 per unit to make the part. COSTS MAKE OPTION BUY OPTION Fixed Cost $29,000 $800 Variable Cost $3 $6 Annual Requirement = 11,000 units 1. What is the break-even point? Round your answer to the nearest whole number. 2. What is the total cost at the break-even point? Round your answer to the nearest dollar. 3. What is the total cost for the make option? Round your answer to the nearest dollar.arrow_forwardThe Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera B Price: 310). The sales of these products are not independent of each other, but rather if the price of one increase, the sales of the other will increase. In economics, these two camera models are called substitutable products. The store wishes to establish a pricing policy to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model: NA = 196 - 0.5PA + 0.35PB NB = 301 + 0.06PA - 0.6PB Construct a model for the total revenue and implement it on a spreadsheet. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. Vary each price from $250 to $500 in increments of $10. Max profit occurs at Camera A price of $ . Max profit occurs at Camera B price of $ . Check My Work (3 remaining)arrow_forwardAny Company buys and resells a wide range of personal care products. Their ongoing challenges, like many of their competitors include shipping time for purchases, optimizing use of their storage space, and shipping time for sales to their customers. The company’s control over shipping time for purchases is limited. Their choice of suppliers has more impact on shipping time than any encouragement they can offer to those suppliers. Any Company uses multiple warehouses. Some are owned by the company, others are leased. The company uses contract shippers, FedEx/UPS, and the US Postal Service. Your task is to identify at least 4 KPIs you think will be relevant for Any Company to understand and improve their inventory management. Identify the data necessary for your KPIs as specifically as possible. You may use any KPIs we have mentioned in class or from the labs. Feel free to use others or to create your own. Your response does not need to include a description of graphs you might…arrow_forward
- Company A sells networking equipment to large corporations and federal, state, and local governments. Corporate sales are the result of a competitive bidding process, where Company A competes against other companies based on selling price. Sales to the government, however, are determined on a cost plus basis, where the selling price is determined by adding a fixed markup percentage to the total job cost. James Lopez is the cost accountant for the Electronics Division of Company A. The division is under pressure from senior management to improve income from operations. As James reviewed the division's job cost sheets, he realized that he could increase the division's income from operations by moving a portion of the direct labor hours that had been assigned to the job order cost sheets of corporate customers onto the job order costs sheets of government customers. He believed that this would create a “win–win” for the division by (1) reducing the cost of corporate jobs, and (2)…arrow_forwardAdriana Alvarado has decided to purchase a personal computer. She has narrowed the choices to two: Drantex and Confiar. Both brands have the same processing speed, 6.4 gigabytes of hard-disk capacity, two USB ports, and a DVDRW drive, and each comes with the same basic software support package. Both come from mail-order companies with good reputations. The selling price for each is identical. After some review, Adriana discovers that the cost of operating and maintaining Drantex over a 3-year period is estimated to be $300. For Confiar, the operating and maintenance cost is $600. The sales agent for Drantex emphasized the lower operating and maintenance costs. The agent for Confiar, however, emphasized the service reputation of the product and the faster delivery time (Confiar can be purchased and delivered 1 week sooner than Drantex). Based on all the information, Adriana has decided to buy Confiar. What is the total product purchased by Adriana?arrow_forwardA distribution channel for the sale of imported Italian leather shoes includes a manufacturer, a distributor and a retailer. The retailer sells the shoes to his consumers for $127 a pair, earning a margin of 20%. The distributor buys the product directly from the manufacturer for $78. The manufacturer realizes a 59% margin when selling to the distributor. If the retailer must maintain a margin of at least 12% on every pair of shoes sold and believes the retail customer won't pay more than the current retail price, what is the most the retailer would be .willing to pay the distributor for shoes?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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