Company manufactures desks and chairs

Assignment Help Operation Management
Reference no: EM131628437

A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 2000 units of wood available. a. Use Solver to maximize the company's profit. b. Confirm graphically that the solution in part a maximizes the company's profit. c. Use SolverTable to see what happens to the decision variables and the total profit when the availability of wood varies from 1000 to 3000 in 100-increments. Based on your findings, how much would the company be willing to pay for each extra unit of wood over its current 2000 units? How much profit would the company lose if it lost any of its current 2000 items? MUST BE DONE IN EXCEL WITH FORMULAS.

Reference no: EM131628437

Questions Cloud

Job description for your dream position : Write a job description for your “dream position.”
What is meant by organizational culture : What is meant by organizational culture and how it is created, influenced, and changed based on globalization.
Marketing-human resource management and operations : marketing, human resource management, and operations.
Career objective statements are not effective : The following career objective statements are not effective. What is wrong with each statement as it stands?
Company manufactures desks and chairs : A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood.
Analyze the needs of the job : Analyze the needs of the job and identify your personal strengths and qualifications to obtain it
Article about marketing : How does poverty undermine the nation's overall well being? Find a recent article about " MARKETING" and analyze it briefly.
Collective bargaining for the union contract : You are the fire chief for a local fire department. You are about to enter into the collective bargaining for the union contract.
Discuss the juvenile justice system in general : Discuss the juvenile justice system in general.

Reviews

Write a Review

Operation Management Questions & Answers

  The transformational-leadership style

Compare and contrast the transactional-leadership style with the transformational-leadership style? Which style would you adopt as a manager, and why? Next, review the suggested skills needed for effective leadership. How do these relate to the 4 mai..

  What are some significant areas of overlap

What are some significant areas of overlap between the long-term and mental health care categories? Implications for providers of care, for the patients.

  The half-truths about business writing

Which of the following statements is true of the half-truths about business writing?(a) never forget to acknowledge your source if you have borrowed words or ideas. (a) Never use "you" because it is too informal. (c) Never use "but" to begin a senten..

  From a distance as well as securing the privacy

In the last decade more and more health services are being outsourced to private companies, many of which are located or operational outside of the United States. What would you be concerned about (or not?) with an outsource company providing service..

  Examples of inventory control systems tools

Provide 3 examples of inventory control systems tools. Explain what these tools are and how they are used.

  Significant supply chain risk factors impacting warehousing

Think about two upcoming projects your company or school will be perfoming in the future which one do you think would have a more detailed WBS? Why? What do you consider to be the most significant supply chain risk factors impacting warehousing? And ..

  Fractional values for decision variables as optimal solution

It is quite possible that when you solve a linear programming application you may get fractional values for the decision variables as an optimal solution. For example, if your decision variables are how many trains and buses to run daily to meet expe..

  Global warming-ozone depletion and forest conservation

Comment on two or more of the following issues in our environment: Global Warming, Ozone Depletion, Forest Conservation. Using the text and videos supplied in the modules comment on: What are your personal views and concerns. What do you personally d..

  Contribute to the overall competitiveness of the corporation

How does supply chain management contribute to the overall competitiveness of the corporation? What factors have raised the strategic importance of the supply chain management function?

  Payment dates in connection with cash dividend

The declaration, record, and payment dates in connection with a cash dividend of $1,250,000 on a corporation's common stock are August 1, October 15, and November 14.

  What competitive advantages-integrated strategy

How does Amazon's strategy for slow moving, low-volume products and fast moving, high-volume items fit within its push-pull strategy (Simchi-Levi, Kaminsky, & Simchi-Levi, 2008, 203)? What competitive advantages does Amazon realize with its integrate..

  Think this will have on the local houston economy

Are you likely to use this express service (ONE HOUR DELIVERY) by Amazon? What kind of impact do you think this will have on the local Houston economy? What kind of impact do you think this will have on the companies like Wal-Mart, Target, CVS and Wa..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd