Questions
Employee Project Hours Week1 Hours Week2 Hours Week3 Hours Week4 Sophia APC101 47 64 73 25...

Employee Project Hours Week1 Hours Week2 Hours Week3 Hours Week4
Sophia APC101 47 64 73 25
Isabella APC101 33 72 73 46
Emma APC101 33 51 44 53
Olivia APC101 31 3 49 19
Ava APC101 37 35 60 21
Emily APC101 62 32 58 11
Abigail APC101 37 65 47 77
Madison FXCK301 33 40 12 50
Mia FXCK301 15 49 5 57
Chloe FXCK301 69 55 58 21
Elizabeth FXCK301 46 60 7 38
Ella FXCK301 38 58 77 25
Addison FXCK301 14 55 28 38
Natalie FXCK301 66 9 11 74
Lily VERZ123 28 74 52 22
Grace VERZ123 52 18 36 21
Samantha VERZ123 25 67 56 46
Avery VERZ123 76 49 43 50
Sofia TMOB001 43 30 51 56
Aubrey TMOB001 47 44 40 23
Brooklyn TMOB001 6 3 40 35
Lillian TMOB001 64 55 17 44
Victoria TMOB001 42 57 41 27
Evelyn TCK999 41 51 27 36
Hannah TCK999 4 49 15 58
Alexis TCK999 50 48 48 16
Charlotte TCK999 58 55 33 19
Zoey TCK999 51 46 8 34
John STUB301 73 42 60 46
Nathan STUB301 24 16 79 43
Lucas STUB301 42 57 10 50
Christian STUB301 51 56 34 79
Jonathan STUB301 17 58 58 74
Caleb STUB301 10 58 64 30
Dylan VN095 22 51 50 52
Landon VN095 51 41 59 40
Isaac VN095 5 38 54 54
Gavin VN095 53 41 54 10
Brayden VN095 59 2 44 67
Tyler VN095 65 47 7 53
Luke VN095 48 5 9 41
Evan VN095 58 52 26 56
Carter VN095 2 38 57 20
Nicholas VN095 44 54 65 6
Isaiah VN095 67 50 26 75
Owen VN095 48 32 19 48
Jack GUA001 51 67 62 44
Jordan GUA001 50 7 61 29
Brandon GUA001 54 53 42 61
Wyatt GUA001 63 73 26 17
Julian GUA001 26 34 60 61
Aaron GUA001 52 28 52 38
Jeremiah DEF001 40 43 17 11
Angel DEF001 75 31 17 44
Cameron DEF001 10 58 40 62
Connor DEF001 15 60 17 70
Hunter DEF001 52 62 69 37
Adrian DEF001 38 40 24 8
Employee Employee ID Rate per hour ($)
Aaron 1 94
Aarony 2 55
Abigail 3 21
Addison 4 60
Adrian 5 16
Alex 6 55
Alexis 7 44
Angel 8 55
Aubrey 9 46
Ava 10 79
Avan 11 44
Avery 12 69
Brand 13 55
Brandon 14 22
Brayden 15 95
Brooklyn 16 14
Caleb 17 37
Cameron 18 79
Carter 19 42
Charlotte 20 90
Chloe 21 65
Christian 22 42
Christianie 23 55
Connor 24 83
Connory 25 55
Dylan 26 12
Elizabeth 27 30
Ella 28 68
Emily 29 46
Emma 30 15
Evan 31 38
Evelyn 32 95
Evene 33 55
Gavin 34 72
Grace 35 95
Hannah 36 44
Hunter 37 94
Isaac 38 89
Isabell 39 11
Isabella 40 28
Isaiah 41 59
Jack 42 59
Jeremiah 43 98
John 44 50
Jonath 45 55
Jonathan 46 8
Jordan 47 76
Julian 48 92
Landon 49 33
Lillian 50 60
Lily 51 88
Lucas 52 18
Luke 53 16
Madison 54 77
Mia 55 12
Miana 56 33
Natalia 57 55
Natalie 58 28
Nathan 59 59
Nicholas 60 13
Olivia 61 55
Owen 62 71
Samantha 63 83
Sofi 64 55
Sofia 65 44
Sophia 66 54
Tyler 67 49
Victoria 68 22
Wyatt 69 75
Zoey 70 18
Project Payments
STUB301                12,000
FXCK301                10,000
TCK999                10,000
VERZ123                10,000
FXCK301                  9,000
GUA001 3000
TMOB001                10,000
STUB301                20,000
VN095                17,000
DEF001 35000
VN095                  5,000
DEF001 5000
VN095                  9,000
GUA001 23000
APC101 15000
TCK999                  3,000
GUA001 8000
STUB301                16,000
DEF001 4000
FXCK301                10,000
VN095                15,000
STUB301                18,000
TCK999                15,000
VN095                13,000
FXCK301                10,000
TMOB001                10,000
GUA001 18000
APC101 5000
APC101 15000
TMOB001                10,000
VN095                11,000
FXCK301                  1,000
VERZ123                10,000
VERZ123                10,000
GUA001 13000
DEF001 5000
TMOB001                10,000
VERZ123                10,000
VN095                  7,000
TCK999                  5,000
APC101 15000
APC101 25000
STUB301                14,000
DEF001 15000
DEF001 25000
STUB301                10,000
FXCK301                  1,000
TCK999                10,000
APC101 5000
GUA001 28000
APC101 5000
General question for the company:
1 How many projects does this company have?
2 What is the average total working hours per week for the whole company?
3 Who work the most during this 4 weeks? Report his/her ID (clearly it is not included in Working hours sheet but you have to find it)
4 Over this reporting period, who have the highest pay rate?
Project level questions:
5 Which project have the highest revenue?
6 What is the total profit for the company over this reporting window?
7 What is the (%) gross profit margin for the whole company? If the answer is 25.23%, simply put 25.23 on Sakai
8 Which project posts the largest $ profit?
9 Which project posts the largest profit margin?
10 Which project posts the largest dollar loss?
11 Which project posts the lowest profit margin?
12 Report the (%) gross profit margin for project that have the highest margin. If the answer is 25.23%, simply put 25.23 on Sakai

In: Finance

Consider the following income statements for Nero Company: Income statement 1 Revenue = 1,800 Direct costs...

Consider the following income statements for Nero Company:

Income statement 1

Revenue = 1,800

Direct costs = (300)

Contribution margin = 1,500

Fixed costs = (500)

Operating income = 1,000

Income statement 2

Revenue = 1,400

Direct costs = (200)

Contribution margin = 1,200

Fixed costs = (300)

Operating income = 900

Income statement 3

Revenue = 2,000

Direct costs = (800)

Contribution margin = 1,200

Fixed costs = (400)

Operating income = 800

  1. Identify which income statement is prepared using each of the following costing methods:

Absorption costing, Variable costing, and Throughput costing.

  1. For each costing method, identify one assumption associated with its use
  2. Explain why Nero Company might produce all three types of income statements for the same period.

In: Accounting

Should Firms That Go Public Engage in International Offerings? POINT: Yes. When a U.S. firm issues...

Should Firms That Go Public Engage in International Offerings?

POINT: Yes. When a U.S. firm issues stock to the public for the first time in an initial public offering (IPO), it is naturally concerned about whether it can place all of its shares at a reasonable price. It will be able to issue its stock at a higher price by attracting more investors. It will increase its demand by spreading the stock across countries. The higher the price at which it can issue stock, the lower is its cost of using equity capital. It can also establish a global name by spreading stock across countries.

COUNTER-POINT: No. If a U.S. firm spreads its stock across different countries at the time of the IPO, there will be less publicly-traded stock in the U.S. Thus, it will not have as much liquidity in the secondary market. Investors desire stocks that they can easily sell in the secondary market, which means that they require that the stocks have liquidity. To the extent that a firm reduces its liquidity in the U.S. by spreading its stock across countries, it may not attract sufficient U.S. demand for the stock in the U.S. Thus, its efforts to create global name recognition may reduce its name recognition in the U.S.

WHO IS CORRECT? Use the Internet to learn more about this issue. Which argument do you support? Offer your own opinion on this issue.

In: Finance

Research Problem 2. Five years ago Bridget decided to purchase a limited partnership interest in a...

Research Problem 2. Five years ago Bridget decided to purchase a limited partnership interest in a fast-food restaurant conveniently located near the campus of Southeast State University. The general partnerof the restaurant venture promised her that the investment would prove to be a winner. During theprocess of capitalizing the business, $2 million was borrowed from Northside Bank; however, each of thepartners was required to pledge personal assets as collateral to sa±sfy the bank loan in the event thatthe restaurant defaulted. Bridget pledged shares of publicly traded stock (worth $200,000, basis of$75,000) to sa±sfy the bank’s requirement.The restaurant did a good business un±l just recently, when ²agrant health code viola±ons werediscovered and widely publicized by the media. As a result, business has declined to a point where therestaurant’s con±nued existence is doub³ul. In addi±on, the $2 million loan is now due for payment.Because the restaurant cannot pay, the bank has called for the collateral provided by the partners to beused to sa±sfy the debt. Bridget sells the pledged stock for $200,000 and forwards the proceeds to thebank. Bridget believes that her share of the restaurant’s current and suspended passive losses can o´setthe $125,000 gain from the stock sale. As a result, aµer ne¶ng the passive losses against the gain, noneof the gain is subject to tax. How do you react to Bridget’s posi±on?

In: Accounting

CA19-7 ETHICS (Deferred Taxes, Income Effects) Stephanie Delaney, CPA, is the newly hired director of corporate...

CA19-7 ETHICS (Deferred Taxes, Income Effects) Stephanie Delaney, CPA, is the newly hired director of corporate taxation for Acme Incorporated, which is a publicly traded corporation. Ms. Delaney’s first job with Acme was the review of the company’s accounting practices on deferred income taxes. In doing her review, she noted differences between tax and book depreciation methods that permitted Acme to realize a sizable deferred tax liability on its balance sheet. As a result, Acme paid very little in income taxes at that time. Delaney also discovered that Acme has an explicit policy of selling off plant assets before they reversed in the deferred tax liability account. This policy, coupled with the rapid expansion of its plant asset base, allowed Acme to “defer” all income taxes payable for several years, even though it always has reported positive earnings and an increasing EPS. Delaney checked with the legal department and found the policy to be legal, but she’s uncomfortable with the ethics of it. Instructions Answer the following questions. (a) Why would Acme have an explicit policy of selling plant assets before the temporary differences reversed in the deferred tax liability account? (b) What are the ethical implications of Acme’s “deferral” of income taxes? (c) Who could be harmed by Acme’s ability to “defer” income taxes payable for several years, despite positive earnings? (d) In a situation such as this, what are Ms. Delaney’s professional responsibilities as a CPA?

In: Accounting

Cell Phone Inc. is a private cellular firm that reported net income of $5 million in...

Cell Phone Inc. is a private cellular firm that reported net income of $5 million in the current financial year. The firm has borrowed $10 million at a rate of 15%, on which it reported interest expenses of $1.5 million in the current financial year. Cell Phone’s debt has an estimated current market value of $8.5 million. The firm has depreciation of $0.1 million for the current year, and capital expenditures equal to 200% of depreciation. The firm’s sales and capital expenditures are expected to grow at 5% annually during the next five years, while depreciation and interest expenses will remain constant. The firm has estimated that COGS (excluding depreciation) over Sales is 35% and that SG&A/Sales is 15%. The following information was also obtained from peer publicly traded firms:

Firm Asset Beta P/E M/B (Equity)

A 0.65 8.2 1.6

B 0.70 9.5 1.3

C 0.55 7.3 0.9

D 0.63 10.5 1.2

E 0.58 15.2 1.4

The firm’s book value of equity is $7.5 million and the firm’s owners hold 750,000 shares. The yield on 10 year Treasuries is 6.5% and the historic market risk premium is assumed to be 5.5%. Assuming that there is no working capital requirement and a constant growth rate of FCFF of 4% beyond the forecast period of five years, estimate a range for the firm’s intrinsic value per share at the end of the current year (tax rate = 50%).

In: Finance

Describe the study Pozzulo and Dempsey (2006) conducted on lineup instructions and the conclusions that can...

Describe the study Pozzulo and Dempsey (2006) conducted on lineup instructions and the conclusions that can be drawn from this study.

In: Psychology

Question 2 (1 point) The owner of a local phone store wanted to determine how much...

Question 2 (1 point)

The owner of a local phone store wanted to determine how much customers are willing to spend on the purchase of a new phone. In a random sample of 15 phones purchased that day, the sample mean was $302.071 and the standard deviation was $27.9396. Calculate a 99% confidence interval to estimate the average price customers are willing to pay per phone.

Question 2 options:

