Equipment produces two types of desks-standard-deluxe

Assignment Help Operation Management

Reference no: EM131036572

Johnson 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 80 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 16 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 board feet of oak, and 400 hours of labor available. Standard desks net a profit of $150, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot.

a. What is the objective function?

b. What are the equations for the constraints?

c. Set up your linear program in Microsoft Excel. Solve it using the Solver add-in.

d. What is the optimal solution? Identify the number of desks to build and the total profit.

e. Which constraints use all of the available resources? Which constraints have resources remaining?

Reference no: EM131036572

Questions Cloud

Choose the best definition of temperature : Choose the best definition of temperature

Develop knowledge base that is integrated with disciplines : The professional logistics manager must develop a knowledge base that is integrated with other disciplines. The decision to enter the global or international supply chain and marketplace is a difficult decision and requires a lot of homework (fact fi..

Resistant employees consists of middle managers : A second group of resistant employees consists of middle managers. Some middle managers resist using your company's intranet. Although there middle managers do not resist the technology per se and use their PCs for multiple purposes, including commun..

Alternative minimum taxable income : Abbygail, who is single, had taxable income of $120,000 for 2015. She had positive AMT adjustments of $35,000; negative AMT adjustments of $16,000; and tax preference items of $45,000.

Equipment produces two types of desks-standard-deluxe : Johnson 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. What is the objective function? What are the equations for the ..

Some of them seem computer-phobic : One resistant group of employees is made up of top managers. Some of them seem computer-phobic. They have never used, and do not want to start using, personal computer (PCs) for any purpose, including communication. What step will you take to get the..

Allocate between radio and television advertising : A brand manager for Lolol must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it..

Create liability for fraudulent misrepresentation : Assume a salesperson intentionally made one of the following statements - knowing that the statement was false - to a customer considering a purchase. Which statement could create liability for fraudulent misrepresentation if the customer made the pu..

Linear programming for production scheduling problems : What benefits exist in using linear programming for production scheduling problems? Provide an example and discuss your opinion.? What are at least the two important relationships of an inventory system (EOQ) you need to recognize in order to apply t..

User Account

All Pages