I need help with this question. Please assist with a detailed answer with calculations (either excel solver or python code). A detailed answer with clear explanations would be helpful to me because I do not want an answer only, I also want to learn the process.

A bicycle shop, Take a Bike, offers bonuses to its sales team for selling more than 4 bicycles in a day. Each salesperson can sell between 0 and 8 bikes per day and has a 40% probability of selling more than 4 bicycles in any given day (60% probability of selling 4 or fewer). If the salesperson sells more than 4 bikes, the probability of selling 5, 6, 7, or 8 bikes is shown below. The bonus that is paid is dependent on the model of each bike sold, each of which has a different probability of sale and bonus payout (also shown below). If the salesperson sells more than 4 bikes, the bonus is paid for each of the bikes sold, not just the number above 4. So if a salesperson sells 6 bikes, the bonus is paid for each of those 6 bikes, not just the 2 above the threshold. Develop a simulation model to calculate the bonus a salesperson can expect in a day. Do not simply calculate expected values for this - use random numbers to determine the number and types of bikes sold. Ensure you iterate your simulation multiple times (between 400 and 20,000).

A bicycle shop, Take a Bike, offers bonuses to its sales team for selling more than 4 bicycles in a day. Each salesperson can sell between 0 and 8 bikes per day and has a 40% probability of selling more than 4 bicycles 1 any given day (60% probability of selling 4 or fewer). If the salesperson sells more than 4 bikes, the probability of selling 5, 6, 7, or 8 bikes 1s shown below. The bonus that 1s paid 1s dependent on the model of each bike sold. each of which has a different probability of sale and bonus payout (also shown below). If the salesperson sells more than 4 bikes. the bonus is paid for each of the bikes sold. not just the number above 4. So if a salesperson sells 6 bikes, the bonus 1s paid for each of those 6 bikes, not just the 2 above the threshold. Develop a simulation model to calculate the bonus a salesperson can expect in a day. Do not simply calculate expected values for this use random numbers to determine the number and types of bikes sold. Ensure you iterate your simulation multiple times (between 400 and 20,000). Number sold|Probability | Model | Portion of total sales 5 A0%