You are hired to do some data analysis for a financial services company. There are three different Investment Plans that the company could offer to its customers. You are asked to find out if the expected revenue from marketing any one of these plans is different from the other plans. You survey 60 customers and this survey asks each customer to choose a plan they prefer and also involves other relevant questions that allow you to compute the expected revenues that the company can generate from each customer. Given the three different plans and the expected revenues, test whether each plan generates the same mean revenue. If the mean revenue generated is different depending on the marketed plan, which plan would be a better choice?      

Inv Revenue

1   4500.00
1   1100.00
1   3500.00
1   3000.00
1   2750.00
1   2800.00
1   2400.00
1   2100.00
1   5200.00
1   4250.00
1   3500.00
1   3000.00
1   2750.00
1   1600.00
1   2400.00
1   1300.00
1   5900.00
1   4500.00
1   4250.00
1   3500.00
2   4500.00
2   5000.00
2   3500.00
2   5450.00
2   6200.00
2   5750.00
2   7500.00
2   8000.00
2   8450.00
2   4500.00
2   5000.00
2   3500.00
2   5450.00
2   6200.00
2   5750.00
2   7500.00
2   8000.00
2   8450.00
2   8900.00
2   5000.00
3   6000.00
3   7000.00
3   8500.00
3   9250.00
3   9450.00
3   9900.00
3   10000.00
3   11000.00
3   5000.00
3   6000.00
3   7000.00
3   8500.00
3   9250.00
3   9450.00
3   9900.00
3   10000.00
3   11000.00
3   6500.00
3   6540.00
3   7100.00

A bakery runs a Groupon campaign. $3 cost for $8 value 50/50 split with Groupon 70% of coupons redeemed 1,200 coupons sold Average ticket value: $11 Bakery’s gross margin: 45%

A. Calculate the revenue from the campaign

B. Calculate the restaurant expenses associated with the Groupon customers.

C. Assume that the campaign generated 75 new customers. Calculate the breakeven sales revenue for a new customer.

Problem 4-7A: I must 1) Enter the Nov 1 balances into the ledger accounts, 2)Journalize the November transactions, 3)Post above journal entries to the ledger accounts.4) Prepare a trial balance at November 30. 5) journalize the adjusted entires, 6)Post the above adjusting entries. 7) post an adjusted trial balance, 8) post an income statement for nov 30, 9) prepare a retained earnings sheet 10)prepare a classified balance sheet.

For 5) here is the info needed:

Start of question: On November 1, 2017, the following were the account balances of Soho Equipment Repair.

During November, the following summary transactions were completed.

1. What is a gamete? A zygote? How many chromosomes do they have (n or 2n)? Are they haploid or diploid cells?
2. Describe two different aspects of meiosis that contribute to genetic variation between individuals.

Define and differentiate between data, information, and knowledge.

Discuss how each can contribute to organizational competitive advantage. Discuss the role of data and data management solutions in organizational decision making

Case Study: Establishing General Access Company’s Dividend Policy and Initial Dividend

General Access Company (GAC) is a fast-growing internet access provider that initially went public in early 2003. Its revenue growth and profitability have steadily risen since the firm’s inception in late 2001. GAC’s growth has been financed through the initial common stock offering, the sale of bonds in 2006, and the retention of earnings. Due to its rapid growth in revenue and profits with only short-term earnings declines, GAC’s common stockholder have been content to let the firm reinvest earnings as part of its plan to expand capacity to meet the growing demand for its services. This strategy has benefited most stockholders in terms of stock spilts and capital gain. Since the company’s initial public offering in 2003, GAC’s stock twice has been spilt 2-for-1. In terms of total growth, the market price of GAC’s stock, after adjustment for stock split has increased by 800% during the 7-year period 2003-2009.

