7.17. The school board for the Bellevue School District has made the decision to purchase 1,350 additional Macintosh computers for computer laboratories in all its schools. Based on past experience, the school board also has directed that these computers should be purchased from some combination of three companies-Educomp, Macwin, and McElectronics. In all three cases, the companies charge a discounted variable cost per computer and a fixed delivery and installation cost for these large sales to school districts. The next table shows these charges as well as the capacity (the maximum number of computers that can be sold from the limited inventory) for each of the companies. Capacity Fixed cost Variable cost Educomp 700 $45,000 $750 Macwin 700 $35,000 $775 McElectronics 1,000 $50,000 $700 The school board wants to determine the minimum-cost plan for meeting its computer needs. a. Formulate a BIP model in algebraic form for this problem. b. Formulate and solve this model on a spreadsheet. Page 272

7.17. The school board for the Bellevue School District has made the decision to purchase 1,350 additional Macintosh computers for computer laboratories in all its schools. Based on past experience, the school board also has directed that these computers should be purchased from some combination of three companies-Educomp, Macwin, and McElectronics. In all three cases, the companies charge a discounted variable cost per computer and a fixed delivery and installation cost for these large sales to school districts. The next table shows these charges as well as the capacity (the maximum number of computers that can be sold from the limited inventory) for each of the companies. Capacity Fixed cost Variable cost Educomp 700 $45,000 $750 Macwin 700 $35,000 $775 McElectronics 1,000 $50,000 $700 The school board wants to determine the minimum-cost plan for meeting its computer needs. a. Formulate a BIP model in algebraic form for this problem. b. Formulate and solve this model on a spreadsheet. Page 272

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
2. Karen Weber, the purchasing agent for Smith Manufacturing, views the purchase of widgets as a routine buying decision. What factors might lead her to alter this position? More important, what factors determine whether Karen considers a particular supplier, such as Albany Widget?
Which of the following procedures will best detect the theft of valuable items froman inventory that consists of hundreds of different items selling for $1 to $10 and afew items selling for hundreds of dollars?(1) Maintain a perpetual inventory master file of only the more valuable items withfrequent periodic verification of the validity of the perpetuals.(2) Have an independent CPA firm prepare an internal control report on the effectiveness of the administrative and accounting controls over inventory.(3) Have separate warehouse space for the more valuable items with sequentiallynumbered tags.(4) Require an authorized officer’s signature on all requisitions for the more valuableitems.
Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. He was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, “I don’t like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us!” Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him…
Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. He was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, “I don’t like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us!” Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him…
15.________ is financial capacity of an individual to buy what he/she wants. a. Wants. b. Needs. c. None of these options. d. Demands.
37- Inventory management is expensive for the retailer due to ________________________. a. small transactions to small number of customers b. large transactions to a large number of customers c. large transactions to a small number of customers d. small transactions to a large number of customers
1. A hotel tries to reduce the perishability of its services by selling last minute inventory at a highly discounted price. This technique presents threats to a company’s: A. Brand image B: Variability of services C: Relationships with suppliers D: Human resources turnover 2. Sometimes, hotel and airline companies upgrade guests to higher-end services. For such services, there are not a lot of word-of-mouth, reviews, or pictures available. For example, a hotel may upgrade a guest who paid for a regular room to a suite in order for the guest to experience an upscale product that the customer does not purchase often, but may purchase in the future. This situation, where a guest may experience an unfamiliar upscale service for the first time, is likely to result in a __________ in the __________ of services. A: increase, intangibility B: reduction, intangibility C: reduction, variability D: increase, variability 3. In hospitality and travel industries, customers and frontline…
Which approach is most effective in disabling WPS?
5)The set of brand assets, its name and symbol, that add or subtract value to a Firm and/or to that Firm's customer is known as ---------------
Lily used to make customized mugs for her customers. She bought regular mugs, painted designs on them, and then resold them. Recently, she bought a large stock of regular mugs because she could get them at a discount. Keeping her selling price the same, she was able to increase her profits by selling the additional customized mugs. Which factor explains Lily’s increased profits with increased production?