Variable cells and model variable

Assignment Help Financial Management

Reference no: EM13940178

Variable Cells:

Model Variable: U Name: US Oil Final Value 800.000 Reduced Cost 0.000 Objective Coefficient 3.000 Allowable Increases 7.000 Allowable Decrease 0.500

Model Variable: H Name: Huber Final Value 1200.000 Reduced Cost 0.000 Obj Coeffcient 5.000 Allow increase 1.000 Allowable Decrease 3.500

Constraints:

Constraint Number Name Final Value Shadow price Contraint RH Side Allowable Increase Allowable Decrease

1 Funds available 80000.000 0.093 80000.000 60000.000 15000.000

2 Risk Maximum 700.000 1.333 700.000 75.000 300.000

3 US Oil Maximum 800.000 0.000 1000.000 1E + 30 200.000

a. How much would the return for US oil have to increase before it would be beneficial to increase the investment in this stock?

b. How much would the return for Huber Steel have to decrease before it would be beneficial to reduce the investment in this stock?

c. How much would the total annual return be reduced if US Oil maximum were reduced to 900 shares?

Reference no: EM13940178

Questions Cloud

Estimate the probability that the exchange rate : An exchange rate is currently $1.20. The volatility of the exchange rate is quoted as 15% and interest rates in the two countries are the same. Using the lognormal assumption, estimate the probability that the exchange rate in six months will be (a) ..

Counterfeit goods with counterfeiters : Introduction "Counterfeiting is said to be the crime of the 21st century." (Cademan, A & Henriksson, R & Nyqvist, V. (2012). The luxury brand market is highly associated with counterfeit goods with counterfeiters attempting to replicate many big n..

Develop a set of classes for a college : Person: A Person contains a first name, last name, street address, zip code, and phone number. The class also includes a method that sets each data field and display method that displays all of a Person's information.

Put–call parity formula for an option on a currency : How does the put–call parity formula for a currency futures option differ from the put–call parity formula for an option on a currency?

Variable cells and model variable : How much would the return for US oil have to increase before it would be beneficial to increase the investment in this stock? How much would the return for Huber Steel have to decrease before it would be beneficial to reduce the investment in this st..

Solve the below given equation : Solve the below given equation If 3 = log10 27 + 3 log10 x, solve for x Show complete steps, how did you reach the answer.

Suppose bursa had used the cost relationships determined : Suppose Bursa had used the cost relationships determined in part a to estimate the total manufacturing overhead expected for the months of February and March.

Rights and responsibilities of the employer and employee : Who should be responsible for workers safety? Why? Weigh up the rights and responsibilities of the employer and employee? Which has a higher weighting, and why?

Preferred stock of erie railroad ties pays annual dividend : The preferred stock of Erie Railroad Ties pays an annual dividend of $8.20 and sells for $51.70 a share. What is the rate of return on this security?

User Account

All Pages