Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. [30 points] TriStar Manufacturing makes three models of fans, identified by the unimaginative names of A,B, and C. The fans are made out of

image text in transcribed 2. [30 points] TriStar Manufacturing makes three models of fans, identified by the unimaginative names of A,B, and C. The fans are made out of nuts, bolts, wire, blades, and motors. The current inventory levels and parts list for each type of fan is shown in the table below. Profit from Fan A is $35, Fan B profit is $50, and Fan C profit is $60. TriStar Manufacturing wants to know the best product mix to maximize the revenue. a. What are decision variables for this problem? What is the objective function for this problem? b. What are the constraints for this problem? Express them as mathematical relationships. c. Solve the problem using Excel Solver or LP Solve. How many of each type to make so as to maximize profits? Show screen captures to earn full credit. If you used Excel Solver, a screen capture of the Solver parameters must be shown to earn full credit. d. How much profit does the manufacturer earn with optimal production quantities

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

Cyber Security And Supply Chain Management

Authors: Steven Carnovale, Sengun Yeniyurt

1st Edition

9811231567, 978-9811231568

More Books

Students also viewed these General Management questions