Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. A ball point pen manufacturing company makes three models of ball point pens. Requirements for each lot of pens for each model are

image text in transcribed

3. A ball point pen manufacturing company makes three models of ball point pens. Requirements for each lot of pens for each model are given below. Economy Model Super Model Premium Model Available Plastic 3 4 4 800 units Ink Assembly Molding Time 3 4 6 1120 units 4 3 8 1200 hours The profit for the economy model is $900 per lot. The profit for the super model is $1150 per lot and the profit for the premium model is $1600 per lot. How many lots of each model should the company manufacture to maximize the total profit? (a) Formulate a linear optimization model for this problem. (b) Solve this model by using the Excel Solver. Include Excel output with your answer. (c) Determine the optimal solution. Interpret and make recommendations based on the optimal solution.

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_2

Step: 3

blur-text-image_3

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

Survey of Accounting

Authors: Carl S Warren

5th Edition

9780538489737, 538749091, 538489731, 978-0538749091

More Books

Students also viewed these Accounting questions