A random sample of 100 customers was chosen in a market between 3:00 and 4:00 PM on a Thursday afternoon. The frequency distribution below shows the distribution for checkout time, in minutes.
Checkout Time
1.0-1.9
2.0-2.9
3.0-3.9
4.0-5.9
6.0-6.9
Frequency
8
22
Missing
Missing
Missing
Cumulative Relative Frequency
Missing
Missing
0.84
0.98
1.00

(a) Complete the frequency table with frequency and cumulative relative frequency. Express the cumulative relative frequency to two decimal places

(b) What percentage of checkout times was less than 3 minutes?

(c) Which of the following checkout time groups does the median of this distribution belong to? 1.0-1.9, 2.0-2.9, 3.0-3.9, 4.0-5.9, 6.0-6.9

A random sample of 100 customers was chosen in a market between 3:00 and 4:00 PM on a Thursday afternoon. The frequency distribution below shows the distribution for checkout time, in minutes.
Checkout Time
1.0-1.9
2.0-2.9
3.0-3.9
4.0-5.9
6.0-6.9
Frequency
8
22
Missing
Missing
Missing
Cumulative Relative Frequency
Missing
Missing
0.84
0.98
1.00

(a) Complete the frequency table with frequency and cumulative relative frequency. Express the cumulative relative frequency to two decimal places

(b) What percentage of checkout times was less than 3 minutes?

(c) Which of the following checkout time groups does the median of this distribution belong to? 1.0-1.9, 2.0-2.9, 3.0-3.9, 4.0-5.9, 6.0-6.9

#3 A regional automobile dealership sent out fliers to prospective customers indicating that they had already won one of three different​ prizes: an automobile valued at ​$21000​, a ​$125 gas​ card, or a ​$5 shopping card. To claim his or her​ prize, a prospective customer needed to present the flier at the​ dealership's showroom. The fine print on the back of the flier listed the probabilities of winning. The chance of winning the car was 1 out of 31,324​, the chance of winning the gas card was 1 out of 31,324 comma and the chance of winning the shopping card was 31,322 out of 31, 324. Complete parts​ (a) through​ (d).

a) how many flied do you think the automobile dealership sent out?

b) Using your answer to​ (a) and the probabilities listed on the​ flier, what is the expected value of the prize won by a prospective customer receiving a​ flier?

MEAN u= $

c) Using your answer to​ (a) and the probabilities listed on the​ flier, what is the standard deviation of the value of the prize won by a prospective customer receiving a​ flier?

SD o= $

d) do you think this is an effective promotion why or why not?

A. No. The promotion will not turn a profit regardless of how many customers redeeming fliers make a purchase.
B. Yes. The promotion will turn a profit if any of the customers redeeming fliers make a​ purchase, which is likely.
C. Yes. The promotion will turn a profit if the customers redeeming fliers make an average purchase greater than the expected value of the prize​ won, which is likely.
D. No. The promotion will only turn a profit if the customers redeeming fliers make an average purchase less than the expected value of the prize​ won, which is unlikely

3. Personal information about customers is collected, used, disclosed, and maintained only in compliance with internal policies and external regulatory requirements and is protected from unauthorized disclosure. With reference to Privacy Concern how would you deal with SPAM and Identify Theft problem of your business organization?

3.

a. Design a simple normalized Library database for tracking “customers reserve books” with not more than 3 tables and answer the following questions about your database.

b. Discuss how your database is in third normal form using functional dependencies (FDs).

c. Create an instance of your database.

d. Provide one external level view query in English on your database.

Question 3(a):
When customers arrive at Cool's Ice Cream Shop, they take a number and wait to be called to purchase ice cream from one of the counter servers. From experience in past summers, the store's staff knows that customers arrive at a rate of 150 per hour on summer days between 3:00 p.m. and 10:00 p.m., and a server can serve 1 customer in 1 minute on average. Cool's wants to make sure that customers wait no longer than 10 minutes for service. Cool's is contemplating keeping three servers behind the ice cream counter during the peak summer hours.
(i) Will this number be adequate to meet the waiting time policy?
(ii) What will be the probability that 3 to 4 customers in Shop?
(iii) In winter season, arrival rate of customer is reduced to half from 3:00 p.m. and 10:00 p.m. What decision should be taken by the owner according to cost cutting point of view?
Question 3(b):
Analysis of arrivals at a PSO gas station with a single pump (filler) has shown the time between arrivals with a mean of 10 minutes. Service times were observed with a mean time of 6 minutes.
(i) What is the probability that a car will have to wait?
(ii) What is the mean number of customers at the station?
(iii) What is the mean number of customers waiting to be served?
(iv) PSO is willing to install a second pump when convinced that an arrival would expect to wait at least twelve minutes for the gas. By how much the flow of arrivals is increased in order to justify a second booth?

Your company is analyzing the potential purchase of a new set of tractors for over-the-road use with a MACRS depreciable life of 3 years. The new tractors will replace the existing tractors. Depreciation charges will be $27,500 in year 1; $38,000 in year 2; $11,500 in year 3; and $5,700 in year 4. Estimated revenues and expenses are shown in the following table for the new and the old tractors. The company will pay an estimated 34% tax rate. Assume expenses depreciation and interest.

New Tractor Old Tractor

Year Revenue Expenses   Revenue   Expenses

1 $400,000 $320,000   $350,000 $290,000

2 410,000 320,000 350,000 290,000

3 420,000 320,000 350,000 290,000

(A)Compute operating cash flows (best to set up a table) associated with both the new and the old tractors. Don’t forget to include depreciation in year 4.

(B)Determine the incremental (relevant) operating cash flows as a result of the tractors’ replacement (best to set up a table).

(C)From the results in part B, show the time line of incremental operating cash flows.

On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances:

During January 2021, the following transactions occur:

The following information is available on January 31, 2021.

1. The company estimates future uncollectible accounts. The company determines $4,800 of accounts receivable on January 31 are past due, and 20% of these accounts are estimated to be uncollectible. The remaining accounts receivable on January 31 are not past due, and 5% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger.)
2. Supplies at the end of January total $900.
3. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31.
4. Unpaid salaries at the end of January are $35,400.

Please prepare an unadjusted, adjusted, and post-closing trial balance.

On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances:

During January 2021, the following transactions occur:

The following information is available on January 31, 2021.

1. The company estimates future uncollectible accounts. The company determines $4,800 of accounts receivable on January 31 are past due, and 20% of these accounts are estimated to be uncollectible. The remaining accounts receivable on January 31 are not past due, and 5% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger.)
2. Supplies at the end of January total $900.
3. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31.
4. Unpaid salaries at the end of January are $35,400.

Please prepare an unadjusted, adjusted, and post-closing balance sheet.

Operating Cash Flows (Direct Method)
Lincoln Company owns no plant assets and reported the following income statement for the current year:

Additional balance sheet information about the company follows:

Calculate the net cash flow from operating activities using the direct method. Show a related cash flow for each revenue and expense.

Use negative signs in answers below to indicate a decrease in cash.

Do not use negative signs for this portion of the problem.