Identify the decision variables and objective function

Assignment Help Operation Management

Reference no: EM131224632

Implement the linear optimization model that you developed for Burger Office Equipment in Problem 3 in Excel and use Solver to find an optimal solution. Interpret the Solver answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constraints. Problem 3: Burger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more-expensive hardware and require additional time for finishing and polishing. Standard desks require 70 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 15 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 square feet of oak, and 400 hours of labor available. Standard desks net a profit of $225, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot. a. Identify the decision variables, objective function, and constraints in simple verbal statements. b. Mathematically formulate a linear optimization model.

Reference no: EM131224632

Questions Cloud

About the car in first year if the advertising claim is true : Colonel Motors (an automobile company) has prepared a marketing campaign for its best-selling car. The focus of the campaign is quality, and it is claimed that 97 percent of the purchasers of this car have no complaints in the first year. You and you..

Recommend reallocating production between these two plants : Given these data, how, if at all, would you recommend reallocating production between these two plants? Briefly explain why.

Types of market entry offer greater control : Companies should use investment entry modes whenever possible because they offer the greatest control over business operations. " do you agree or disagree with this statement? are there times when other types of market entry offer greater control? wh..

What do you think about the inconvenient nature of ethics : How would you apply a Levinasian perspective to understanding the ethical obligations corporations have to stakeholders? How would you apply this perspective to business ethics more generally?

Identify the decision variables and objective function : Implement the linear optimization model that you developed for Burger Office Equipment in Problem 3 in Excel and use Solver to find an optimal solution. Interpret the Solver answer report and identify the binding constraints and verify the values of ..

Opportunity cost of studying chapter : Suppose your studying partner states that the opportunity cost of studying chapter 1 of your microeconomics textbook is about 1/25 the price you paid for the book, since the chapter is about 1/25 of the book. Do you agree with this assessment? Exp..

What changes did kmart make to its store in chicago : What marketing research methods would you recommend to a retailer like Kmart to learn more about the consumer shopping experience in its stores and to better understand what consumers think about Kmart?

Discuss how quantitative analysis techniques : Introduce yourself and discuss how quantitative analysis techniques can directly affect strategic business decision making and the management of production and service operations. What is the most significant factor to consider when making a crucial ..

Abundance of phytoplankton : A large number of fish are suddenly found floating dead on a lake. You are called in to investigate the problem. You find an abundance of phytoplankton and no evidence of toxic dumping. Suggest a reason for the fish kill.

User Account

All Pages