Manufacturer          
A   B   C   D
25   23   25   27
23   21   25   26
21   23   25   27
23   24   21   26
To test whether the mean time needed to mix a batch of material is the same for machines produced by 4 manufacturers, the Jacobs Chemical Company obtained the following data on the time (in minutes) needed to mix the material.

What is the p value?

Does the data provide strong evidence evidence against Ho or weak evidence?

Are the mixing machine considered all equal?

12. A CPA examines a sample of copies of December and January sales invoices for the initials of the person who verified the quantitative data and the consistency between prices on purchase order and invoice. This is an example of a:

A) Substantive test with respect to the completeness of revenue.

B) Cutoff test.

C) Tests of internal control.

D) Statistical test.

13. Which of the following revenue related transactions is not linked to the accounts indicated?

A) Recognize revenues too early--accounts receivable and revenue.

B) Understate allowance for doubtful accounts--Bad debt expense, allowance for doubtful accounts.

C) Don't write off uncollectible receivables—accounts receivable, sales discounts.

D) Don't record discounts given to customers--Cash, sales discounts, accounts receivable.

14. Which of the following is necessary if the auditor can plan to observe inventory at interim dates rather than the end of fiscal year?

A) Perpetual inventory records are maintained.

B) Complete recounts are performed by independent teams.

C) Unit cost records are integrated with production-accounting records.

D) The company adopted a sophisticated Peachtree-based accounting system.

15. Effective internal control for purchases generally can be achieved in a well-planned organizational structure with a separate purchasing department that has:

A) The ability to prepare payment vouchers based on the information on a vendor's invoice.

B) The responsibility of reviewing purchase orders issued by user departments.

C) The authority to make purchases of materials and services.

D) A direct reporting responsibility to controller of the organization.

Mastery Problem: Target Income and Margin of Safety

Target Income and Margin of Safety

At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may be computed.

Complete the following:
If a company makes $3 off of each unit it sells and has a target operating income of $1,200, then it must sell  units. Similarly, if a company has a target operating income of $75,000 and knows that total expenses for the period will be $75,000, how much revenue must it earn to reach its target operating income? $

Units sold or revenue earned above and beyond the break-even point contributes to the margin of safety for a company. Margin of safety is a crude measure of risk, in that it serves as the padding between profit and the break-even point.

Complete the following:
Expressed in terms of units, if a company hits its break-even point in units (say, 100 units) and actually sells 400 units, then the margin of safety is  units. Similarly, if the break-even point in sales revenue is $200,000, and it actually has sales revenue of $400,000, then its margin of safety is $.

Feedback

APPLY THE CONCEPTS: Target income (number of units sold)

Suppose a business has pricing and cost information as follows::

For the upcoming period, the company wishes to generate operating income of $900. Given the cost and pricing structure for the company’s product, how many units must the company sell to attain its target income?

Remember that the basic equation for calculating operating income is as follows:

Step 1: Replace the operating income in the equation with your company’s target income, and insert your cost and pricing information into the equation, as well:

Step 2: Rearrange the equation to isolate units to one side of the equation:

Number of Units to Earn Target Income =  units

Step 3: Create a contribution margin income statement to check your previous work. Enter all amounts as positive numbers.

Feedback

APPLY THE CONCEPTS: Target income (sales revenue)

Another useful method for figuring out the type of performance your company will need to reach a target income is by using sales revenue. Rather than using the number of units, this method uses total sales revenue. In companies for which the total set of goods produced and sold is more varied, this would be the preferred method, as opposed to a business in which only one product is sold. Assume a company has pricing and cost information as follows:

For the upcoming period, the company wishes to generate operating income of $75,000. Given the cost and pricing structure for the company’s product, how much sales revenue must it generate to attain its target income?

Step 1: Calculate the contribution margin ratio:

The contribution margin ratio is the contribution margin in proportion to the selling price on a per-unit basis.

Note: The contribution margin ratio is calculated to one decimal place.)

Step 2: Calculate the sales revenue required to attain the target income:

Step 3: Create a contribution margin income statement, to check your previous work. Enter all amounts as positive numbers.

Feedback

APPLY THE CONCEPTS: Margin of Safety
Margin of safety can allow you to see how much padding there is for your company between profit and loss. If this number is great, it may indicate that your company is performing very well. If this number is small, it may be worth looking into possible remediation. Consider the following pricing and cost information:

For the upcoming period, the company projects that it will sell 2,000 units. Considering that the company has a unit break-even point of 1,400 units, what is the margin of safety in terms of both units and sales revenue? Round your answers to two decimal places, if necessary.

Discuss three (3) of the levels of risk assessment as they could be applied to your company. For example, Home Depot:

       1.    Operational risk assessment: Home Depot faces the risk that their employees are not adequately trained to meet the needs of its customers.

       2.    Supply chain risk assessment: Home Depot faces the risk that the quality of the products offered by any supplier declines.

       3.    Customer risk assessment: Home Depot faces the risk of another housing downturn that places financial stress on homebuilders and lowers overall sales.

In the previous item, we used the Mann-Whitney test rather than an independent t-test. Why might we Mann-Whitney rather than the t-test?

Original question- A sample of nurses with affiliation to private hospitals (affiliation = 0) and to university hospitals (affiliation = 1) was asked to rate their confidence in making the right decisions based on their level of ongoing inservice professional development. Use a Mann-Whitney U-test to determine if the distribution of confidence in each group is the same. Be sure to always write the null and alternate hypotheses, so that the decision is made in the correct direction. Also, conduct all as two-tailed tests at α = 0.05.

In a study of environmental lead exposure and IQ, the data was collected from 148 children in Boston, Massachusetts. Their IQ scores at age of 10 approximately follow a normal distribution with mean of 115.9 and standard deviation of 14.2.Suppose one child had an IQ of 74. The researchers would like to know whether an IQ of 74 is an outlier or not.

Calculate the lower fence for the IQ data, which is the lower limit value that the IQ score can be without being considered an outlier. Keep a precision level of two decimal places for the lower fence.

Then, calculate the probability of obtaining an IQ score value of 74 or less. Keep a precision level of four decimal places for the probability.

probability of IQ score less than the lower fence:

The relationship between "strength" and "fineness" of cotton fibers was the subject of a study that produced the following data. (Give your answers correct to two decimal places.) x, Strength 76 69 71 76 83 72 78 74 80 82 y, Fineness 4.3 4.5 4.7 4.0 3.9 4.0 5.0 4.7 4.1 4.5 (a) Draw a scatter diagram. (Do this on paper. Your instructor may ask you to turn in this work.) (b) Find the 95% confidence interval for the mean measurement of fineness for fibers with a strength of 74. Lower Limit Upper Limit (c) Find the 98% prediction interval for an individual measurement of fineness for fibers with a strength of 74. Lower Limit Upper Limit

The relationship between "strength" and "fineness" of cotton fibers was the subject of a study that produced the following data. (Give your answers correct to two decimal places.)

(a) Draw a scatter diagram. (Do this on paper. Your instructor may ask you to turn in this work.)

(b) Find the 95% confidence interval for the mean measurement of fineness for fibers with a strength of 74.

(c) Find the 95% prediction interval for an individual measurement of fineness for fibers with a strength of 74.

The table below gives the average high temperatures in January and July for 12 random cities in a region with 192 192 cities. Write a 99 99​% confidence interval for the mean temperature difference between summer and winter in the region.

Mean High Temperatures ​( degrees °​F)

City A B C D E F G H I J K L

July 73 71 78 74 91 88 71 87 74 65 74 85

Jan. 35 37 40 37 56 53 39 45 46 43 19 36

The confidence interval is left parenthesis nothing comma nothing right parenthesis . , . ​(Round to one decimal place as​ needed.)

Assignment Description: In this assignment, a script file should be created to contain a set a SQL statements for the Pretty Prints Company to better manage their business. Use the database created for Pretty Prints in Assignment 2. Include the SQL statements to satisfy the following queries.

The following queries should be included in the script:

1. Create a view named Under_100. It consists of the item_id, title, artist, unit_price and order_qty for every print with a unit_price under 100 dollars.
2. Create a view named Allen. It consists of the customer_id, customer_name, customer_phone, title, and artist of each print ordered.
3. Create a view named orders. It consists of the item_id, title, artist, unit_price and order_qty for every print ordered in the range of 2014-01-01 and 2014-02-28.
4. Create a view named zip_27. It consists of the customer_name, customer_phone, title, artist and date_shipped of each print ordered by a customer whose zip code begins with 27.
5. Create the following indexes. Use the indicated index name.
   1. Create an index named customer_id on the customer_id field in the customers table.
   2. Create an index named name on the customer_name field in the customers table.
   3. Create an index named shipped on the customer_id and ship_date in the orders table.
6. Drop the name index.
7. Specify the integrity constraint that the unit_price of any print must be more than $35.
8. Create the following foreign keys within the prints database.

    a. customer_id is a foreign key in the orders table.

b. Item_id is a foreign key in the orderline table.

9. Add to the items table a new character field named type that is one character in length.

10. Change the type field in the items table to M for the print titled Skies Above.
11. Change the length of the artist field in the items table to 30.
12. What command would you use to delete the orders table from the prints database? (Do not delete the orders table.)

HERE IS DATABASE CREATED IN ASSIGNMENT 2:

USE PrettyPrints;

SELECT customer_name, customer_add, customer_city, customer_state, customer_zip FROM customers;
SELECT customer_name, customer_phone FROM customers WHERE customer_state = 'GA';
SELECT customer_name, customer_zip FROM customers WHERE customer_state = 'NC' OR customer_state = 'SC';
SELECT title, artist, order_date, ship_date FROM items,orders,orderline WHERE orders.order_id = orderline.order_id AND items.item_id = orderline.item_id;
SELECT * FROM items ORDER BY unit_price ASC;
SELECT * FROM items WHERE unit_price > 100.00;
SELECT * FROM items WHERE on_hand > 300;
SELECT title, unit_price, unit_price * 2 AS retail_price FROM items;
SELECT title, order_qty FROM items,orderline WHERE items.item_id = orderline.item_id;
SELECT title FROM items WHERE unit_price BETWEEN 40 AND 100;
Select customer_name, title, artist, sum (order_qty) from customers left outer join orders on customers.customer_id = orders.customer_id join orderline on orders.order_id = orderline.order_id join items on orderline.item_id = items.item_id group by items.artist order by items.artist;

SELECT c.customer_name, c.customer_phone FROM customers c LEFT OUTER JOIN orders o ON c.customer_id = o.order_id WHERE YEAR(o.ORDER_DATE) = '2014';

SELECT customer_name, sum(unit_price * 2) AS total_revenue FROM customers join orders on customers.customer_id = orders.customer_id join orderline on orders.order_id = orderline.order_id join items on orderline.item_id = items.item_id group by customer_name;
SELECT customer_state, COUNT(DISTINCT customer_name) AS number_of_customers FROM customers GROUP BY customer_state;