dolution

dolution.

Breezy Company

(This case was prepared by Elizabeth Morris, Lehigh University.)

Breezy Company of Bethlehem, Pennsylvania, is a small wholesale distributor of heating and cooling fans. The company deals with retailing firms that buy small-tomedium quantities of fans. The president, Chuck Breezy, was very pleased with the marked increase in sales over the past couple of years. Recently, however, the company’s accountant informed Chuck that although net income has increased, the percentage of uncollectibles has tripled. Due to the small size of the business, Chuck fears he may not be able to sustain these increased losses in the future. He has asked his accountant to analyze the situation.

Background

In 1998, the sales manager, John Breezy, moved to Alaska, and Chuck hired a young college graduate to take over the position. The company had always been a family business and, therefore, measurements of individual performance had never been a large consideration. The sales levels had been relatively constant because John had been content to sell to certain customers with whom he had been dealing for years. Chuck was leery about hiring outside of the family for this position. To try to keep sales levels up, he established a reward incentive based on net sales. The new sales manager, Bob Sellmore, was eager to set his career in motion and decided he would attempt to increase the sales levels. To do this, he recruited new customers while keeping the old clientele. After one year, Bob had proved himself to Chuck, who decided to introduce an advertising program to further increase sales. This brought in orders from a number of new customers, many of whom Breezy had never done business with before. The influx of orders excited Chuck so much that he instructed Jane Breezy, the finance manager, to raise the initial credit level for new customers. This induced some customers to purchase more.

Existing System

The accountant wrote up a comparative income statement to show changes in revenues and expenses over the last three years, shown in Exhibit A. Currently, Bob is receiving a commission of 2 percent of net sales. Breezy Company uses credit terms of net 30 days. At the end of previous years, bad debt expense amounted to approximately 2 percent of net sales.
As the finance manager, Jane performs credit checks. In previous years, Jane had been familiar with most clients and approved credit on the basis of past behavior. When dealing with new customers, Jane usually approved a low credit amount and increased it after the customer exhibited reliability. With the large increase in sales, Chuck felt that the current policy was restricting a further rise in sales levels. He decided to increase credit limits to eliminate this restriction. This policy, combined with the new advertising program, should attract many new customers.

Future

The new level of sales impresses Chuck and he wishes to expand, but he also wants to keep uncollectibles to a minimum. He believes the amount of uncollectibles should remain relatively constant as a percentage of sales. Chuck is thinking of expanding his production line but wants to see uncollectibles drop and sales stabilize before he proceeds with this plan.

Required:

Analyze the weaknesses in internal control and suggest improvements.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

The city’s Crime Analysis unit has submitted the following data requests. Provide the SQL statements
using subqueries to satisfy the requests. Test the statements and show execution results.

1. List the name of each officer who has reported more than the average number of crimes officers
have reported.

2. List the names of all criminals who have committed less than average number of crimes and
aren’t listed as violent offenders.

3. List appeal information for each appeal that has a less than average number of days between
the filing and hearing dates.

4. List the names of probation officers who have had a less than average number of criminals
assigned.

5. List each crime that has had the highest number of appeals recorded.

6. List the information on crime charges for each charge that has had a fine above average and a
sum paid below average.

7. List the names of all criminals who have had any of the crime code charges involved in crime ID
10089.

8. Use a correlated subquery to determine which criminals have had at least one probation period
assigned.

9. List the names of officers who have booked the highest number of crimes. Note that more than
one officer might be listed.

Note: Use a MERGE statement to satisfy the following request:
10. The criminal data warehouse contains a copy of the CRIMINALS table that needs to be updated
periodically from the production CRIMINALS table. The data warehouse table is named
CRIMINALS_DW. Use a single SQL statement to update the data warehouse table to reflect any
data changes for existing criminals and to add new criminals.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

This is an individual, written submission assignment.

Reflect and Describe a problem you have encountered where the “root cause” was unknown to you. (If you have experience in Industry/Quality, please use a relevant example, without disclosing company-private information. If you do not have any industrial quality experience, try to name a problem that was recurring, and challenging to solve.)
Does your example qualify as a “quality” problem as discussed in this course? Why or why not? How would you describe its recurrence? Try to use our SMART template to describe the problem. What parts of our template apply or don’t?
Describe the process you followed to solve it. Would you consider your solution process to be a “structured problem solving” method? What key methods/tools did you use? Would a more formal process have helped?
Your submission should connect directly to the course material so far. If you have not yet experienced an “industry-type” quality problem, you can still answer the above, contrasting your example with an industrial problem – how are they different? How are the problem solving methods different and why? Could any of our course content still apply?

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

Homeruns Go to the book’s website to obtain the data file 12_2_22 using the file format of your choice for the version of the text you are using. The variable “TrueDist” represents the distance, in feet, that the homerun traveled for all homeruns hit in the 2014 season.

(a) Draw a relative frequency histogram of the distance a homerun traveled in 2014 using a lower class limit of the first class of 300 and a class width of 10. Describe the shape of the distribution.

(b) Find the population mean and population standard deviation distance.

(c) Find the quartiles of distance.

(d) Draw a boxplot of distance. Are there any outliers?

(e) Use a normal model to determine the proportion of homeruns that exceeded 450 feet. Compare this to the actual proportion of homeruns that exceeded 450 feet.

(f) Use a normal model to determine the first and third quartiles. Compare this result to the quartiles found in part (c).

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"