Use the following information to create 1) Balance Sheet for yearends 2017 and 2018 and 2) and Income statement for 2018

1) She had 305 breeding does value at $340/head at yearend 2017. She increased her flock in 2018 to 325 head.

2) As of December 31, 2017, she had livestock held for sale (lambs and non-breeding ewes) valued at $38,000. She also had wool inventories valued at $9,000. As of December 31, 2018, her livestock inventories increased to $43,000, and her wool inventories decreased to $8,500.

There are those who suggest that any standard setting body is redundant because accounting standards are unnecessary. Other people feel that such standards should be produces, but by the government, so that they are a legal requirement.

Required:

Discuss the statement that accounting standards are unnecessary for the purpose of regulating financial statements.

a compound has the empirical the empirical formula CH2Br. In the gas phase, it has a density of 6.00 g/L at 375 K and .983 atm. It has a mass of 187 g/mol.

b. What is the molecular formula of the compound?

As a consultant, you need to use the Hospital database and construct a 90% confidence interval to estimate the average census for hospitals. Change the level of confidence to 99%. What happened to the interval? Did the point estimate change?

Determine the sample proportion of the Hospital database under the variable “service” that are “general medical” (category 1). From this statistic, construct a 95% confidence interval to estimate the population proportion of hospitals that are “general medical.” What is the point estimate? How much error is there in the interval?

Suppose you want to “prove” that the average hospital in the United States averages more than 700 births per year. Use the hospital database as your sample and test this hypothesis. Let alpha be 0.01.

On average, do hospitals in the United States employ fewer than 900 personnel? Use the hospital database as your sample and an alpha of 0.10 to test this figure as the alternative hypothesis. Assume that the number of births and number of employees in the hospitals are normally distributed in the population.

Part 3 - Inferential Statistics (2-3 paragraphs)

Use the Part 3: Inferential Statistics document.

• Create (formulate) hypotheses
• Run formal hypothesis tests
• Make decisions. Your decisions should be stated in non-technical terms.

The purpose of this exercise is to successfully identify and describe in detail 3 database systems that you or someone you are close to encounters often for their normal day-to-day activities. When considering database systems to describe, consider the points listed below:
1. What is the database system identified? Remember to keep it broad (e.g. our accounting system) 2. Where would you typically see such a database system used? 3. Why does this database system exist? What problem is being solved? 4. How is this database system used? 5. Who is the primary user for this database system?
I expect to see nothing less than a paragraph (4-5 sentences) about each system identified. You are all database professionals so I expect it to be written in a professional format.

So I pick three database systems that are a good one is Personal database, Document databases and, Network databases. So first database system is Personal that has support one application and involves one computer. The personal database has information people name, email, and password that my opinion.

Increase all of the listing prices by 5% for all listings under $500,000 and 10% for all listings $500,000 and higher. Update the listings table with the new prices.

update LISTING
set LISTING_PRICE = LISTING_PRICE +
case
  when LISTING_PRICE < 500000 then (LISTING_PRICE*5)/100
  when LISTING_PRICE >= 500000 then (LISTING_PRICE*10)/100
  else 0
end

-- Add 30 days to the date expires for all listings.

update LISTING set DATE_EXPIRES = DATEADD(dd, 30, DATE_EXPIRES)

-- Add "Listing updated on [current date]." to the remarks. Replace [current date] with the current systems date. Do not replace the remarks currently in the table. Add these remarks to the remarks already in the table.

update LISTING set REMARKS=CONCAT(REMARKS ," ","Listing updated on ",GETDATE())

-- Return the following information from the listings table from the stored procedure to display the information in the new real estate app: address, city, state, zip, updated listing price, updated date expires, and updated remarks.

CREATE PROCEDURE DISPLAYLISTING
AS
BEGIN
select ADDRESS,CITY,STATE,ZIP,LISTING_PRICE,DATE_EXPIRES,REMARKS from LISTING;
END;

-- Call and run the stored procedure to make the appropriate updates and return the proper results.

In order to execute the stored procedures we use the following SQL script :

EXEC DISPLAYLISTING;

We can update and display the information from the listings table using following stored procedure as :

CREATE PROCEDURE DISPLAYLISTING
AS
BEGIN

