MOUNTAIN ADVENTURE: WHITE WATER AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES)MOUNTAIN ADVENTURE is a Montana-based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northwest. You have been hired by MOUNTAIN ADVENTURE to evaluate their processes, risks, and internal controls. The following paragraphs describe Outdoor Adventure’s revenue cycle procedures.Revenue CycleSALES ORDER PROCESSING PROCEDURES.Customer orders are mailed or e-mailed to the sales department. When the order is received the sales clerk checks the customer’s creditworthiness from a computer terminal by running a validation application. The credit-check program determines if the customer’s account is up-to-date regarding payments and the customer has not exceeded his or her credit limit. Computer controls in the application prevent further processing of any transactions that fails the credit check. Under certain extenuating circumstances, the credit manager may override the validation control.After the customer’s credit is verified, the clerk then records the sales order through his computer terminal. A digital copy of the order is distributed to the warehouse and the shipping department terminals for further processing. The computer system automatically records the sale in the sales journal. Finally, the clerk files the hard copy of the customer order in the sales department. The warehouse manager is prompted by receipt of the digital sales order on the warehouse terminal. The manager prints out two copies of order: the stock release and a shipping notice. Using the stock release copy, a warehouse clerk picks the selected items from the shelves and sends them to the shipping department along with stock release and the shipping notice. The warehouse manager then updates the inventory subsidiary ledger and the general ledger control account from his computer terminal.When the shipping clerk receives the goods, the stock release, and the shipping notice, he matches them to the corresponding digital sales order dis-played on his terminal. If everything matches, he prints out three hard copies of the bill of lading and a packing slip.Two copies of the bill of lading and the packing slip are sent, along with the goods, to the carrier. The stock release copy and the shipping notice are sent to the accounts receivable department. The third bill of lading copy is filed in the shipping department.Upon receipt of the stock release and shipping notice, the accounts receivable clerk manually creates a hard-copy invoice, which is immediately mailed to the customer. After mailing the invoice, the clerk uses information on the stock release to update the accounts receivable subsidiary ledger and general ledger from his computer terminal. After the records are updated, the clerk files the stock release and shipping notice in the accounts receivable department.Cash Receipts ProceduresCustomer payments come directly to the general mail room along with other mail items. The mail clerk sorts the mail, opens the customer payment envelope, removes the customer’s check and remittance advice, and reconciles the two documents. To control the checks and remittance advices, the clerk manually prepares two hard copies of a remittance list. He sends one copy to the accounts receivable department, along with the corresponding remittance advices. The other copy of the remittance list accompanies the checks to the cash receipts department.Once the checks and remittance list arrive in the cash receipts department, the treasurer reconciles the documents, endorses the checks, and manually pre-pares three hard copies of a deposit slip. He then updates the cash receipts journal and the general led-ger from his computer terminal. Next, the treasurer sends the checks and two copies of the deposit slip to the bank. Finally, he files the third copy of the deposit slip and the remittance in the department.When the accounts receivable clerk receives the remittance list and remittance advices from the mail room, he reconciles the two documents. He then updates the accounts receivable subsidiary led-ger and the general ledger. Finally, he files the two documents in the department.RequiredCreate a data flow diagram of the current system.Create a system flowchart of the existing system.Describe internal control weaknesses in the system and discuss the risks associated with these weaknesses.

Question
Asked Jan 26, 2020
9 views

MOUNTAIN ADVENTURE: WHITE WATER AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES)

MOUNTAIN ADVENTURE is a Montana-based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northwest. You have been hired by MOUNTAIN ADVENTURE to evaluate their processes, risks, and internal controls. The following paragraphs describe Outdoor Adventure’s revenue cycle procedures.

Revenue Cycle

SALES ORDER PROCESSING PROCEDURES.

Customer orders are mailed or e-mailed to the sales department. When the order is received the sales clerk checks the customer’s creditworthiness from a computer terminal by running a validation application. The credit-check program determines if the customer’s account is up-to-date regarding payments and the customer has not exceeded his or her credit limit. Computer controls in the application prevent further processing of any transactions that fails the credit check. Under certain extenuating circumstances, the credit manager may override the validation control.

After the customer’s credit is verified, the clerk then records the sales order through his computer terminal. A digital copy of the order is distributed to the warehouse and the shipping department terminals for further processing. The computer system automatically records the sale in the sales journal. Finally, the clerk files the hard copy of the customer order in the sales department. The warehouse manager is prompted by receipt of the digital sales order on the warehouse terminal. The manager prints out two copies of order: the stock release and a shipping notice. Using the stock release copy, a warehouse clerk picks the selected items from the shelves and sends them to the shipping department along with stock release and the shipping notice. The warehouse manager then updates the inventory subsidiary ledger and the general ledger control account from his computer terminal.

