Questions
Problem 9-2A In recent years, Avery Transportation purchased three used buses. Because of frequent turnover in...

Problem 9-2A In recent years, Avery Transportation purchased three used buses. Because of frequent turnover in the accounting department, a different accountant selected the depreciation method for each bus, and various methods were selected. Information concerning the buses is summarized as follows.

Bus Acquired Cost Salvage Value Useful Life in Years Depreciation Method

1 1/1/15 $ 98,300 $ 7,000 5 Straight-line

2 1/1/15 118,000 10,000 4 Declining-balance

3 1/1/16 88,640 8,000 4 Units-of-activity

For the declining-balance method, the company uses the double-declining rate. For the units-of-activity method, total miles are expected to be 126,000. Actual miles of use in the first 3 years were 2016, 24,000; 2017, 31,500; and 2018, 30,000.

For Bus #3, calculate depreciation expense per mile under units-of-activity method. (Round answer to 2 decimal places, e.g. 0.50.)

Depreciation expense $________ per mile

Compute the amount of accumulated depreciation on each bus at December 31, 2017. (Round depreciation cost per unit to 2 decimal places, e.g. 0.50 and depreciation rate to 0 decimal places, e.g. 15%. Round final answers to 0 decimal places, e.g. 2,125.)

Accumulated depreciation

BUS 1 $ ________

BUS 2 $ ________

BUS 3 $ ________

If Bus 2 was purchased on April 1 instead of January 1, what is the depreciation expense for this bus in (1) 2015 and (2) 2016? (Round answers to 0 decimal places, e.g. 2,125.)

(1) 2015 (2) 2016

Depreciation expense $_____ $_____

In: Accounting

Based on your teams determination of the number of airplanes needed, ExpressJet is considering multiple options...

Based on your teams determination of the number of airplanes needed, ExpressJet is considering multiple options for acquiring the Embraer 170 airplanes at a price of $10.9 million each. The executives in charge of capital acquisitions at ExpressJet are relying on you to show and explain which option will place the company in the best financial position based on your Net Present Value calculations. In the past, all acquisitions have been in cash. However with the current trend of the company, the options being considered are as follows: ExpressJet will borrow the funds necessary on a 5-year note from Bank of America. This will cause the marginal tax rate to be 35% ExpressJet will lease the planes for 10 years from LeaseCo. This will be an operating lease. This will cause the marginal tax rate to be 35%. Calculate Net Present Value for all the scenarios as compared to a cash purchase. Use the below data to fill in the spreadsheet. Cost of new equipment: $10,900,000 Expected life of equipment in years: 30 Disposal value in 5 years: $1,090,000 Lifetime miles per plane: 1,575,000,000 Annual miles per year: 52,500,000 Number of workers needed: 3 Annual hours to be worked per employee: 2,000 Earnings per hour for employees: $35 Annual health benefits per employee: $2,000 Other annual benefits per employee—% of wages: 15% Cost per Passenger Seat Mile: $0.06 Other variable costs per Seat Mile: $0.10 Costs to purchase cans—per can: $0.50 Required rate of return: 11% Tax rate: 35% Monthly lease payments: $95,000 Lease term: 10 years Monthly Note payments: ($203,208.91) Note Term: 5 years Down payment: $1,000,000

In: Accounting

Exercise 9-7 Linton Company purchased a delivery truck for $29,000 on January 1, 2017. The truck...

Exercise 9-7 Linton Company purchased a delivery truck for $29,000 on January 1, 2017. The truck has an expected salvage value of $1,100, and is expected to be driven 109,000 miles over its estimated useful life of 5 years. Actual miles driven were 12,200 in 2017 and 10,000 in 2018.

Calculate depreciation expense per mile under units-of-activity method. (Round answer to 2 decimal places, e.g. 0.52.)

Depreciation expense $___________ per mile

Compute depreciation expense for 2017 and 2018 using (1) the straight-line method, (2) the units-of-activity method, and (3) the double-declining-balance method. (Round depreciation cost per unit to 2 decimal places, e.g. 0.50 and depreciation rate to 0 decimal places, e.g. 15%. Round final answers to 0 decimal places, e.g. 2,125.)'

