A small firm makes three similar products, which all follow the same three-step process, consisting of...

90.2K

Verified Solution

Question

Finance

A small firm makes three similar products, which allfollow the same three-step process, consisting of milling,
inspection, and drilling. Product A requires 12 minutes of milling,5 minutes for inspection, and 10 minutes of
drilling per unit; product B requires 10 minutes of milling, 4minutes for inspection, and 8 minutes of drilling per
unit; and product C requires 8 minutes of milling, 4 minutes forinspection, and 16 minutes of drilling. The
department has 20 hours available during the next period formilling, 15 hours for inspection, and 24 hours for
drilling. Product A contributes $2.40 per unit to profit, product Bcontributes $2.50 per unit, and product C
contributes $3.00 per unit. Determine the optimal mix of productsin terms of maximizing contribution to profits
for the period.
Requirements:
a) Define the decision variables;
b) Show the business objective and objective function;
c) List all constraint equations;
d) Create an EXCEL working sheet for the linear programmingmodel;
e) Provide both Answer and Sentivity reports;
f) Find the range of optimality for the profit coefficient of eachvariable using the reoprts generated.

Answer & Explanation Solved by verified expert

4.1 Ratings (681 Votes)

Define the Decision Variables A is the production quantity of Product A In Units B is the production quantity of Product B In Units C is the production quantity of Product C In Units b Business Objective is to Maximize this See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member