Problem 1:-“George's New Hair Salon”George is having trouble finding the compensation structure for the employees. The challenge is to find salaries using a decision support tool. Solution: finding the break-even point in the number of jobs, i.e. n. of haircuts will help George assign the pay structure to the hairstylists. Scenario 1: Prerequisite: - Flat rate of $40 per hour. The salary is obtained by multiplying the hourly wage and the planned working hours. Formula used in Excel referring to in the screenshot below (cells), C6*C7*C8 The total annual cost for George is $470,000 (fixed annual cost + salary for employees) including salary for employees as shown in the screenshot below. The total annual cost for George is $470,000 (fixed annual cost + salary for employees) including salary for employees as shown in the screenshot below. Using the “What if” feature, click “Goal Search Analysis” to find the no. of haircuts.Total no. of haircuts = 9171 Scenario 2:-Prerequisite: - Fixed hourly rate of $20 per hour + a commission on each haircut equal to 20% of the cost of the haircut. 20% of the cost of the haircut can be calculated by 0.2 multiplied by Haircut cost for men. Similarly it can be calculated for women. Break-even point i.e. the no. of haircuts can be found using the target search analysis. The total cost can be calculated in Excel using the following formula: -C23+(1600*5*20)+(C27*C34*C29)+(C34*C28*C30) Revenue can be calculated as shown in the formula(C34* C24*C27)+(C34*C28*C25)(Total # of haircuts * Haircut – Men * Expected ratio men:women (men)) +(Total # of hair cuts * Haircut – Women * Expected men: women Relationship (women))...... middle of paper......approach. This is why decisions support tools or techniques are created for the betterment of the bank or other businesses. Furthermore, lift curves are also generated to show the comparison of values. These results are useful for the company to make a decision based on this report. To best predict the company's future, we need the best possible approaches or outcomes that give the organization the most profit. These approaches lay a solid foundation for achieving a company's goal. To conclude, “logistic regression” is a much better approach than other approaches. This provides better value-enabled performance that leads to a higher level of marketing and customers respond more broadly. We can witness a consistent approach, so it is confirmed by showing the high value of the area.