A furniture company manufactures tables and chairs each, Ask an Expert

Management Studies

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?

Can anyone attach an excel file showing all the work?

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91949377

Have any Question?Write your Review or question?

Related Questions in Operation Management

As a new leader you must prepare a report for the ceo that

As a new leader, you must prepare a report for the CEO that assesses the organization’s overall alignment between its vision, mission, values, and strategy. This report should consist of the following sections: An analys ...

1 suppose a dataset has a mean of 100 and standard

1. Suppose a dataset has a mean of 100 and standard deviation of 6. If the data are normally distnibuted, between what two values would I expect to find approximately 95% of the data? a. Between 5 and 195. b. Between 94 ...

Assignment what makes the best place to work and

Assignment : "What Makes ______ the Best Place to Work and Why?" Choose one (1) company that you believe would be an ideal company to work for based on working conditions, salary, opportunity for advancement and work inv ...

Handling organizational conflict paperresearch an

Handling Organizational Conflict Paper Research an organization that has recently had major conflict that made the news. You must identify the organization and the source of the conflict. Instructions: Describe the five ...

1 discuss the difficulty in having a standardized price for

1. Discuss the difficulty in having a standardized price for a company’s products across all countries and areas within a country. Give an example of a company that prices a product differently through a region. 2. Why i ...

1 put these company achievements in order of how likelye

1. Put these company achievements in order of how likelye they are to create a lasting competitive advantage (from shortest/no advantage to longest). A. Having the lowest costs created by plant upgrades and a history of ...

1 what is risk risk is the concept which is understood by

1. What is risk? Risk is the concept which is understood by the simple definition of exposing something valued to danger, harm, or loss. When we think of project management, is that not what we are doing? 2. What do you ...

Management vs leadership five ways they are differentmar 27

Management Vs. Leadership: Five Ways They Are Different Mar 27, 2016, 10:41pm 290,627 views For years we were taught that management has to do with forecasting, budgeting, planning and controlling. Managers were taught t ...

How picking a chief executive is more random than wise new

How picking a chief executive is more random than wise. New York Times What makes the perfect chief executive? If the way corporate boards at Yahoo and Duke Energy picked chief executives is any indication, it may be up ...

1 goodwill is an example of a tangible assettruefalse2

1. Goodwill is an example of a tangible asset. True False 2. Inventory is an example of a tangible asset. True False 3. An income statement method of business valuation focuses more on cash flow than asset value. True Fa ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert