Reference no: EM131042317
Business Analytics 2nd Edition James R Evans Chapter 13 problem 7
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.
|
What value cluster is represented in the advertising
: Search the Web and compare at least five companies’ slogans. Briefly state what value cluster is represented in the advertising. For example: Kentucky Fried Chicken – We do chicken right! Value Cluster – Efficiency Respond to two colleagues, agreeing..
|
|
Which was suspended from the ceiling instead of placed
: In Rodchenko's Spatial Construction (1920), which was suspended from the ceiling instead of placed on a traditional pedestal, all of the following effects resulted from the sculpture,except that it
|
|
Cognitive models of participative decision making
: Explain how an idea of one member in an organization would evolve through the degrees of separation in the scaling up process. Compare and contrast the affective and cognitive models of participative decision making. How do these models differ in the..
|
|
Customers in three locations at grid locations
: We have customers in three locations at grid locations (2,6), (5,1), and (2,2). Each area needs the same quantity. Where is the center of gravity?We have customers in three locations at grid locations (2,6), (5,1), and (2,2). Each area needs the same..
|
|
Implement the linear optimization model
: 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 evolution of business landscapes in the last century
: Write a paper on the following theme: "The evolution of business landscapes in the last century through today has created a new role for the leader requiring the emergence of the people centric person who creates competitive edge within an organiz..
|
|
Identify the tasks on the critical path
: Identify the tasks on the critical path and the length of the critical path in weeks. Find the minimum additional cost required to complete the project 2 weeks ahead of its normal schedule.
|
|
Underemployed to prepare for the job market
: Welfare to work programs help the unemployed and the underemployed to prepare for the job market and to succeed in the job market. Organizations such as Get Out and Stay Out (GOSO) help young prison inmates with individual job and educational counsel..
|
|
Regarding layoffs in unionized organizations
: Which of the following statements is true regarding layoffs in unionized organizations?
|