Reference no: EM131442407
Interpreting Sensitivity Reports
Adjustable Cells
Cell: $G$17
Name: Product X
Final Value: 120
Reduced Cost: 0
Objective Coefficient: 40
Allowable Increase: 13.33333333
Allowable Decrease: 0
Cell:$H$17
Name: Product Y
Final Value: 80
Reduced Cost: 0
Objective Coefficient: 40
Allowable Increase: 0
Allowable Decrease: 10
Constraints
Cell: $I$18
Name: Machining
Final Value: 6.2
Shadow Price: 0
Constraint RHS: 7
Allowable Increase: 1E+30
Allowable Decrease:.8
Cell: $I$19
Name: Labor
Final Value: 10
Shadow Price: 80
Constraints RHS: 10
Allowable Increase: 4.70588235
Allowable Decrease: 1
Cell: $I$20
Name: Painting
Final Value: 6
Shadow Price: 0
Constraint RHS:6
Allowable Increase: .666666667
Allowable Decrease: .4444444
A) If profit margin for X is increased by 10, what would be the change in optimum value? What if it is increased by 15?
B) If profit margin for Y is decreased to 39, what would he te change in optimum value?
C) If 3 hours of extra labor can be provided for a total cost of $200, should the conpanyt do it? Why or why not?
D) The machining availability has dropped from 7 to 6.5. What impact will Thai have on the optimal solution and the optimal value?
E) The painting availability has dropped from 6 to 5.5. What impact will this have o. the optimal solution and the optimal value?
|
What is the impact on the deficit and on investment
: Assuming that the government raises taxes on interest income, what is the total impact on national savings, taking into account both deficit reduction and changes in private savings? What is the impact on investment?
|
|
Described the economic environment
: Lacey Harmoniski had just moved to the Endura Republic as a part of a business school summer internship. His mentor and supervisor, Mr. Rickki, had handed him THE FASTNER CO. income statements and asked him to analyze them. Mr. Rickki had described t..
|
|
How different government actions affect various groups
: Assume the government is considering whether to reduce the deficit by increasing capital gains taxes or by increasing payroll taxes. Describe how different groups are affected by the alternatives.
|
|
Construct press release setting forth your company position
: Summarize the issues, interests, institutions, and information (the Four I's explained in the attachment). Construct a Press Release setting forth your company's position
|
|
Interpreting sensitivity reports-optimum value
: Interpreting Sensitivity Reports. If profit margin for Y is decreased to 39, what would he te change in optimum value? The machining availability has dropped from 7 to 6.5. What impact will Thai have on the optimal solution and the optimal value?
|
|
Potential tax ramifications to your future clients
: Joe Ji is divorced from Joy Ji. They have 2 children together, Daniel and Julie. Joe and Joy live apart and in separate homes. Joe is ordered to pay Joy $1,500 a month in alimony. Potential tax ramifications to your future clients or your practice?
|
|
Evaluate the proposed acquisition
: You have been asked by the president of your company to evaluate the proposed acquisition of a new special purpose truck. The truck's basic price is 50,000 and it will cost another 10,000 to modify it for special use by your firm. The firms marginal ..
|
|
The market value of the equity
: The market value of the equity of Thompson, Inc., is $562879. The balance sheet shows $38152 in cash and $196382 in debt, while the income statement has EBIT of $94026 and a total of $178301 in depreciation and amortization. What is the enterprise va..
|
|
What is the company net income-operating cash flow
: Using the tax tables in the textbook (table 2.3) as shown below, please calculate the total tax, the average tax rate, and the marginal tax rate for a company with $7,650,000 taxable income. During the year, Belyk Paving Co. had sales of $3,350,000. ..
|