A PC manufacturer has a ROI minimum threshold of 50% for new investments. It estimates the following costs for the next model of laptop to be introduced: o R&D costs for year 1: $500,000 o Design costs for year 2: $1,750,000 o Production costs for years 2-5: $650,000, $750,000, $800,000 and $700,000 respectively o Marketing costs for years 2-5: $650,000, $600,000, $500,000 and $150,000 respectively o Transportation and Warehousing costs for years 2-5: $300,000, $320,000, $270,000 and $180,000 respectively o Customer Service costs for years 2-5: $120,000, $220,000, $190,000 and $160,000 respectively o End-of-life costs for years 4-5: $550,000 and $1,200,000 respectively The manufacturer expects a sales volume for the years 2-5: 10,000, 18,000, 25,000 and 7,500 respectively and sales revenue: $2,700,000, $4,500,000, $7,300,000 $1,800,000 respectively I. Build and attach the LCC study spreadsheet you use to calculate the following items without considering the time value of money, and show on the following pages the formula and results for: 1. Life Cycle Unit Cost 2. Life Cycle Unit Revenue Life Cycle Unit Profit Break-even Year Return on Investment Does the ROI meet the minimum threshold