Please do problem 5.2. Show work using excel.

Problems Note: Px means the problem may be solved with POM for Windows and/or Excel OM. - +++++++++ ............... the life cycle, identify a reasonable operations strategy for each: Problems 5.1-5.3 relate to Goods and Services Selection ... 5.1 Prepare a product-by-value analysis for the follow- ing products, and given the position in its life cycle, identify the issues likely to confront the operations manager and his or her possible actions. Product Alpha has annual sales of 1,000 units and a contribution of $2,500; it is in the introductory stage. Product Bravo has annual sales of 1,500 units and a contribu- tion of $3,000; it is in the growth stage. Product Charlie has annual sales of 3.500 units and a contribution of $1,750; it is in the decline stage. .. 5.2 Given the contribution made on each of the three products in the following table and their position in PRODUCT CONTRIBUTION (% OF SELLING PRICE) COMPANY CONTRIBUTION (%: TOTAL ANNUAL CONTRIBUTION DIVIDED BY TOTAL ANNUAL SALES) PRODUCT Smart Watch POSITION IN LIFE CYCLE Introduction 30 40 Tablet 30 50 Growth Hand calculator 50 10 Decline Problems Note: Px means the problem may be solved with POM for Windows and/or Excel OM. - +++++++++ ............... the life cycle, identify a reasonable operations strategy for each: Problems 5.1-5.3 relate to Goods and Services Selection ... 5.1 Prepare a product-by-value analysis for the follow- ing products, and given the position in its life cycle, identify the issues likely to confront the operations manager and his or her possible actions. Product Alpha has annual sales of 1,000 units and a contribution of $2,500; it is in the introductory stage. Product Bravo has annual sales of 1,500 units and a contribu- tion of $3,000; it is in the growth stage. Product Charlie has annual sales of 3.500 units and a contribution of $1,750; it is in the decline stage. .. 5.2 Given the contribution made on each of the three products in the following table and their position in PRODUCT CONTRIBUTION (% OF SELLING PRICE) COMPANY CONTRIBUTION (%: TOTAL ANNUAL CONTRIBUTION DIVIDED BY TOTAL ANNUAL SALES) PRODUCT Smart Watch POSITION IN LIFE CYCLE Introduction 30 40 Tablet 30 50 Growth Hand calculator 50 10 Decline