{"id":987,"date":"2023-03-01T22:58:11","date_gmt":"2023-03-01T22:58:11","guid":{"rendered":"https:\/\/kpwalters.com\/?page_id=987"},"modified":"2023-08-14T14:42:53","modified_gmt":"2023-08-14T14:42:53","slug":"pricing-model","status":"publish","type":"page","link":"https:\/\/kpwalters.com\/index.php\/data-analyst\/pricing-model\/","title":{"rendered":"Pricing model"},"content":{"rendered":"\n
\n
Pricing model<\/h5><\/div>\n<\/div>\n\n\n\n
\n
\n

February 20, 2023<\/em>
 <\/p>\n\n\n\n

Summary
Outcome<\/a>
Project Steps<\/a>
Project Files<\/a><\/p>\n<\/div>\n\n\n\n

\n
Summary<\/h5><\/div>\n\n\n\n

A technology company wished to change its prices. It needed a more flexible and scalable model. Prices were based on a set number of licenses for its products; customers were required to order a particular quantity of licenses, thereby either ordering more licenses than they needed or doing without a certain number of licenses. In addition, competitive analysis suggested that their prices were too high at the upper and lower tiers of the market, and too low in the middle tier.<\/p>\n\n\n\n

\"\"<\/a><\/figure><\/div>\n\n\n\n

This project creates a flexible pricing model by basing the pricing algorithm on a polynomial function derived from curve fitting in Microsoft Excel.<\/p>\n<\/div>\n\n\n\n

\n

Microsoft Excel<\/em><\/p>\n<\/div>\n<\/div><\/div>\n\n\n\n

\n
<\/div>\n\n\n\n
\n
Outcome<\/h5><\/div>\n\n\n\n

The project produced a dashboard in which agents could enter the desired number of licenses and have the dashboard provide a price.<\/p>\n\n\n\n