Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $8.00/unit, and to produce it takes 0.4 hours of labor

A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $8.00/unit, and to produce it takes 0.4 hours of labor and .04 hours of machine time. A keyboard has a profit of $11.00/unit, and to produce it takes 0.3 hours of labor and .09 hours of machine time. A flash drive has a profit of $10.00/unit, and to produce it takes 0.25 hours of labor and .04 hours of machine time. Each month, a total of 13,000 hours of labor and 2,500 hours of machine time are available. The maximum monthly demand is 14,000 mice, 24,000 keyboards and 13,000 flash drives. How many of each should the company make each month to maximize its profit and what is that maximum profit? Include your spreadsheet with any formulas noted. Also include a list of the constraints you used.

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

Succeeding in Business with Microsoft Excel 2013 A Problem Solving Approach

Authors: Debra Gross, Frank Akaiwa, Karleen Nordquist

1st edition

978-1285099149, 9781285963969, 1285099141, 1285963962, 978-1285715346

More Books

Students also viewed these Finance questions

Question

1.. What are the four main purposes service environments fulfill?

Answered: 1 week ago

Question

LO13.1 List the characteristics of monopolistic competition.

Answered: 1 week ago