Practical Management Science
5th Edition
ISBN: 9781305734845
Author: WINSTON
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?
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.…
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.…
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
- please answer within 30 minutes.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_forwardHow do you construct and implement the model? What does it look like?arrow_forward
- The 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_forwardCompany 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_forward
- A 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_forwardplease answer in 30 mins and all parts.arrow_forwardA global sourcing manager for Delta Automotive wants to compute the total supply chain costs for automobile parts purchased from three different global suppliers. The data related to the supply chain costs associated with three possible suppliers has been collected in the Microsoft Excel Online file below.The annual demand D is 450,000 units. The supplier prices and transportation costs are predicated on an order quantity of 45,000 units (note that this is not the EOQ.) We may assume that parts are transported from Mexico to the United States by truck, and by a combination of ships and trucks from Japan and China, and 250 working days per year. Open the spreadsheet and perform the required analysis to answer the questions below. Questions 1. What are the total supply chain cost for each of the suppliers? Round your answers to the nearest dollar. Japanese Mexican Chinese Supplier Supplier Supplier Totalarrow_forward
- A global sourcing manager for Delta Automotive wants to compute the total supply chain costs for automobile parts purchased from three different global suppliers. The data related to the supply chain costs associated with three possible suppliers has been collected in the Microsoft Excel Online file below.The annual demand D is 450,000 units. The supplier prices and transportation costs are predicated on an order quantity of 45,000 units (note that this is not the EOQ.) We may assume that parts are transported from Mexico to the United States by truck, and by a combination of ships and trucks from Japan and China, and 250 working days per year. Open the spreadsheet and perform the required analysis to answer the questions below. Questions 1. What are the total supply chain cost for each of the suppliers? Round your answers to the nearest dollar.arrow_forwardEmily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer. Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time. Emily knows that if any section of…arrow_forwardPlease help me solve this problem. Thanks!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