Questions
FORECASTING A major source of revenue in Jacksonville is a county sales tax on certain types...

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...

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.

Calendar Year
2014 2015 2016 2017
Total Payroll Taxable Payroll Total Payroll Taxable Payroll Total Payroll Taxable Payroll Total Payroll Taxable Payroll
First Quarter $12,000 $12,000 $11,000 $11,000 $13,000 $13,000 $10,000 $10,000
Second Quarter 11,750 11,750 11,500 11,400 12,750 12,700 9,300 9,300
Third Quarter 12,500 12,250 12,750 12,400 12,200 12,000 9,350 9,350
Fourth Quarter 13,000 12,500 12,500 12,200 14,000 13,750

Unemployment benefits became payable to the company's qualified unemployed workers on January 1, 2004. Between that time and September 30, 2017, total benefits amounting to $23,194.15 were charged against the employer's account. Hint: First total each year's taxable payroll. Using those numbers and SUTA rate you can figure out how much has been paid into the reserve from 2004-2017 and deduct benefits paid to get the balance in the reserve account as of 9/30. Compute rate for 2018 by dividing balance in reserve by average of last three years payroll.

In your computations, round amounts to the nearest cent. When required, round your final percentage answers to one decimal place.

a. Contribution rate for 2018.
%

b. Rate for 2018 if $2,000 additional benefits had been charged by mistake to the account of Applebaum Security Company by the State Unemployment Compensation Commission. Hint: Compare total reserve for 9/30/17 that you already calculated and compare it to benefits paid (add $2,000). On table, what tax rate corresponds to balance in reserve account now?

In: Accounting

Notes Receivable Discounting Marienau Suppliers had the following transactions: Mar. 1 Sold merchandise on account to...

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.

Page:  
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,...

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...

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...

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.

  • Required 1
  • Required 2
  • Required 3
  • Required 4

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.)

Percentages of completion
Choose numerator ÷ Choose denominator = % complete to date
2018 ÷ =
2019 ÷ =
2018
To date Recognized in prior years Recognized in 2018
Construction revenue
Construction expense
Gross profit (loss)
2019
To date Recognized in prior years Recognized in 2019
Construction revenue
Construction expense
Gross profit (loss)

In: Accounting

The manager of a department store believes that the mean annual income of the store's credit...

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...

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...

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...

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