Analyze the implications of adverse selection in insurance markets that contain information asymmetry and community ratings. Justify your response. Analyze the primary ways in which analysts may use a model of the labor market to explain wage and employment figures for healthcare workers. Propose the main ways in which health status affects workers’ compensation overall. Provide at least one (1) example the model in use to support your response.

Which statement is not correct?

Governmental funds account for expenditures of financial resources rather than matching revenues and expenses.

The Fund Balance Reserved for Encumbrances account is not closed at the end of a fiscal year.

Revenues from licenses and permit fees are recognized when received in cash if using the modified accrual basis of accounting for governmental funds.

A fund is an independent accounting entity composed of cash and other financial resources, segregated for the purpose of carrying on specific activities and objectives.

Commitments for purchase orders are recorded as expenses.

2.

When a city received a federal grant for books to be purchased for a library, the money should have been recorded in

The Permanent Fund.

an Expendable Trust Fund.

a Capital Projects Fund.

an Agency Fund.

a Special Revenue Fund.

3.

Which statement is false regarding the Statement of Revenues, Expenditures, and Changes in Fund Balance when it is included with government-wide financial statements?

The Statement of Revenues, Expenditures, and Changes in Fund Balance uses the modified accrual method for timing purposes.

The Statement of Revenues, Expenditures, and Changes in Fund Balance presents revenues as either program revenues or general revenues.

A presentation reconciles the change in governmental fund balance to the change in net assets for governmental activities.

Other financing sources are presented on the Statement of Revenues, Expenditures, and Changes in Fund Balance.

All nonmajor funds are combined and reported together.

4.

A five-year lease is signed by the City of Wachovia for equipment with a seven-year life. The asset will be returned to the lessor at the end of the lease. The present value of the lease is $20,000, and annual payments of $5,411.41 are payable beginning on the date the lease is signed. The interest portion of the second payment is $1,604.75. The equipment is to be used in City Hall and was purchased from appropriated funds of the General Fund.

What should be recorded in the General Fund on the date the lease is signed?

Entry A.

Entry B.

Entry C.

Entry D.

Entry E.

5.

If the total acquisition value of an acquired not-for-profit organization is greater than the fair value of all identifiable net assets of the organization, and that organization’s revenues are not earned by dues or other types of earned revenues, then the excess of acquisition value over identifiable net assets is immediately reported:

As goodwill on the consolidated balance sheet.

As a pro-rata increase to the identifiable assets and liabilities acquired.

As a direct reduction in unrestricted net assets on the balance sheet.

As a reduction in unrestricted net assets on the statement of activities.

As an increase in other assets on the balance sheet.

6.

Which of the following types of health care organizations follow FASB Accounting Standards Codification for GAAP?

Entry A.

Entry B.

Entry C.

Entry D.

Entry E.

7.

What is normally required before a reorganization plan can be implemented?

The plan must be presented by the company and confirmed by the court.

The plan must be approved by each class of creditors and each class of stockholders, and confirmed by the court.

The plan must be presented by the company, approved by two-thirds of each class of stockholders, and confirmed by the court.

The plan must be presented by the company, approved by three-fourths of each class of stockholders, and confirmed by the court.

The plan must be approved by two-thirds of each class of creditors, approved by two-thirds of each class of stockholders, and confirmed by the court.

8.

Assuming all of the following expenses have priority, in what order are they prioritized?

Administrative expenses, employee claims for wages, unpaid taxes, claims for the return of customer deposits.

Employee claims for wages, unpaid taxes, administrative expenses, claims for the return of customer deposits.

Unpaid taxes, administrative expenses, employee claims for wages, return of customer deposits.

Administrative expenses, employee claims for wages, claims for the return of customer deposits, unpaid taxes.

Unpaid taxes, return of customer deposits, employee claims for wages, administrative expenses.

9.

What are the goals of probate laws?

(1) Gather and preserve all of the decedent’s property;

(2) Carry out an orderly and fair settlement of all debts;

(3) Discover and follow the decedent’s intent for the remaining property

1 only.

2 only.

3 only.

1 and 2.

1, 2, and 3.

10.

A gift that is specified in a will as “I leave $5,000 in cash to my son” is a

general legacy.

specific legacy.

demonstrative legacy.

residual legacy.

devise.

Questions 1 to 25: Select the best answer to each question. Note that a question and its answers may be split across a page break, so be sure that you have seen the entire question and all the answers before choosing an answer. 1. Jay Miller insured his pizza shop for $200,000 for fire insurance at an annual rate per $100 of $.49. At the end of 10 months, Jay canceled the policy since his pizza shop went out of business. Using the tables in the Business Math Handbook that accompanies the course textbook, determine the refund to Jay. A. $980 B. $186.20 C. $852.60 D. $127.40 2. Crestwood Paint Supply had a beginning inventory of 10 cans of paint at $25.00 per can. They purchased 20 cans during the month at $30.00 per can. They had an ending inventory valued at $500. How much paint in dollars was used for the month? A. $1,350 B. $250 C. $350 D. $850 3. The building of Jim’s Hardware is assessed at $109,000. The tax rate is $86.95 per $1,000 of assessed valuation. The tax due is A. $947.75. B. $8,659.54. C. 94,698.23. D. $8,695.45. E. $9,477.55. 4. The municipality of Waterloo needs $915,000 from property tax to meet its budget. The total value of assessed property in Waterloo is $14,000,000. What is the tax rate per dollar? (Round your answer to the nearest thousandth.) A. $.0655 B. $.07 C. $.065 D. $.071 5. The weighted-average method is best used A. for heterogeneous products. B. only for grains. C. for homogeneous products. D. only for fuels. 6. Which one of the following statements is true of specific identification? A. Flow of goods and flow of cost are the same. B. Low-cost items aren’t used in this method. C. Ending inventory isn’t associated with specific purchase prices. D. The specific purchase invoice prices aren’t used. 7. Which one of the following items is subject to sales tax in the District of Columbia? A. Shampoo B. Milk C. Roast beef D. Tomatoes 8. Which one of the following statements is true about reduced paid-up insurance? A. It results in a face amount less than the original amount . B. It continues for 20 years. C. It means the original face amount is continued for a certain number of years. D. It buys protection with paying new premiums. 9. What is the retail method? A. It doesn’t require a cost ratio. B. It’s not an estimate. C. It eliminates the need to take a physical inventory. D. It aids a company in not having to calculate an inventory cost for each individual item. 10. Calculate the optional bodily injury cost for the following: Class: 10 Optional Bodily Injury: 100/300/50 A. $108 B. $94 C. $144 D. $187 11. Total sales of $400,000 that included a 6% sales tax yields actual sales of A. $377,358.49. B. $37,537.58. C. $48,200. D. $42,800. 12. Kris bought a new fur coat for $8,000. She must pay 5% sales tax and 7% excise tax. The furrier is shipping the coat, so Kris must also pay a $15 insurance charge. What is the total purchase price of the coat? A. $8,975 B. $8,960 C. $8,400 D. $8,560 13. Jim opened a new pizza shop. He insures his store for $90,000.00 for fire. What is his premium if the rate per $100.00 is $0.83? A. $74,700.00 B. $74.70 C. $747.00 D. $700.00 14. With net sales of $40,000, beginning inventory at retail of $14,000, ending inventory at retail of $20,000, and cost of goods sold of $19,500, what is the inventory turnover at retail rounded to the nearest hundredth? A. 2.35 B. 5.23 C. 3.25 D. 5.15 15. An auto insurance premium may be partially based on the A. make of the car. B. number of years one expects to drive a car. C. expected life of the car. D. attitude of the driver. 16. To avoid distortion of extreme values, a good indicator would be the A. median. B. mode. C. weighted-mean. D. mean. 17. Calculate the median from the following numbers: 16 + 9 + 10 + 5 + 4. A. 5 B. 10 C. 4 D. 9 18. Usually, assessed value is rounded to the nearest A. cent. B. dollar. C. tenth. D. percent. 19. Matt Miller, age 28, takes out $50,000 of straight-life insurance. His annual premium is $418.20. Using the tables in the Business Math Handbook that accompanies the course textbook, determine the cash value of his policy at the end of 20 years. A. $26,500 B. $13,250 C. $26,000 D. $30,000 20. Mike’s condo has a market value of $310,000. The property in Mike’s area is assessed at 40% of the market value. The tax rate is $145.10 per $1,000 of assessed valuation. The tax for Mike is A. $16,992.40. B. $17,992.40. C. $7,999.30. D. $7,999.40. 21. Stocks are always quoted in A. percents. B. decimals. C. quarter lots. D. quarters of a dollar. End of exam 22. During inflation, the best method to use in inventory valuation that produces the smallest amount of profit is A. FIFO. B. specific invoice. C. weighted average. D. LIFO. 23. Suppose Department A is 8,000 square feet, Department B is 5,000 square feet, and Department C is 6,000 square feet. What is the percent of overhead expense applied to Department C? (Round your answer to the nearest whole percent.) A. 32% B. 26% C. 68% D. 42% 24. Clay’s Fishing Shop’s beginning inventory is $70,000 and ending inventory is $36,500. What was Clay’s average inventory? A. $35,000 B. $53,250 C. $18,250 D. $48,000 25. Which one of the following statements is true of preferred stock? A. It can be cumulative. B. It never receives dividends in arrears. C. It never has a preference to dividends over common stockholders. D. It has equal rights to common stock.

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:

