FORECASTING
A major source of revenue in Jacksonville is a county sales tax on certain types of goods and services. For the most recent 4 years (2015 to 2018), quarterly sales tax revenue (in millions of dollars) has been collected. These values are shown in the following table:
|
Year |
Quarter |
Sales Tax Revenue ($1,000,000) |
|
2015 |
1 |
218 |
|
2015 |
2 |
247 |
|
2015 |
3 |
243 |
|
2015 |
4 |
292 |
|
2016 |
1 |
225 |
|
2016 |
2 |
254 |
|
2016 |
3 |
255 |
|
2016 |
4 |
299 |
|
2017 |
1 |
234 |
|
2017 |
2 |
265 |
|
2017 |
3 |
264 |
|
2017 |
4 |
327 |
|
2018 |
1 |
250 |
|
2018 |
2 |
283 |
|
2018 |
3 |
389 |
|
2018 |
4 |
356 |
Use multiple regression to estimate the trend and seasonal components of this time series. Explain the meaning of each estimated coefficient that results from the regression procedure. Then, provide a forecast for each quarter of 2019.
In: Statistics and Probability
Since the SUTA rates changes are made at the end of each year and there is much discussion about changes to the FUTA rate, the available 2017 rates were used for FUTA and SUTA. Note: For this textbook edition the rate 0.6% was used for the FUTA tax rate for employers. Example 5-10 Applebaum Security Company is located in State H, which enables employers to reduce their contribution rates under the experience-rating system. From 2004 to 2013, inclusive, the company's total contributions to state unemployment compensation amounted to $18,135. For the calendar years 2014 to 2017, inclusive, the contribution rate for Applebaum was 3.7%. The contributions of each employer are credited to an account maintained by the State Unemployment Compensation Commission. This account is credited with contributions paid into the account by the employer and is charged with unemployment benefits that are paid from the account. Starting January 1, 2018, the contributions rate for all employers in State H will be based on the following tax-rate schedule:
| Reserve Ratio | Contribution Rate | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Contributions falling below benefits paid | 7.0% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 0.0% to 7.9% | 5.5% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 8.0% to 9.9% | 4.5% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10.0% to 11.9% | 3.5% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12.0% to 14.9% | 2.5% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15.0% or |
1.5% The annual payroll for calculation purposes is the total wages payable during a 12-month period ending with the last day of the third quarter of any calendar year. The average annual payroll is the average of the last three annual payrolls. The SUTA tax rate for the year is computed using the information available (benefits received and taxes paid) as of September 30 of the preceding year. The schedule below shows the total payroll and the taxable payroll for the calendar years 2014 to 2017.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Notes Receivable Discounting
Marienau Suppliers had the following transactions:
| Mar. 1 | Sold merchandise on account to G. Perez, $5,200. |
| 20 | G. Perez gave a $5,200, 90-day, 6% note to extend time for payment. |
| 30 | G. Perez's note is discounted at Commerce Bank at a discount rate of 8%. |
| Apr. 20 | Received a $2,900, 60-day, 6% note from D. Larson in payment for sale of merchandise. |
| May 5 | D. Larson's note is discounted at Commerce Bank at a discount rate of 7%. |
| June 19 | D. Larson's note is dishonored. The bank bills Marienau for the maturity value of the note plus a $40 bank fee. |
| July 31 | D. Larson's dishonored note is collected; Larson pays Marienau the maturity value of the note, the $40 bank fee, and interest at 6% on the maturity value plus the bank fee. |
| Aug. 1 | Sold merchandise on account to A. Bauer, $5,900. |
| 12 | A. Bauer paid $500 and gave a $5,400, 30-day, 5% note to extend time for payment. |
| Sept. 11 | A. Bauer paid $300, plus interest, and gave a new $5,100, 60-day, 6% note to extend time for payment. |
| 26 | A. Bauer's note is discounted at Commerce Bank at a discount rate of 7.5%. |
| Nov. 10 | A. Bauer's note is dishonored. The bank bills Marienau for the maturity value of the note plus a $40 bank fee. |
| Dec. 15 | A. Bauer's dishonored note is collected. Bauer pays Marienau the maturity value of the note, the $40 bank fee, and interest at 6% on the maturity value plus the bank fee. |
Required:
Record the transactions in a general journal. Assume 360 days in a year.
| DATE | ACCOUNT TITLE | DOC. NO. |
POST. REF. |
DEBIT | CREDIT | ||
|---|---|---|---|---|---|---|---|
| 1 | 20-- Mar. 1 |
Accounts Receivable/G. Perez | fill in the blank 2 | fill in the blank 3 | 1 | ||
| 2 | Sales | fill in the blank 5 | fill in the blank 6 | 2 | |||
| 3 | 3 | ||||||
| 4 | 20 | Notes Receivable | fill in the blank 8 | fill in the blank 9 | 4 | ||
| 5 | Accounts Receivable/G. Perez | fill in the blank 11 | fill in the blank 12 | 5 | |||
| 6 | 6 | ||||||
| 7 | 30 | Cash | fill in the blank 14 | fill in the blank 15 | 7 | ||
| 8 | Interest Expense | fill in the blank 17 | fill in the blank 18 | 8 | |||
| 9 | Notes Receivable | fill in the blank 20 | fill in the blank 21 | 9 | |||
| 10 | 10 | ||||||
| 11 | Apr. 20 | Notes Receivable | fill in the blank 23 | fill in the blank 24 | 11 | ||
| 12 | Sales | fill in the blank 26 | fill in the blank 27 | 12 | |||
| 13 | 13 | ||||||
| 14 | May 5 | Cash | fill in the blank 29 | fill in the blank 30 | 14 | ||
| 15 | Notes Receivable | fill in the blank 32 | fill in the blank 33 | 15 | |||
| 16 | Interest Revenue | fill in the blank 35 | fill in the blank 36 | 16 | |||
| 17 | 17 | ||||||
| 18 | June 19 | fill in the blank 38 | fill in the blank 39 | 18 | |||
| 19 | fill in the blank 41 | fill in the blank 42 | 19 | ||||
| 20 | 20 | ||||||
| 21 | July 31 | fill in the blank 44 | fill in the blank 45 | 21 | |||
| 22 | fill in the blank 47 | fill in the blank 48 | 22 | ||||
| 23 | fill in the blank 50 | fill in the blank 51 | 23 | ||||
| 24 | 24 | ||||||
| 25 | Aug. 1 | fill in the blank 53 | fill in the blank 54 | 25 | |||
| 26 | fill in the blank 56 | fill in the blank 57 | 26 | ||||
| 27 | 27 | ||||||
| 28 | 12 | fill in the blank 59 | fill in the blank 60 | 28 | |||
| 29 | fill in the blank 62 | fill in the blank 63 | 29 | ||||
| 30 | fill in the blank 65 | fill in the blank 66 | 30 | ||||
| 31 | 31 | ||||||
| 32 | Sept. 11 | fill in the blank 68 | fill in the blank 69 | 32 | |||
| 33 | fill in the blank 71 | fill in the blank 72 | 33 | ||||
| 34 | fill in the blank 74 | fill in the blank 75 | 34 | ||||
| 35 | fill in the blank 77 | fill in the blank 78 | 35 | ||||
| 36 | 36 | ||||||
| 37 | 26 | fill in the blank 80 | fill in the blank 81 | 37 | |||
| 38 | fill in the blank 83 | fill in the blank 84 | 38 | ||||
| 39 | fill in the blank 86 | fill in the blank 87 | 39 | ||||
| 40 | 40 | ||||||
| 41 | Nov. 10 | fill in the blank 89 | fill in the blank 90 | 41 | |||
| 42 | fill in the blank 92 | fill in the blank 93 | 42 | ||||
| 43 | 43 | ||||||
| 44 | Dec. 15 | fill in the blank 95 | fill in the blank 96 | 44 | |||
| 45 | fill in the blank 98 | fill in the blank 99 | 45 | ||||
| 46 | fill in the blank 101 | fill in the blank 102 | 46 | ||||
| 47 | 47 |
In: Accounting
Country ,Infant deaths/1000 ,health $ per capita ,Obesity
%,Average Income,Suicides/ 100,000,Life expectancy,Universal Health
Care?, % Diabetes, Leading Cause of Death, Hospital beds/
100,000
Algeria 21.9 362 23.6
4270 3.1 75 no
7.5 Stroke 17
Argentina 11.1 605
26.5 11960 14.2 76
no 6 Heart Disease 50
Australia 3 6031
29.9 54420 11.8 83
yes 5.1 Heart Disease 38
Austria 2.9 5581
20.1 45230 16.4 82
yes 6.9 Heart Disease 76
Belgium 3.3 4884
22.1 41860 20.5 81
yes 5.1 Heart Disease 62
Brazil 14.6 947
20.1 8840 6.3 75
no 10.4 Heart Disease 22
Burkina Faso 60.9 35
5.2 640 9.2 59
no 2.2 Influenza 4
Canada 4.3 5292
30.1 43660 12.3 82
yes 7.4 Heart Disease 27
China 9.2 420 7.3
8260 10 76 no
9.8 Stroke 42
Colombia 13.6 569
20.7 6320 6.1 74
no 10 Heart Disease 15
Denmark 2.9 6463 21
56730 12.2 81 yes
7.2 Heart Disease 31
Ecuador 18.4 579 18
5820 7.5 76 no
9.2 Heart Disease 15
Ethiopia 41.4 27
3.3 660 8.4 65
no 3.4 Influenza 2
Finland 1.9 4612
22.8 44730 16.2 81
no 6 Heart Disease 49
France 3.5 4959
25.7 38950 16.9 83
yes 5.3 Lung Cancer 65
Germany 3.1 5411
22.7 43660 13.4 81
yes 7.4 Heart Disease 83
Ghana 42.8 58 10.9
1380 6.9 62 yes
2.3 Stroke 9
Greece 3.6 1743
25.1 18960 4.3 82
yes 5.2 Heart Disease 48
Guatemala 24.3 233
16.4 3790 2.5 72
no 11.1 Influenza 6
Iceland 1.6 4662
23.9 56990 13.1 83
yes 6.1 Heart Disease 32
India 37.9 75 4.7
1680 15.7 68 no
9.3 Heart Disease 7
Ireland 3 4239 27
52560 11.7 82 yes
4.4 Heart Disease 28
Israel 3.2 2910
25.8 36190 5.5 82
yes 7.5 Heart Disease 31
Italy 2.9 3258 23.7
31590 7.9 84 yes
5.1 Heart Disease 34
Japan 2 3703 3.5
38000 19.6 84 yes
5.7 Stroke 134
Kenya 36.6 78 5.9
1380 6.5 62 no
2.4 Influenza 14
Lebanon 7.3 569
30.8 7680 3.1 80
no 13 Heart Disease 29
Luxembourg 1.6 8138
24.8 76660 11.1 82
yes 4.7 Heart Disease 49
Malta 5.2 2471 28.7
24140 6 82 yes
9.9 Heart Disease 47
Mexico 11.9 677
27.6 9040 5 77
no 15.8 Diabetes 16
Myanmar 40.7 20 2.9
1190 4.3 66 no
6.8 Stroke 9
Netherlands 4.8 5694
21.9 46310 12.6 82
yes 5.5 Lung Cancer 47
New Zealand 3.3 4896
30.6 39070 11.9 82
yes 7.3 Heart Disease 28
Nicaragua 19.4 178
15.5 2050 9.5 75
no 9.2 Heart Disease 9
Norway 2.2 9522
24.8 82330 10.9 82
yes 6 Heart Disease 39
Peru 13.6 359 20.4
5950 5.8 75 no
6.9 Influenza 16
Portugal 3 2097
22.1 19850 13.6 82
yes 9.9 Stroke 34
Spain 3.6 2658 26.5
27520 8.5 83 yes
7.7 Heart Disease 30
Sweden 2.4 6808 22
54630 15.4 83 yes
4.7 Heart Disease 26
Switzerland 3.5 9674
21 81240 15.1 83
yes 6.1 Heart Disease 47
Tunisia 12.1 785
27.1 3690 5.5 75
no 9.6 Heart Disease 22
Turkey 11.6 1037
29.4 11180 8.7 75
yes 12.8 Heart Disease 27
United Arab Emirates 5.9 2405
34.5 40480 2.9 78
yes 19.3 Heart Disease 12
United Kingdom 3.5 3377
29.8 42390 8.5 82
yes 4.7 Heart Disease 28
United States 5.6 9403
35 56180 14.3 79
no 10.8 Heart Disease 29
Venezuela, RB 12.9 923
24.3 12500 3 74
no 12 Heart Disease 8
Task 7: Best Way to Measure the Center (11 points)
The center of a data set is a value that represents a “typical” data point. There are three ways to measure the center of a data set: mean, median, or mode. In a perfect data set, the mean, median, and mode would all be equal and would accurately represent the center of data set. Unfortunately, most real-world data sets are not perfect. Depending on the characteristics of the variable, we may need to choose the best way represent the center, or “typical” value. For each variable in the Global Health Summary data set, you will need to investigate and decide what measure of center (mean, median, or mode) should be used to best represent a “typical” value. For each variable, briefly explain how you came to your conclusion.
Hint: You may want to consider the type of variable (qualitative or quantitative), shape of the distribution, and/or if there are any outliers.
|
Variable (from the data set) |
Best Measure of Center (Mean, Median, or Mode) |
Explanation |
|
Country |
||
|
Infant Mortality (per 1000 live births) |
||
|
Health Expenditure ($) per capita |
||
|
Obesity Rate |
||
|
Average Income (per capita) |
||
|
Suicide per 100,000 |
||
|
Life Expectancy |
||
|
Universal Health Care? |
||
|
Diabetes Rate (%) |
||
|
Leading Cause of Death |
||
|
Hospital Beds per 100,000 |
In: Statistics and Probability
Issue 4: Design a Guarantee Policy
A company developed a new product – Toner Cartridge. In order to attract more customers to purchase the new product, the manager of the company designs a guarantee policy. If a customer purchases a toner cartridge that does not reach the guaranteed pages, the customer can get 50% of the money back. The manager does not want to lose money. However, if the guaranteed pages were set too low, the guarantee policy will not be attractive to customers at all. From actual tests with the toner cartridges, the company estimated that the mean of printing pages is 30,000 pages and the standard deviation is 1500 pages. To determine guaranteed pages, the manager just simply sets 28,500 pages as guaranteed pages. In your opinion, does the way the manager determines the guaranteed pages make any sense? If you think that it does, explain your reason why. If not, explain your reason why not, and describe what you would do if you were the manager. Discuss and explain your reasons. You must provide your statistical analysis and reasons.
In: Statistics and Probability
Assume Nortel Networks contracted to provide a customer with
Internet infrastructure for $2,050,000. The project began in 2018
and was completed in 2019. Data relating to the contract are
summarized below:
20182019
Costs incurred during the year$304,000 $1,595,000
Estimated costs to complete as of 12/31 1,216,000 0
Billings during the year 385,000 1,630,000
Cash collections during the year 252,000 1,755,000
Required:
1. Compute the amount of revenue and gross profit or loss to be
recognized in 2018 and 2019 assuming Nortel recognizes revenue over
time according to percentage of completion.
2. Compute the amount of revenue and gross profit or loss to be
recognized in 2018 and 2019 assuming this project does not qualify
for revenue recognition over time.
3. Prepare a partial balance sheet to show how the information
related to this contract would be presented at the end of 2018
assuming Nortel recognizes revenue over time according to
percentage of completion.
4. Prepare a partial balance sheet to show how the information
related to this contract would be presented at the end of 2018
assuming this project does not qualify for revenue recognition over
time.
Compute the amount of revenue and gross profit or loss to be recognized in 2018 and 2019 assuming Nortel recognizes revenue over time according to percentage of completion. (Loss amounts should be indicated with a minus sign. Use percentages as calculated and rounded in the table below to arrive at your final answer.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The manager of a department store believes that the mean annual income of the store's credit card customers is at least $21,000. For a sample of 90 customers the mean and standard deviation of income were found to be $20700 and $1450 respectively.
(1) Use the tables in the textbook to determine the critical value for the test statistic at the 5% level of significance. State your answer correct to three decimal places.
(2) Determine the calculated test statistic correct to 3 decimal places
In: Statistics and Probability
Prepare a 3-5 page paper (not including the title page and reference page) in which you review the wellness and prevention services page of a local hospital’s website. Develop a paper in which you discuss how the wellness and prevention site is a marketing effort for the hospital. In your paper, identify and consider customers (patients, physicians, etc.) that are addressed in the site. How does the site offer value to these customers? The paper should be written in APA format.
In: Nursing
Calculate the annual premium for the following policy. (Use Table 20.1) (for females subtract 3 years from the table). (Round your answer to the nearest cent.)
Amount of coverage (face value of policy) $50,000 Age and sex of insured 27 F Type of insurance policy 20-year endowment Annual premium ?
In: Finance
1.Instead of Build-Max-Heap, we could use Heap-Insert-Max to
build a tree with heap property. Write a pseudocode for that
procedure, also evaluate it’s time complexity.
2. How Insertion sort works on the following array
[16, 12, 3, 27, 9, 4, 5, 7]]
In: Computer Science