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.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 18P: The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each...

See similar textbooks

Similar questions

The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
Weenies and Buns is a food processing plant which manufactures hot dogs and hot dog buns. They grind their own flour forthe hot dog buns at a maximum rate of 200 pounds per week. Eachhot dog bun requires 0.1 pound of flour. They currently have a contract with Pigland, Inc., which specifies that a delivery of 800pounds of pork product is delivered every Monday. Each hot dogrequires pound of pork product. All the other ingredients in thehot dogs and hot dog buns are in plentiful supply. Finally, the laborforce at Weenies and Buns consists of 5 employees working fulltime (40 hours per week each). Each hot dog requires 3 minutes oflabor, and each hot dog bun requires 2 minutes of labor. Each hotdog yields a profit of $0.80, and each bun yields a profit of $0.30.Weenies and Buns would like to know how many hot dogsand how many hot dog buns they should produce each week so asto achieve the highest possible profit.(a) Formulate a linear programming model for this problem.D,I (b) Use the…
The company produces navels at three plants, which can be delivered directly to the two customersor it can first be shipped to the two warehouses and then to the customers. Shipments between plantsare allowed. This also applies to between warehouses and between customers.The cost of producing the navels is the same at each plant; as a result, the company is only concernedwith minimising the total shipping cost incurred in meeting customer demands. The productioncapacity of each plant (in tons per year) and the customer demand are summarised in the table below: Plant Capacity Plant 1 400 Plant 2 375 Plant 3 350 Customer Demand Customer 1 500 Customer 2 450 The cost (in thousands of dollars) of shipping a ton of the product between each pair of locations islisted in the table below where a blank indicates that the company cannot ship on that route:From node To node Plant 1 Plant…
1. Transshipment ProblemThe Northside and Southside facilities of Zeron Industries supply three firms (Zrox,Hewes, Rockrite) with customized shelving for its offices. They both order shelvingfrom the same two manufacturers, Arnold Manufacturers and Supershelf, Inc. Currently weekly demands by the users are 50 for Zrox, 60 for Hewes, and 40 forRockrite. Both Arnold and Supershelf can supply at most 75 units to its customers.Because of long standing contracts based on past orders, unit costs from themanufacturers to the suppliers are: Zeron N Zeron S Arnold 5 8 Supershelf 7 4The costs to install the shelving at the various locations are: Zrox Hewes Rockrite Zeron N 1 5 8 Zeron S 3 4 4 How should Zeron…
Ascent, Inc. manufactures hiking boots. Demand for boots is highly seasonal. In particular, the demand in the next year is expected to be 3,000, 4,000, 8,000, and 7,000 pairs of boots in quarters 1, 2, 3, and 4, respectively. With its current production facility, the company can produce at most 6,000 pairs of boots in any quarter. Ascent would like to meet all the expected demand, so it will need to carry inventory to meet demand in the later quarters. Each pair of boots sold generates a profit of ₱1,000 per pair. Each pair of boots in inventory at the end of a quarter incurs ₱400 in storage and capital recovery costs. Ascent has 1,000 pairs of boots in inventory at the start of quarter 1. Ascent's top management has given you the assignment of modeling and analyzing what the production schedule should be for the next four quarters. In particular, you are asked to determine how many pairs of boots to produce in each quarter so that you satisfy the demand in each quarter. While doing…
Kellpost Cereal Company sells four products: (1) Special L (a low-calorie, high-nutrition cereal); (2) Corn Bran (another low-calorie, high-nutrition cereal); (3) Admiral Smacks (a sugary cereal pitched at the children's market); and (4) Honey Pops (another sweet cereal pitched at the children's market). Kellpost has sufficient production capacity to produce a total of 10,000 boxes of cereal per month. For each of the past 16 months, Kellpost has kept track of the price and sales of each product. (These data are listed in the file P07_72.xlsx.) Market executives believe that Special L and Corn Bran might be substitutes for each other, as might be Admiral Smacks and Honey Pops. For example, this means that an increase in the price of Special L might raise the sales of Corn Bran. The variable cost of bringing a box of each cereal to market is as follows: Special L, $2.00; Corn Bran, $2.20; Admiral Smacks, $2.30; Honey Pops, $2.40. a. Use the given information to determine the price for…
Kellpost Cereal Company sells four products: (1) Special L (a low-calorie, high-nutrition cereal); (2) Corn Bran (another low-calorie, high-nutrition cereal); (3) Admiral Smacks (a sugary cereal pitched at the children's market); and (4) Honey Pops (another sweet cereal pitched at the children's market). Kellpost has sufficient production capacity to produce a total of 10,000 boxes of cereal per month. For each of the past 16 months, Kellpost has kept track of the price and sales of each product. (These data are listed in the file P07_72.xlsx.) Market executives believe that Special L and Corn Bran might be substitutes for each other, as might be Admiral Smacks and Honey Pops. For example, this means that an increase in the price of Special L might raise the sales of Corn Bran. The variable cost of bringing a box of each cereal to market is as follows: Special L, $2.00; Corn Bran, $2.20; Admiral Smacks, $2.30; Honey Pops, $2.40. a. Use the given information to determine the price for…
Brady Corporation produces cabinets. Each week, itrequires 90,000 cu ft of processed lumber. The companymay obtain lumber in two ways. First, it may purchaselumber from an outside supplier and then dry it in thesupplier’s kiln. Second, it may chop down logs on its ownland, cut them into lumber at its sawmill, and finally dry thelumber in its own kiln. Brady can purchase grade 1 or grade2 lumber. Grade 1 lumber costs $3 per cu ft and when driedyields 0.7 cu ft of useful lumber. Grade 2 lumber costs $7per cubic foot and when dried yields 0.9 cu ft of usefullumber. It costs the company $3 to chop down a log. Afterbeing cut and dried, a log yields 0.8 cu ft of lumber. Bradyincurs costs of $4 per cu ft of lumber dried. It costs $2.50per cu ft of logs sent through the sawmill. Each week, thesawmill can process up to 35,000 cu ft of lumber. Eachweek, up to 40,000 cu ft of grade 1 lumber and up to 60,000cu ft of grade 2 lumber can be purchased. Each week, 40hours of time are available for…
VVH wants to determine the optimal case mix for diagnosis-related groups(DRGs) that will maximize profits. Limited resources (e.g., space, qualified employees) are available to serve patients classified in the various DRGs, and minimum levels of service (number of cases) must be achieved for each DRG. Formulate linear optimization problem. Is non-negativity constraint required in this problem?
The Scottsville Textile Mill produces several different fabrics on eight dobby looms that operate 24 hours per day and are scheduled for 30 days in the coming month. The mill will produce only Fabric 1 and Fabric 2 during the coming month. Each dobby loom can turn out 4.62 yards of either fabric per hour. Assume that there is a monthly demand of 16,000 yards of Fabric 1 and 12,000 yards of Fabric 2. Profits are calculated as 33¢ per yard for each fabric produced on the dobby looms. (a) Will it be possible to satisfy total demand? (b) In the event that total demand is not satisfied, the Scottsville Textile Mill will need to purchase the fabrics from another mill to make up the shortfall. Its profits on resold fabrics ordered from another mill amount to 20¢ per yard for Fabric 1 and 16¢ per yard for Fabric 2. How many yards of each fabric should it produce to maximize profits? (Round your answers to one decimal place. If total demand is satisfied, enter NONE.)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS