17. A company runs three oil refineries, R1, R2, and R3. Each R; produces heating oil (HO), diesel oil (DO), and gasoline (G). Suppose that for one barrel of crude oil each refinery produces the number of gallons of heating oil, diesel oil, and gasoline shown in the table below. The monthly demand for each product is given in thousands of barrels in the table as well. R1 R2 R3 Demand но 20 5 15 525 DO 10 3 8 278 G 10 10 10 430 Let x, be the number of barrels (in thousands) of crude oil processed by refinery R; (i=1,2,3) per month, find the number of barrels needed to meet the demand.

17. A company runs three oil refineries, R1, R2, and R3. Each R; produces heating oil (HO), diesel oil (DO), and gasoline (G). Suppose that for one barrel of crude oil each refinery produces the number of gallons of heating oil, diesel oil, and gasoline shown in the table below. The monthly demand for each product is given in thousands of barrels in the table as well. R1 R2 R3 Demand но 20 5 15 525 DO 10 3 8 278 G 10 10 10 430 Let x, be the number of barrels (in thousands) of crude oil processed by refinery R; (i=1,2,3) per month, find the number of barrels needed to meet the demand.

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

I need solution of 2.34 as possible as please
14. Toyco produces a line of Bonnie dolls and accessories at its plants in New York and Baltimore that must be shipped to distribution centers in Chicago and Los Angeles. The company uses Air Freight, Ic., to make its shipments. Suppose that it can ship directly or through Pittsburgh and Denver. The daily production rates at the plants are respectively 5,000 and 7,000 units daily, and the demands at the dis- tribution centers are respectively 3,500 and 8,500 units daily. The costs of shipping 1,000 units are given in the following table. Find the optimal shipping routes and the associated cost. то Pittsburgh Denver Chicago Los Angeles $182 77 F New York Baltimore $375 290 275 $285 245 125 $460 575 380 R Pittsburgh M Denver 90 110
1 ton of material 1 ton of material 2, and 11/13 3 10 The Kashif Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of ton of material 1 and 3 ton of material 3. A ton of solvent base is a mixture of // Kashif's production is constrained by a limited availability of the three raw materials. For the current production period, Kashif has the following quantities of each raw material: material 1, 20 tons; material 2, 5 tons; material 3, 21 tons. Management wants to achieve the following P, priority level goals. Goal 1: Produce at least 30 tons of fuel additive. Goal 2: Produce at least 15 tons of solvent base. Assume there are no other goals. (a) Is it possible for management to achieve both P₁ level goals given the constraints on the amounts of each material available? If not, which constraint is the limiting factor? O Yes. It is possible to satisfy both P₁ level goals. O No. There is an insufficient…
7. Maribel is considering installing ice cream stalls on Turtle Beach. The length of the beach is 5 miles long. On average, in a week, there are 1,000 subathers that come to the beach and each value an icecream at $5. Transportation costs are $2.5. Each icecream costs $0.5 to make and there are $40 as a fixed maintenance cost per stall. A )Find the optimal number of stalls for Maribel? B) What is the profit at optimal number of stalls?
Problem 13-3 Determining the Time Value of Money [LO13-1] Complete the following table. Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D. Note: Use appropriate factor(s) from the tables provided. Round time value factors to 3 decimal pla nearest whole number. Annual Deposit Rate of Number of Return Years Investment Value at the End of Time Period Total Amount of Investment $ 3,000 4 % 9 $ 3,000 8% 9 $ 3,000 4 % 18 $ 3,000 8% 18 Total Amount of Interest or Earnings
E4 The Handy Manufacturing Company manufactures small air conditioner compressors. The estimated demand for the year is 140,000 units. The setup cost for the production process is $200 per run, and the carrying cost is $10.00 per unit per year. The daily production rate is 100 units per day, and demand has been 50 units per day. Determine (a) the number of units to produce in each batch. (The problem assumes 240 operating days.) and (b) the ordering cost
A local manufacturer of Toys produces several toys. Among the most popular is Elsa Doll. Suppose that there are currently 100 Elsa Doll in inventory and that there are customer orders that have been committed and must be filled. Suppose that a production lot size of 150 Elsa Dolls. The weekly forecasts for the eight weeks are 176, 172, 50, 130, 40, 120, 132, and 135 respectively. The customer orders for weeks 1, 2, 3 through 8 are the 88, 86, 25, 65,20, 51, 0, 0 respectively. Using the standard principles of Master Production Schedule (MPS) along with Available-To-Promise (ATP) for the Elsa Dolls, what is the Available to promise (ATP) level in week 2 Select one: O a. 150 b. 79 O c. 39 O d. 0 Oe. None is correct Next page
4
10/Do not solve it in excel , please.