The Gorilla Oil Company near Pittsburg transports gasoline to its distributors by truck. The companyrecently contracted to supply gasoline distributors in Kansa, and it has $1,000,000 available to spend on thenecessary expansion of its fleet of gasoline tank trucks. Three models of gasoline tank trucks are available.II.Truck ModelCapacity (gallons)Purchase Cost Monthly Operating CostSuper TankerRegular LineEcono-Tanker5,0003,0002,000$50,000$40,000$25,000$1,000$ 800$ 600The company estimates that the monthly demand for the region will be 500,000 gallons of gasoline.Because of the size and speed differences of the trucks, the number of deliveries or round trips possible permonth for each truck model will vary. Trip capacities are estimated at 10 trips per month for the SuperTanker, 20 trips per month for the Regular Line, and 30 trips per month for the Econo-Tanker. Based onmaintenance and driver availability, the firm does not want to add more than 30 new vehicles to its fleet. Inaddition, the company has decided to purchase at least 10 of the new Econo-Tankers for use on short-run,low-demand routes. If the company wishes to satisfy the gasoline demand with a minimum monthlyoperating expense, how many models of each truck should be purchased. Formulate this problem as a LPmodel. Don't ever try to solve it.

Linear programming is a mathematical technique that is also used in operations management…

Answered: The company estimates that the monthly…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

(Revenue Mgmt) Donut Shop Donna's Delicious Donuts (DDD) produces 380 donuts each morning. There are 3 flavors of glaze Donna coats the donuts with: Regular Glaze, Chocolate Glaze, and Blueberry Glaze. Tommy of Tommy's Terrific Tours (TTT) called Donna and said he wants to bring his tour bus by DDD at 11:00am tomorrow. Normally, DDD has sold out of donuts by 11:00am, but Donna told Tommy she would hold back at least 30% of all donuts made that morning until the tour bus arrived. In addition, she said she would give tour customers a 20% discount off of the regular price. Donna has only enough blueberry glaze on hand to make 90 blueberry glaze donuts.lq 100 The table below shows the prices and maximum demand for the different options. Develop and solve an LP model to maximize revenues for DDD on the day the tour bus arrives. (Include Ranges.) What is her maximized amount of revenues? How many total regular glaze, chocolate glaze, and blueberry glaze donuts will she make? How many regular…
Weekly Average Demand 698 Standard deviation of (weekly) demand 35 Setup cost ($) 1750 Procurement cost ($) 290 Holding cost /unit/week ($) 1 In the provided table, you will find details about the demand and inventory levels of the "Galaxy Explorer" drone, a best-selling product at a department store. The store is open for 42 weeks in a year. The store manager placed an order in the beginning of week 13, and he expects to receive the orders in the beginning of week 15. On average, how many units of "Galaxy Explorer" drone should the store manager expect to sell while waiting for the order to arrive? (Do not round your intermediate calculations. Round your final answers to the nearest whole number. Only enter a number. Do not enter any units
Problem 12-3 (Static) A large bakery buys flour in 25-pound bags. The bakery uses an average of 1,215 bags a year. Preparing an order and receiving a shipment of flour involves a cost of $10 per order. Annual carrying costs are $75 per bag. a. Determine the economic order quantity. (Round your final answer to the nearest whole number.) Economic order quantity b. What is the average number of bags on hand? (Round your final answer to the nearest whole number.) Average number of bags c. How many orders per year will there be? (Round your final answer to the nearest whole number.) Number of orders per year bags d. Compute the total cost of ordering and carrying flour. (Round your final answer to the nearest whole number.) Total cost e. If annual holding costs were to increase by $9 per bag, how much would that affect the minimum total annual cost? (Round your Intermediate calculations to 2 decimal places and final answer to 2 decimal places.) Increase by
1(a). Weekly demand for EPSON printers at a WALMART store is normally distributed with a mean of 280 and a standard deviation of 180. The store manager continuously monitors inventory and currently orders 1,100 printers each time the inventory drops to 700 printers. EPSON currently takes two weeks to fill an order. How much safety inventory should WALMART carry? What is the Cycle Service Level (CSL)? What is the expected shortage per replenishment cycle (ESC)? What is the fill rate (fr)?
1. Safety stock and service levels are positively correlated. True False
Problem 16-16 (Algo) The McDonald's fast-food restaurant on campus sells an average of 7,200 quarter-pound hamburgers each week. Hamburger patties are resupplied twice a week, and on average the store has 795 pounds of hamburger in stock. Assume that the hamburger patties cost $4 a pound and there are 52 weeks in a year. a. What is the Inventory turnover for the hamburger pattles? (Round your answer to 2 decimal places.) Inventory turnover ratio per year b. On average, how many days of supply are on hand? (Do not round Intermediate calculations. Round your answer to 2 decimal places.) Average days of supply
d-Term Exam)_BUS 384 (page 15 of 20) 2316036-SUPPLY CHAIN AND LOGISTICS MANAG Soru 15 Logistics firms or divisions deliver goods from places of lower value to the customer to places where they Cevap are of higher value, which of the following does it provide? kaydedildi 5,00 üzerinden içaretlenmiş Lütfen birini seçin O a Ownership benefit P Soruyu igaretle Ob Structure benefit Oc Space benefit Od Shape benefit O e Time benefit Seçimimi Temızle Onceki sayfa Sonraki sayfa O O ||>
Problem 20-36 (Algo) Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 3,910 mufflers Ordering cost $ 75 per order Standard deviation of daily demand 6 mufflers per working day Service probability 87 % Item cost $ 27.00 per muffler Lead time 2 working days Annual holding cost 36 % of item value Working days 230 per year Review period 18 working days a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level_________________ b. If the…
Problem 16-16 (Algo) The McDonald's fast-food restaurant on campus sells an average of 4,800 quarter-pound hamburgers each week. Hamburger patties are resupplied twice a week, and on average the store has 465 pounds of hamburger in stock. Assume that the hamburger patties cost $3 a pound and there are 52 weeks in a year. a. What is the inventory turnover for the hamburger patties? (Round your answer to 2 decimal places.) Inventory turnover ratio per year b. On average, how many days of supply are on hand? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Average days of supply
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,240 February 4,340 March 4,040 April 4,440 May 5,040 June 4,740 July 5,340 August 4,940 September 5,440 October 5,740 November 6,335 December 6,030 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 4 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
Weekly demand for diesel fuel at a department of parks depot is 250 gallons. The depot operates 52weeks a year. Weekly usage is normal and has a standard deviation of 14 gallons. Holding cost forthe fuel is $1 a month, and it costs $20 in administrative time to submit an order for more fuel. Ittakes one-half week to receive a delivery of diesel fuel. Determine the amount of safety stock thatwould be needed if the manager wantsa. An annual service level of 98 percent. What is the implication of negative safety stock?b. The expected number of units short per order cycle to be no more than five gallons.
Q33 please please help me Next week, Super Discount Airlines has a flight from New York to Los Angeles that will be booked to capacity. The airline knows from history that an average of 36 customers (with a standard deviation of 22) cancel their reservation or do not show for the flight. Revenue from a ticket on the flight is $145. If the flight is overbooked, the airline has a policy of getting the customer on the next available flight and giving the person a free round-trip ticket on a future flight. The cost of this free round-trip ticket averages $240. Super Discount considers the cost of flying the plane from New York to Los Angeles a sunk cost. By how many seats should Super Discount overbook the flight? Note: Use Excel's NORM.S.IN( function to find the z value. Round z value to 2 decimal places. Round your answer to the nearest whole number.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS