| 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 = (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
Absorption costing, Variable costing, and Throughput costing.
In: Accounting
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 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 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 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 be drawn from this study.
In: Psychology
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:
|
|||
|
|||
|
|||
|
|||
|
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:
|
|||
|
|||
|
|||
|
|||
|
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:
|
|||
|
|||
|
|||
|
|||
|
In: Statistics and Probability
A 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 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