Optimization2

xlsx

School

Thompson Rivers University *

*We aren’t endorsed by this school

Course

6250

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by AdmiralComputer13551

31988918de510929ba1d0c3705b8d4efad8aafc4.xlsx Profit Product Mice Keyboards Joysticks What would be the revised maximum profit if you had 1 extra hour of machine time = ### 0.00% Profit/unit $ 8.00 $ 11.00 $ 9.00 What would be the revised maximum profit if you had 1 extra hour of labour = ### 0.01% Labor usage/unit 0.200 0.300 0.240 What would be the revised maximum profit if I had to manufacture all 29,000 Keyboards = ### ### Machine time/unit 0.040 0.055 0.040 Monthly Demand 15,000 29,000 11,000 Number 15,000 24,533 11,000 Profit $ 488,863 Available: Labour Used 13,000 13,000 Machine Time Used 2,389 3,000 Problems From Chapter #29 Using Solver to Determine the Optimal Product Mix Problem #2: A computer manufacturing plant produces mice, keyboards, and video game joysticks. The per-unit profit, per-unit labor usage, monthly demand, and per-unit machine-time usage are given in the following table: Each month, a total of 13,000 labour hours and 3,000 hours of machine time are available. How can the manufacturer maximize its monthly profit contribution from the plant? % Change from original profit Set up and solve this model and find the maximum profit that can be made. Put your answer in the space below. In additional answer the three marginal insight questions. - insights are always based off the original model so make sure you return to the original setting each time - You might want to copy the model down below and use this to get your insights that way your original model is always correct. - you will also have to copy and paste as values for each insight so you remove the formulas ANSWER:

Discover more documents: Sign up today!

Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

WEEK 14 ASSIGMENT ECO 252-02 W.docx

WEEK 3 ASSIGMENT ECO 252-02 W.docx

WEEK 2 ASSIGMENT ECO 252-02 W.docx

Lec 1 Exercise.pdf

Optimization1.xlsx

Optimization5.xlsx

MAC Salary Report.docx

Mastered Report.docx

Module 6 Discussion.docx

GP1-Group 12-Checked.xlsx

Review Test Submissio3.docx

Results & discussion.docx

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach

Economics

ISBN:9781337106665

Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:Cengage Learning

Microeconomics: Principles & Policy

Economics

ISBN:9781337794992

Author:William J. Baumol, Alan S. Blinder, John L. Solow

Publisher:Cengage Learning

Managerial Economics: Applications, Strategies an...

Economics

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:Cengage Learning

Exploring Economics

Economics

ISBN:9781544336329

Author:Robert L. Sexton

Publisher:SAGE Publications, Inc

Micro Economics For Today

Economics

ISBN:9781337613064

Author:Tucker, Irvin B.

Publisher:Cengage,

Survey Of Economics

Economics

ISBN:9781337111522

Author:Tucker, Irvin B.

Publisher:Cengage,

SEE MORE TEXTBOOKS

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Microeconomics: Principles & Policy
Economics
ISBN:9781337794992
Author:William J. Baumol, Alan S. Blinder, John L. Solow
Publisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Exploring Economics
Economics
ISBN:9781544336329
Author:Robert L. Sexton
Publisher:SAGE Publications, Inc
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,