1. Consider a study on the number of accidents occurred in 10 states of the United States of America in different cities for 3 consecutive years. Create a PivotTable in Excel to answer the following questions. The PivotTable should group the number of accidents into yearly bins and display the sum of accidents occurred each year in columns of Excel. Row labels should include the accident locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of accidents between 2011 and 2013 appear at the top of the PivotTable.

1. Which state had the greatest number of accidents between 2011 and 2013?
2. How many accidents occurred in the state of Colorado (CO) in 2012? In what cities did these accidents occur?
3. Use the PivotTable’s filter capability to view only the accidents in Alabama (AL), Arizona (AZ), and Arkansas (AR) for the years 2011 through 2013. What is the total number of accidents in these states between 2011 and 2013?
4. Create a PivotChart to display a column chart that shows the total number of accidents in each year 2011 through 2013 in the state of California. Adjust the formatting of this column chart so that it best conveys the data. What does this column chart suggest about accidents between 2011 and 2013 in California? Discuss.

Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart.

2. Hire-a-Car System rents three types of cars at two different locations. The profit made per day for each car type and company at the two locations is listed below:

1. Helen and Rob are directors of Archers PLC, a company whose shares are traded on the stock market.

1. Rob thinks that Helen was not properly appointed as a director, and wants to know what action he can take to challenge her appointment.
2. Helen has identified payments made by an agent of the company to the personal bank account of a director of a business they supply.  When asked about the payments the agent gave Helen a large sum of cash that he said was a refund on the payments. Helen wants to know if there could be any legal consequences for the company over the payments, and whether she should pay the cash into the company bank account.
3. Rob hears that because of bad weather in South America the product the company supplies is going to be in high demand, and so the company profits should rise. He buys more shares in Archers PLC expecting the share price to rise, and advises a friend to do the same. Has Rob or the friend done anything wrong?
4. Helen has negotiated a contract for the company that she thinks will be very good for the business, but the shareholders have rejected it. Helen wants to know if she can take the contract herself.
5. Because of difficulty in supply of chemicals  a scientist working for the company has changed the formula for one of the company’s products without telling anyone. This means the product does not match the description given on the label, which is a criminal offence. Rob wants to know whether the company has committed a crime. Would it matter if Rob or Helen was the scientist involved?

Sage Corporation provides a defined contribution pension plan for its employees. Under the plan, the company deducts 6% of each employee’s gross pay for each bi-weekly pay period. The company also contributes 7% of the employees’ gross pay to the pension plan. The combined pension contributions are then submitted to the pension trustee within 11 days of the end of the month in which the pay was earned.

For the first pay period of October (from Sunday October 1 to October 14, 2020), Sage’s total gross payroll was $171,000. Total gross payroll for the period October 15 through Saturday, October 28, 2020, was $162,000. The total anticipated payroll for the period October 29 through November 10, 2020, was $180,000 (employees worked Monday through Friday each week). On November 10, 2020, Sage submitted the pension contributions to the trustee for the month of October (including accruals up to and including October 31).

a. Prepare the October 14 journal entry to record the payroll, including employee and employer contributions to the pension plan. For simplicity, ignore income taxes and other statutory deductions.

b. Prepare the October 28 journal entry to record the payroll, including employee and employer contributions to the pension plan. For simplicity, ignore income taxes and other statutory deductions.

c. Prepare the October 31 journal entry to accrue the last two days of October’s payroll, including employee and employer contributions to the pension plan. For simplicity, ignore income taxes and other statutory deductions.

d.Prepare the November 10 journal entry to record the payment of the pension contributions to the trustee.

T-Comm makes a variety of products. It is organized in two divisions, North and South. The managers for each division are paid, in part, based on the financial performance of their divisions. The South Division normally sells to outside customers but, on occasion, also sells to the North Division. When it does, corporate policy states that the price must be cost plus 20 percent to ensure a “fair” return to the selling division. South received an order from North for 300 units. South’s planned output for the year had been 1,200 units before North’s order. South’s capacity is 1,500 units per year. The costs for producing those 1,200 units follow.

a. If you are the manager of the South Division, what unit cost would you ask the North Division to pay?
b. If you are the manager of the North Division, what unit cost would you argue you should pay?

If you are the manager of the South Division, what unit cost would you ask the North Division to pay? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

If you are the manager of the North Division, what unit cost would you argue you should pay? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

Alex is a furniture designer. In September 2017, she decided to start her own business (Alex Furniture). Below is the summary of transactions that occurred during the first month of operations. On the basis of this information construct a balance sheet as of September 30th, 2017. 1. Sept 1st: Alex invested 100 000€ cash in the company. 2. Sept 2nd: Alex bought a new machine to be used in the business for 3 years. The machine cost 12000€, she paid 6000€ in cash and 6000€ was put on credit to be paid on September 30th (!). 3. Sept 3rd: Alex purchased material for building 5 tables, each set of material cost her 100€. She paid in cash. 4. Sept 20th: Alex sold her first table to a customer for 1000€. The customer paid in cash. By the end of the month the machine depreciated by 1000€. By September 30th Alex had 350€ worth of inventories in her warehouse. The rent for the office in September was 500€. She would pay the rent to the landlord in October 2017. a. Record these transactions in the accounting equation. Identify each transaction by the date when it was recorded.

The accounts receivable listing of Houmans Inc. shows the following on December 31, 2018. The general ledger showed a $350 credit balance in Allowance for Doubtful Accounts before adjustment Name of customer Invoice date Amount Cycles Inc. May 5, 2018 $950 First Corporation August 12, 2018 500 First Corporation December 10, 2018 550 Garron Inc. December 15, 2018 200 Heartwell Inc. September 15, 2018 480 Heartwell Inc. July 5, 2018 915 Leash Inc. March 5, 2018 575 Sign Corporation November 15, 2018 825 Spares Inc. November 18, 2018 325 Summer Corporation October 10, 2018 650 Required: 1. Prepare an aging of accounts receivable at December 31, 2018 2. Compute estimated loss based on the following: Age (days) Estimated Loss Percentage 1-30 2% 31-60 3% 61-90 5% 91-120 12% 121-150 15% Over 150 50% 3. Prepare journal entry to record the bad debt expense for the year.

Fiction Cruiseline offers three ways to exercise on their cruise ships. 73 of the 86 passengers participated in at least one method of exercise. 36 people went rock climbing, 44 people went ice skating, and 19 went to the fitness center. 14 people went rock climbing and ice skating, 11 people went rock climbing and to the fitness center, and 9 people went ice skating and to the fitness center. Calculate the probability for each given event.

1.A randomly selected passenger went rock climbing, given they did not go ice skating

2. A randomly selected passenger did not go rock climbing, given they did not go to the fitness center

3.A randomly selected passenger did not go ice skating, given they did at least two activities

Draw a Venn Diagram for the three sets if necessary. Include how you found the number of ALL three activities.

OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship would cost $505 ?million, but would operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $70.1 million? (at the end of each? year) and its cost of capital is 11.9%

a. Prepare an NPV profile of the purchase using discount rates of 2.0%?, 11.5% and 17.0%. b. Identify the IRR on a graph. c. Is the purchase attractive based on these? estimates?

d. How far off could? OpenSeas' cost of capital estimate be before your purchase decision would? change? ?(NOTE: Subtract the discount rate from the actual IRR. Use Excel to compute the actual? IRR.)