A hospital needs to purchase 3 gallons of a perishable medicine for use during the current month and 4 gallons for use during the next month. Because the medicine is perishable, it can only be used during the month of purchase. Two companies (Daisy and Laroach) sell the medicine. The medicine is in short supply. Thus, during the next two months, the hospital is limited to buying at most 5 gallons from each company. The companies charge the prices shown in table. a. Formulate a balanced transportation model to minimize the cost of purchasing the needed medicine b. Use Northwest Cormer method to find initial BFS. Identify all basic and non-basic variables Current Month's Next Month's Company Price per Gallon ($) Price per Gallon ($) Daisy 800 720 Laroach 710 750

A hospital needs to purchase 3 gallons of a perishable medicine for use during the current month and 4 gallons for use during the next month. Because the medicine is perishable, it can only be used during the month of purchase. Two companies (Daisy and Laroach) sell the medicine. The medicine is in short supply. Thus, during the next two months, the hospital is limited to buying at most 5 gallons from each company. The companies charge the prices shown in table. a. Formulate a balanced transportation model to minimize the cost of purchasing the needed medicine b. Use Northwest Cormer method to find initial BFS. Identify all basic and non-basic variables Current Month's Next Month's Company Price per Gallon ($) Price per Gallon ($) Daisy 800 720 Laroach 710 750

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

Happy Henry’s car dealer sells an imported car called the EX123. Once everythree months, a shipment of the cars is made to Happy Henry’s. Emergencyshipments can be made between these three-month intervals to resupply the carswhen inventory falls short of demand. The emergency shipments require twoweeks, and buyers are willing to wait this long for the cars, but will generally goelsewhere before the next three-month shipment is due.From experience, it appears that the demand for the EX123 over a three-monthinterval is normally distributed with a mean of 60 and a variance of 36. The cost ofholding an EX123 for one year is $500. Emergency shipments cost $250 per carover and above normal shipping costs.a. How many cars should Happy Henry’s be purchasing every three months?b. Repeat the calculations, assuming that excess demands are back-ordered fromone three-month period to the next. Assume a loss-of-goodwill cost of $100 forcustomers having to wait until the next three-month period and a…
3. Gursoy is selling Christmas trees. She purchases trees for $10 and sells for $25 each. The number of trees she can sell is normally distributed with a mean of 100 and standard deviation of 30. How many trees should Gursoy purchase?
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.
Please do not give solution in image formate thanku. Consider a firm that operates a cannery. All fish brought in by a fleet of fishing boats are processed at the cannery. The firm also has a freezer of unlimited size that stores unprocessed fish. Assume that the freezer is empty in the beginning of the year. There are three seasons. The fleet yields 8400 tons/month during the first third of the year, 11200 tons/month during the middle third, and only 1400 tons/month during the final third. The cannery's processing capacity equals 7000 tons/month. a- What is the inventory level at the end of January? Please give your answer in tons. b - What is the inventory level at the end of February? Please give your answer in tons. c - What is the inventory level at the end of May? Please give your answer in tons. d - What is the average monthly inventory (in tons)? Please keep 4 decimals. e - Calculate the average system throughput rate. Please give your answer in tons/month. f - Determine the…
Torrance Refinery produces approximately 23.1 Million barrels of gasoline per year. A California distributor sources its gasoline from the Torrance refinery. The annual demand for gasoline at the California distributor is 5.3 Million barrels. The cost of storing gasoline is approximately $29 per barrel (per year). The cost of placing an order to the Torrance refinery (including shipping) is $7300 per order. Orders will be received gradually instead of delivered all at once (hence EPQ). At what quantity will the total cost of procurement be the lowest? Round your answer to the nearest whole number. Do NOT include a comma. For example, answer like 103542 and NOT 103,542 Answer: 58845 Check
Irwin’s sells a particular model of fan, with most of the sales being made in thesummer months. Irwin’s makes a one-time purchase of the fans prior to eachsummer season at a cost of $40 each and sells each fan for $60. Any fans unsoldat the end of the summer season are marked down to $29 and sold in a special fallsale. Virtually all marked-down fans are sold. The following is the number of salesof fans during the past 10 summers: 30, 50, 30, 60, 10, 40, 30, 30, 20, 40.a. Estimate the mean and the variance of the demand for fans each summer.b. Assume that the demand for fans each summer follows a normal distribution,with mean and variance given by what you obtained in part (a). Determine theoptimal number of fans for Irwin’s to buy prior to each summer season.c. Based on the observed 10 values of the prior demand, construct an empiricalprobability distribution of summer demand and determine the optimal numberof fans for Irwin’s to buy based on the empirical distribution.d. Based on your…
A purchaser of a $100,000 single-family home for her family refuses to close escrow after making a $10,000 deposit. She is entitled to Group of answer choices $3,000. $7,000. $10,000. nothing
General Motors is trying to determine how frequently they should have tires delivered to their Flint, Michign truck assembly plant. The tires are large and expensive to hold in inventory, and there is also a sgiicant fee each te a tire delivery is made. Which of the following tools would be most useful in making this decision O A/F Ratio Method Newsvendor Model Base Stock Model Economic Order Quantity Model Minimum Cycle Length Model
Each day, QBlitz, a Seattle-based startup, offers a single product through its website.The product is available for order only on one day, and no other products are availableduring that day. To add to this odd selling strategy, QBlitz does not post prices for itsproducts. Instead, for each product there is a reserve price. On the day a product is available, customers can submit bids. All of the bids that exceed the reserve price are told atthe end of the day that they “won” the product and they pay the price they bid. QBlitzthen adds up all of the winning bids and submits an order to a supplier for the neededquantity. If the supplier delivers that quantity, then QBlitz ships the product to the winners once the product is received. However, if the supplier delivers only a portion ofthe ordered quantity, then QBlitz ships the product to the highest bidders that it cansatisfy and notifies the others that they will receive a refund because they will not in factreceive the product. The…
A manufacturer has a production facility that requires 15,604 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 7 days. The unit purchase cost is $25.6 per unit. The cost to place and process an order from the supplier is $121 per order. The unit inventory carrying cost per year is 10.5 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 2,640 units per order, what is the annual holding cost? Use at least 4 decimal places.
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…
is selling Christmas trees. She purchases trees for $10 and sells for $25 each. The number of trees she can sell is normally distributed with a mean of 100 and standard deviation of 30. How many trees should purchase?