Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE USE EXCEL AND PROVIDE ALL FORMULAS THIS QUESITON MUST BE DONE IN EXCEL A computer plant produces mice, keyboards and flash drives. A mouse

PLEASE USE EXCEL AND PROVIDE ALL FORMULAS THIS QUESITON MUST BE DONE IN EXCEL

image text in transcribed
A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $8.35/ unit, and to produce it takes 0.09 hours of machine time and 0.20 hours of labor. A keyboard has a profit of $13.78 / unit, and to produce it takes 0.15 hours of machine time and 0.31 hours of labor. A flash drive has a profit of $6.10 /unit, and to produce it takes 0.04 hours of machine time and 0.15 hours of labor. Each month, a total of 3,000 hours of machine time and 7,000 hours of labor are available. The maximum monthly demand is 10,000 mice, 28,000 keyboards and 14,000 flash drives. How many of each (to 0 decimal places) should the company make each month to maximize its profit and What is that maximum profit (rounded UP to the nearest integer)

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

Secured Finance Transactions Key Assets And Emergin Markets

Authors: Paul U Ali

1st Edition

1905783108, 978-1905783106

More Books

Students also viewed these Finance questions

Question

=+1. How well known is your organization?

Answered: 1 week ago

Question

Derive expressions for the rates of forward and reverse reactions?

Answered: 1 week ago

Question

Write an expression for half-life and explain it with a diagram.

Answered: 1 week ago

Question

What do you mean by underwriting of shares ?

Answered: 1 week ago

Question

Define "Rights Issue".

Answered: 1 week ago

Question

1. Write down two or three of your greatest strengths.

Answered: 1 week ago

Question

What roles have these individuals played in your life?

Answered: 1 week ago

Question

2. Write two or three of your greatest weaknesses.

Answered: 1 week ago