Depreciation Expense: 2017 2018

(1) Straight-line method $ $

(2) Units-of-activity method $ $

(3) Double-declining-balance method $ $

Assume that Linton uses the straight-line method. Prepare the journal entry to record 2017 depreciation. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places, e.g. 2,125.)

Account Titles and Explanation Debit Credit

Assume that Linton uses the straight-line method. Show how the truck would be reported in the December 31, 2017, balance sheet. (Round answers to 0 decimal places, e.g. 2,125.)

LINTON COMPANY Partial Balance Sheet

$ :

$

In: Accounting

10-12 please answered with work please? The multivariate demand function (below) is needed for questions 6...

10-12 please answered with work please? The multivariate demand function (below) is needed for questions 6 – 12. Setting: U.S. Auto manufacturers are trying to develop a multivariate function with which to estimate the demand for their gas-electric hybrid compact cars. Here is one that Motors General developed for its Jolt: Qj = 65000 – 20Pj + 20Pf + 35Pt – 5Pb + 0.2Tc + 0.05Y + 10Mg + 0.04A Where Qj = the number of Jolts demanded per week. Pj = the price of each new Jolt (in $). Pf = the price of each new Ford gas-electric hybrid (in $). Pt = the price of each new Toyota gas-electric hybrid (in $). Pb = the price of replacement batteries for the Jolt (in $). Tc = the amount of tax credit incentive offered with the purchase of a new hybrid (in $). Y = average weekly disposable income of a typical Jolt purchaser (in $). Mg = the miles per gallon of gas rating of the Jolt (in miles per gallon). A = average weekly Jolt advertising expenditure (in $).

10. Enter the following values into your Jolt demand function (be very careful with the calculation because the resulting quantity of Jolts demanded will be used in several questions to follow). Circle your answer on the answer sheet. Pj = $45000 Pf = $40000 Pt = $45000 Pb = $7000 Tc = $8000 Y = $1000 Mg = 55 A =$20000

11. What is the point cross-price elasticity of Jolt demand with respect to the Toyota price (Pt) of $45000? Work out completely and show the sign (+ or -); carry out to 3 decimal places.

12. What is the point elasticity of Jolt demand with respect to the advertising expenditure (A) of $20000. Work out completely and show the sign (+ or -); carry out to four decimal places.

In: Economics

Part 2: T-tests and Correlation For each question, conduct the appropriate statistical analysis. If some sort...

Part 2: T-tests and Correlation

For each question, conduct the appropriate statistical analysis. If some sort of t-test is appropriate for the question, determine which type of t-test is appropriate. If you are going to conduct an independent samples t-test, determine whether you need to do the version of the test for equal variances or the version for unequal variances. For each test, state the null hypothesis, state the alternative hypothesis, state the type of test that you conducted, and report and interpret the results. If ANOVA is the appropriate analysis, follow-up with the appropriate post-hoc tests if you reject the null hypothesis for your ANOVA. The data for each question can be found in the Excel file entitled “Data for Project 3.” Show your work in your spreadsheet just as you did for the practice exercise. Each question is worth 7 points.

A group of 12 welfare recipients participated in a job training program. Before- and after-abilities were measured through a standardized test. The data can be found in the sheet entitled “Part 2 Question 1.” Is there evidence of improvement?

Before After
5 7
4 5
6 6
4 5
5 5
4 5
3 4
6 5
5 5
4 5
4 4
5 6

An important function of a firm’s human resources manager is to track worker turnover. As a general rule, companies prefer to retain workers. New workers frequently need to be trained and it often takes time for new workers to learn how to perform their jobs. To investigate nationwide results, a human resources manager organized a survey wherein a random sample of men and women was asked how many years they had worked for their current employers. The data can be found in the sheet entitled “Part 2 Question 2”. Can we infer that men and women have different job tenures?

Men Women
3.2 0.7
15.7 0.9
1.3 0.8
0.7 0.3
8.6 5.8
10.4 2.3
3.2 1.4
1.3 9.3
23.9 5.7
0.2 12.1
0.8 2.8
11.1 0.4
1.5 1.4
3.7 1
14.9 0.8
3 11.9
2.3 4.8
18.2 1.3
12.9 21.5
2.5 10.8
3.8 6.3
3.4 20.7
5.5 1.8
3.8 16.4
7.3 4.1
3.7 2.7
9.7 1.4
10.3 20.7
4.3 4.5
9 4
15.8 0.6
9.9 3
4.1 1.1
5.6 7
1.4 1.4
0.1 2.3
1.2 17
5.1 6
5.8 3.7
6.8 6.8
13.7 6.1
6.1 0.4
6.4 4.9
2.5 3.3
2.2 10.6
4.4 4.9
18.1 0.3
0.4 4.7
2.8 3.7
13.9 1.4
7.9 2.8
5.4 1.3
6.2 18.6
2.5 4
1.3 7.1
10 2.5
2 30.8
1.5 5.8
4.3 8.9
1.3 7.6
5.8 11.2
2.8 3.2
1.5 9.4
0.6 5.6
5.8 8.2
4.8 0.1
2.7 2.5
5.7 11.1
17 2.8
11.3 1.1
9.6 13.5
1.9 2.2
15.8 10.3
2.4 1.6
5.6 6.6
0.9 1.9
0.6 1.3
11.2 1.7
0.6 7.8
1.2 5.3
0.7 3.1
3.1 5.2
0.2 7.6
0.5 0.6
3.7 5.6
7.1 2.2
1.6 10.5
0.1 2.8
3.8 8.5
3.6 6.2
1.8 18.3
1.4 3.4
11.3 8.9
10.2 20.2
1.6 0.6
1 2.5
5.3 3
10.1 0.7
3.4 10.7
3.7 0.3
6.4 4.1
14.2 35.9
2.2 7.1
2.6 4.2
18.9 3.2
6.4 1.4
12 2
6.6 2
7.3 20.9
5.3 25.2
10.3 1.4
16.7 5.2
12.6 2.9
1.9 3
7.1 2.5
6.6 6.1
1.6 12.4
3.2 3
1.6 8.4
0.9 0.8
0.5 13
1.5 1.5
1.9 1.1
4.8 5.9
18 8.4
1 10.6
0.8 4.2
16.5 0.6
1.6 17.6
3.1 1.4
0.6 4.7
10.8 15.4
1.2 8.6
3.1 2.6
3.3 0.6
3.1 8.8
3.7 5.6
0.7 10.3
2.5 6.5
2.3 1.6
5 0.6
0.3 0.8
4.1 7.9
3.4 3.5
6.2 7.5
8 6.5
7.8 3.3
1.8 3.2
0.3 2.4
0.7 3.3
14.1 3.6
5.1 8.1
2.5 3.9
3.3 1
1.5 2
19.5 27.9
3 15.4
1.8 0.5
3 0.5
14.7 3.2
21.4 2
11.8 18.5
8 2.9
0.9 1.2
23.5 5
4.7 1.4
4 11.5
3.3 10.8
3.3 0.9
16.6 0.5
1.6 2.2
0.6 14.9
6.3 0.4
13.4 5.4
1.1 4.5
2.6 0.8
11.2 0.1
5 7.2
17.3 3.2
0.2 6.3
4 7.3
5.2 3
8 17.9
12.2 0.1
0.7 8.9
3.4 0.1
0.4 2.3
1.3 12
0.8 3.5
3.2 1.4
1.2 2.7
1.6 9.9
15 0.9
11.7 2.4
6.6 3.1
5.3 2.2
9.5 10.7
1.4 10.7
5.9 15.7
9.1 4.5
2.1 3.5
0.6 4.9
1.6 5.9
1 4.6
1.8 7.6
29.3 2
6 4.1
16.4 0.5
8 12
2.6 1.4
13.6 16.2
1.1 0.8
4.5 5.4
1.6 0.1
5.8 1.1
0.2 8.6
3 1.7
0.1 3.4
2.8 1.3
11 2.8
4.9 1.7
24.1 5.3
15 0.2
6.1 2.6
9.3 1.1
1 7.1
1.5 5.3
1 2.5
2.5 20.3
0.5 7
0.2 0.4
2.3 2.2
0.4 3.1
10.9 7.5
8.3 1.2
5.3 6.6
1.4 10.1
2.5 2.8
2.5 1.7
2 18.8
1.2 3
3.3 1.6
2.9 1.5
1.8 1
4.4 5.7
4.5 2.7
6.2 3
0.9 1.2
0.8 4.6
0.2 4
0.9 0.6
1.3 6.8
2.6 0.4
2.6 1.2
1.2 3.7
2.7 0.3
6.3 8
4.3 11.5
1 4.2
12.2 7.6
11.9 4.3
6.5 5.3
1.2 4.3
6.1 2.4
16 1.4
0.5 4
9.8 10.7
4.3 10
5.1 2.6
3.7 1.1
17.3 9.1
0.7 5.8
2.2 11.9
1.5 0.3
1 1.3
18.6 1.8
2 3.7
1.5 2.6
3.2 1.8
4.1 1.2
16.4 3
7.2 2.3
8.2 2.1
15.2 3.2
0.1 3.6
1.2 3
7.7 9.2
2.2 6.9
9.7 12.7
4 2.5
6.5
3.5
4.7
5.8
8.7
0.4
3.2
2.5
0.4
16.6
2
9.8
12.8
4.8
2.2
5.4















In: Statistics and Probability

INFO 564 Homework Assignment 5 (100 pts) This work must be done completely in EXCEL. Answer...

INFO 564 Homework Assignment 5 (100 pts)

This work must be done completely in EXCEL. Answer each question on a separate tab. Label each tab appropriately. You can copy and paste the data given into an Excel worksheet.

South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. The following data show quarterly sales revenues (in $’000s) for the past 5 years.

Quarter

Year 1

Year 2

Year 3

Year 4

Year 5

1

20

37

75

92

176

2

100

136

155

202

282

3

175

245

326

384

445

4

13

26

48

82

181

Question 1 (5 pts)

Plot this data with quarters from years 1-5 on the horizontal axis. What components do you see in this time series?

Question 2 (20 pts)

Ignore any trend or seasonality in the data.

  1. Suppose the company uses moving averages to make forecasts. Make forecasts all the way through Q4 Year 5. Assume the company uses (i) 3-quarterly moving averages and (ii) 4-quarterly moving averages.
  2. Compare the two sets of forecasts from (a) on the basis of Mean Absolute Percent Deviation. Which is more accurate – 3 quarterly moving average or 4 quarterly moving average?
  3. On a line chart plot the time series along with the forecasts from the method you select in (b).

Question 3 (20 pts)

Ignore any trend or seasonality in the data.

  1. Suppose the company uses weighted moving averages to make forecasts. Make forecasts all the way through Q4 Year 5. Assume the company uses (i) 3-quarterly moving averages with weights 0.6, 0.3, and 0.1 and (ii) 4-quarterly moving averages with weights 0.4, 0.3, 0.2, and 0.1. In both cases the most weight is given to the most recent quarter and the least to the oldest quarter in the moving average.
  2. Compare the two sets of forecasts from (a) on the basis of Mean Absolute Percent Deviation. Which is more accurate – 3 quarterly weighted moving average or 4 quarterly weighted moving average?
  3. On a line chart plot the time series along with the forecasts from the method you select in (b).

Question 4 (20 pts)

Again ignore any trend or seasonality in the data.

  1. Suppose the company uses exponential smoothing to make forecasts. What are the forecasts for periods Q2 Year 1 through Q4 Year 5 assuming (i) alpha = 0.3 and (ii) alpha = 0.7? In both cases assume that the forecast for Q1 Year 1 was 25 units.
  2. Compare the two sets of forecasts from (a) on the basis of Mean Absolute Percent Deviation. Which is more accurate – alpha of 0.3 or alpha of 0.7?
  3. On a line chart plot the time series along with the forecasts from the method you select in (b)

Question 5 (20 pts)

Now make adjustments for trend and seasonality.

  1. Quantify the trend in the time series. What does the trend equation tell you?
  2. Quantify the seasonality in the time series by calculating seasonality indexes. What do these indexes tell you?
  3. Using the trend and the seasonality information from (a) and (b) make forecasts from Q1 Year 1 through Q4 Year 5.
  4. Calculate the Mean Absolute Percent Deviation for the forecasts in (c).
  5. On a line chart plot the time series along with the forecasts from (c).

Question 6 (15 pts)

Using the most accurate method of all of the above,

  1. Make forecasts for the four quarters of Year 6.
  2. Plot these forecasts on the same line chart as the time series.
  3. Summarize in a few lines your findings from your answers to Q1 through Q6b. I really need answer to question 4 and 5 please. Thank you.

In: Operations Management

Week 6 As the auditor of Komsu Air Limited (KAL) that manufactures and installs large commercial...

Week 6
As the auditor of Komsu Air Limited (KAL) that manufactures and installs large commercial air- conditioning systems. KAL typically has two or three large contracts (ranging from $6 million to $10 million each) in progress at any one time. The contracts usually take up to six months to complete, although unexpected on-site difficulties can result in lengthy delays in completion (of up to 12 months). KAL finances its operations with a mixture of equity, long-term debt (secured by fixed assets) and short-term bank loans.
It is now May 2017 and your planning of the audit of KAL for the year ended 30 June 2017 is nearing completion. You have met with the management of KAL and, from those discussions and a review of the preliminary information provided by KAL, you have identified several issues that may have implications for the company’s ability to continue as a going concern. The relevant issues are as follows:
 Competition in the industry is becoming more intense, with some customers now installing their own systems.
 KAL’s bank has requested cash flow forecasts for the coming year to support the short-term loans. It has indicated that it may need to withdraw funding or restructure debt if the forecasts are not adequate. The review of work-in-progress indicates that all the contracts in progress at year end are due for completion within six months of the balance date. There are no new contracts in place for the coming year, although management has indicated that there are orders currently being negotiated. The nature of the business is such that sales will fluctuate considerably from year to year depending on the timing of one or two large contracts.
 Assets consist chiefly of plant and equipment, some of which is specialised to the industry. Debtors are significant, but recoverability is not considered an issue as the ongoing projects are with reputable customers and management is not aware of any problems. Creditor balances are at normal levels, and the company is in a positive working capital position.
 Included in provisions is a large provision for warranty for one of KAL’s jobs completed at a hotel two years ago. It appears that the air-conditioning system is still not working and the hotel is now requesting a substantial refund of the contract price.
Required:
Explain whether you believe the area of going concern should be assessed as high risk for KAL’s audit for the year ended 30 June 2017.

In: Accounting

No Hand drawings, please. Consider the following scenario and then answer the corresponding questions. ABC Travel...

No Hand drawings, please.

Consider the following scenario and then answer the corresponding questions.

ABC Travel and Tourism specializes in providing tourist packages to customers across the globe and the company has decided to develop an in-house software system that will help customers search for travel destinations based on popularity, budget, visa restrictions, government policies and attractive climatic conditions. Customers will also be able to book their air tickets, hotel and transportation (rental car, public transportation, cab services) through this system. Prior to the booking, the system will allow users to check for their visa eligibility to travel to destinations outside of their country of citizenship. Users will also be able to review and rate destinations or hotels using the system. The company also offers pre-set packages and if a customer decides to go with a specific package, they will be asked to provide the dates for their travel. The system will find an airline reservation, hotel/ transportation choices and create an itinerary for the customer. Customers will not be allowed to customize the pre-set packages.

Once the booking is done, the system should send a notification to the users on the purchase confirmation within 2 hours. Cancellations will incur a 25% penalty, if users are “Gold” members. In all other cases, the reservations will be non-refundable. Customers can pay using their credit cards or Paypal.

Upon your review complete the following:

  1. Identify ALL MAJOR the tables relevant this case, the primary key, foreign keys, attributes and data types. For each table, list the fields, description, datatype and description about that field as suggested in the format below. (30 pts). (Hint: Refer to your class diagram).

Table Name

Field Name

Description

Data Type

