# Question

A leading hardware company produces three types of computers: Pear computers, Apricot computers, and Orange computers. The relevant data are given in the file S14_91.xlsx. The equipment cost is a fixed cost; it is incurred if any of this type of computer is produced. A total of 30,000 chips and 12,000 hours of labor are available. The company wants to produce at least two types of computers.

a. Determine how the company can maximize its profit.

b. For any computer type not in the optimal product mix, use SolverTable to find how much larger its unit margin would have to be before it would enter the optimal product mix.

a. Determine how the company can maximize its profit.

b. For any computer type not in the optimal product mix, use SolverTable to find how much larger its unit margin would have to be before it would enter the optimal product mix.

## Answer to relevant Questions

A food company produces tomato sauce at five different plants. The tomato sauce is then shipped to one of three warehouses, where it is stored until it is shipped to one of the company’s four customers. All of the inputs ...A financial company is considering investing in three projects. If it fully invests in a project, the realized cash flows (in millions of dollars) will be as listed in the file S14_97.xlsx. For example, project 1 requires a ...It is currently the beginning of 2010. A city (labeled C for convenience) is trying to sell municipal bonds to support improvements in recreational facilities and highways. The face values (in thousands of dollars) of the ...Use @RISK to draw a binomial distribution that results from 50 trials with probability of success 0.3 on each trial, and use it to answer the following questions.a. What are the mean and standard deviation of this ...In the Walton Bookstore example with a discrete demand distribution, explain why an order quantity other than one of the possible demands cannot maximize the expected profit.Post your question

0