Question: please answer part C in excel format. 4-49. Karma Computers produces two computer models, Standard and Deluxe. A Standard model is produced by assembling a
please answer part C in excel format.
4-49. Karma Computers produces two computer models, Standard and Deluxe. A Standard model is produced by assembling a single disk drive with a Standard Chassis. A Deluxe model is produced by assembling two disk drives with a Deluxe Chassis. The Standard model has a net profit per unit of $300 while the Deluxe model has a net profit per unit of $400. The current inventory of Karma consists of 60 Standard Chassis, 50 Deluxe Chassis and 120 Disk Drives. (a) Formulate the Karma LP model. (b) Optimize the Karma model and use that result to fill in the missing values in the blank cells of the worksheet in Figure 4.22. B D EF G 1 KARMA COMPUTER 2 Decision Variables S D 3 Quantity PROFIT 4 Contrib. Margin $300 $400 5 Subject To: LHS RHS Slack 6 Schas Constr 1 s 60 7 Dchas Constr s 50 8 Ddrive Constr (c) Use the results from the worksheet above to fill in the missing values for Final Value and Constraint R.H. Side in the blank cells of the Karma model Sensitivity Report below. Next, determine the values of the remaining missing cells in the Sensitivity Report in Figure 4.23. Microsoft Excel 16.0 Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $813 Quantity s 300 $C03 Quantity D 400 200 400 Constroints Final Shadow Constraint Allowable Allowable Cell Name Value Price RH. Side Increase Decrease D36 Sches Constr LHS 60 60 D37 Dchas Constr LHS 50 20 DB Ddrne Constr LHS 50

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
