Gerard grew up in Virginia. One of his colleagues remembers that Gerard was known in school, skilled at his schoolwork and that he liked to play soccer and listen to Opera. The friend also remembers that Gerard’s family was a modest one that can barely satisfy its needs while Gerard was not happy with this type of living. Gerard graduated with an accounting degree from a good college in 1996. He enjoyed the inward mechanisms of accounting systems, and in 2000 he found himself part of Delta Company after his employer, Pioneer manufacturing, was acquired for more than $10 billion. Gerard had an influential role in adopting enterprise resource planning system that replaced the old one in while he was employed at Delta Company. A mistake by his new employer, Pioneer Manufacturing created an opportunity for Gerard to steal company funds.

As a part of the changeover team, Gerard became experienced in all aspects of ERP accounting modules including accounts receivables, accounts payable, fixed assets, financial reporting, journal entries, checks and wire payment processing. I was granted by mistake an authorization to sign and approve checks, along with a co-worker, up to $300,000. I discovered this permission quite by accident some two years after the takeover.

Our accounting department consisted of a manager, assistant manager, accounting controller, and three people whom I supervise. Together with a fellow worker and an associate, I was among those authorized employees who can request checks. The fellow- worker and I also could approve checks. In the accounting department, we shared our passwords with each other so we can finalize the work without any delay in case someone was out of office and the task had to be done immediately. One day, while I was drinking my coffee and thinking, I realized that I can access to one of my colleagues’ account to request a check and I can then log into my credentials and approve my own request. I went to work every day for the next year tempted by the pot of gold that was there for the taking.

In June 2003, my spouse was pregnant and my yearly eighty thousand dollars salary was not covering my due bills and college loans. I thought that in case I fairly paid off my obligations, at that point we might do very well with my salary coordinating our living costs. I tried my scheme by paying the current due on one of my credit cards that had a title that included the word “Universal.” Before I left my office late, I logged on as fellow worker and asked for check issuance in the amount of $1,200 to Universal. This check looked typical since we did a lot of transactions with a company that includes the word “Universal” in its title. After the check was issued, I sent it with my statement of account to my credit card company, and the company credited my account in the amount of $1,200. After some time, I felt guilty and worried because if I were caught, I would lose my job for stealing $1,200. After one week, I continued repeating the same embezzlement process while changing the amounts till I had settled the whole amount of ninety-five thousand dollars due on my credit card. After my credit card settlement, I was free and clear of all debt, except for the mortgage on our house.

I noticed that one of my checks for $5,555 had apparently gone missing just before I’d cleared all the charges to the Universal card; it wasn’t posted against my credit card account, and it had not cleared the company’s bank account. I was stressed that something had caused the bank not to prepare the check or that my extortion had been discovered. For a couple of weeks, I anxiously looked at my emails each morning checking the subject lines for words like “explanation requested.” Each time the phone rang I expected that I would be called for a meeting. At that point at around 10 on a hot late-August morning, I received a mail envelope from our accounts payable department in Chicago. There was the check I had overlooked to put my individual credit card number on the check, and so the card payment processors didn’t know whose account to credit. The accounts payable department sent it back to me since they did not know the purpose and the nature of this check.

In the middle of cold winter, the impacts of the panic had worn off, and I began considering around how simple it was to get that $95,000 “bonus. I am thinking of repeating again the fraud although I was not really in need of that money as was the case before. I remembered the missing check scare, and so I now wanted a scheme that bypassed mailing the checks to my credit card company. I registered “Sigma Enterprise” with our secretary of state, got a federal ID number, and opened a bank account at a major bank with lots of branches in Chicago. I chose Sigma because our company did a lot of business with another company that had Sigma in its name. On a Wednesday afternoon, right before I left for the day, I logged on as associate and requested a check made out for $35,250. I then logged on as myself and approved it. I picked up the check on Thursday and deposited it in Sigma’s bank account on Saturday morning. The teller treated the transaction like any other routine transaction and handed me the deposit receipt showing that the whole $35,250 was available. Using this method, I stole about $2.1 million in 2004, $1.9 million in 2005, $3.4 million in 2006, and $0.9 million in 2007.

