Question

1. COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and Pro modelThe problem is formulated and solved in Excel Solver as follows. Decision variables: X1 = Number of Student models produced eModel in Excel: G6 - A =SUMPRODUCT($C$4:$F$4,06:56) A B C D E F 1 MVC ENTERPRISES G H I Student 325 Plus 100 Net 375 Pro 425Sensitivity report: Adjustable Cells Cell Name $C$4 Production Student $D$4 Production Plus $E$4 Production Net $F$4 Producti

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

Optimal weekly production schedule:

Production Student = 325
Production Plus = 100
Production Net = 375
Production Pro = 425

Optimal weekly profit = 143250

b)

Allowable decrease of Production plus is 55 which means minimum profit => lower range of optimality => 80-55 = 25 for which optimal quantity production for Production plus will remain same as calculated in part a)

c)

Yes MVC should do this as shadow price of 17 in monitor total is 25 and this is valid for another 100 17 inch monitors. This means for every additional unit profit will increase by 25 which is more than the cost to do it which is 15

d)

No MVC should not do this as there is slack in production hours total constraint which means that the available production hours is not utilized so no point in increase production hours by hiring additional worker

Add a comment
Know the answer?
Add Answer to:
1. COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT