esults for the fourth quarter of 2019 are provided below. CVI's management is concerned as to why the operating income was lower than budgeted. 2019 fourth-quarter operating statement Actual Budget Revenues: High-speed Internet service $1,822,800 $1,890,000 Regular-speed Internet service 2.856.000 2.646.000 4,678,800 4,536,000 Expenses Billing and collection (55 per customer per quarter) 226,800 210.000 Variable costs of high-speed service ($15 per customer per quarter) 176,400 189.000 Variable costs of regular-speed service ($5 per customer per quarter) 168,000 147.000 Fixed costs 2.650.000 2.300.000 3221 2002 846 000 Operating income $1.457 600 $1.690.000 The budget was based on CVi holding a 35% market share assuming a total budgeted market size of 120.000 customers. The actual market size for the fourth quarter of 2019 turned out to be 125.000 customers, due to new apartment buildings in the area. The budget also assumed that 30% of CVI's customers would select the high-speed package and the remaining 70% of CVI's customers would select the regular-speed package CVI's high-speed package was budgeted with a selling price of $150 per customer per quarter. The regular-speed package had a budgeted selling price of $90 per customer per quarter. The actual prices in the fourth quarter were $155 and $85 per customer for the high-speed and regular-speed packages respectively.

Calculate each of the following variances:

a) Sales price variance

b) sales volume variance

c) Sales quantity variance

d) Sales mix variance

e) Market size variance

f) Market share variance

Studies have shown that people who suffer sudden cardiac arrest (SCA) have a better chance of survival if a defibrillator is administered very soon after cardiac arrest. How is survival rate related to the time between when cardiac arrest occurs and when the defibrillator shock is delivered? This question is addressed in the paper “Improving Survival from Sudden Cardiac Arrest: The Role of Home Defibrillators” (by J.K. Stross, University of Michigan, February 2002). The accompanying data give y = survival rate (percent) and x = mean call-to-shock time (minutes) for a cardiac rehabilitative center (where cardiac arrests occurred while victims were hospitalized and so the call-to-shock time tended to be short) and for four communities of different sizes

Mean call-to-shock time,x                 2              6              7              9              12

Survival Rate, y                                   92............ 44 .............32 ...............6 .................4

Do the following by hand and on Minitab.

1)Construct a scatter plot.

2)Calculate the Pearson correlation coefficient.

3)Determine equation of least squares line that can be used for predicting a value of y based on a value of x.

4)Compute SSE = for the least squares line.

5)Why do we call the least squares line the “best fitting line”?

6)   Calculate r² using the following formula: .   Interpret the r² value.

7) Using your equation in part c, draw the least squares line on the scatterplot you constructed in part a.

8) Use your prediction equation to predict SCA survival rate for a community with a mean call-to-shock time of 8 min. (Round your answer to five decimal places.)

1. (20 pts) Use the “Distance.sav” (SPSS) data set (located below) to perform a linear regression analysis. This dataset shows how far on average a person in Illinois drives each year. Write your findings using the format presented in the class slides. (2 pts) How much of the variation in the dependent variable is explained by the variation in the independent variable? What statistic did you use? (2 pts) Is the linear model significantly different than zero? Why or why not? What statistic did you use? (4 pts) Do the model assumptions hold? Why or why not? Provide a thorough response. (Hint: Create both a Histogram and a Normal probability plot using the standardized residuals. Also create a scatterplot of Regression Standardized Residuals and the Regression Standardized Predicted Value of the dependent variable. Attach a copy of each below.)

2. Enter the following record into the Inventory table using data listed below:

3. The Chevrolet Lumina was sold on 5/20/08 by Bauer for $9,300. Update the INVENTORY table and modify date sold, selling price, and repnumber.
4. Write SQL statements to query the following information
   1. All vehicles available for sale with a selling price less than $6,000, sorted by cost in descending order.
   2. All vehicles sold, grouped by Sales Rep.
   3. All vehicles made by Ford and Toyota.

(5 Questions are the end of the article. please I need the answer)

U.S. Factory Sector Clocks Strongest Growth in 14 Years

Analysts had expected a slowdown given rising trade tensions

By Sharon Nunn

