Question: Refer to the MOLP problem presented in this chapter. The solutions shown in Figures (a), (b), and (c) each result in more than the required

Refer to the MOLP problem presented in this chapter. The solutions shown in Figures (a), (b), and (c) each result in more than the required amount of one or more types of coal being produced, as summarized in the following table.

a. Formulate an LP model that could be solved to find the solution that minimizes the maximum amount of excess coal produced. (Use a MINIMAX objective rather than a MAX( ) function.)
b. Implement your model in a spreadsheet and solve it.
c. What is the optimal solution?
d. Revise your model to find the solution that minimizes the maximum percentage of excess coal produced. What is the optimalsolution?

Figure (a) Solver Parameters V7.0 Set Cell: FD$81 Equal To: Max OMin O Value Of: 0 By Changing Variable Cells: Solve Close Options Model $B$5:$C$5 Subject to the Constraints: Standard LP Simplex Add Variables D$13:$D$15$E$13 $E$15 Reset All Delete Help

Step by Step Solution

★★★★★

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a MIN Q ST 0 12W 4G 48 Q 0 4W 4G 28 Q 0 10W 20G 100 Q WG 0 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

167-B-M-L-M-D-A (242).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Refer to the MOLP example presented in this chapter. a. What weights could be used to generate the solution at X1 = 2.5, X2 = 4.5? b. What weights could be used to generate the solution at X1 = 4.0,...

The confidence intervals presented in this chapter give both lower and upper bounds on plausible values for the population characteristic being estimated. In some instances, only an upper bound or...

Use the data visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following, in your report: 1. Create a scatter chart...

eBook Refer to the MOLP problem presented here. The solutions shown in Figures 7.9, 7.10, and 7.11 each result in more than the required amount of one or more types of coal being produced, as...

Refer to the MOLP problem presented below. Lee is the owner of a Mining Company, which operates two different coal mines in Wythe and Giles counties in Southwest Virginia. Due to increased commercial...

i would just like to see if E. DLH per totes is correct and if not what did i do wrong. i have a feeling my numbers are off, thank you! All information is found in the Company Description and...

get an anwer and solution of problem in both paper 1 full disclousure second revenue recognition IV. Test Questions and Solutions Chapter 1 Multiple Choice 1. What basic financial statements can be...

CHAPTER 3 PROBLEM MANAGEMENT 77 FIGURE 3.2 The CAPRA Problem-Management System CLIENTS Who are the clients (direct and indirect)? ACQUIRING AND ANALYZING INFORMATION IF What is the apparent problem?...

Instructions_Smithville_ShortVersion_18e (Read-Only) - Microsoft Word X Home Insert N Page Layout References S Mailings Review View Add Text Ury Insert Endnote M R WI PDE Y1 Foxit Reader PDF Foxit PD...

Tree, Inc. has held a 10percent interest in the stock of Limb Company for several years. Because of the level of ownership, this investment has been accounted for using the fair-value method. At the...

Select an appropriate piece of equipment and calculation method to complete these calculations: Calculate the simple interest amounts by completing the following table: Principal Interest rate...

17. The Business Cycle Dating Committee of the National Bureau of Economic Research would most likely classify which one of the following as a recession? (LO3) a) A one-tenth of 1 percent decline in...

In the short-run the Phillips curve is vertical, implying that the rate of unemployment is independent of the rate of infl ation.TRUE OR FALSE

This chapter followed the convention of using negative numbers to represent the supply at a node and positive numbers to represent the demand at a node. Another convention is just the oppositeusing...

Consider the revised Coal Bank Hollow recycling problem discussed in section 5.5.4 of this chapter. We said that it is safest to assume the supply in a generalized network flow problem is capable of...

Consider the generalized transportation problem shown in Figure. How can this problem be transformed into an equivalent transportation problem? Draw the network for the equivalentproblem. 500 $10 $12...

I need help on question C and D The following frequency histogram presents the final grades of a random sample of 100 college studen 183 15 - 12 - Frequency LO 63 66 69 72 90 93 96 Final Grade Score...

The mean clotting time of blood is 7.45 seconds with a standard deviation of 3.6 seconds. What is the probability that an individual's clotting time will be less than 3 seconds or greater than 8...

15. A share of common stock has just paid a dividend of $2.00. If the expected long-run growth rate for this stock is 15 percent, and if investors require a 19 percent rate of return, what is the...