Consider the transportation table below.REQUIRED:(a) Use the Northwest-Corner Method, the Least-Cost Method and the VAM to get the starting feasible solution.(b) Find the optimal solution by considering the smallest value of the objective function computed in (a). Cost to ship one unit fromfactory 1 to warehouse AA1Factory 23Demand804128B907310CWarehouse B can use90 units per period12070016D16018Supply100200150(450450_Factory 1 can supply100 units per periodTotal supply capacityper periodTotal demandper period

(a) Use the Northwest-Corner Method, the Least-Cost Method and the VAM to get the starting feasible solution. (b) Find the optimal solution by considering the smallest value of the objective function computed in (a).

(a) Use the Northwest-Corner Method, the Least-Cost Method and the VAM to get the starting feasible solution. (b) Find the optimal solution by considering the smallest value of the objective function computed in (a).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

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?
Suppose the utility function for goods x and y is given by U(x,y) = xy + y4.1. Calculate the uncompensated (Marshallian) demand functions for x and y and describe how the demand curves for x and y are shifted by changes in I or the price of the other good.4.2. Calculate the expenditure function for x and y.4.3. Use the expenditure function calculated in (4.2) to compute the compensated demand functions for goods x and y. Describe how the compensated demand curves for x and y are shifted by changes in income or by changes in the price of the other good.4.4. Given money income = 6, px = 2, py = 2, calculate CV, EV, and consumer surplus when px becomes 4.
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
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
Determine the board measure (BF) and the cost 2x4 = $1700 MBM MBM or FBM = Thousand Board Measure or Thousand Board Feet 2 x 6 = $1600 MBM 2x10 = $ 1900 MBM 3/8 OSB = $ 1700 7/16 OSB = $ 1750 All prices are given is per Thousand Square Feet 3/4 OSB = $ 2400 1) 250 pcs of 2x4 …. 10 feet long 2) 300 pcs of 2x6 …. 4 meters long 3) 45 pcs of 2x10 …. 16 foot long
1.The company has three months (April. May and June) for subtracting the units for both NOOR-Company's and AL-SALAM company 2. The company should first satisfy AlNOOR company demand then AL-SALAM company demand. 3. Both production units will work in producing the units 4. Production Unit B will be busy during April 5. The company can work up to 24 hours per day 6. The profit should be at least $1500 Do you think that XYZ-Company should accept or reject the offer?
Dark beer is purchased by the case for $18.90. There are 24 bottles in each case, and each bottle contains 12 fluid ounces. You are making brine that requires 2 ½ quarts of dark beer. How much will the beer cost for the brine?
David Austin recently purchased a chain of dry cleaners innorthern Wisconsin. Although the business is making amodest profit now, David suspects that if he invests in a new press, he could recognize a substantial increase in profits.The new press costs $15,400 to purchase and install and canpress 40 shirts an hour (or 320 per day). David estimatesthat with the new press, it will cost $0.25 to launder andpress each shirt. Customers are charged $1.10 per shirt.a. How many shirts will David have to press to break even?b. So far, David’s workload has varied from 50 to 200shirts a day. How long would it take to break even on the new press at the low-demand estimate? at the high-demand estimate? c. If David cuts his price to $0.99 a shirt, he expects to beable to stabilize his customer base at 250 shirts per day.How long would it take to break even at the reducedprice of $0.99? Should David cut his price and buy thenew press?
You are the owner of Caché, a chain of women's clothing boutiques. Your state has a sales tax of 7%, and your city has an additional sales tax of 1.5%. Each quarter you are responsible for making these tax deposits to the city and state. Last quarter your stores had total revenue, including sales tax, of $488,250. a) How much of this revenue was sales (in $) and how much was sales tax (in $)? sales sales tax b) How much sales tax (in $) should be sent to the city? c)How much sales tax (in $) should be sent to the state?
Fitness Express sells three different types of elliptical machines. They have manufactured 50 of each machine for a special sale. The store already ha orders for 46 of machine A and 16 of machine B. Use the following information to determine how many of machine C the store needs to sell to break even? Show your work on a separate sheet of paper. Manufacturing Cost $105.00 $140.00 $175.00 Elliptical Machine Machine A Machine B Machine C Total costs of all machines: $ Total revenue: $ Number of machine Cs to sell to break even: Retail Cost $250.00 $305.00 $420.00
Adidas is an athletic company designs and manufacturesseveral athletic things. Football is one of the company'sproducts that sells for $40 per unit. Total fixed costs relatedto the manufacturing of the football are $150,000 per monthand variables costs involved in manufacturing are $ 15 per unit. 1-Compute the number of footballs to be sold to earn atarget profit of $30.000.?