Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Will W Inc. makes two doors ( ( A ) and ( B ) ). The final product, in both instances, requires machining and painting.

image text in transcribed
Will W Inc. makes two doors ( \\( A \\) and \\( B \\) ). The final product, in both instances, requires machining and painting. The company has loyal customers order 320 units of product A. There are only 3,800 machine-hours available for making both products. Products \\( A \\) requires 2 hours per unit and product \\( B \\) requires 4 hours per unit at the machine stage. Similarly, there are 4000 person-hours available for painting the products. The number of person-hours required for painting products \\( A \\) and \\( B \\) are 3 and 4 respectively. Product \\( A \\) contributes \\( \\$ 2.50 \\) to the company's profits while product \\( B \\) contributes \\( \\$ 3.50 \\) to the company's profits. Required: c. State the objective function and the constraints related to the above conditions. (4 marks) 2. Graph the constraints, determine the points that make the feasible region and the optimal number of \\( A \\) and \\( B \\). Show all calculations. (5 marks) b. Use Excel Solver to find the solution to this linear programming problem and provide a copy of the Excel solution with your answer. (1 mark)

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

Public Finance

Authors: Harvey Rosen, Ted Gayer

10th Global Edition

007715469X, 978-0077154691

More Books

Students also viewed these Finance questions

Question

Define Conventional Marketing.

Answered: 1 week ago

Question

Define Synchro Marketing.

Answered: 1 week ago

Question

Define marketing concepts.

Answered: 1 week ago

Question

1 what does yellow colour on the map represent?

Answered: 1 week ago

Question

We want the new copier not the old model.

Answered: 1 week ago

Question

Stoneridge Inc. will go public on September 9 2014.

Answered: 1 week ago

Question

After Martha has gone talk to me about promoting her.

Answered: 1 week ago