1)

( -280.596 , 323.546 )

2)

( 280.596 , 323.546 )

3)

( 280.811 , 323.331 )

4)

( 294.857 , 309.285 )

5)

( 299.094 , 305.048 )

Question 3 (1 point)

You own a small storefront retail business and are interested in determining the average amount of money a typical customer spends per visit to your store. You take a random sample over the course of a month for 12 customers and find that the average dollar amount spent per transaction per customer is $102.028 with a standard deviation of $15.1769. Create a 99% confidence interval for the true average spent for all customers per transaction.

Question 3 options:

1)

( -88.421 , 115.635 )

2)

( 98.922 , 105.134 )

3)

( 88.421 , 115.635 )

4)

( 88.643 , 115.413 )

5)

( 97.647 , 106.409 )

Question 4 (1 point)

The owner of a local golf course wanted to determine the average age (in years) of the golfers that played on the course. In a random sample of 27 golfers that visited his course, the sample mean was 41.1 years old and the standard deviation was 5.19 years. Using this information, the owner calculated the confidence interval of (39, 43.2) with a confidence level of 95% for the average age. Which of the following is an appropriate interpretation of this confidence interval?

Question 4 options:

1)

We are 95% confident that the average age of the golfers surveyed is between 39 and 43.2 years old.

2)

We are 95% confident that the proportion of the ages of all golfers is between 39 and 43.2 years old.

3)

We cannot determine the proper interpretation of this interval.

4)

We are certain that 95% of the average ages of all golfers will be between 39 and 43.2 years old.

5)

We are 95% confident that the average age of all golfers that play on the golf course is between 39 and 43.2 years old.

In: Statistics and Probability

A company reported the following accounts in its unadjusted trialbalance at December 31, 2020:Dividends...

company reported the following accounts in its unadjusted trial
balance at December 31, 2020:

Dividends ...................  $ 14,000
Income Tax Expense ..........  $ 25,000
Salaries Expense ............  $ 31,000
Rental Revenue ..............  $ 33,000
Cash ........................  $ 36,000
Supplies ....................  $ 37,000
Cost of Goods Sold ..........  $ 52,000
Unearned Revenue ............  $ 54,000
Accounts Receivable .........  $ 57,000
Land ........................  $ 69,000
Accounts Payable ............  $ 76,000
Trademark ...................  $ 88,000
Inventory ...................  $ 91,000
Retained Earnings ...........  $ 95,000 (at January 1, 2020)Sales Revenue ...............  $119,000
Common Stock ................  $123,000

The Company needs to record adjusting entries at December 31, 2020
related to the following three items:

1)  A utility bill totaling $16,000 was received in late December.
    The Company expects to pay the bill in January, 2021.

2)  A physical count revealed that supplies costing $15,000 were
    still on hand as of December 31, 2020.

3)  The unearned revenue relates to a $54,000 payment received on
    July 1, 2020. The payment was from a customer who paid the company for
    services to be provided each month for 18 months, beginning on
    July 1, 2020.

Calculate Company's total liabilities at December 31, 2020 afterthe appropriate adjusting entries have been recorded and posted.

In: Accounting

A researcher was interested in investigating a relationship between the age (independent variable) of a driver...

A researcher was interested in investigating a relationship between the age (independent variable) of a driver and the distance the driver can see. For this purpose, he collected data on some drives. The data is provided in Appendix ‘1”.

To help you, partial summary analysis is provided below: SSxx= 13,752 SSxy=- 41,350 SSyy=193,667 ∑ x = ∑ Age = 1,530; ∑ y = ∑(Distance the driver can see)=12,700

Age Distance
18 510
20 590
22 560
23 510
23 460
25 490
27 560
28 510
29 460
32 410
37 420
41 460
46 450
49 380
53 460
55 420
63 350
65 420
66 300
67 410
68 300
70 390
71 320
72 370
73 280
74 420
75 460
77 360
79 310
82 360

a) Write the estimated regression line

b) Is the relationship meaningful (significant at α=0.05)? (3 pts) – make sure to state the null and alternative hypothesis first.

c) What is the strength of the relation? It is significant? (3 pts)

d) What is the coefficient of determination? (2 pts)

e) John is 61 years old. What is the expected driving distance for him? What is the 95% prediction interval for John? (4 pts)

In: Statistics and Probability