Determine how the company can maximize its revenue

Assignment Help Operation Management

Reference no: EM131193307

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?

Reference no: EM131193307

Questions Cloud

Explain the resources used as inputs to produce output : Briefly explain the resources used as inputs to produce output, and provide an example of each resource.

Find the amount of energy the freezer : Find the amount of energy the freezer must remove from the R-134a and the extra amount of work input to the freezer to do the process.

Conventional views of organizational communication : In this week's video Professor Koschmann moves beyond conventional views of organizational communication. Reflect for a moment on the video ideas. What does Professor Koschmann mean by the "flat earth" approach? Why do you believe this approach in..

Describe the problem that researcher was trying to address : Describe the problem or opportunity that the researcher was trying to address. Discuss the intent of the study and list any research questions or hypotheses that were used.

Determine how the company can maximize its revenue : 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. Determine how the company can maximize..

Workouts on investment benefit analysis : Can you give me an example with workouts on investment benefit analysis for B2B situation from automobile manufacturer perspectives?

Prepare an income statement for the company in good format : Prepare an income statement for the company in good format. Always include the name of the company and the period covered in the title.

Explain whether or not intruder is liable for his actions : Discuss ways to prevent or mitigate the risk of the potential torts. Discuss what you would want from your landlord if you were Sharon and what you would want from your employer if you were Daryl.

User Account

All Pages