Petersen Seafood, Inc. buys and processes crab, which it sells mainly to Japan and 2 distributors in Montréal and Toronto. The business also sells crab to local consumers and restaurateurs from a sales counter at the plant. During the fishing season, which lasts approximately 15 weeks, the business produces 24,000 kg of crab per day, 5 days a week. Crab is processed before being frozen and packed in 15-kg boxes. Crab for the Japanese market is transported in refrigerated containers over more than 1,100 km to the Mirabel Airport, where it is shipped to its final destination by cargo airplane.
JPL Transpo, a local company that Petersen has been dealing with for several years, transports the containers. Containers hold 1,500 boxes and the negotiated rates are $0.20/kg for shipments to the Montréal region and
$0.25/kg for the Toronto region.
During the last few monthly audits, the owners have noted significant discrepancies between the total number of boxes produced and the number of boxes sold. The final physical inventory count at the end of the fishing season showed a discrepancy of 406 boxes between boxes produced and boxes sold. Normally, this discrepancy is less than 0.1% of the total yearly production. This year, the owners have also noted on several occasions that surplus production was not enough to satisfy local demand. This phenomenon had rarely occurred in the past. Because of these events, the owners have asked you, a management auditing expert, to analyze the situation based on the following data.
Here are the data obtained prior to the analysis:
Petersen is responsible for all ground shipping costs. Air freight costs are paid by the Japanese customer. You have asked your assistant to carry out a preliminary analysis of the production and invoicing files as well as transportation costs. The results of the analysis carried out with computer-assisted auditing techniques (CAATs) are presented in Exhibit 1. The other files in the central system are the shipping file and the employee file.
Production file
LOTNO: Lot number: unique transaction number generated automatically by the system PRODDATE: Date of lot production
QTYPRO: Crab quantity processed (in kg) LABHRS: Labour hours used in processing PROD: Production (number of 15-kg boxes)
EMPNO: Employee number of the person who completed the transaction
Invoicing file
INVNO: Invoice number: unique transaction number generated automatically by the system
INVDATE: Invoice date CUSTNO: Customer number 1: Japan Crab Meat Market
2: Montréal Fish & Sea Food Market 3: Toronto Fish & Sea Food Market 4: Local sales counter
QTYINV: Number of boxes sold and invoiced
EMPNO: Employee number of the person who completed the transaction
Transportation costs file
REFNO: Reference number: unique transaction number generated automatically by the system SHIPNO: Shipping number: unique transaction number generated automatically by the system CUSTNO: Customer number
CARNO: Carrier number CARINVNO: Carrier invoice number
INVAMT: Invoice amount for transportation costs PAYDATE: Date of payment of invoice
EMPNO: Employee number of the person who received and paid the invoice
Shipping file
SHIPNO: Shipping number: unique transaction number generated automatically by the system SHIPDATE: Shipping date
CARNAME: Carrier name CUSTNO: Customer number 1: Japan Crab Meat Market
2: Montréal Fish & Sea Food Market 3: Toronto Fish & Sea Food Market
SHIPQTY: Quantity shipped (number of 15-kg boxes)
EMPNO: Employee number of the person who signed the bill of lading
Employee file
EMPNO: Employee’s number EMPNAME: Employee’s last name EMPFTNAME: Employee’s first name SIN: Employee’s social insurance number DOB: Employee’s date of birth
ADDRESS1: Employee’s street number and name ADDRESS2: Employee’s city
TD1: TD1 amount
DATEHIRE: Date employee was hired
Command: TOTAL FIELDS PROD
The TOTAL command computes total production expressed in 15-kg boxes (PROD) from the production table.
|
Table: Production
Command: CLASSIFY ON CUSTNO SUBTOTAL QTYINV TO SCREEN
The CLASSIFY command computes the number of invoices, from the invoicing table, that were issued for each customer (CUSTNO). The amount for each customer appears in the Count field. The command also generates the total value of boxes (QTYINV) invoiced for each customer.
Table: Invoicing
CUSTNO | Count | Percent of Count | Percent of Field | QTYINV |
1 | 89 | 72.36% | 81.84% | 100,740 |
2 | 10 | 8.13% | 9.02% | 11,101 |
3 | 9 | 7.32% | 8.21% | 10,108 |
4 | 15 | 12.19% | 0.93% | 1,145 |
Totals | 123 | 100% | 100% | 123,094 |
Command: CLASSIFY ON CUSTNO SUBTOTAL AMOUNTPD TO SCREEN
The CLASSIFY command computes the amount of transportation invoices, from the transportation costs table, that were paid by each customer (CUSTNO). The amount for each customer appears in the Count field. The command also generates the total value of invoices paid (AMOUNTPD) by each customer.
Table: Transportation costs
CUSTNO | Count | Percent of Count | Percent of Field | AMOUNTPD |
1 | 89 | 82.41% | 80.74% | 302,220 |
2 | 10 | 9.26% | 9.14% | 34,203 |
3 | 9 | 8.33% | 10.12% | 37,905 |
Totals | 108 | 100% | 100% | 374,328 |
We always make sure that writers follow all your instructions precisely. You can choose your academic level or professional level, and we will assign a writer who has a respective degree.
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document.
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension.A 100% refund is guaranteed.
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.
Tutorpro support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Tutorpro Homework Help Services
At Tutorpro, we have top rated masters and PhD writers who will help you tacke that homework and score A+ grade. Tutorpro services covers all levels of education : high school, college, university undergraduate, masters and PhD academic level.
Essays
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admissions
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Editing
Tutorpro academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
Revision
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. This is free because we want you to be completely satisfied with the service offered.