update LISTING
set LISTING_PRICE = LISTING_PRICE +
case
  when LISTING_PRICE < 500000 then (LISTING_PRICE*5)/100
  when LISTING_PRICE >= 500000 then (LISTING_PRICE*10)/100
  else 0
end;

update LISTING set DATE_EXPIRES = DATEADD(dd, 30, DATE_EXPIRES);
  
update LISTING set REMARKS=CONCAT(REMARKS ," ","Listing updated on ",GETDATE());

select ADDRESS,CITY,STATE,ZIP,LISTING_PRICE,DATE_EXPIRES,REMARKS from LISTING;

END;

For this lab exercise you will be working with and modifying the stored procedure you created in the last module. In your stored procedure, the first three requirements performed updates to your database and the last two requirements returned the data that was updated. Perform the following:

1. Enclose the code for the first requirement in its own single transaction with the proper commit and rollback functions.

2. Enclose the code for both the second and third requirements in one single transaction with the proper commit and rollback functions.

3. Call and run the stored procedure to make the appropriate updates and return the proper results. Take the appropriate screenshots to show this working and insert into your screenshot document.

4. In the second transaction you created that included the code for the second and third requirements - create an error in the middle of the transaction between the code for the two requirements. For example, you can add an insert or an update statement that uses a field that does not exist. This would cause an error. When you run it, the error should cause the entire transaction to rollback. Because of this error, no changes should be made by this transaction. This is one way of testing your rollback code.

5. Call and run the stored procedure a second time to make the appropriate updates and return the proper results. The first transaction should run without any issues but the second transaction should rollback any changes it made.

You are going to take the stored procedure you created in the lab exercise from the last module and create two transactions within it. The first transaction will contain the first requirement from that module's lab exercise. The second transaction will contain the second and third requirements from that module's lab exercise. You will run it and take screenshots to show it working properly. Then you will purposely insert code to create an error in the middle of the second transaction, in between the two items to cause the transaction to fail and rollback any changes. You will run it again and take screenshots to show your rollback working properly.

DBMS Create/Insert/Update SQL

I need the create, insert, and update SQL statement for this table as if it were being added to MySQL (please give explanations for each line of SQL code and a copy of the code as it would be entered into the query by itself:

Vendor is the name of the table the FK comes from.

Case A - Report

Value: 15%

Due Date: 19-Aug-2018

Return Date: 07-Sep-2018

Length: 2000 words

Submission method options: Alternative submission method

Task

back to top

Background:

You a member of the audit team at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors. MYH have now been appointed auditors of a community bank. Two audit directors have previous experience auditing in the banking sector and need to raise the awareness of staff with respect to the governance issues that have recently impacted the banking sector.

Question 1 (7%)

Required:

You have been asked to:

read audit standard ASA315 focusing on audit responsibility with respect to client governance,

read the web page on the ASIC report on the Commonwealth bank which details the governance issues raised by ASIC (http://www.apra.gov.au/MediaReleases/Pages/18_17.aspx), and

prepare a report that:

summarises and justifies the auditor’s responsibility to review the governance of an audit client, and

Includes a table for use in the audit which explains the impact of each of the ASIC identified Commonwealth Bank governance issues on audit risk. The table should further explain why each of the ASIC recommendations would reduce audit risk. The template below should be used.

Question 2 (3%)

David Little is a senor working at MYH and is part of a 3-person team working on a client’s material loan application that needs to be finished and delivered to the partner on Monday morning. The team are working all weekend to get it finished. There is a strong incentive for the team members, as a well prepared and successful application will ensure that this major client is retained within the firm and raise the standing of the team members in the firm. On Sunday morning, one of the team, John, calls in sick. The rest of the team work harder and get the job done. When David get home exhausted on Sunday night, his flatmate says, “I saw John and his girlfriend at that new restaurant in town today, I thought he was working in your team.”

What should David do? David doesn't think that it is fair if John gets the same kudos as the rest of the team when he did not put in the same amount of effort but he is David's friend. David and John play on the same touch football team and often spend time with each other after work and at weekends. Should David tell the partner or are there other options?

Required:

Outline the ethical issues and your decision using the American Accounting Association decision model. Use the following template to guide your answer:

Question 3 (3%)

Required:

Explain the role that incorporation of auditors and a statutory cap on auditors’ liability have on the limitation of auditors’ liability.

Rationale