Question
SOLVE FOLLOWING QUESTION IN EXCEL SOLVER The owner of a local car dealership has just received a call from a regional distributor stating that a
SOLVE FOLLOWING QUESTION IN EXCEL SOLVER
The owner of a local car dealership has just received a call from a regional distributor stating that a $5000 bonus will be awarded if the owner's dealership sells at least 10 new cars next Saturday. On an average Saturday, this dealership has 75 potential customers look at new cars, but there is no way to determine exactly how many customers will come this particular Saturday. The owner is fairly certain that the number would not be less than 40, but also thinks it would be unrealistic to expect more than 120 (which is the largest number of customers to ever show up in 1 day). The owner determined that, on average, about one out of ten customers who look at cars at the dealership actually purchase a car - or, a .10 probability (or 10% chance) exists that any given customer will buy a new car. a. Create a spreadsheet model for the number of cars the dealership might sell next Saturday b. What is the probability that the dealership will earn the $5000 bonus? c. If you were this dealer, what is the maximum amount of money you would be willing to spend on sales incentives to try to earn this bonus?
Need all parts solved in excel solver.
Requirements: Model structure Name usage Comments Formulas Completeness Solution Analysis / Interpretation Graphical analysis Tabular Analysis Measures calculation Extensions Color subdivision Groupings Graphics
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started