Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2.Use Excel and Solver to find the maximum profit. A manufacturer will be making two new items: Widget X and Widget Y The unit profit

image text in transcribed
2.Use Excel and Solver to find the maximum profit. A manufacturer will be making two new items: Widget X and Widget Y The unit profit for Widget X is $25.00 and the unit profit for Widget Y is $45.00. There are 2 factories available to make the products. Factory 1 cuts the material for each item and requires 3 minutes to make Widget X and 4 minutes to make Viidget Y. It has 450 hours available. Factory 2 puts the pieces together to create the final product and requires 1 minute to finish Widget X and 4 minutes to finish Widget Y. It has 500 hours available. Factory 1 needs at least 3 employees to produce Widget X and 1 employee for Widget Y. The total minimum employees required is 75. Factory 2 needs at least 2 employees to produce Widget X and 3 employees for Widget Y. The total minimum employees required is 45. There is strong competition in this industry. The company has decided to create a strong marketing campaign. It is estimated that achieving a production and sales rate of Widget x per week will require weekly marketing cost of X2. The corresponding marketing costs for Widget Yare estimated to be 3Y Thus, the objective function in the model should be: Profit - 25x + 45Y - X2-3Y deskton rather than

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

Financial And Managerial Accounting Working Papers Volume 1

Authors: Belverd E. Needles

6th Edition

0618102337, 978-0618102334

More Books

Students also viewed these Accounting questions

Question

1. What is an effective strategy for writing a routine request?

Answered: 1 week ago