Icon

CS-141 Crack the Competitive Strategy Game CSG - Part 01 Willingness To Pay v05

[Case Studies] CS-141 Crack the Competitive Strategy Game (CSG) - Part 01 Willingness To Pay
Case Study (CS-141) - Crack the Competitive Strategy Game (CSG) - Part 01Calculating the Willingness To Pay (WTP) of CustomersThe Competitive Strategy Game (CSG) was developed by Professor SeverinBorenstein at the Haas School of Business, UC Berkeley. The CSG simulateseight Competitors competing in four different Markets.Cracking the CSG (Part 01) involves calculating the Customer Willingness To Pay(WTP) Matrix for each Product in a single Market using the public informationprovided at the beginning of the game. Step 1: Copy the public data from the CSG into the companion Excel spreadsheetStep 2: Copy the formatted data from Excel into the top 'Table Creator' node.Step 3: Tune the Market against the public data for Firm 1 / 2 / 3 / 4.Step 4: Extract the Tuning Parameters: (a) Market Mean = 0.0 (b) Market Standard Deviation (SD) (c) Market CorrelationStep 5: Generate a WTP Matrix for the 8 Products in the MarketStep 6: Copy-and-Paste the WTP Matrix into the 'Part 02' workflow: [CS-142 - Crack the Competitive Strategy Game CSG - Part 02] Enter Data: Enter Data: Each output row (C00001 - C20000) from thebottom WTP Matrix contains the Willingness ToPay (WTP) for each of the 20,000 Customers inthe Market. Copy-and-Paste this data into the 'Part02' Market Simulation workflow.Market ArrayCopy-and-Pastefrom ExcelGenerate CustomerWTP Matrixfor 4 x ProductsKPIMarket ResultsCleanMarket ResultsKPIMarket Results8 x Product NamesCopy fromPublic DataMarketMeanMarketSD8 x ProductsColumns8 x ProductsColumnsDefaultCorrelationColumns x RowsEmpty CorrelationMatrixEmptyColumnsEmptyCorrelationPairsFillCorrelationPairsMarketCorrelationMatrixGenerate CustomerWTP Matrixfor 8 x ProductsConvert Market Size to IntegerNumber of CustomersWTPHistogramSaveWTP MatrixKPIFlow Variables Table Creator Tune Scenarios Row Filter Column Filter RowID Table Creator ConstantValue Column ConstantValue Column Transpose RowID ConstantValue Column Concatenate Row Filter CorrelationMatrix To Pairs ConstantValue Column CorrelationPairs To Matrix MatrixDistributions Java Edit Variable Histogram Chart(JFreeChart) Excel Writer Table Columnto Variable Case Study (CS-141) - Crack the Competitive Strategy Game (CSG) - Part 01Calculating the Willingness To Pay (WTP) of CustomersThe Competitive Strategy Game (CSG) was developed by Professor SeverinBorenstein at the Haas School of Business, UC Berkeley. The CSG simulateseight Competitors competing in four different Markets.Cracking the CSG (Part 01) involves calculating the Customer Willingness To Pay(WTP) Matrix for each Product in a single Market using the public informationprovided at the beginning of the game. Step 1: Copy the public data from the CSG into the companion Excel spreadsheetStep 2: Copy the formatted data from Excel into the top 'Table Creator' node.Step 3: Tune the Market against the public data for Firm 1 / 2 / 3 / 4.Step 4: Extract the Tuning Parameters: (a) Market Mean = 0.0 (b) Market Standard Deviation (SD) (c) Market CorrelationStep 5: Generate a WTP Matrix for the 8 Products in the MarketStep 6: Copy-and-Paste the WTP Matrix into the 'Part 02' workflow: [CS-142 - Crack the Competitive Strategy Game CSG - Part 02] Enter Data: Enter Data: Each output row (C00001 - C20000) from thebottom WTP Matrix contains the Willingness ToPay (WTP) for each of the 20,000 Customers inthe Market. Copy-and-Paste this data into the 'Part02' Market Simulation workflow.Market ArrayCopy-and-Pastefrom ExcelGenerate CustomerWTP Matrixfor 4 x ProductsKPIMarket ResultsCleanMarket ResultsKPIMarket Results8 x Product NamesCopy fromPublic DataMarketMeanMarketSD8 x ProductsColumns8 x ProductsColumnsDefaultCorrelationColumns x RowsEmpty CorrelationMatrixEmptyColumnsEmptyCorrelationPairsFillCorrelationPairsMarketCorrelationMatrixGenerate CustomerWTP Matrixfor 8 x ProductsConvert Market Size to IntegerNumber of CustomersWTPHistogramSaveWTP MatrixKPIFlow VariablesTable Creator Tune Scenarios Row Filter Column Filter RowID Table Creator ConstantValue Column ConstantValue Column Transpose RowID ConstantValue Column Concatenate Row Filter CorrelationMatrix To Pairs ConstantValue Column CorrelationPairs To Matrix MatrixDistributions Java Edit Variable Histogram Chart(JFreeChart) Excel Writer Table Columnto Variable

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Berlin
Created at: 2018-10-22
On NodePit since: 2021-02-05
Last update: 2024-04-26
Created with KNIME version: v4.3.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!