For the LP problem presented in the 'Problem Formulation' worksheet, set up and solve the LP using Solver in the 'Solver Solution' worksheet to find the optimal solution and generate the Answer and Sensitivity Reports.

Once complete, answer the questions below and upload the complete spreadsheet with the Solver set-up and solution/sensitivity analysis intact to D2L.
What is the minimum net profit required for crude type C1 before we would use any in the refining process? Exlpain/justify your response.
How low could the net profit on crude type 'A' be and still have our current optimal solution remain optimal

The wall street journal reported that walmart stores inc. is planning to lay off 2,300 employees at its sam's club warehouse unit. approximately half of the layoffs will be hourly employees (the wall street journal, january 25-26, 2014). suppose the following data represent the percentage of hourly employees laid off for 15 sam's club stores. 55 56 44 43 44 56 60 62 57 45 36 38 50 69 65 (a) compute the mean and median percentage of hourly employees being laid off at these stores. (b) compute the first and third quartiles. (c) compute the range and interquartile range. (d) compute the variance and standard deviation. (e) do the data contain any outliers? (f) based on the sample data, does it appear that walmart is meeting its goal for reducing the number of hourly employees?

Russell's is considering purchasing $697,400 of equipment for a four-year project. the equipment falls in the five-year macrs class with annual percentages of .2, .32, .192, .1152, .1152, and .0576 for years 1 to 6, respectively. at the end of the project the equipment can be sold for an estimated $135,000. the required return is 13.2 percent and the tax rate is 23 percent. what is the amount of the aftertax salvage value of the equipment assuming no bonus depreciation is taken

Financial performance is measured in many ways. requirements 1. explain the difference between lag and lead indicators. 2. the following is a list of financial measures. indicate whether each is a lag or lead indicator: a. income statement shows net income of $100,000 b. listing of next week's orders of $50,000 c. trend showing that average hits on the redesigned website are increasing at 5% per week d. price sheet from vendor reflecting that cost per pound of sugar for the next month is $2 e. contract signed last month with large retail store that guarantees a minimum shelf space for grandpa's overloaded chocolate cookies for the next year