Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. (Linear Programming: basic formulation and graphical solution) A wood product firm uses available time at the end of each week to make goods

image text in transcribed

1. (Linear Programming: basic formulation and graphical solution) A wood product firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items are produced for stock: a chopping board and a knife holder. Both items require three operations: cutting, gluing, and finishing. The manager of the firm has collected the following data on these products: Item Profit per unit Cutting (minutes) Gluing (minutes) Finishing (minutes) Chopping board $2 1.4 5 12 Knife holder $6 0.8 13 3 The manager has also decided that, during each week, 56 minutes are available for cutting, 650 minutes are available for gluing, and 360 minutes are available for finishing. a) Formulate it as a linear programming problem. b) Solve the LP using the graphical method. You are required to show the feasible solution space, the corner solutions, and the optimal solution. c) Solve the LP again using Excel Solver. Note: complete this question in the same file of Question 2- (b), and then upload it to Canvas; that is, you can upload a document (Word or PDF) for your written answers to all questions, as well as a separate Excel file for questions that require Excel Solver.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Creating Value Along the Supply Chain

Authors: Roberta S. Russell, Bernard W. Taylor

7th Edition

9781118139523, 0470525908, 1118139526, 978-0470525906

More Books

Students also viewed these General Management questions