Solve using excel LP solver

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. A B 1 KARMA COMPUTER 2 Decision Variables S D 3 Quantity PROFIT 4 Contrib. Margin $300 $400 L 5 Subject To: LHS RHS Slack 6 Schas Constr