WASHINGTON—American factory activity in August expanded at the strongest pace in more than 14 years, despite rising tensions with some of the U.S.’s largest trade partners.

The Institute for Supply Management on Tuesday said its manufacturing index rose to 61.3 in August, the highest level since May 2004, from 58.1 in July. Sales of factory-made products, or new orders, output and employment all grew at a faster pace in August.

Newsletter Sign-up

Tuesday’s release surprised analysts who had expected a slowdown in the industry in light of rising trade tensions and a typically weaker month for factory activity. Economists surveyed by The Wall Street Journal had expected a 57.5 reading for August.

“Despite concerns over U.S. protectionist policies, manufacturing sentiment remains on a solid footing, supported in large part by firm domestic demand,” said Pooja Sriram, U.S. economist at Barclays.

The U.S. and Europe, China and other countries are in the midst of trade battles stemming from steel and aluminum tariffs the Trump administration enacted earlier this year.

Mohamed A. El-Erian, chief economic adviser at Allianz, tweeted, “In addition to highlighting the strength of the U.S. #economy, this also points to the more general theme of divergence in advanced countries’ economic performance and policies.”

Though most economists hailed Tuesday’s report as a sign of robust growth continuing into the second half of 2018, some analysts said there are signs of overheating in the manufacturing industry.

“The last time we have seen something akin to the current run late in an expansion occurred in” the late 1980s, when the Federal Reserve had to raise the fed funds target rate to almost 10% to tamp down inflation, according to Stephen Stanley, chief economist at Amherst Pierpont Securities. “If you want to conclude from this quick history lesson that the Fed is currently too easy and in the process of making a policy mistake, I would not object.”

Most private economists expect the Fed will raise short-term interest rates two more times this year, once in September and again in December, with strong economic data continuing to roll into the summer months.

Despite the headline growth in factory activity, there are latent signs recent trade actions may be beginning to take a toll. An underlying gauge of new export orders for primary metals, transportation equipment and machinery declined in August, with machinery last declining at the beginning of 2017.

“We’re a significant exporter of railcars, airplanes, automobiles…Machinery is our number 6 industry sector,” said Tim Fiore, who oversees the ISM survey of factory purchasing and supply managers. “If export markets are closed off to us, orders will go down, [then] exports and production.”

Trade tensions, coupled with what appear to be economic slowdowns in some of the U.S.’s biggest trading partners, could be headwinds for the manufacturing sector.

Tuesday’s ISM report also showed a measure of inflation grew at a slower pace; the Backlog of Orders Index continued to expand, at higher levels compared with the previous month; and imports grew at a slower pace.

Broader economic growth picked up robustly in the second quarter after a modest slowdown in the early months of 2018. The unemployment rate declined below 4% this spring and forecasters expect solid growth this year, supported by recent tax cuts and strong consumer sentiment.

QUESTIONS:

With double-digit annual percentage increases in the cost of health insurance, more and more workers are likely to lack health insurance coverage (USA Today, January 23, 2004). The following sample data provide a comparison of workers with and without health insurance coverage for small, medium, and large companies. For the purposes of this study, small companies are companies that have fewer than 100 employees. Medium companies have 100 to 999 employees, and large companies have 1000 or more employees. Sample data are reported for 50 employees of small companies, 75 employees of medium companies, and 100 employees of large companies.

1. Conduct a test of independence to determine whether employee health insurance coverage is independent of the size of the company. Use  = .05. Use Table 12.4.
   
   Compute the value of the  ² test statistic (to 2 decimals).
   
   
   The p value is Selectless than .005between .005 and .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 2
   
   What is your conclusion?
   SelectConclude health insurance coverage is not independent of the size of the companyCannot reject the assumption that health insurance coverage and size of the company are independentItem 3
   
2. The USA Today article indicated employees of small companies are more likely to lack health insurance coverage. Calculate the percentages of employees without health insurance based on company size (to the nearest whole number).
   

   Small	%
   Medium	%
   Large	%

   
   
   Based on the percentages calculated above, what can you conclude?

30. Which one of the following is correct?

