Business Data Model

Topics: Standard deviation, Arithmetic mean, Normal distribution Pages: 9 (3130 words) Published: December 7, 2010
Business Decision Models ____________________________________________________________


Question 1 (10 marks)
Sandra Enright of Techtronics Inc., an electronics supply firm, has been examining the times required for stock pickers to fill orders requested from inventory. She has determined that individual order-filling times approximately follow a normal distribution with a mean value of 3.2 minutes and standard deviation of 68 seconds. a)What is the probability that a randomly selected order will require more than three minutes? b) What is the probability that a randomly selected order will require less than two minutes? c) What is the probability that a randomly selected order will require between two and three minutes? d) Sandra is considering a quality assurance that 95% of orders will be filled within a specified time. What time should she specify?

Question 2 (15 marks)

Gerald Black of BlackFly Airline has an exclusive contract to run flights of a four-passenger aircraft to a remote mining center. His contract requires him to fly if there are any passengers wanting to make the trip. His fixed costs per day are $400.00, his fixed costs per flight are $1,200.00, the variable cost per passenger is $25.00, and he charges $850.00 per passenger.

He has tracked the number of passengers who flew with him over the past sixty days. His findings are summarized in the following table: Number of Passengers| 0| 1| 2| 3| 4|
Number of Days| 5| 12| 15| 21| 7|
Of course, he does not fly on days with zero passengers. Assume that this sample gives a good approximation to his future demand patterns. Let G be the random variable: profit on a future day. a) Calculate the Expected Value, E[ G ], Variance, 2[ G ] and standard deviation, [ G ], of his future daily profit. [Hint: You can calculate a profit corresponding to each number of passengers. The probabilities of those profits are then determined by the probabilities of the numbers of passengers.] b) Comment briefly on the profitability and volatility of Gerald’s business.

Question 3 (15 marks)

Local development initiatives often use estimates of the daily expenditures of tourists to justify expenses incurred in supporting local events. Some years ago, the City of Kingston hosted a Tall Ships weekend, which cost the City some $850,000. To justify this expense, suppose that the City conducted a survey of 30 out-of-town visitors, asking them the grand total of what they spent during their visit to Kingston, and how many days they visited. The data are contained in the file visitor expenditures.xlsx, and are summarized below. a. What is a 95% confidence interval for the average daily expenditure by visitors to Kingston, based on these data? Interpret the meaning of your interval, in English. b. The Mayor of Kingston at the time, Ms. Turner, had stated that “the average visitor to Kingston spends $100 per day in the local economy”. Set up Ms. Turner’s comment as a hypothesis test, and use the data to establish whether her statement can be refuted, or not. c. Some visitors to Kingston are Canadian, and some from other parts of the world. A sample of 200 visitors on this weekend revealed that 120 were Canadian, and 80 from elsewhere. What is a 95% confidence interval for the proportion of visitors who are Canadian on a weekend such as this? d. The Mayor had also stated that “more than 50% of the visitors to Kingston are Canadians”. Set up this statement by the Mayor in a hypothesis test framework, and use the data to determine if her statement can be refuted, or not.

Question 4 (10 marks)

Fast Computers Inc. supplies made-to-order personal computers through direct (telephone and online) sales channels. A key competitive feature of its business is the delivery time – the time lapse between receipt of an order...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Data Warehouse
  • Data Base Mangement System Essay
  • Procedure for Preparing Data Flow Diagram Essay
  • System Concepts for Data Modeling Essay
  • Data Scientist Career path Essay
  • Data Resource Management Essay
  • Business Model Essay

Become a StudyMode Member

Sign Up - It's Free