Question: Prepare a sensitivity analysis question with an Excel Sensitivity analysis report and answer it. Make sure your question asks about the following a. Optimal solution

Prepare a sensitivity analysis question with an Excel Sensitivity analysis report and answer it. Make sure your question asks about the following

a. Optimal solution

b. Optimal objective function

c. Objective function coefficient changes

d. Reduced cost

e. Constraint right hand side changes

f. A question where you can not use the given Excel sensitivity analysis is not useful, you need to rerun to find the solution.

2. Consider the Apex Television Company problem in your previous homework. Generate the sensitivity report from Excel Solver

2. Consider the Apex Television Company problem in your previous homework. Generate the sensitivity report from Excel Solver and answer the following questions using only the sensitivity report. NOTE: Attaching a sensitivity report is NOT enough. You need to actually answer each part of the question. (a) Apex is considering to pay for extra work hours. What is the maximum price that Apex is willing to pay for an extra work hour? (b) Apex is planning advertisement for 27-inch TV. The marketing team anticipates that it costs $12 for one additional demand of 27-inch TV per month. Should Apex start the advertisement? (c) Apex is planning advertisement for 20-inch TV. The marketing team anticipates that it costs $8 for one additional demand of 20-inch TV per month. Should Apex start the advertisement?

Step by Step Solution

★★★★★

3.38 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

part a ne the slver hs fund slutin yu n generte sensitivity ... 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

Students Have Also Explored These Related Accounting Questions!

You are working for the summer at a research laboratory. Your research director has devised a scheme for holding small charged particles at fixed positions. The scheme is shown in the figure below....

In the early 2000s, according to the World Bank, about 110 million children between the ages of 6 and 11 were not in school and about two-thirds of them were girls. In Afghanistan, for example, the...

Use parametric linear programming to find an optimal solution for the following problem as a function of , for 0 30. Maximize Z () = 5x1 + 6x2 + 4x3 + 7x4, Subject to and xj 0, for j = 1, 2, 3,...

Scenario: Steve Smith was recently hired as a controller for a chocolate bar manufacturing plant in the United States that is a division of a Swiss parent company. Steve is a direct report to the...

Write an essay in two well written paragraphs. The first paragraph summarizes in your own words the article of "Oil Spill Impacts". The second paragraph provides your analysis that connects the...

Tucker Inc. produces high-quality suits and sport coats for men. Each suit requires 1.2 hours of cutting time and 0.7 hours of sewing time, uses 6 yards of material, and provides a profit...

Central University (CU) opened its law school in September 2011. The law school is the only part of the university offering a graduate-level professional degree. A group of the law schools faculty...

Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63, $95, and $135, respectively. The production...

Digital Controls, Inc. (DCI) manufactures two models of a radar gun used by police to monitor the speed of automobiles. Model A has an accuracy of plus or minus 1 mile per hour, whereas the smaller...

The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual racetracks. Because safety is a primary consideration at such events, many...

Job 412 was one of the many jobs started and completed during the year. The job required $9,000 in direct materials and 40 hours of direct labor time at a total direct labor cost of $9,900. If the...

As a supervisor , write the solution for the employee scenario below Withdrawing from Work: "Chloe is an excellent worker. When she is on, she's on. But when she's not, she can be irritable, erratic,...

Downtown Kingston Transport Centre/ Project management Instructions: Read the case study below, access the links provided and answer all questions. The downtown Kingston and Saint Andrew Centre were...

The J.R. Ryland Computer Company is considering a plant expansion to enable the company to begin production of a new computer product. The company's president must determine whether to make the...

The retail positioning matrix is an analytical tool thatA ) positions retail outlets in terms of the breadth of product line and value addedB ) identifies the best location for building or leasing a...

Since understanding forces in our environment that either help or hinder the acquisition of human capital, answer the following: What are the internal and external factors that influence an...

You purchased 4,400 shares in the New Pacific Growth Fund on January 2, 2010, at an offering price of $47.9 per share. The front-end load for this fund is 5 percent, and the back-end load for...

If the annual fixed costs are 54,000 dinars, the occupation expense represents 20%, the contribution margin is 25%, and the unit selling price is 40 dinars. Required: Calculate the closing point of...

Cominsky Company purchased a machine on July 1, 2011, for $28,000. Cominsky paid $200 in title fees and county property tax of $125 on the machine. In addition, Cominsky paid $500 shipping charges...

Four years after issue, debentures with a face value of $1,000,000 and book value of $960,000 are tendered for conversion into 80,000 shares of common stock immediately after an interest payment...

Analysis of Various Accounting Changes and Errors Katherine Irving, controller of Lotan Corp., is aware that a pronouncement on accounting changes has been issued. After reading the pronouncement,...

The Wechsler Adult Intelligence Scale (WAIS) is best able to tell us what part of an individuals intelligence is determined by genetic inheritance. whether the test-taker will succeed in a job. how...

Terrorist attacks in Paris and San Bernardino made Americans, in the words of one senator, really scared and worriedand more fearful of being victimized by terrorism than of other greater threats....

Charles Spearman suggested we have one ____________ ____________ underlying success across a variety of intellectual abilities.