Question

In: Economics

USING EXCEL!! FOR BOTH PROBLEMS SCREEN SHOTS OF WORK PLEASE 19. Write the following primal problem...

USING EXCEL!! FOR BOTH PROBLEMS SCREEN SHOTS OF WORK PLEASE

19. Write the following primal problem in canonical form, and find its dual. Max 3x1+1x2+5x3+3x4 s.t. 3x1+1x2+2x3 = 30 2x1+1x2+3x3+1x4 >= 15 2x2+3x4<= 25 x1,x2,x3,x4 >= 0 20. Photo Chemicals produces two types of photograph-developing fluids at a cost of $1.00 per gallon. Let x1 = gallons of product 1 x2 = gallons of product 2 Photo Chemicals management requires that at least 30 gallons of product 1 and at least 20 gallons of product 2 be produced. They also require that at least 80 pounds of a perishable raw material be used in production. A linear programming formulation of the problem is as follows: Min 1x1 + 1x2 s.t. 1x1 >= 30 Minimum product 1 1x2 >= 20 Minimum product 2 1x1 + 2x2 >= 80 Minimum raw material x1, x2 >= 0 a. Write the dual problem. b. Solve the dual problem. Use the dual solution to show that the optimal production plan is x1 = 30 and x2 = 25. c. The third constraint involves a management request that the current 80 pounds of a perishable raw material be used. However, after learning that the optimal solution calls for an excess production of five units of product 2, management is reconsidering the raw material requirement. Specifically, you have been asked to identify the cost effect if this constraint is relaxed. Use the dual variable to indicate the change in the cost if only 79 pounds of raw material have to be used.

Solutions

Expert Solution

1.This is very simple programmed is R which can be seen is forgure 4.The first line override any last explainations of the variable lo1,making for the new situation explaintion.The bad situation ios then explained and in last solved on the last line.
Figure 4.Linear Optimixation*lo1)
lo1 <- list ()
lo1$sense <- "max"
lo1$c <- c(3 ,1 ,5 ,1)
lo1$A <- Matrix (c(3,1,2,0,
2,1,3,1,
0,2,0,3), nrow =3, byrow=TRUE , sparse =TRUE)
blc <- c(30,15,- Inf)
buc <- c(30,Inf ,25); lo1$bc <- rbind(blc , buc );
blx <- c(0 ,0 ,0 ,0)
bux <- c(Inf ,10,Inf ,Inf ); lo1$bx <- rbind(blx , bux );
r <- mosek(lo1)

A.Max 15x1+30x2+20x3
S.T.
x1+x3<4
0.5x1+2x2+x3<3
x1+x2+2x3<6
x1,x2,x3>0
B.From the above values for the extra changing we can see that the optimal answer is x1=15/2,x2=15 and x3=0.
C.The optimal value for the dual is shown in sun part to equal 78.Substututing x1=15/2,x2=15 into the primal objective function we can find the given values.


Related Solutions

Write the dual maximization problem, and then solve both the primal and dual problems with the...
Write the dual maximization problem, and then solve both the primal and dual problems with the simplex method. (For the dual problem, use x1, x2, and x3 as the variables and f as the function.) Minimize g = 6y1 + 28y2 subject to 2y1 + y2 ≥ 14 y1 + 3y2 ≥ 14 y1 + 4y2 ≥ 17 . primal g = primal y1 = primal y2 = dual f = dual x1 = dual x2 = dual x3 =
Solve problems using Minitab. Show evidence that they used the program by putting screen shots of...
Solve problems using Minitab. Show evidence that they used the program by putting screen shots of the results. Will give good rating. Exercises: 1. Among the 120 applicants for a job, only 80 are qualified. If 5 of these applicants are selected at random for an interview, answer the following: to. Identify the random process b. Define a variable c. Associate the random variable with a distribution and its parameters Solve the following questions using Minitab: d. Find the probability...
Solve problems using Minitab. Show evidence that they used the program by putting screen shots of...
Solve problems using Minitab. Show evidence that they used the program by putting screen shots of the results. Will give good rating 2. On a certain cruise, there are, on average, 3 traffic accidents each month. Answer the following: to. Identify the random process b. Define a variable c. Associate the random variable with a distribution and its parameters Solve the following questions using Minitab: d. Find the probability that in a period of 2 months exactly 4 accidents will...
Excel to VBA Please post with screen shots Add a few Check Box controls or Option...
Excel to VBA Please post with screen shots Add a few Check Box controls or Option Button controls to a worksheet and then use a Select/Case code structure in a sub procedure that outputs a message to the user telling him which box or option has been selected.
Run the following ANOVA analysis in excel and interpret your findings. Upload your screen shots of...
Run the following ANOVA analysis in excel and interpret your findings. Upload your screen shots of the steps you took in running the analysis in excel. Treatment 1 Treatment 2 Treatment 3 0 1 6 1 4 5 0 1 8 3 2 5
Run the following ANOVA analysis in excel and interpret your findings. Upload your screen shots of...
Run the following ANOVA analysis in excel and interpret your findings. Upload your screen shots of the steps you took in running the analysis in excel. Treatment 1 Treatment 2 Treatment 3 0 1 6 1 4 5 0 1 8 3 2 5
please write all formulas and show your work without using excel Using the information in Question...
please write all formulas and show your work without using excel Using the information in Question 1, what is the break-even market size for the project? Show your work, and round to the nearest unit. Refer to question 1: Consider a project with annual expected income based on approximately $125 million in revenue and approximately $77.5 million in total variable cost. You realize that both of these numbers are projected, and that your projections may be incorrect. Your boss wants...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit the Excel spreadsheet. A fair coin is tossed 15 times, calculate the probability of getting 0 heads or 15 heads A biased coin with probability of head being .6 is tossed 12 times. What is the probability that number of head would more than 4 but less than or equal to 10. You have a biased dice (with six faces numbered 1,2,3,4,5 and 6)...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit the Excel spreadsheet. You started a new restaurant. Based on invoices for the first 30 days, you estimated your average grocery bill to be $20,000 with a standard deviation of $2000. You want to start another restaurant in a similar neighborhood and you are planning to prepare a brochure for investors and to work out a deal with a whole sale food distributor. Prepare...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT