Questions from Business Analytics


Q: David Lee is a soft drinks stallholder at Cotton Tree Park.

David Lee is a soft drinks stallholder at Cotton Tree Park. He must decide how many soft drink cartons to order for the coming season. Each bottle of soft drink costs $2.50 and is sold for $4.80. No i...

See Answer

Q: Dean Kuroff started a business of rehabbing old homes. He recently

Dean Kuroff started a business of rehabbing old homes. He recently purchased a circa-1800 Victorian mansion and converted it into a three-family residence. Yesterday, one of his tenants complained tha...

See Answer

Q: Modify the data in the Base Data worksheet in the Excel file

Modify the data in the Base Data worksheet in the Excel file Credit Risk Data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is...

See Answer

Q: Many automobile dealers advertise lease options for new cars. Suppose that

Many automobile dealers advertise lease options for new cars. Suppose that you are considering three alternatives: 1. Purchase a car outright with cash. 2. Purchase a car with 20% down and a 48-month...

See Answer

Q: Perform a sensitivity analysis of David Lee’s soft drinks stall scenario.

Perform a sensitivity analysis of David Lee’s soft drinks stall scenario. Find the optimal order quantity and optimal expected profit for probabilities of a cold weather ranging from 0.2 to 0.8 in inc...

See Answer

Q: IM Retail deals in various products from a popular cosmetic brand Beau

IM Retail deals in various products from a popular cosmetic brand Beau. The cost of stocking and selling a product varies according to whether it is in season or not. In season, the cost of a product...

See Answer

Q: For the payoff table you developed in Problem 1, determine the

For the payoff table you developed in Problem 1, determine the decision using the aggressive, conservative and opportunity-loss strategies. Data from Problem 1: Use the Outsourcing Decision Model Exc...

See Answer

Q: Ravex Yacht has developed a new cabin cruiser, which they have

Ravex Yacht has developed a new cabin cruiser, which they have earmarked for the medium to large boat market. A market analysis suggests a 30% probability of annual sales being 5,000 boats, 40% probab...

See Answer

Q: Drilling decisions by oil and gas operators involve intensive capital expenditures made

Drilling decisions by oil and gas operators involve intensive capital expenditures made in an environment characterized by limited information and high risk. A well site is dry, wet, or gushing. Histo...

See Answer

Q: MetaGo is a small metal parts manufacturer. It has two automatic

MetaGo is a small metal parts manufacturer. It has two automatic machines (Machine A and Machine B) for daily production processes. Both the machines can produce defective metal parts. Historically, t...

See Answer