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

Sachs Brands' defined benefit pension plan specifies annual retirement benefits equal to: 1.5% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2004 and is expected to retire at the end of 2038 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $98,000 at the end of 2018 and the company's actuary projects her salary to be $320,000 at retirement. The actuary's discount rate is 8%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:

1. What is the company's projected benefit obligation at the beginning of 2018 (after 14 years' service) with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
2. Estimate by the projected benefits approach the portion of Davenport's annual retirement payments attributable to 2018 service.
3. What is the company's service cost for 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
4. What is the company's interest cost for 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
5. Combine your answers to requirements 1, 3, and 4 to determine the company's projected benefit obligation at the end of 2018 (after 15 years' service) with respect to Davenport. (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

Sachs Brands’ defined benefit pension plan specifies annual retirement benefits equal to: 1.6% × service years × final year’s salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2004 and is expected to retire at the end of 2038 after 35 years’ service. Her retirement is expected to span 18 years. Davenport’s salary is $90,000 at the end of 2018 and the company’s actuary projects her salary to be $240,000 at retirement. The actuary’s discount rate is 7%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: 1. What is the company's projected benefit obligation at the beginning of 2018 (after 14 years' service) with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) 2. Estimate by the projected benefits approach the portion of Davenport's annual retirement payments attributable to 2018 service. 3. What is the company's service cost for 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) 4. What is the company's interest cost for 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) 5. Combine your answers to requirements 1, 3, and 4 to determine the company's projected benefit obligation at the end of 2018 (after 15 years' service) with respect to Davenport. (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

Sachs Brands' defined benefit pension plan specifies annual retirement benefits equal to: 1.3% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2004 and is expected to retire at the end of 2038 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $96,000 at the end of 2018 and the company's actuary projects her salary to be $310,000 at retirement. The actuary's discount rate is 6%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:

1. What is the company's projected benefit obligation at the beginning of 2018 (after 14 years' service) with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
2. Estimate by the projected benefits approach the portion of Davenport's annual retirement payments attributable to 2018 service.
3. What is the company's service cost for 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
4. What is the company's interest cost for 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
5. Combine your answers to requirements 1, 3, and 4 to determine the company's projected benefit obligation at the end of 2018 (after 15 years' service) with respect to Davenport. (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)