In order to compare the satisfaction of customers of 2 competitor companies of , 174 customers of company A and 355 customers of company B were chosen randomly. Customers were required to rate the companies from level 1 (least satisfaction) to 5 (maximum satisfaction). The results are included below. Check whether the difference in the mean level of customers' satisfaction of the two companies is statistical important at 1%. The results are included below:
Company A Company B
Sample Size 174 355
Sample mean 3.51 3.24
Sample Standard Deviation (S) 0.51 0.52
In: Statistics and Probability
Find the ‘best fit’ equation of net income for last year on last year’s sales. Test the significance of the overall model at 1% level of significance.
| Company | Market value | Sales | Profits | Assets | Recent share price | P-E Ratio | Yield |
| 1 | 42926 | 9663 | 2446.6 | 11086 | 38 | 18 | 2.67 |
| 2 | 31557 | 37799 | 975.0 | 38870 | 47 | 33 | 3.76 |
| 3 | 19143 | 7230 | 1093.5 | 9590 | 59 | 18 | 2.85 |
| 4 | 9915 | 4908 | 737.6 | 19429 | 46 | 16 | 6.66 |
| 5 | 9094 | 989 | 267.7 | 1203 | 30 | 37 | 0.00 |
| 6 | 7206 | 13428 | 952.4 | 111896 | 70 | 8 | 1.72 |
| 7 | 7164 | 5814 | 319.4 | 5662 | 68 | 22 | 2.96 |
| 8 | 6340 | 3962 | 478.9 | 12578 | 29 | 15 | 4.87 |
| 9 | 4996 | 3525 | 183.1 | 3987 | 33 | 27 | 1.92 |
| 10 | 4211 | 3702 | 56.8 | 4070 | 33 | 74 | 3.30 |
| 11 | 4041 | 4102 | 282.3 | 50863 | 54 | 17 | 2.23 |
| 12 | 3789 | 1619 | 79.2 | 1490 | 87 | 48 | 0.32 |
| 13 | 3744 | 8311 | 194.0 | 5458 | 60 | 19 | 3.16 |
| 14 | 3618 | 3832 | 128.0 | 2769 | 35 | 20 | 0.00 |
| 15 | 3200 | 3434 | 190.0 | 7483 | 29 | 21 | 5.54 |
| 16 | 3167 | 2330 | 146.1 | 2458 | 58 | 22 | 2.43 |
| 17 | 2759 | 3472 | 138.6 | 3175 | 205 | 19 | 0.49 |
| 18 | 2636 | 1172 | 172.7 | 6455 | 27 | 15 | 3.31 |
| 19 | 2567 | 3858 | 91.4 | 3188 | 19 | 36 | 3.20 |
| 20 | 2416 | 6895 | 115.6 | 1812 | 21 | 22 | 0.00 |
| 21 | 2300 | 1553 | 202.3 | 4802 | 27 | 13 | 6.23 |
| 22 | 2206 | 1739 | 139.6 | 3005 | 33 | 16 | 0.61 |
| 23 | 2012 | 3376 | 65.2 | 2994 | 34 | 31 | 1.18 |
| 24 | 2010 | 1773 | 133.8 | 6859 | 18 | 24 | 0.00 |
| 25 | 1994 | 3389 | 28.0 | 3266 | 43 | 66 | 2.64 |
| 26 | 1707 | 644 | 29.4 | 845 | 41 | 58 | 0.98 |
| 27 | 1612 | 5550 | 120.7 | 3162 | 34 | 13 | 4.71 |
| 28 | 1404 | 505 | 107.1 | 2273 | 27 | 14 | 5.77 |
| 29 | 1318 | 2152 | 99.0 | 2008 | 28 | 14 | 2.12 |
| 30 | 1285 | 1220 | 64.7 | 920 | 13 | 20 | 1.85 |
| 31 | 1281 | 2867 | 112.6 | 15925 | 28 | 11 | 3.67 |
| 32 | 1261 | 577 | 60.5 | 628 | 34 | 21 | 0.00 |
| 33 | 1253 | 840 | 84.9 | 13626 | 38 | 21 | 0.74 |
| 34 | 1216 | 1386 | 102.6 | 16844 | 38 | 13 | 3.73 |
| 35 | 1066 | 2219 | 39.1 | 1662 | 21 | 27 | 1.76 |
| 36 | 1060 | 2650 | 53.7 | 1479 | 35 | 20 | 1.47 |
| 37 | 1034 | 219 | 10.6 | 250 | 30 | 57 | 0.00 |
| 38 | 1021 | 819 | 34.3 | 1566 | 37 | 28 | 0.00 |
| 39 | 1011 | 3352 | 54.4 | 1319 | 21 | 20 | 0.00 |
| 40 | 956 | 528 | 42.5 | 438 | 27 | 22 | 2.48 |
| 41 | 832 | 966 | 69.7 | 1844 | 38 | 9 | 2.86 |
| 42 | 824 | 461 | 55.4 | 502 | 24 | 15 | 0.00 |
| 43 | 805 | 883 | 16.1 | 495 | 35 | 47 | 0.00 |
| 44 | 788 | 600 | 39.7 | 584 | 31 | 22 | 0.65 |
| 45 | 692 | 389 | 26.6 | 497 | 30 | 25 | 0.00 |
| 46 | 633 | 708 | 35.8 | 1020 | 24 | 20 | 5.45 |
| 47 | 616 | 526 | 40.9 | 475 | 27 | 16 | 2.12 |
| 48 | 602 | 351 | 50.7 | 3916 | 48 | 12 | 3.60 |
| 49 | 585 | 453 | 27.1 | 331 | 44 | 23 | 0.63 |
| 50 | 581 | 705 | 39.4 | 472 | 20 | 15 | 3.16 |
Find the ‘best fit’ equation of net income for last year on last year’s sales. Test the significance of the overall model at 1% level of significance.
In: Statistics and Probability
In 2021, the Westgate Construction company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2023. Information related to the contract is as follows.
| 2021 | 2022 | 2023 | |||||||
| Cost incurred during the year | $ | 2,184,000 | $ | 3,510,000 | $ | 2,316,600 | |||
| Estimated costs to complete as of year-end | 5,616,000 | 2,106,000 | 0 | ||||||
| Billings during the year | 1,800,000 | 3,894,000 | 4,306,000 | ||||||
| Cash collections during the year | 1,600,000 | 3,400,000 | 5,000,000 | ||||||
Assume that Westgate Construction's contract with Santa Clara County does not qualify for revenue recognition over time.
Westgate recognizes revenue over time according to percentage of completion.
1. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years.
2a. In the journal below, complete the necessary journal entries for the year 2021 (credit "Various accounts" for construction costs incurred)
2b. In the journal below, complete the necessary journal entries for the year 2022 (credit "Various accounts for construction costs incurred)
2c. In the journal below, complete the necessary journal entries for the year 2023 (credit "Various accounts for construction costs incurred)
3. Complete the information required below to prepare a partial balance sheet for 2021and 2022 showing any items related to the contract. Indicate whether any of the amounts shown are contract assets or contract liabilities
4. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.)
| 2021 | 2022 | 2023 | |||||||
| Costs incurred during the year | $ | 2,520,000 | $ | 3,860,000 | $ | 3,220,000 | |||
| Estimated costs to complete as of year-end | 5,720,000 | 0 | |||||||
5.Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information.
| 2021 | 2022 | 2023 | |||||||
| Costs incurred during the year | $ | 2,520,000 | $ | 3,860,000 | $ | 4,080,000 | |||
| Estimated costs to complete as of year-end | 5,720,000 | 4,220,000 | 0 | ||||||
Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.)
| 2021 | 2022 | 2023 | |
| Revenue | |||
| Gross profit (loss) |
In: Accounting
Technology advancements have become a driving force for national and economic growth to transact across the global. Service providers have become so alarmed with the rate at which customers are able to download a web page. In one of the optic fiber survey, it was noted that the most customers tend to experience a mean download time of a resource web page is normally distributed to 8.5 seconds. After analysis by the census office, the data obtained had a standard deviation of 4.5 seconds.
In: Statistics and Probability
Create an excel workbook for the following questions. Answer these questions under your Solver work for each respective problem.
1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel:
Answer the following using your Solver answers:
In: Statistics and Probability
Fill out the summary of T-Accounts for
1. Revenue and Expenses (Temporary Income Statement Accounts)
-Includes: Sales and Service Revenue, Costs of Goods sold, Wages Expense, Insurance Expense, Rent Expense, Depreciation Expense.
2. Assets (Permanent Balance Sheet Accounts)
-Includes: Cash, Inventory, accounts receivable, prepaid insurance, equipment, accumulated depreciation, prepaid rent.
3. Liabilities and Equities (Permanent Balance Sheet Accounts)
-Includes: Accounts payable, unearned revenue, wages payable, common stock, retained earnings
4. What are the total Assets?
5. What are the total Liabilities & Shareholder's Equity?
Note: Total assets and Liabilities + Shareholders equity should balance.
Additional Info:
-Xenon uses Straight Line Depreciation
-Two months of employee wages was accrued on Dec. 31, 2020. Xenon plans to pay employees Jan. 1 2021
In: Accounting
Additional Info:
-Xenon uses Straight Line Depreciation
-Two months of employee wages was accrued on Dec. 31, 2020. Xenon plans to pay employees Jan. 1 2021
Questions
Fill out the summary of T-Accounts for
1. Revenue and Expenses (Temporary Income Statement Accounts)
-Includes: Sales and Service Revenue, Costs of Goods sold, Wages Expense, Insurance Expense, Rent Expense, Depreciation Expense.
2. Assets (Permanent Balance Sheet Accounts)
-Includes: Cash, Inventory, accounts receivable, prepaid insurance, equipment, accumulated depreciation, prepaid rent.
3. Liabilities and Equities (Permanent Balance Sheet Accounts)
-Includes: Accounts payable, unearned revenue, wages payable, common stock, retained earnings
4. What are the total Assets?
5. What are the total Liabilities & Shareholder's Equity?
Note: Total assets and Liabilities + Shareholders equity should balance.
In: Accounting
Please compose three full paragraphs (one page single spaced) with any graphical or technical analysis as appropriate for each question d) Allocating an unexpected increase in local government revenue for street improvements.
In: Economics
What does yield/revenue management entail? What types of businesses, besides hotels and airlines, would benefit from revenue management? As a consumer, how do you view the practice?
Describe the output of aggregate planning. When is aggregate planning most useful?
Explain three alternatives for adjusting capacity and two alternatives for managing demand. Give relevant industry examples as to when these are best (or least) utilized to make your point.
In: Operations Management
Badger Air is an all-cargo airline that operates on four continents. Its headquarters are in the United States. It has two divisions, Cargo and Maintenance. Cargo Division flies cargo to and from international locations, but does not operate services between two points outside the United States. That is, the planes fly to and from the United States only. Badger Air also has a maintenance facility located in Hong Kong and schedules its planes in such a way that most maintenance can be done there. In addition to Badger aircraft, Maintenance Division also provides services to Asian passenger and cargo air companies.
All of the Cargo Division income is deemed to be earned in the United States. Income from the Maintenance Division is deemed to be earned in Hong Kong. Badger’s income deemed attributable to the United States is taxed at a 40 percent rate. Its income attributable to Hong Kong is taxed at a 25 percent rate. Last year, Maintenance Division had operating revenues of $46 million, excluding services performed for Cargo Division aircraft. Cargo Division revenues last year were $135 million.
Operating costs of Maintenance Division were $36 million last year and operating costs for the Cargo Division, before considering maintenance costs, totaled $54 million. No similar maintenance facilities in Hong Kong are available to Badger.
Recently, a maintenance facility opened in the Philippines. That facility proposed to Cargo Division that it could conduct the maintenance in the Philippines. The facility proposed a price of $42 million for the services that Maintenance Division in Hong Kong provided to Cargo Division. Badger management estimated that had the services been provided in United States, the costs for the year would have totaled $74 million. In its latest tax filing, Badger assigned the $74 million as the appropriate transfer price Cargo paid for the services from Maintenance. The U.S. tax authorities denied that expense and instead applied $42 million dollars as the appropriate transfer price.
Required:
1. Calculate the revenues, costs, income taxes and total taxes for both Cargo Division and the Maintenance Division using the Philippines basis. (Do not round intermediate calculations. Enter your answers in millions rounded to 2 decimal places.)
2. Calculate the revenues, costs, income taxes and total taxes for both Cargo Division and the Maintenance Division using the U.S. basis. (Do not round intermediate calculations. Enter your answers in millions rounded to 2 decimal places.)
3. What is the difference in tax costs to Badger between the alternate transfer prices for maintenance services, that is, the difference between a transfer price of $42 million and $74 million? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)
In: Accounting