PLEASE ANSWER IT WITH EXCEL. I NEED THAT.

LO 1,4 3-63 Dropping a product Merchant Company manufactures and sells three models of electronic printers. Ken Gail, president of the company, is considering dropping model JT484 from its product line because the company has experienced losses for this product during the past three quarters. The following product-level operating data have been compiled for the most recent quarter: CATEGORY TOTAL IT284 11384 JT4S $1,000,000 600.000 $400,000 S500,000 300,000 $200,000 $200,000 100,000 $100,000 $300,000 200,000 $100,000 Sales Variable costs Contribution margin Fixed costs: Rent Depreciation Utilities Supervision Maintenance Administrative Total fixed costs Operating income (loss) 550,000 60,000 40,000 50,000 30,000 100,000 $330,000 $70,000 $25,000 30,000 20,000 15,000 15,000 30,000 $135.000 $65,000 $10,000 12.000 5,000 5,000 6,000 20,000 $58,000 $42,000 $15,000 18.000 15,000 30,000 9,000 50,000 $137.000 (537.00) In addition, the following information is also available: Factory rent and depreciation will not be affected by a decision to drop model JT484 Quarterly utility bills will be reduced from $40,000 to $31,000 if JT484 isdropped. Supervision costs for JT484 can be eliminated if dropped. The maintenance department will be able to reduce quarterly costs by $7,000 if JT484 is dropped. Elimination of JT484 will make it possible to eliminate two administrative staff positions with combined salaries of $30,000 per quarter. Required (a) Should Merchant Company eliminate JT484? (b) Merchant's sales manager believes that it is important to continue to produce JT484 to maintain a full product line. He expects the elimination of JT484 will reduce sales of the remaining two products by 5% each. Will this information change your answer to part a? Explain