A printing shop that produces advertising specialties produces paper cubes of various sizes, of which the 3.5 inch cube is the most popular. The cubes are cut from a stack of paper on cutting presses. The two sides of the cube are determined by the distance of stops on the press from the cutting knife and remain fairly constant, but the height of the cube varies depending on the number of sheets included in a “lift” by the operator. The lift height does not remain constant within an operator or between operators. The difficulty is in judging, without taking much time, what thickness of lift will give the correct height when it is pressed by the knife and cut. The humidity in the atmosphere also contributes to this difficulty, because the paper swells when humidity is high. The operators tend to err on the safe side, by lifting a thicker stack of paper than necessary.

The company management believes the cubes are being made much taller than the target, thus giving away excess paper and causing loss to the company. They have received advice from a consultant that they could install a paper-counting machine, which will give the correct lift containing exactly the same number of sheets each time a lift is made. This, however, will entail a huge capital investment. To see if the capital investment would be justifiable, the company management wants to assess the current loss in paper because of the variability of the cube heights from the target.

Data were collected by measuring the heights of 20 groups of five cubes and are provided in the table below. Estimate the loss incurred because of the cubes being taller than 3.5 inches. A cube that is exactly 3.5 inches in height weighs 1.2 lb. The company produces 3 million cubes per year, and the cost of paper is $64 per hundred-weight (100lb.).

Note that the current population of cube heights has a distribution (assume this to be normal) with an average and standard deviation, and the target population of the cubes is also a distribution with an average of 3.5 in. and a standard deviation to be determined. (You can not make every cube exactly 3.5 in. in height.) The target standard deviation can be smaller than the current standard deviation, especially if the current process is subject to some assignable causes.

Estimate the current loss in paper because of the cubes being too tall. You first may have to determine the attainable variability before estimating the loss. If any of the information you need is missing, make suitable assumptions, and state them clearly.

Activity 9: Linear Regression and Correlation Analysis

Scenario: A graduate student has administered a pro-inflammatory substance, lipopolysaccharide (LPS), to humans in the form of a pill (several doses – 0mg or placebo, 5mg, 10mg, and 15mg). She then determines the blood concentration of a particular protein that is thought to be upregulated due to LPS (mg) called Inflammotin (pg/ml) using ELISA. Find the linear model and the correlation coefficient of the experimental data (in JMP and Excel) using the data posted in the Activity 9 folder.   

DATA:

Task #1: Write the equation for the linear regression. _____________________________________________________________________

Task #2: According to your JMP results, is there a correlation between LPS and Inflammotin concentration? Why or why not? Hint: what is your correlation coefficient?

____________________________________________________________________________________________________________________________________

____________________________________________________________________________________________________________________________________

Task #3: Is this linear model the best fit for the data? Include your plot here. Why or why not? Hint: what is your coefficient of determination?

____________________________________________________________________________________________________________________________________

____________________________________________________________________________________________________________________________________

Activity 9: Linear Regression and Correlation Analysis

Task #4: Write the equation for the linear regression. ______________________________________________________________________

Task #5: According to your Excel results, is there a correlation between LPS and Inflammotin concentration? Why or why not? Hint: what is your correlation coefficient?

____________________________________________________________________________________________________________________________________

____________________________________________________________________________________________________________________________________

Task #6: Is this linear model the best fit for the data? Include your plot here. Why or why not? Hint: what is your coefficient of determination?

____________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________

Task #7: Do the answers in JMP and Excel match?

____________________________________________________________________________________________________________________________________

____________________________________________________________________________________________________________________________________

