A furniture company manufactures tables and chairs

Assignment Help Applied Statistics

Reference no: EM13847035

A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine are available. A table requires either 17 board feet of oak or 30 board feet of pine, and a chair requires either 5 board feet of oak or 13 board feet of pine. Each table can be sold for $800, and each chair for $300.

a) Determine how the company can maximize its revenue.

b) Use SolverTable to investigate the effects of simultaneous changes in the selling prices of the products. Specifically, see what happens to the total revenue when the selling prices of oak products and the selling prices of pine products are allowed to vary (independently) by as much as plus or minus 30%, in increments of 10%, from their original values. Revise your model from the previous problem so that you can use SolverTable to investigate these changes. Can you conclude that total revenue changes linearly within this range?

Make sure to state the objective and exactly what has to be decided.

Hint: There are four ways of using wood. Answer: $1,460.000

Reference no: EM13847035

Questions Cloud

The better business bureau settles 75% of complaints : The Better Business Bureau settles 75% of complaints it receives involving new car dealers. Suppose a sample of 160 complaints involving new car dealers is selected. Find the probability that Better Business Bureau settles less than 124 of these com..

Dividend growth rate-implied by expected dividend amounts : A share of preferred stock costs $75.00 and the next dividend is to be paid in 1 year. The expected annual return on this stock is 15%. In excel, compute and graph the dividend growth rate, as implied by expected dividend amounts (to be paid one year..

The state of california has a mean annual rainfall : The state of California has a mean annual rainfall of 27.6 inches, whereas the state of New York has a mean annual rainfall of 48.7 inches. Assume the standard deviation for California is 6.3 inches and for New York is 5.6 inches. Find the probabili..

What are the internal and sustainable growth rates : Better Burgers reported the following numbers (in millions) for the years ending February 2011 and 2012. What are the internal and sustainable growth rates? (Do not round intermediate calculations. What are the internal and sustainable growth rates u..

A furniture company manufactures tables and chairs : A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine are available. A table requires either 17 board feet ..

A statistics department only accepts students : A statistics department only accepts students with SAT-Math scores in the top 15% of the population. Given that the population of SAT-Math scores has a mean of 500 and a standard deviation of 100, what is the minimum score needed for admissions to th..

Cost of trade credit and accounts payable : Calculate the nominal annual cost of nonfree trade credit under each of the following terms. Assume payment is made either on the due date or on the discount date. Assume 365 days in year for your calculations. A chain of appliance stores, APP Corpor..

The general population one woman in ten : The general population one woman in ten will develope breast cancer research has shown that 1 woman in 600 carries a mutation of the brca gene seven out of 10 woman with this mutation develop breast cancer. he probability that a selected woman will..

A new phone answering system for a company : A new phone answering system for a company is capable of handling seven calls every 10 minutes. Prior to installing th new system company analysts determined that the incoming calls to the system are Poisson with a mean equal to three every 10 minut..

User Account

All Pages