When the shipping clerk receives the goods, the stock release, and the shipping notice, he matches them to the corresponding digital sales order dis-played on his terminal. If everything matches, he prints out three hard copies of the bill of lading and a packing slip.

Two copies of the bill of lading and the packing slip are sent, along with the goods, to the carrier. The stock release copy and the shipping notice are sent to the accounts receivable department. The third bill of lading copy is filed in the shipping department.

Upon receipt of the stock release and shipping notice, the accounts receivable clerk manually creates a hard-copy invoice, which is immediately mailed to the customer. After mailing the invoice, the clerk uses information on the stock release to update the accounts receivable subsidiary ledger and general ledger from his computer terminal. After the records are updated, the clerk files the stock release and shipping notice in the accounts receivable department.

Cash Receipts Procedures

Customer payments come directly to the general mail room along with other mail items. The mail clerk sorts the mail, opens the customer payment envelope, removes the customer’s check and remittance advice, and reconciles the two documents. To control the checks and remittance advices, the clerk manually prepares two hard copies of a remittance list. He sends one copy to the accounts receivable department, along with the corresponding remittance advices. The other copy of the remittance list accompanies the checks to the cash receipts department.

Once the checks and remittance list arrive in the cash receipts department, the treasurer reconciles the documents, endorses the checks, and manually pre-pares three hard copies of a deposit slip. He then updates the cash receipts journal and the general led-ger from his computer terminal. Next, the treasurer sends the checks and two copies of the deposit slip to the bank. Finally, he files the third copy of the deposit slip and the remittance in the department.

When the accounts receivable clerk receives the remittance list and remittance advices from the mail room, he reconciles the two documents. He then updates the accounts receivable subsidiary led-ger and the general ledger. Finally, he files the two documents in the department.

Required

  1. Create a data flow diagram of the current system.
  2. Create a system flowchart of the existing system.
  3. Describe internal control weaknesses in the system and discuss the risks associated with these weaknesses.
check_circle

Expert Answer

Step 1

Data Flow Diagram:

 

A data flow diagram can be defined as a systematic method to represent the data flow in a system or a process. This diagram also offers the information regarding inputs and outputs of the process or an entity.

 

a.

 

The data flow diagram for the sales:

 

The above figure represents the data flow diagram of Company M regarding sales revenue. The data flow diagram depicts the sales system of the company. With the help of this diagram, the order processing and revenue cycle of the company can be determined along with the shipment process.

 

The data flow diagram for the cash receipts:

Accounting homework question answer, step 1, image 1
fullscreen
Step 2

The above figure represents the data flow diagram regarding receipt of cash. It can determine how the company collects the amount of consideration from the customers with the help of this data flow diagram. It also depicts the process of comparison between the checks deposited and the amount received from the customers.

Step 3

b.

 

Prepare the system flowchart for the existing system.

 

The system ...

Accounting homework question answer, step 3, image 1
fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Accounting

Accounting Information Systems

Related Accounting Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Friendly’s Quick Loans, Inc., offers you $8.50 today but you must repay $10.75 when you get your pay...

A: a.Calculate the effective annual rate.

question_answer

Q: Unlike the other major financial statements, the statement of cash flows is not prepared from the ad...

A: Click to see the answer

question_answer

Q: Hawkins Corporation has the following balances at December 31, 2020. Projected benefit obligation...

A: Click to see the answer

question_answer

Q: Glaus Leasing Company agrees to lease equipment to Jensen Corporation on January 1, 2020. The follow...

A: Since we are entitled to answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the que...

question_answer

Q: Determining the effect of stock dividends, stock splits, and treasury stock transactions Many types ...

A: First case: 

question_answer

Q: What are the major lessor groups in the United States? What advantage does a captive leasing subsidi...

A: The major lessor groups in the United States are banks, captives, and independents.

question_answer

Q: What is service cost, and what is the basis of its measurement?

A: Service cost: Actuarial present value of benefit attributed by the pension benefit formula to servic...

question_answer

Q: Identify the amounts included in the measurement of the right-of-use asset.

A: Following are the amounts included in the right-of-use asset: 1) Lease liability at its initial reco...

question_answer

Q: Anthony Incorporated leases a piece of machinery to Irving Company on January 1, 2020, under the fol...

A: a.Leases is a contract by which one party conveys land, property, services, etc. to another for a sp...