A new graduate nurse is working in a surgical ward of the local hospital. She has been allocated to care for Mrs Beverly Smith, a 70-year-old woman admitted for a hemicolectomy for stage 2 bowel cancer. Mrs Smith has a history of hypertension and stage 2 Chronic Kidney Disease (CKD). Mrs Smith had her surgery yesterday and is reported to have been stable overnight. She has a midline incision closed with staples, one Belovac of with minimal haemo-serous drainage, IV 4% Dextrose in 1/5 Normal Saline running at 85mL/hr and a PCA of Morphine sulphate 100mg in 100mL Normal Saline set to deliver 1mg with each press. She has an indwelling urinary catheter draining an average of 60mL/hr.

When the nurse assesses Mrs Smith at the beginning of the shift, she appears distressed and complains of pain rated 7 out of 10 in her abdominal area. Her observations are blood pressure 140/85 mmHg, pulse 90 bpm, respiratory rate 12, oxygen saturation 92% and temperature 36.2 degree Celsius. She is unwilling to sit up in bed and has difficulty taking a deep breath.   

The nurse explains to Mrs Smith the importance of pressing the PCA button regularly. She then checks her medication chart for any orders for “breakthrough” medication. Mrs Smith has an order for oxycodone (Endone) 10mg oral PRN, so the RN asks the endorsed EN to accompany her to the locked medication cupboard, check out the dose of Endone, and administer it to Mrs Smith, checking all the “5 rights” of medication administration.

The RN continues to give care to her other patients. When she returns to the room, she notes that Mrs Smith is sleeping peacefully. Because she had a poor night, she decides not to wake her for observations and charts “sleeping” on her PCA chart. The nurse then goes to morning tea.

When she returns from morning tea, she notes that Mrs Smith is slumped down in the bed and looks very pale. She does a set of observations and notes the following:

Patient is semi-conscious, rousing to voice, unable to give a pain score, PCA history delivered dose 15 times in the last 2 hours, blood pressure 90/60mmHg, pulse 70 bpm, respiratory rate 4 breaths per minute and shallow, oxygen saturation 84%.

Question

Express the immediate priority patient problem indicated by this situation as a Nursing Diagnosis with a ‘Related to’ and ‘Evidenced by’ statement.

Question

List four immediate priority nursing actions that are required in this situation to address the identified problem and a rationale for each.

Questions

Discuss what you believe were the main patient factors and nursing or system errors, that led to this occurrence.

Question

Following treatment by the medical and nursing team, Mrs Smith is significantly improved by the time her daughter visits later.

Describe the actions required following this incident as part of NSW Health and hospital policy to address issues of patient safety and standards of care.

Question

What are the legal requirements for a Tort of negligence? Do you believe that the new graduate RN was negligent in this situation? Justify your answer.

SORRY FOR POSTING 5 QUESTIONS BUT ITS ALL BASED ON THE SAME SCENARIO

Could you use Australian standard

A new graduate nurse is working in a surgical ward of the local hospital. She has been allocated to care for Mrs Beverly Smith, a 70-year-old woman admitted for a hemicolectomy for stage 2 bowel cancer. Mrs Smith has a history of hypertension and stage 2 Chronic Kidney Disease (CKD). Mrs Smith had her surgery yesterday and is reported to have been stable overnight. She has a midline incision closed with staples, one Belovac of with minimal haemo-serous drainage, IV 4% Dextrose in 1/5 Normal Saline running at 85mL/hr and a PCA of Morphine sulphate 100mg in 100mL Normal Saline set to deliver 1mg with each press. She has an indwelling urinary catheter draining an average of 60mL/hr.

When the nurse assesses Mrs Smith at the beginning of the shift, she appears distressed and complains of pain rated 7 out of 10 in her abdominal area. Her observations are blood pressure 140/85 mmHg, pulse 90 bpm, respiratory rate 12, oxygen saturation 92% and temperature 36.2 degree Celsius. She is unwilling to sit up in bed and has difficulty taking a deep breath.   

The nurse explains to Mrs Smith the importance of pressing the PCA button regularly. She then checks her medication chart for any orders for “breakthrough” medication. Mrs Smith has an order for oxycodone (Endone) 10mg oral PRN, so the RN asks the endorsed EN to accompany her to the locked medication cupboard, check out the dose of Endone, and administer it to Mrs Smith, checking all the “5 rights” of medication administration.

The RN continues to give care to her other patients. When she returns to the room, she notes that Mrs Smith is sleeping peacefully. Because she had a poor night, she decides not to wake her for observations and charts “sleeping” on her PCA chart. The nurse then goes to morning tea.

When she returns from morning tea, she notes that Mrs Smith is slumped down in the bed and looks very pale. She does a set of observations and notes the following:

Patient is semi-conscious, rousing to voice, unable to give a pain score, PCA history delivered dose 15 times in the last 2 hours, blood pressure 90/60mmHg, pulse 70 bpm, respiratory rate 4 breaths per minute and shallow, oxygen saturation 84%.

Question 16. Maximum word limit 50 words. (1 mark) (Reference not required for this question)

Express the immediate priority patient problem indicated by this situation as a Nursing Diagnosis with a ‘Related to’ and ‘Evidenced by’ statement.

Question 17. Maximum word limit 200 words.

List four immediate priority nursing actions that are required in this situation to address the identified problem and a rationale for each.

Questions 18. Maximum word limit 200 words.

Discuss what you believe were the main patient factors and nursing or system errors, that led to this occurrence.

Question 19. Maximum word limit 150 words.

Following treatment by the medical and nursing team, Mrs Smith is significantly improved by the time her daughter visits later.

Describe the actions required following this incident as part of NSW Health and hospital policy to address issues of patient safety and standards of care.

Question 20. Maximum word limit 200 words.

What are the legal requirements for a Tort of negligence? Do you believe that the new graduate RN was negligent in this situation? Justify your answer.

A new graduate nurse is working in a surgical ward of the local hospital. She has been allocated to care for Mrs Beverly Smith, a 70-year-old woman admitted for a hemicolectomy for stage 2 bowel cancer. Mrs Smith has a history of hypertension and stage 2 Chronic Kidney Disease (CKD). Mrs Smith had her surgery yesterday and is reported to have been stable overnight. She has a midline incision closed with staples, one Belovac of with minimal haemo-serous drainage, IV 4% Dextrose in 1/5 Normal Saline running at 85mL/hr and a PCA of Morphine sulphate 100mg in 100mL Normal Saline set to deliver 1mg with each press. She has an indwelling urinary catheter draining an average of 60mL/hr

When the nurse assesses Mrs Smith at the beginning of the shift, she appears distressed and complains of pain rated 7 out of 10 in her abdominal area. Her observations are blood pressure 140/85 mmHg, pulse 90 bpm, respiratory rate 12, oxygen saturation 92% and temperature 36.2 degree Celsius. She is unwilling to sit up in bed and has difficulty taking a deep breath.   

The nurse explains to Mrs Smith the importance of pressing the PCA button regularly. She then checks her medication chart for any orders for “breakthrough” medication. Mrs Smith has an order for oxycodone (Endone) 10mg oral PRN, so the RN asks the endorsed EN to accompany her to the locked medication cupboard, check out the dose of Endone, and administer it to Mrs Smith, checking all the “5 rights” of medication administration.

The RN continues to give care to her other patients. When she returns to the room, she notes that Mrs Smith is sleeping peacefully. Because she had a poor night, she decides not to wake her for observations and charts “sleeping” on her PCA chart. The nurse then goes to morning tea.

When she returns from morning tea, she notes that Mrs Smith is slumped down in the bed and looks very pale. She does a set of observations and notes the following:

Patient is semi-conscious, rousing to voice, unable to give a pain score, PCA history delivered dose 15 times in the last 2 hours, blood pressure 90/60mmHg, pulse 70 bpm, respiratory rate 4 breaths per minute and shallow, oxygen saturation 84%.

Question 16. Maximum word limit 50 words. (1 mark) (Reference not required for this question)

Express the immediate priority patient problem indicated by this situation as a Nursing Diagnosis with a ‘Related to’ and ‘Evidenced by’ statement.

Question 17. Maximum word limit 200 words.

List four immediate priority nursing actions that are required in this situation to address the identified problem and a rationale for each.

Questions 18. Maximum word limit 200 words.

Discuss what you believe were the main patient factors and nursing or system errors, that led to this occurrence.

Question 19. Maximum word limit 150 words.

Following treatment by the medical and nursing team, Mrs Smith is significantly improved by the time her daughter visits later.

Describe the actions required following this incident as part of NSW Health and hospital policy to address issues of patient safety and standards of care.

Question 20. Maximum word limit 200 words.

What are the legal requirements for a Tort of negligence? Do you believe that the new graduate RN was negligent in this situation? Justify your answer.

Company was started on January 1, 2017. The following accounts are on the Balance Sheet Accounts: Cash, Accounts Receivable, Equipment, Accumulated Depreciation, Prepaid Expenses, Supplies, Accounts Payable, Notes Payable, Interest Payable, Wages Payable, Unearned Revenue, Common Stock, Additional Paid in Capital, and Retained Earnings.

The company report results as of the fiscal year ending December 31, 2017.

Following are fiscal 2017 transactions:

a. January 1: The company sold 12,000 shares of $0.50 par common stock for $6 per share.

b. January 1: Borrowed $80,000 from the local bank. The loan carries a 6% annual interest rate. Interest and principal are due in full on January 1, 2026.

c. January 1: Purchased equipment with cash to be used in the business for $60,000. The estimated life of the equipment is 4 years, and the expected salvage value is $8,000.

d. January 1: Purchased an 18-month insurance policy for $9,000 with cash. The policy begins immediately.

e. During 2017: Paid $8,000 cash for advertising in the local paper, $6,500 of which was for 2017 papers and $1,500 of which is for 2018 papers.

f. During 2017: The firm pays each month’s rent for the building space on the first of the month (i.e., the firm pays rent on January 1 for rent in January). The monthly rent is $1,350. The firm began renting the building in January and rented it through December 31.

g. During 2017: Purchased supplies (e.g., cleaning solutions, sponges) for $40,000 on credit.

h. During 2017: Paid suppliers $25,000 in cash relating to items purchased in transaction

i. During 2017: Performed and billed customers for 9,500 car washes at $20 per car wash.

j. During 2017: Collected $125,000 in cash from customers billed in transaction

k. During 2017: The firm pays employees on the first of each month for work performed the previous month (i.e., the firm pays employees on February 1 for work performed in January). The total monthly wages are $3,100. Employees began work on January 1 and worked through December 31.

l. November: Started a membership program that allowed customers to pay in advance for 10 car washes at a discounted price of $15 per car wash. A total of 250 customers signed up for this membership program.

m. December: Voted the “Best Car Wash” by a people’s poll in the city. Due to this, the Bubble Blasters Auto Spa had a one-page article in the city’s magazine. 10 Bubbles estimates an increase of $20,000 in sales in 2018 as a result of this good press.

n. December: Bubble Blasters granted bonuses to three employees based on their exceptional performance in 2017. The bonus amount is $1,000 per employee and will be paid on January 15, 2018.

o. December 31: The firm declared and paid a dividend of $0.10 per share.

p. December 31: The cost of car wash supplies remaining at year end totaled $7,500. The market value of the supplies is $12,000.

q. December 31: Records show that 500 “member” car washes (from the prepaid membership program in part l) were provided during 2017.

Instructions: Record the transactions in the FSET. The beginning balances in all the accounts are 0 because the company began operations on January 1, 2017. In good form, prepare the balance sheet at December 31, 2017, and the income statement, the statement of stockholders’ equity, and the statement of cash flows (direct method) for the period ending December 31, 2017.

You have been hired as the new Director of Internal Controls and Oversight for the Clueless Corporation, in part because you took this Fraud Examination class. Clueless produces jet engines for numerous private and public clients (including the military), employs about 40,000 people nationally, has facilities in 6 states, and revenues exceed $5B per year. Clueless has recently been in the press because a former contract manager had been prosecuted for taking kickbacks from an engine parts supplier from Taiwan. About 5 years ago, a salesperson had been prosecuted for attempting to bribe an Air Force General to award a new engine contract to Clueless. From time to time, federal investigators have investigated other allegations of wrongdoing, but none of these investigations led to prosecution. Last year, Clueless hired a private fraud examination firm to look into possible inventory thefts based on an analysis done by the Clueless purchasing department. Apparently, an analysis of inventory on hand, inventory used, and inventory purchased indicated that some facilities should have been well-stocked with parts. This was not the case. The fraud examiners concluded that theft occurred but could not identify the individuals involved. The President of Clueless asks you to write a paper to present to the Board of Directors. The paper is intended to convince the Directors to support a comprehensive Fraud Control Program (FCP). New contracts with the U.S. Department of Defense require the creation of an FCP and the President is very concerned about these recurring investigations, possible thefts and how these might impact client perception and an ability to get future contracts. Clueless currently relies on its annual financial audit process as the primary anti-fraud program. Clueless does not have an internal audit function, but does have a compliance and quality control program to ensure engine quality, and contract, and regulatory compliance. The Compliance, Oversight, and Professional Standards (COPS) department is composed of staff that has been promoted through the ranks and includes engineers, accountants, lawyers, and other technical and non-technical staff. They are essentially overseeing work they used to themselves perform. The annual financial auditor has identified control weaknesses in its management letters for many years. These weaknesses have not been fully addressed.

In a clear and well-thought out paper, the President asked you to address the following:

1) A clear rationale for introducing an FCP with supporting third-party support. (For example, ACFE or other professional support for an FCP).

2) The details of the FCP as follows: a. The components/structure of the program. b. What components will prevent or deter fraud? How? c. What components will detect fraud? How?

3) What type of staff will you need to hire? (Just a description of the credentials or experience staff will need).

4) Where should the FCP fit into the organizational structure? Is the FCP one unit or multiple units?

5) How could you use existing Clueless resources within the FPC? Should you?

6) What is your plan of action given the current state of affairs and the President’s concerns? In other words, after establishing the FCP, what do recommend it and/or Clueless do in the short term (say within a year) and the long term (say within 3 to 5 years.)?

7) Include anything else you believe is relevant to your case.

If you were offered a position with a company which would allow you to take the position as either a W2 employee or an independent contractor as a 'consultant' explain which one you would choose under these circumstances and why:

- The job pays $100,000 per year paid monthly. One month vacation for both 1099 & W2. Job stability is equal regardless of which option you choose. No other benefits beyond what is required by Federal Law. You are in the 25% income tax bracket. You have to commute fifty miles to the employer's workplace (travel costs on you) and you must do so every day Monday thru Friday to get water samples needed to do your job. As a W2 employee you will have to share laboratory space with a real nerd who you don't like working with. You have a similar lab in your basement. You are a control freak and don't like being told how to do things and when to do them. It is given that there is no difference in job stability between taking this job as 1099 or W2.

- At least once a week you have to travel to the client sites (employer paid travel) which are in the deep jungle and the chances of injury and contracting diseases transmitted by mosquitoes are a concern. Ten percent of prior employees have died or been permanently disabled from these health threats. Its a dangerous and exciting job and you have a talent and passion for it. Your accomplishments will be published in the press. Your demise or injury pursuing cures for mankind will also be published.

- You are married, have three kids four, six and eight years old. You have a stay at home spouse who relies on you to bring home the bacon. Your highest priority is to provide for them. You will subordinate your lust for fame, glory and adventure found in your professional nitch and your aversion to being 'controlled' by others and even working with people you detest in order to provide for your family... if need be.

- This job will require all of your time available to work. Even as an independent contractor you won't have time to take on any other contracts.

- Your health insurance like all personal health insurance does not cover you for injuries or illnesses incurred while working. You don't have life or disability insurance. The employer provides no health benefits except those required by law. Assume you aren't able to acquire any insurance as an independent contractor to replace employer provided L&I and unemployment (though that is pausable as a high cost). Also, you aren't taking a 'home office' tax deduction for the lab in the basement because that flags you for an audit.

Assignment: 1. Identify the best choice between W2 and 1099 based on the above conditions and priorities. (Only one correct answer.) Explain your choice by explaining the most significant 'decision making' benefits of one over the other that apply to this job situation in the context of your given priorities and circumstances. Where a benefit or expense has a dollar value provide the amount involved and how it is calculated. Identify the savings or greater costs in dollar amounts related to Social Security, Medicare and federal income taxes of W2 versus 1099.

For this assignment, you will use the provided database in the Unit 5 script file. You will add statements to this file to query the database tables. For your reference, below is a screenshot of the enhanced entity relationship diagram (ERD) as a reference when you write your queries. With the data types listed in the diagram, this will help you identify the types of operators that you can use for particular queries.

Use paiza.io for MySQL to execute and troubleshoot your Structured Query Language (SQL) statements. It is recommended that you use Notepad to write your SQL statements. Then, copy and paste your SQL statements to paiza.io to test your statements to ensure that they execute without errors. Save your work frequently.

The asterisk (*) indicates that a column is not null (i.e., required to have a value).

1. If you would like to see the test SQL statements, click on “Run” to see the statements execute. You should see “Hello” appear in the Output window (see the following screenshot).
2. Because you do not require these test SQL statements for your assignment, delete the sample SQL statements. To do this, select the text, and click on the Delete key on your keyboard. Your MySQL paiza.io screen should now be blank, as you see in the following screenshot. Note that if you ran the test statements, “Hello” will still appear in the Output window.
3. Copy and paste the code from the provided script file into the code editor, and click on “Run” (“Ctrl + Enter”). You should see no error messages displayed in the Output area at the bottom of your paiza.io screen. After you click on “Run,” you should see a green bar with “Success” at the top. You will see this circled in the following screenshot:
4. Next, you will write 1 query to respond to each of the following questions. Note that you can only use the information that is in the question or the enhanced ERD. Write a query to do the following:
   1. Display all of the rows in the publisher table.
   2. Display all of the books in the book table that were written by the author whose author ID is 1504192.
   3. Display all of the purchases in the shopbasket that were ordered on 2020-02-29.
   4. Display the largest quantity ordered in the shopbasket.
   5. Display the authors' first and last names sorted by their last name.
   6. Display a count of the number of orders placed via the shopbasket.
   7. Display the order date and quantity of orders in the shopbasket that have a quantity of more than 25.
   8. Display the first and last names of those authors who have a null Facebook.
   9. Display all of the customers' names, city, and state if they live in GA, FL, or CA.
   10. Display the book titles of those books that were not published by Scholastic Press.
   11. Display the first and last names of the authors and the book titles. Only display those authors who wrote a book with the word database in the title.
   12. Add a multiline comment before the first CREATE TABLE statement that includes your name, the course code (ITCO231), and the date when you are submitting your assignment.
5. Save your script file using your last name, ITCO231, U5, and the file extension .sql, as in “Smith_ITCO231_U5.sql.”
   1. Tip: When saving a Notepad file, you can change the file extension to .sql as required for the assignment by changing the “Save as type” to “All Files” and then typing the .sql extension, as shown in the example.

I didnt understand by what you mean by SQL TEST. If what you are asking me is that an SQL TEST? Yes! It is SQL QUERY TEST!!