Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Coast Foodservice is a wholesale food distributor located on the Central Coast. It sells a variety of meat, frozen foods and grocery to foodservice organizations

Coast Foodservice is a wholesale food distributor located on the Central Coast.

It sells a variety of meat, frozen foods and grocery to foodservice organizations from Salinas to Camarillo. It is a privately owned corporation with a 30,000 square facility. It has 50 employees and virtually operates 24 hours a day, 6 days per week. The company generates approximately $20 million in annual sales and most sales are on credit.

Coast Foodservice uses an old legacy database accounting software and is considering an upgrade to a customized ERP computer system designed by a local software company. The Company has hired your auditing firm to assess its operations and recommend improvements to its internal controls to reduce risk and improve the accounting system.

Sales Order Processing

Coast Foodservices salespeople telephone and bring handwritten orders to the office, which prepares an invoice.The Sales Manager approves the customers credit. If a salesperson has a special delivery order for a customer, they pick the goods from the warehouse and deliver the order themselves to avoid the burdensome time for warehouse personnel to assemble the order. A copy of the invoice serves as a shipping notice and picking slip for the warehouse. The shipping department (part of warehouse operations) removes inventory from the warehouse and prepares the shipment. When the order is complete, the goods are shipped and inventory is updated by the warehouse staff. The office clerk records the sale in the general journal and the account receivable subsidiary ledger.

Cash Receipts

The receptionist opens the mail and lists all payments. The receptionist also handles all customer complaints and prepares sales return forms for defective merchandise. The accounts receivable clerk records all cash receipts in the general journal and makes the appropriate entry in the accounts receivable subsidiary ledger. The accounts receivable clerk prepares the daily bank deposit. The Controller makes the bank deposit and later reconciles the bank statement on a monthly basis.

Required

  1. Create system flowcharts of the existing system separate diagrams for each processes (see text)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 22nd International Conference Dexa 2011 Toulouse France August/September 2011 Proceedings Part 1 Lncs 6860

Authors: Abdelkader Hameurlain ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou

2011th Edition

3642230873, 978-3642230875

More Books

Students also viewed these Databases questions

Question

Describe Balor method and give the chemical reaction.

Answered: 1 week ago

Question

How to prepare washing soda from common salt?

Answered: 1 week ago

Question

Explain strong and weak atoms with examples.

Answered: 1 week ago

Question

Explain the alkaline nature of aqueous solution of making soda.

Answered: 1 week ago

Question

Describe the linkages between HRM and strategy formulation. page 74

Answered: 1 week ago

Question

Identify approaches to improving retention rates.

Answered: 1 week ago