4. Tom would like 3 pints of home brew today and an additional 6 pints of home brew tomorrow. Dick is willing to sell a maximum of 5 pints total at a price of $3.00 per pint today and $2.70 per pint tomorrow. Harry is willing to sell a maximum of 4 pints total at a price of $2.90 per pint today and $2.80 per pint tomorrow. Tom wishes to know what his purchases should be to minimize his cost while satisfying his thirst requirements. (a) Formulate a linear programming model for this problem. (max or min Z=..., subject to ... constraints...) (Let x₁ be the amount of pints of brew bought from Dick today, x₂ be the amount of pints of brew bought from Dick tomorrow, x3 be the amount of pints of brew bought from Harry today, x4 be the amount of pints of brew bought from Harry tomorrow.) (b) Formulate this problem as a transportation problem by constructing the appropriate parameter table (in the format as below). Source Demand 1 2 1 Destination 2 3..... supply (c) Draw the network representation of this problem. (d) Use Excel Solver to obtain an optimal solution.

4. Tom would like 3 pints of home brew today and an additional 6 pints of home brew tomorrow. Dick is willing to sell a maximum of 5 pints total at a price of $3.00 per pint today and $2.70 per pint tomorrow. Harry is willing to sell a maximum of 4 pints total at a price of $2.90 per pint today and $2.80 per pint tomorrow. Tom wishes to know what his purchases should be to minimize his cost while satisfying his thirst requirements. (a) Formulate a linear programming model for this problem. (max or min Z=..., subject to ... constraints...) (Let x₁ be the amount of pints of brew bought from Dick today, x₂ be the amount of pints of brew bought from Dick tomorrow, x3 be the amount of pints of brew bought from Harry today, x4 be the amount of pints of brew bought from Harry tomorrow.) (b) Formulate this problem as a transportation problem by constructing the appropriate parameter table (in the format as below). Source Demand 1 2 1 Destination 2 3..... supply (c) Draw the network representation of this problem. (d) Use Excel Solver to obtain an optimal solution.

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?
Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. * a. 75 b. 480 c. 500 d. 20 2. The amount of your product that you will need to produce and sell to cover total costs of production. * a. Break even sales volume b. Sales volume percentage c. Sales volume
22. A purchasing agent for a particular type of silicon wafer used in the production of semiconductors must decide among three sources. Source A will sell the silicon wafers for $2.50 per wafer, independently of the number of wafers ordered. Source B will sell the wafers for $2.40 each but will not consider an order for fewer than 3,000 wafers, and Source C will sell the wafers for $2.30 each but will not accept an order for fewer than 4,000 wafers. Assume an order setup cost of $100 and an annual requirement of 20,000 wafers. Assume a 20 percent annual interest rate for holding cost calculations. a. Which source should be used, and what is the size of the standing order? b. What is the optimal value of the holding and setup costs for wafers when the optimal source is used? c. If the replenishment lead time for wafers is three months, determine the reorder point based on the on-hand level of inventory of wafers.
1. Identify 7 sources of vehicle purchasing information and the type of information available in each source. 2. For all the information available, what specific information about the different makes and models is the most relevant to Samuel and Grace in making their purchasing decision. 3. What is the highest price they can pay on the new vehicle if they can afford a down payment of $4,000?Assume they finance their purchase for 48 months at 7.5%? 4. If they were to lease, what key factors are important in a good lease?
ABC Corporation has determined that his cologne is selling at 300 per bottle with a fixed cost of Php 2,000 and a variable cost of Php100 per unit., EFG has decided to order 40 bottles of the cologne. Will you decide to produce the products based on the number of orders or will you decline the order? Why? Given the situation of ABC Corporation, suppose EFG has decided to order 5 bottles only, would you decide to produce the products? Why? What is the break even point of ABC Corporation before they can decide to produce the units? *
Misu Sheet, owner of the Bedspread Shop, knows his customers will pay no more than $120 for a comforter. Misu wants a 30% markup on selling price. What is the most that Misu can pay for a comforter? Assume Misu Sheet wants a 30% markup on cost instead of on selling price. What is Misu's cost? Round to the nearest cent.
The Company has the oppotunity to introduce a new product. The sales manager believes that the firm could sell 5,000 units per year at 14 per unit for 5 years. The production manager has determined that machinery costing 60,000 and having a 5 year life and no salvage value could be required. The machinery will have an annual fixed cash operating costs of 4,000. Variable cost per unit will be 8. Straight-line depreciation is to be used for both book and tax purposes. The tax rate is 40% and the firm's cost of capital is 14%. What is the Net Present Value of the Investment?
49 The local supermarket buys lettuce each day to ensure really fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $7.00 a box. The lettuce is sold for $18.00 a box and the dealer that sells old lettuce is willing to pay $2.00 a box. Past history says that tomorrow's demand for lettuce averages 255 boxes with a standard deviation of 40 boxes.
The sales manager like to have seasonal prices discounted from the regular sales price. He would like to change all his product prices at the same time whenever the season changes. What is the most efficient way to do this? Create a price list called 'regular sales price list' to list the regular sales prices. Whenever Manager wants to have a seasonal price list, he will use the 'regular sales price list' as the base price list and enter a discount factor. Create a price list for the regular sales price. Create a hierarchy called 'seasonal prices' which will be based on the regular sales price list and will give time-based discounts for the season based on a factor Manager enters. Create a price list which will contain the regular sales prices. Define period and volume discounts for the seasonal prices which will contain both the validity periods for the discounts and a factor to calculate the discounts for all items. Create a price list called 'regular sales price list' to list the…
4. Astore is currently offering a 60% discount on all items purchased. Your cashier is trying to convince you to open a store credit card and says to you, "In addition to the 60% discount you are receiving for purchasing these items on sale today, you will get an additional 20% off for opening a credit card account. That means you are getting 105% off!" %3D a. What is the mistaken assumption here? b. Why is that assumption incorrect? c. If you did truly have 80% discount, explain what should happen when you go to the counter to buy $500 worth of items? show calculation d. If you got your 60% discount and opened up the card for an additional 20%, what is the actual % discount you would receive? show calculation e. Is it better to apply the 60% discount first or the 20% discount first?_show calculation
Hair Zone manufactures a brand of hair-styling gel. It is considering adding a modifiedversion of the product—a foam that provides stronger hold. Hair Zone’s variable costs and prices to wholesalers are: Current Hair Gel New Foam Product Unit selling price 2.00 2.25 Unit variable costs . 85 1.25Hair Zone expects to sell 1 million units of the new styling foam in the first year after introduction, but it expects that 60% of those sales will come from buyers who normally purchase Hair Zone’s styling gel. Hair Zone estimates that it would sell 1.5 million units of the gel if it did not introduce the foam. If the fixed cost of launching the new foam will be $100,000 during the first year, should Hair Zone add the newproduct to its line? Why or why not?
Q4) You are the transportation manager of a manufacturing company producing construction materials and equipment in the UAE. Two main products that your company produces are pumps for concrete, which weigh 25 kg and sell for $1000 each, and isolation bricks, which weigh 0.5 kg and sell for $10 each. Although the isolation bricks are light, they require too much space. Your main customers of both products are located in Europe. To serve your customers in that region, you own and manage a big distribution center (DC in France. Your production plant in the UAE and the DC in France are strategically located with easy access to an airport, harbor, train station and main highways. You are preparing a report to the upper management about the transportation possibilities for these products to your DC in France. Discuss 3 possible transportation modes that you think are convenient to transport these products from your plant to your DC in France. Discuss the general advantages and disadvantages…