Question
Your company produces two types of computers, laptops and desktops. Each laptop sold produces a profit of $40 and each desktop produces a profit of
Your company produces two types of computers, laptops and desktops. Each laptop sold produces a profit of $40 and each desktop produces a profit of $60. You need to consider two separate resources for building laptops and desktops: the amount of labor and assembly time required in the production process. Each laptop requires 4 hours of labor and 12 minutes of assembly time while each desktop requires 6 hours of labor and 4 minutes of assembly time. You have 40 hours of labor available and 60 minutes of assembly time. You can sell every laptop and desktop you produce. Formulate the linear programming model in Excel to solve the problem. Two possible optimal solutions are: produce 0 Laptops and 6.66667 Desktops for a profit of $400 produce 3.5714 Laptops and 4.2857 Desktops for a profit of $400. If you want to produce exactly 5.57 Desktops. How many Laptops would you need to produce to keep your new solution optimal?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started