As the GAC’s growth is becoming to slow, the firm’s CEO, Marilyn McNeely believes that its shares are becoming less attractive to investors. McNeely had discussion with the CFO, Bobby Joe Rook, who believes that the firm must begin to pay cash dividends. He argues that many investors value regular dividends and by paying them, GAC would increase the demand and price for its shares. McNeely decided that at the next board meeting, she would propose that the firm begin to pay dividends on a regular basis. McNeely realized that if the board approved her recommendation, it would have to (1) establish a dividend policy and (2) set the amount of the initial annual dividend. She had Rook to prepare a summary of the firm’s annual Earnings Per Share (EPS). It is given in the following table.

Rook indicated that he expects EPS to remain within 10% (plus or minus) of the most recent (2009) value during the next years. His most likely estimate is an annual increase of about 3%. After much discussion, McNeely and Rook agreed that she would recommend to the board one of following types of dividend policies:

1. Constant-payout-ratio dividend policy
2. Regular dividend policy
3. Low-regular-and-extra dividend policy

McNeely realizes that her dividend proposal would significantly affect future financing opportunities, costs and the firm’s share price. She also knows that she must be sure that her proposal is complete and fully educates the board with regard to the long term implications of each policy.

Based on the case study, answer the following questions.

1. Analyze each of the three dividend policies in light of GAC’s financial position.
2. Which dividend policy would you recommend? Justify your recommendation.
3. Discuss any four key factors to consider when setting the amount of a firm’s initial annual dividend?
4. How should McNeely go about deciding on what initial annual dividend she will recommend to the board?
5. In view of your dividend policy recommendation in part (b), how large an initial dividend would you recommend? Justify your recommendation.

Take a look at this financial plan for an EcoFriendly cleaning product. Do these financial assumptions make sense? If not, what financial assumptions would you make?

Financial Plan. According to Gallup News website 39% of people are buying green products in east coast of America. We are assuming that 39% in Boston are interested buying green products. The total population in Boston is 673,184, which means that 262,541 are buying green products. We want to reach 1% of the customers within 6 months. We are assuming that we can sell 1000 units in the first month and we will sell 15,249 units by year one as a short term objective. The total start cost is $56,500 and the total funds are $81,000 ending with $24,500 cash. We get $60,000 loan from one member's father and we contribute $7,000 each. Total fixed cost in the first year is $9,550 each month, and $17,470 each month in the second year. We are assuming that we will sell 1000 units in the first month because there are some cleaning companies in Boston that use green products only, and they will try our products. The total revenue in the first month is $4255 with $1000 product cost. By the end of the first month we end up with a negative net income of ($-6,759). We start making profit when the sales unit increases in month six. By the end of the year we are assuming that we will sell 15,249 units with $171,963 revenue, and total cost of good sold of $40,199. Our net income will be $11,596 in first year. Second year, we increase marketing budget and hire more employees to reach $331,614 total revenue. By the end of year 2 our net income will be $39,063 and $72,322 on year 3. We maintain a positive cash flow to service during the first six months where our net income is negative. After six month our cash flow increases because we assuming that we will have a positive net income by six month. There are money companies in the market selling the same products we have and that means that the demand for green products is increasing. Our business makes sense because there are customers buying cleaning products and we are adding the value to customers by providing green cleaning products at a competitive price.

Part A:  The number of cars arriving at a self-service gasoline station during the last 50 hours of operation are as follows:

The following random numbers have been generated: 44, 30, 26, 09, 49, 13, 33, 89, 13, 37. Simulate 10 hours of arrivals at this station. What is the average number of arrivals during this period?

Part B:  The time between arrivals at a drive-through window of a fast-food restaurant follows the distribution given below. The service time distribution is also given in the table in the right column. Use the random numbers provided to simulate the activity of the first five arrivals. Assume that the window opens at 11:00 a.m. and the first arrival is after this, based on the first interarrival time generated.

Random numbers for arrivals: 14, 74, 27, 03

Random numbers for service times: 88, 32, 36, 24

What time does the fourth customer leave the system?