• A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
• A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.
• A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.

Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:

1. Design a data model that will conform to the following criteria:
   1. Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.
   2. Create naming conventions for each entity and attributes.
   3. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
2. Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.
3. Using the salesperson table described in the summary above, complete the following:
   1. Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).
   2. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to.
4. Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

Calculate the financial ratios for the assigned company’s financial statements, and then interpret those results against company historical data as well as industry benchmarks:

• Compare the financial ratios with each of the preceding three (3) years (e.g. 2014 with 2013; 2013 with 2012; and 2012 with 2011).
• Compare the calculated financial ratios against the industry benchmarks for the industry of your assigned company.

Write a 500 to 750 word summary of your analysis.

Show financial calculations where appropriate.

This is the link where I was researching my company:

Target Corporation

• Helpful Link: http://investors.target.com/phoenix.zhtml?c=65828&p=irol-reportsAnnual
• Yahoo Finance: http://finance.yahoo.com/q/bs;_ylt=AwrBJSDLKoZUCDAA4kuTmYlQ?s=tgt+Balance+Sheet&annual

Attached is the categories to choose from. This is due today so kind of short notice, I apologize. If you could have the assignment completed by midnight central time zone that would be great. I’m willing to pay the payment of $20 as described in that category. It also has to be in apa format and all references accounted for as well as proper citations.

Socrates compared Athenians to a dazed, sluggish horse that could possibly be awakened by the persistent biting of an (annoying!) fly. This idea of Socrates as a transformative “philosophical gadfly” inspired many who have read about Socrates’s life and death.

Your formal writing assignment this week is to write a 600-900 word essay that answers each of the following questions:

• Did Socrates’s philosophical lifestyle have the potential to “wake up” Athenians in a way that could have been useful to that society?
• Does the importance of being awoken in that way justify the extreme manner that Socrates chose to live and die?
• Do you agree that (to use a famous phrase from the eighteenth century Prussian philosopher Immanuel Kant), awakening an individual–or an entire society–from “dogmatic slumbers” is a constructive and useful role of raising probing philosophical questions? Is there a significant opportunity for philosophers or others to play this kind of constructive role in our own society?

Please ensure that your essay addresses each component of the assigned questions and that your answer is well-organized, uses excellent, college-level prose, and makes judicious use of textual evidence.

****The paper must be in the APA format example I have attached as an example***

If the paper is done well, I will be more than willing to give more work to you for the next 8 weeks of this course.

Attachments:

w1_assignment.docx

w1_lecture.docx

apa_template.docx

• From the e-Activity, create a personal scenario that exemplifies the time value of money that includes the opportunity cost involved.
• Describe one (1) real-life example that shows the manner in which a person can use an annuity for retirement planning.

translate the following You-language statements into I-language messages.

Sentences to be translated:  for example:

1. You are so selfish.
2. You don’t understand a word I’m saying.
3. You are too nosy; mind your own business.
4. You totally humiliated me in front of our friends.
5. You never help me around the house.

part 2 Think of a You-language statement that you find yourself using when you communicate with a friend, family member, spouse, or romantic partner. Compose a paragraph that explains the situation in which you have used this You-language message. Consider how you would translate this You-language statement into an I-language message.