MAXIMIZING PROFIT: CUSTOM GAMING PCs You are the owner of a mid-sized computer manufacturing and assembling facility...

60.1K

Verified Solution

Question

Basic Math

MAXIMIZING PROFIT: CUSTOM GAMING PCs

You are the owner of a mid-sized computer manufacturing andassembling facility – what started as a small business building andcustomizing computers for friends and family has grown into a muchlarger operation, and you want to make sure you are using yourlabor hours in the most efficient way to maximize your profits.Your company manufactures and assembles three types of customgaming PCs, and the amount of manufacturing and assembling timesrequired for each model along with the profit you make on each unitare given below:

Model Name

Manufacturing Time (in hours)

Assembling Time (in hours)

Profit
(per unit sold)

Dendrite Ice

2

2

$280

Neuron Pro

3

2

$320

Axon Glacier Pro

2

4

$400

Your labor budget each week is 1,000 hours of totalmanufacturing time, and 1,600 hours of assembly time. How many ofeach type of custom gaming PC should you task your teams withcreating each week to maximize your profit?

1. Provide the solution to your completed tableau, listing thevalues for each variable (including any slack variables) and theobjective function. Finally, state the solution in terms of ouroriginal problem: how many of each type of custom gaming PC shouldyour teams manufacture each week in order to maximize yourprofits?

Answer & Explanation Solved by verified expert
3.6 Ratings (574 Votes)
We will help this problem with the help of Excel SolverWe are given with the constraints and the function which is tobe maximizedLet us load the data into Excel which is as followsModel NameManufacturing Time in hoursAssembling Time in hoursProfit per unit soldLimitsDendriteIce22280NeuronPro32320AxonGlacier    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students