1. US treasury bonds have more risk than common stock
2. Common stock has more risk than secured bonds
3. Secured bonds have less risk than US treasury bonds
4. Secured debt has more risk than unsecured debt

31. The following statements are true about mutual funds except which one:

1. Mutual funds invest mostly in private unlisted companies not public stocks
2. Mutual funds are appropriate for small investors
3. Some mutual funds charge upfront “loads”, and some do not
4. Mutual funds pool individuals’ money and invest in managed public stock portfolios

32. The term “ETF” is an abbreviation for:

1. Externally Traded Funds
2. European Traded Funds
3. Essential Traded Funds
4. Exchange Traded Funds

33. As discussed in class which of the following is correct about Warren Buffet

1. He was Secretary of the Treasury during the most recent recession
2. He bailed out accounting firm Arthur Anderson following the Enron scandal
3. He purchased cheap shares of American express after the Great Salad Oil Scandal
4. None of the above

34. The Great Salad Oil Scandal referred to a company that

1. Sold salad oil with salmonella that resulted in deaths to Americans in 1989
2. Sold rancid salad oil to Mexico that killed Mexicans in 1958
3. Almost bankrupted major brokerage firms in 1963
4. Bought crude oil from Iran and labeled it as salad oil to avoid trade sanctions in 2004

35. Which of the following is not an accepted standard for reporting financial results?

1. Global Accounting Standards and Principles (GASP)
2. International Financial Reporting Standards (IFRS)
3. Generally Accepted Accounting Principles (GAAP)

Create a case Study "Eliminating measles in southern Africa" with the infor below

Health Condition: Measles, one of the most contagious infections known to humans, ranks among the top four childhood killers worldwide. Despite the existence of a safe and effective vaccine, an estimated 30 to 40 million cases of the disease and some 454,000 deaths occurred in 2004. Just under half of these deaths were in sub-Saharan Africa, where measles kills more children than HIV/AIDS. In 1996, the seven countries of southern Africa reported a total of 60,000 measles cases and 166 measles deaths.

Intervention or Program: In 1996, seven southern African countries agreed on a plan to eliminate measles. The strat­egy consisted of:

routine immunization for babies at nine months;

a nationwide "catch-up" campaign to provide a second opportunity for immunization to all children aged 9 months to 14 years; and

follow-up campaigns in young children every three to four years.

In addition, the countries organized surveillance for cases of measles and improved laboratory fa­cilities so that suspect cases could be confirmed.

Impact: Between 1996 and 2000, the number of measles cases across southern Africa fell from 60,000 to 117. The number of measles deaths fell from 166 to zero.

Cost and Cost-Effectiveness: The majority of the funding for the measles initiative came from national budgets. An esti­mate of the total cost of the program is $26.4 million, with the average cost per immunized child at $1.10. The cost of in­creasing routine coverage from 50 to 80 percent has been estimated at about $2.50 per year of healthy life gained, making measles immunization an extremely cost-effective intervention.

30) Which of the following types of unemployment can exist in an economy that is at its potential output level?

a.         cyclical unemployment only     

b.         structural unemployment only  

c.         frictional, cyclical, and seasonal unemployment only     

d.         frictional, seasonal, and structural unemployment only  

e.         there will be no unemployment in an economy that is at the potential output level

31) In the long run, but not in the short run,

a.         cyclical unemployment can exist          

b.         structural unemployment can exist        

c.         frictional unemployment can exist        

d.         the actual rate of unemployment equals the natural rate of unemployment

e.         actual output can exceed potential output

32) If the price level turns out to be higher than expected,

a.         businesses increase production

b.         the potential output level increases       

c.         initially, the short-run aggregate supply curve shifts rightward; later, there is an upward movement along that curve  

d.         initially, the short-run aggregate supply curve shifts rightward; later, there is a downward movement        along that curve        

e.         a contractionary gap develops

33) Suppose that between 2004 and 2014, Jack's salary increased from $100,000 to $200,000 per year and the price index increased from 100 to 300 during the same period. Which of the following statements best describes Jack's situation?

a.         his real income and money income have both increased

b.         his real income increased and money income decreased

c.         his real income and money income both decreased        

d.         his real income decreased and money income increased

e.         his real income and money income remained unchanged