Questions from Business Analytics

Q: A stockbroker calls on potential clients from referrals. For each call

A stockbroker calls on potential clients from referrals. For each call, there is a 20% chance that the client will decide to invest with the stockbroker’s firm. Forty percent of thos...

Q: Cinéma Le Méliès is a small movie theatre in Grenoble, France

Cinéma Le Méliès is a small movie theatre in Grenoble, France. After the release of a widely anticipated Marvel movie, like the Avengers: Endgame, the number of adult and children’s tickets sold at th...

Q: J&G Bank receives an average of 30,000 credit

J&G Bank receives an average of 30,000 credit card applications each month. Approximately 60% of them are approved. Each customer charges an average of $2,000 to his or her credit card each month. App...

Q: With the growth of digital photography, a young entrepreneur is considering

With the growth of digital photography, a young entrepreneur is considering establishing a new business, Wild World Photography. She estimates that the average number of safari trail bookings per ye...

Q: An auditor found an expense receipt for $179.24 without

An auditor found an expense receipt for $179.24 without a name. Write a left table lookup function that would identify the sales rep in the Travel Expenses database.

Q: The wedding banquet prices at a famous hotel in Singapore continue to

The wedding banquet prices at a famous hotel in Singapore continue to increase on a yearly basis. The booking volume this year is estimated to be at 3,000 tables (for 10 persons per table) and is pr...

Q: The board of directors of Bolt Electric Vehicles (BEV) is

The board of directors of Bolt Electric Vehicles (BEV) is considering replacing its original model, the BEV Neo, with a new model, the BEV-Alpha, which they feel will appeal to the younger demographic...

Q: Few companies take the time to estimate the value of a good

Few companies take the time to estimate the value of a good customer (and often spend little effort to keep one). Suppose that a customer at a restaurant spends, on average, R per visit and comes F ti...

Q: Adam is 24 years old and has a 401(k)

Adam is 24 years old and has a 401(k) plan through his employer, a large financial institution. His company matches 50% of his contributions up to 6% of his salary. He currently contributes the maximu...

Q: Jennifer Bellin has been put in charge of planning her company’s annual

Jennifer Bellin has been put in charge of planning her company’s annual leadership conference. The dates of the conference have been determined by her company’s exe...