Create spreadsheet model for the number of cars

Assignment Help Business Management
Reference no: EM132829019

Case R12-29

The owner of a local car dealership has just received a call from a regional distributor stating that a $5,000 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 one day). The owner determined that, on average, about 1 out of 10 customers who look at cars at the dealership actually purchase a caror, a 0.10 probability (or 10% chance) exists that any given customer will buy a new car.

1. Create spreadsheet model for the number of cars the dealership might sell next Saturday.

2. What is the probability that the dealership will earn the $5,000 bonus?

3. 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?

Reference no: EM132829019

Questions Cloud

Where is dollarama inc in the bcg matrix : Where is dollarama inc in the BCG MATRIX? are they cash cow, star, question mark or a dog? and could you please explain why
Organization information technology effort : How does the data mining approach and concept flow to BI solutions and the enterprise level of an organization's information technology (IT) effort?
Discuss why employment be based on meritocracy : Discuss why employment be based on meritocracy, need, or affirmative action-type policies designed to bring about greater diversity?
Examine major theoretical approaches and research methods : Examine the major theoretical approaches, research methods, and assessment instruments used in the five perspectives of personality. Evaluate and describe the.
Create spreadsheet model for the number of cars : 1. Create spreadsheet model for the number of cars the dealership might sell next Saturday.
Compute the standby charge and operating cost benefits : Original cost of the vehicle to the employer, including HST: $26,000. Compute the standby charge AND operating cost benefits for 2020
Case study-soda company : You are the claims adjuster for Insurance Company. One of your insureds, Soda Company, has suffered a loss. Soda Company is insured under a Commercial General L
How might approach an active duty military personnel : How might you approach an active duty military personnel who might be resistant to including specific details of his or her family care plan?
Facebook-data privacy dilemma : In 2018, Facebook founder and CEO Mark Zuckerberg came under fire from lawmakers, testifying before a U.S. congressional hearing, for the Facebook data-privacy

Reviews

Write a Review

Business Management Questions & Answers

  Bank in the loans department

You have just taken a job at a bank in the loans department. Your bank is worried about the current economic climate and the potential to limit the real rate of interest they will earn on new loans.

  Reduce the negative effect of csr

What are the possible solutions to reduce the negative effect of CSR?

  Why can people avoid paying an excise tax more readily

Why can people avoid paying an excise tax more readily than they can avoid paying a sales tax?

  Reason for developing a contingency plan

Define what a contingency plan is and provide at least one reason for developing a contingency plan.

  Research a topic on some aspect of professional communicate

You will individually research a topic on some aspect of professional communication.  You will then prepare a 1–2 page outline using thestandard outline format (shown below) that would be used in a training session.  At the end of your outline you mu..

  What type of property does it cover or protect

What is a patent? What type of property does it cover or protect? How are patents helpful? Please explain. How are patents harmful? Please explain.

  Diverse workforce

Assume that an employer wants a diverse workforce, but does not have many diverse candidates apply for open positions.

  Dividends during the current period

How would you know whether the company you are considering to invest in has repurchased any of its own stock and/or issued stock dividends

  List four types of organizational structure

List four factors that influence how successful the companies in an industry cluster will be when they compete internationally.

  Discuss the three ways in which textiles can be recycled

Discuss the three ways in which textiles can be recycled. Why is it preferable to reuse rather than recycle textiles?

  Why are rolling forecasts valuable

Why are rolling forecasts valuable? at least 10 reasons

  Is the negotiated agreement a valid one

(a) What is this agreement called? (b) Is the negotiated agreement a valid one? (c) What guidelines would a court follow in assessing its enforceability?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd