Ask DBMS Expert


Home >> DBMS

Newham Company Information

Newham Company is a publicly traded company operating in the "personal product" industry. Newham manufactures cosmetic and body-care products. These products are sold to large department chain stores, such as Target and Walmart, to be sold and distributed to the final consumer. Competitors include Revlon, Inc. (REV - NYSE) and Avon Products, Inc. (AVP - NYSE).

Newham Company has experienced steady growth over the past several years. Recently, there has been a change in executive management, including the CEO and CFO. The change was sparked by questionable bonus payments that were paid to the executive management team based on the company's performance. In addition, a recent lawsuit has been filed based on claims that a new product was not properly advertised, leading many customers to experience allergic reactions.

Sales and Accounts Receivable

A sample of weekly sales invoices shall be analyzed from the sales report by product category. All sales are on account. Sales are classified into four product categories: cosmetics, skin care, fragrance, and personal care. Charges to customer accounts should be dated with the date of shipment.

Sales invoices are prepared in batches on a daily basis using numbered sales invoices. Sales invoice numbers are automatically generated by the company's computer system. The accounts receivable clerk does not have appropriate computer rights to override the computer-generated invoice number. Upon preparing sales invoices, the accounts receivable clerk verifies that the first invoice number of the batch is consistent with the last invoice number of the previous batch. Inconsistencies or skipped sales invoice numbers are investigated and resolved before new sales invoices are prepared. The items shipped are compared to the items billed for proper quantity, price, and other sales order terms.

The accounting department supervisor compares and reconciles a copy of the daily sales invoice batch report to the daily accounts posting report indicating the individual accounts. The daily account posting report is prepared and sent by the accounts receivable department. Discrepancies are investigated and resolved to help assure that the customer subsidiary accounts are posted for the same total amount posted to the control account.

At the end of each month, the total of the trial balance of customer account balances (prepared by the accounts receivable department) are reconciled to the general ledger control account by the accounting department supervisor.

Sales invoice batches are dated with the date of shipment, and totals of each batches are accumulated each month and recorded in the accounts receivable control and sales revenue accounts. The accounting department supervisor approves all monthly summary entries before posting to the general ledger.

The controller approves all cash refunds and allowance credit memos for sales returns, after initiation by customer service.

Cash Management

The monthly bank statements are mailed to the controller's office. Duplicate deposit slips are retained and used when bank deposits are made, the cash receipts journal listing, and the cash disbursements listing to reconcile the general bank accounts. The payroll bank account is also reconciled, utilizing the payroll register retained by the controller's office.

The assistant controller oversees all cash management and activity, including the performance of the bank account reconciliation for each bank account held by the company. The assistant controller compares the cash receipts journal and daily deposit records with the bank deposits and duplicate deposit slips during the bank account reconciliation.

Internal auditors will randomly review the bank account reconciliations.

Cash Receipts and Accounts Receivable Processing

All cash receipts from customers related to sales are credited to accounts receivable individual and control accounts. Cash receipts are received by mail and opened by the office secretary. The office secretary prepares the cash receipt listing and daily deposit. A copy of the cash receipt listing and duplicate deposit slip is sent to the controller's office. Another copy of the cash receipt listing and the remittance advice are sent to the accounts receivable clerk for posting.

The accounts receivable department posts credits to individual customer accounts, dating the entries with the date of the remittance advice and cash receipt listing received.

Statements of accounts receivable balances are mailed to customers each month by the accounts receivable accounting department. Customers' reports of disputes or differences shall be handled by customer service.

Cash Disbursements

All disbursements are made by check, signed by the controller.

Artifact Two: Sample Audit Program

Your second portfolio artifact will be the professional audit program based on PCAOB audit standards that you create for Newham, an influential client at S.N.H.U, LLC. Make sure to incorporate the feedback you receive from your instructor while developing this audit program. The following sections should be included:

- Business Risk Analysis: Identifying risk in an organization and the environment in which it operates is the first step in approaching a potential audit and designing an effective audit program. To analyze business risk, you must:

o Gain an understanding of Newham
o Investigate the industry in which Newham operates
o Analyze and assess the risk, including fraud, involved in the company and industry
o Identify the relevant PCAOB audit standards and address their relevance to the Newham audit risk assessment

- Sample Audit Program: An audit program involves compiling a list (program) of procedures for the auditors to perform in order to obtain evidence and reasonable assurance that internal controls are operating properly and thus producing accurate financial statements. To compile a sample audit program, you have been provided with tests of control in revenue and inventory.

You must identify the relevant PCAOB audit standards and address their relevance to the Newham audit program. Include other elements as applicable to Newham.

- Report of Recommendations: Based on an auditor's experiences and knowledge of accounting, finance, and common errors or pitfalls, it is common for an auditor to provide recommendations. The sample audit program addressed here is merely a small sample, not a comprehensive program. Thus, recommendations for further risk analysis, sample methods, and other concerns should be offered. In your report of recommendations to the head of the new audit team, include the following sections:

o Explanation of findings in the risk analysis
o Sarbanes-Oxley concerns or requirements
o Recommendations on appropriate sampling methods
o Recommendations for preparation and success in the external audit

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91734539
  • Price:- $25

Priced at Now at $25, Verified Solution

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As