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 (maximum number of computers that can be sold from the limited inventory) for each of the companies. Educomp Маcwin McElectronics Capacity 700 700 1,000 Fixed Cost $45,000 $35,000 $50,000 Variable Cost $750 $775 $700 Formulate the model on a spread and solve using Solver, the, give the following: i. Optimum number of computers bought from:

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 (maximum number of computers that can be sold from the limited inventory) for each of the companies. Educomp Маcwin McElectronics Capacity 700 700 1,000 Fixed Cost $45,000 $35,000 $50,000 Variable Cost $750 $775 $700 Formulate the model on a spread and solve using Solver, the, give the following: i. Optimum number of computers bought from:

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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…
Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…
Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…
Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…
Any 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…
Glams Touch is a budding cosmetics family business in Sekondi. The owners, Baaba Benson and Bernard Benson, must ensure that they judiciously use the store space available. They have never kept detailed inventory or sales records. They immediately place new items on the shelves as soon as shipment of goods arrives.Invoices from suppliers are only kept for tax purposes. During sales, they record the items numbers and the total amount received at the cash register. The owners use their own judgment in identifying items that need to be reordered. Baaba and Bernard rely on their own judgment in deciding the cosmetics that need to be restocked.Analyse the business implication of this situation. In your view, how could information systems be utilized to assist the Bensons manage Glams Touch. Enumerate some data that should be captured by the systems and what information outputs are to be churned out from the system.
You need to replace your dryer. Both a big box store and a local appliance dealer are selling a dryer for the same price. Which of the following alternatives has a relevant benefit? A big box store offers free expedited delivery, making its delivery date the same as a local appliance dealer. The price for a dryer from a local appliance dealer includes a repair warranty on the dryer. Both the local appliance dealer and the big box store offer a free haul away service for your old dryer. Both the local appliance dealer and the big box store offer compatible warranty coverage.
As mentioned in the chapter, some analysts predict barcodes maybe replaced by a wireless technology called radio-frequency identification (RFID). RFID is a system of installing tags containing tinycomputer chips on, say, supermarket items. These chips automatically radio the location of the item to a computer network whereinventory data is stored, letting store managers know not onlywhere the item is at all times but also when and where it was madeand its color and size. Proponents believe RFID cuts costs and simplifies inventory tracking and reordering. It may also allow marketersto respond quickly to shifts in demand, avoid under- and overstocking, and reduce spoilage by automatically removing outdated perishables from the shelves. Privacy advocates, however, think thechips provide too much product-preference information that mightbe identified with individual consumers. In the meantime, Walmartrequires its major suppliers to use the new technology on productsstocked by the giant…
The last two weeks of December are usually slow for room sales, but a local Snow and Ice Festival will attract visitors who may request reservations for single overnight accommodations. What policy should the hotel develop for accepting such room reservations
It’s Friday night and your family car has just broken down. You promised your wife that you would take her to her high school reunion about 200 miles away this weekend. The company car assigned to you as a sales manager is parked in the company parking lot, so you’re considering using it for the high school reunion trip. No one at work will know that you used the company car for pleasure since you often pick the car up early on Monday mornings in case you have to accompany any of your salespeople to make sales calls?