Getting a check was easy because I logged on as fellow worker or associate and requested a check and then I approved the check. The checks were printed overnight, and it was associate’s job to collect the physical checks every day from the company building next door. I had to make sure that associate had the day off the next day because, when associate was away, I was the person who collected the checks. At my desk I would remove the Sigma check from the batch, and all the other checks were mailed off to where they were supposed to go. Normally, I would just wait for associate to take the day off, and I’d request a Sigma check the day before. If I needed money urgently, I’d give associate the day off so that I could collect the checks.

For every credit, there has to be a debit, and my debits needed to be hidden somewhere. Our payments were usually for purchases, sales commission expenses, miscellaneous expenses, or an administrative expense. In 2003 and 2004, I hid all the debits in ledger accounts that had a lot of reconciliation activity, making sure that my debit helped the account reconcile to zero. One of my accounting tasks was to record the investment income of our Australian investments in U.S. dollars (USD) in our U.S. accounting records. I was supposed to use the average Australian-dollar-to-USD exchange rate to record the interest income. From 2005 to 2007, I would calculate the real exchange rate, and then I would purposely weaken the Australian dollar by a few basis points to understate the USD value of that income. I was the only person who worked on this task for seven years, and because the accounting system had thousands of journal entries and billions of dollars of transactions, my Sigma checks remained hidden.

Every Sigma check was deposited in my account, and I have to find some explanations and excuses to spend my money without making my spouse and colleagues suspicious. In the beginning, I told my friends and wife that I have a side business where I have many clients and good source of money; at that time, all was convinced because my lifestyle was normal. However, when my lifestyle changed to the ownership of unique luxury cars, travel trips to different cities on business class, I told people that I was a gambler at Vegas and brought with me proofs that I really gambled. The gambling story did not work with my wife especially that my wealth jumped to three million dollars in less than two years. So, I knew that I had to choose either my wife or continue my fraudulent activities. I chose to insulate her from all the acts I committed and I did not want to engage her with any of my dirty actions, so I divorced her.

By mid-2007, my extortion had cooled off, and I’d as it was taken $1 million so distant that year. An internal audit found that 3 of us in the accounting department had an authorization to approve checks and we were given internal forms that we had to fill them. One morning, the fellow worker and I were discussing this matter with our boss and we all agreed that we must not have approval checks authority since we are much involved in the accounting function. We actually revoked our own check approval authority.

My ex-wife and the fellow worker became friends and she informed him that she was not convinced of the gambling story which raised the suspicion of the fellow worker. The fellow worker went immediately to the office and ran a query about the whole list of 2007 checks that she had approved or requested. She found the Sigma checks which amounted to 0.9 million dollars. On Friday, I was called for a meeting which did not went well and after two days I was arrested by fraud investigators and I told them that I wanted to talk with my attorney

Required:

Answer the following questions:

1. What anti-fraud policies would have Delta Company adopt to prevent such fraudulent activities?

2. Based on your analysis of the case, why the accounting information system controls are important?

3. What are the fraudulent behaviors encountered in the case, and what are the mitigating controls that can be implemented to avoid such fraudulent activities?

4.        Suppose that you were assigned to conduct an integrated audit for Delta Company., what are the high-risk areas that you may identify?

A study was conducted on students from a particular high school over the last 8 years. The following information was found regarding standardized tests used for college admitance. Scores on the SAT test are normally distributed with a mean of 1010 and a standard deviation of 200. Scores on the ACT test are normally distributed with a mean of 20.9 and a standard deviation of 4.4. It is assumed that the two tests measure the same aptitude, but use different scales.

If a student gets an SAT score that is the 34-percentile, find the actual SAT score.
SAT score =
Round answer to a whole number.

What would be the equivalent ACT score for this student?
ACT score =
Round answer to 1 decimal place.

If a student gets an SAT score of 1490, find the equivalent ACT score.
ACT score =
Round answer to 1 decimal place.

11.The number of meals consumed in a school canteen is recorded each day for two weeks.

n-point moving average value for n is 5.

(i) a)Explain why a suitable value for n is 5

ii) b) explain why centring will not be necessary

iii) c) Calculate all the 5-point moving average values and insert them in appropriate places in the table above.

d)Use values from your table to find an estimate for the seasonal component for Wednesday

Q7

This is from a dataset of 420 CA school districts.

We estimate the relationship between the student-teacher ratio (X1=STR) and test scores (Y=TestScore), controlling for the percentage of English learners in the classroom (X2=PctEL):

TestScore=686.0-1.10*STR-0.65*PctEL

The standard error of beta0hat is 8.7. The standard error of beta1hat is 0.43. The standard error of beta2hat is 0.31.

Test the statistical significance of STR using alpha=0.05.

What is the lower bound of your 95% confidence interval? Round to two decimal places.

Q6

This is from a dataset of 420 CA school districts.

We estimate the relationship between the student-teacher ratio (X1=STR) and test scores (Y=TestScore), controlling for the percentage of English learners in the classroom (X2=PctEL):

TestScore=686.0-1.10*STR-0.65*PctEL

The standard error of beta0hat is 8.7. The standard error of beta1hat is 0.43. The standard error of beta2hat is 0.31.

Test the statistical significance of STR using alpha=0.05.

What is your p-value? Round to four decimal places.

1. For each of the 2 majors consider the ‘School Type’ column. Construct a 92% confidence interval for the proportion of the schools that are ‘Private’.  

2. For each of the 2 majors, construct a 98% confidence interval for the mean of the column ‘Annual % ROI’.

3.In a highlighted box, discuss the following. How do these confidence intervals provide information about the which is the better major in terms of Annual ROI? Compare the confidence intervals. Which is narrower? Wider? What does the width have to do with advising someone on which major has the better ROI?  Why is it important to know the proportion of schools that are private? What factors differ in public and private schools that could influence ROI? Is a 98% confidence interval a guarantee that the ROI will be in the interval? Why or why not?

Engineer

Business

A survey of high school students revealed that the numbers of soft drinks consumed per month was normally distributed with mean 25 and standard deviation 15. A sample of 36 students was selected. What is the probability that the average number of soft drinks consumed per month for the sample was between 28.5 and 30 soft drinks? Write only a number as your answer. Round to 4 decimal places (for example 0.0048). Do not write as a percentage.

A small public school in northern California experienced an outbreak of pertussis (whooping cough). Pertussis was observed to develop in 31 of 96 unvaccinated children, 26 of 489 vaccinated children, and 14 of 67 children with unknown vaccination status. Are the unvaccinated students and those of unknown vaccination status at higher risk of pertussis? Calculate the appropriate measure of excess risk for the unvaccinated students versus the vaccinated students and for those with unknown vaccination status versus the vaccinated students (i.e., the vaccinated students are the unexposed). Interpret your results in plain language.

Skolt Products, Inc., is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Skolt Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July–October are as follows: July August September October Sales $ 42,000 $ 72,000 $ 52,000 $ 47,000 Cost of goods sold 25,200 43,200 31,200 28,200 Gross margin 16,800 28,800 20,800 18,800 Selling and administrative expenses: Selling expense 7,400 11,900 8,700 7,500 Administrative expense* 5,800 7,400 6,300 6,100 Total selling and administrative expenses 13,200 19,300 15,000 13,600 Net operating income $ 3,600 $ 9,500 $ 5,800 $ 5,200 *Includes $2,000 depreciation each month. b. Sales are 20% for cash and 80% on credit. c. Credit sales are collected over a three-month period with 10% collected in the month of sale, 65% in the month following sale, and 25% in the second month following sale. May sales totaled $32,000, and June sales totaled $38,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month’s inventory purchases are paid for in the month of purchase. The remaining 50% is paid in the following month. Accounts payable for inventory purchases at June 30 total $12,300. e. The company maintains its ending inventory levels at 75% of the cost of the merchandise to be sold in the following month. The merchandise inventory at June 30 is $18,900. f. Land costing $4,700 will be purchased in July. g. Dividends of $1,200 will be declared and paid in September. h. The cash balance on June 30 is $7,000; the company must maintain a cash balance of at least this amount at the end of each month. i. The company has an agreement with a local bank that allows it to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $60,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. (Do not round intermediate calculations.) 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for July, August, and September. (Do not round intermediate calculations.) b. A schedule of expected cash disbursements for merchandise purchases for July, August, and September and for the quarter in total.