Comments (Identify as primary key, foreign key or any special considerations)

  1. Apply 1st, 2nd and 3rd normalization rules for your tables. Explain how each table satisfies these normalization rules. (Hint: You may end up creating intersection tables as needed, in addition to the tables identified for question #1). (20 points)

(Please see normalization examples from the lecture notes and show the normalization process for the tables as applicable)

  1. Draw an ER diagram for this case including the tables, relationships, cardinality and all the fields. (10 points)

In: Computer Science

FRAUDD EXAMINATION Case 4 Stephanie Adkins is an accountant who is trained in forensic accounting. She...

FRAUDD EXAMINATION

Case 4

Stephanie Adkins is an accountant who is trained in forensic accounting. She is an experienced fraud investigator. She was recently hired by Lake Side Hotels, a closely-held corporation, to investigate a company manager who is suspected of taking kickbacks from vendors.

Stephanie gave Lake Side her standard engagement letter stating that the scope of the engagement would be limited to investigating only one suspect. It did not guarantee findings or results.

According to the provisions of Stephanie’s engagement, she was to communicate directly with Bernie James, the company’s controller, and Amanda Peterson, the outside attorney.

At the first meeting of this team, Bernie indicated that Lake Side had received four separate anonymous tips about possible kickbacks. All the tips indicated that Laurie Miller, an evening manager, was taking kickbacks from food vendors. One tip named a particular vendor, the Mid States Beef Source, a company that supplies meat to the hotel’s restaurants.

Stephanie asked if Bernie had any documentation that supports Laurie Miller’s possible involvement in kickbacks. Bernie had no documentation but hoped Stephanie could help them substantiate the information from the anonymous tips. He was concerned that kickbacks would hurt the hotel financially.

Amanda, the outside attorney, said that she had already talked to several hotel employees and was convinced that Laurie was guilty.

Kickback schemes can be difficult to uncover, so Stephanie wanted to proceed cautiously.

Bernie wanted to confront Laurie immediately. He was convinced she would confess if he told her that he had evidence against her.

Stephanie asked what evidence Bernie had. Bernie said, “Only the anonymous tips, but I know she will confess if we bluff.” It was against Stephanie’s professional principles to lie and she said so.

“Detectives do it all the time on cop shows,” Bernie said. Stephanie insisted she would need to run the investigation her way or she wouldn’t be able to undertake this engagement.

In relation to this scenario, write responses to the following:

What steps might Stephanie follow to proceed with her investigation?

What mistakes, if any, have already been made in the investigation?

In: Accounting

The Town of Brown has the following financial transactions: 1. The town council adopts an annual...

The Town of Brown has the following financial transactions:

1. The town council adopts an annual budget for the general fund estimating general revenues of $2.0 million, approved expenditures of $1.6 million, approved transfers pf $150,000.

2. The town levies property taxes of $1.5 million. It expects to collect all but 4% of these taxes during the year. Of the levied amount, $50,000 will be collected next year but after more than 60 days.

3. The town orders three new police cars at an approximate cost of $120,000.

4. A transfer of $60,000 is made from the general fund to the debt service fund.

5. The town makes a payment on a bond payable of $50,000 along with $15,000 of interest using the money previously set aside.

6. The Town of Brown issues a $3 million bond at face value in hopes of acquiring a building to convert into a high school.

7. The two police cars are received with an invoice price of $115,000. The voucher has been approved and will not be paid for three weeks.

8. The town purchases the building for the high school for $2.5 million in cash and immediately begins renovating it.

9. Depreciation on the new police cars is computed at $35,000 for the period.

10. The town borrows $120,000 on a 30-day-tax anticipation note.

11. The Town of Brown begins a special assessment curbing project. The government issues $900,000 in notes at face value to finance this project. The town has guaranteed the debt if the assessments collected do not cover the entire balance.

12. A contractor completes the curbing project and is paid $900,000 as agreed.

13. The town assesses citizens $900,000 for the completed curbing project.

14. The town collects the special assessments of $900,000 in full and repays the debt plus $40,000 in interest.

15. The town receives a $20,000 cash grant from a regional charity to beautify a local park. The grant must be used to cover the specific costs that the town incurs.

16. The town spends the first $5,000 to beautify the park.

Question 1. – Please prepare journal entries for the town based on the production of fund financial statements.

Question 2 – Please prepare journal entries in anticipation of preparing government-wide financial statements.

In: Accounting