Business analytics-operational management

Assignment Help Operation Management
Reference no: EM132320811

[Business Analytics/Operational Management]

The Oak Works is a family-owned business that makes handcrafted dining room tables and chairs. They obtain the oak from a local farm tree farm, which ships them 2,500 pounds of oak each month. Each table uses 50 pounds of oak while each chair uses 25 pounds of oak. The family builds all the furniture itself and has 480 hours of labor available each month. Each table or chair requires six hours of labor. Each table nets Oak Works $400 in profit, while each chair nets $100 in profit. Since chairs are often sold with tables, they want to produce at least twice as many chairs as tables. The Oak Works would like to decide how many tables and chairs to produce so as to maximize profit.

a. Formulate algebraically the linear programming model of this problem.

b. Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel solver (Provide a printout of the corresponding "Excel Spreadsheet" and the "Answer Report")

Reference no: EM132320811

Questions Cloud

What is the learning rate for project : What is the learning rate for this project? How many hours do you expect the third unit to take? How many hours do you expect the 15th unit to take?
Can you estimate the learning curve : a) Can you estimate the learning curve? b) How long till they get it down to less than the time required for the old system?
What are the challenges of leading an org in today world : BUMGT5970 Leadership Assessment Task - Essay, Federation University, Australia. What are the challenges of leading an org. in today's world
What is the overall reliability of the call center : The service center for a brokerage company provides three functions to callers: accounts status, order confirmations
Business analytics-operational management : The Oak Works is a family-owned business that makes handcrafted dining room tables and chairs. They obtain the oak from a local farm tree farm
Graph the constraints and identify the feasible region : a. Graph the constraints and identify the feasible region. b. Determine the optimal solution (Show your work).
Business analytics-management science : The manager of a food processing plant that specializes in potato chips has developed an LP model to reflect processing times.
What is the utilization of the clinic : What is the utilization of the clinic? State your answer as a percentage with at least three decimal points, e.g., 50.000 (for 50% utilization).
Amount of work in seconds is required at station : Assume you plan to make boxes together with three classmates and each of you is assigned to exactly one task (A-D).

Reviews

Write a Review

Operation Management Questions & Answers

  The evolution of management thinking

When Andy Pforzheimer was in college, he took a road trip to New Orleans that would change his life. The sights and sounds of the Big Easy were thrilling to the nineteen-year-old student, but it was the smells and tastes of the city restaurants that ..

  Borrowing and lending at a risk-free rate

Explain the choice among Portfolios A, B, and C using the Markowitz decision rule. Explain the choice among Portfolios A, B, and C assuming that borrowing and lending at a risk-free rate of R_F = 2 percent is possible.

  Differentiate between internal and external recruiting

While assessing performance of subordinates over past year, manager has rated all employees under him as average. Differentiate in internal-external recruiting.

  Personal and professional development

A part of my 'Personal and Professional Development' Assignment says the following

  What would be the impact on world trade and investment

Do you expect the U.S. dollar to maintain its position as the dominant currency in the foreign-exchange market or will the euro or the Chinese yuan supplant it? Explain your answer. [3] What would be the impact on world trade and investment if there ..

  Differences between maximum capacity and effective capacity

Explain the differences between maximum capacity and effective capacity.

  Motivational theory applications argue for recognizing

Motivational theory applications argue for recognizing individual differences.

  Technology impact employment and production

What are some of the social and cultural effects of the technology? How did the technology impact employment and production?

  How does his leadership style affect the motivation

One of the principles of path-goal theory is to make the end goal valuable to workers. What could Daniel do to improve follower motivation in this area?

  What are the social and security issues for individuals

what are the social and security issues for individuals and organizations relative to person and business use of social media.

  Update on the delivery of an outstanding order

Kevin contacts an overseas manufacturer to get an update on the delivery of an outstanding order. Which acitivty is Kevin a part of?

  Value the significance of communication

Members of any team must value the significance of communication, particularly when setting goals and when attempting to solve problems. One form of communication—feedback—is most helpful when it is given in a descriptive fashion or offers suggestion..

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