Question

In: Accounting

QUESTION Most grocery stores use bar code scanning technologies that interface with cash registers used to...

QUESTION

Most grocery stores use bar code scanning technologies that interface with cash registers used to process customer purchases. Cashiers use the scanners to read bar code labels attached to each product, which the system then uses to obtain unit prices, calculate transaction totals, including sales taxes, and update perpetual inventory databases. Similarly, cashiers scan bar codes on coupon or member discount cards presented by the customer to process discounts. Along with the scanning technologies, groceries use point-of-sale technologies that allow customers to swipe debit and credit cards for payment, while still maintaining the ability for customers to pay with cash.

Required:

A) Which financial statement accounts are impacted by the use of these technologies in a typical grocery store?

B) Identify risks inherent to this business process in a grocery store that might affect the financial statement accounts identified in part a. For each risk, describe how these technologies help reduce the inherent risk.

C) How does the use of these technologies create new risks for a grocery store?

D) How might an auditor use technology to test the operating effectiveness of a bar code scanner based check-out system?

thank you for your help~

Solutions

Expert Solution

A) Which financial statement accounts are impacted by the use of these technologies in a typical grocery store?

Ans - The following accounts are affected

Sales revenue account,

Sales tax (if any)

Recievables Account,

Cash account,

Discount on sales Account,

Sales Return Account,

Inventory(Stock) Account,

COGS, etc.

B) Identify risks inherent to this business process in a grocery store that might affect the financial statement accounts identified in part a. For each risk, describe how these technologies help reduce the inherent risk.

Ans - 1. As there are lot of items purchased generally, there can be totalling error. This error is automatically eliminated as the system does the totalling work.

2. Some items may get skipped from the bill, while purchased by the customer, this risk is reduced as each item is scanned by the barcode system.

3. Sometimes, Cashier can apply wrong price /wrong discount on any product, this is also eliminated as the system generates the price through the barcode

4. Also, there is a risk of out of stock for any item in grocery stores which is carefully handlled by this system as the inventory account is directly affected by sales billing. So the Shopkeeper can track stock of all items anytime & aviod stockouts.

C) How does the use of these technologies create new risks for a grocery store?

Ans- 1. Arithmetical error by the system.

2. The price of product is changed or discount is changed, but changes are not made in the system.

3. Wrong barcode sticker is fixed on the product or the master file contains wrong data.

4. Inventory of wrong product is affected, & hence inventory records are improper.

5. Techinal errors & system failures.

D) How might an auditor use technology to test the operating effectiveness of a bar code scanner based check-out system?

Ans- Using different audit softwares, the auditor can do the following things to check the barcode system:

1. Inorder to check whether the price list is correct, auditor can check the list & find out if there is any unusual pricing, negative pricing, etc.

2. He can perform walk through procedure, i.e Select some items and get them scanned through barcode & billed. Now he can verify them with the data available with him & ensure the operating effectiveness.

3. Auditor can check few items of inventory by physical count & verify with the system whether correct quantity is reflected.

4. He can test check some bills for arithemetical errors. Also, check whether daily totals are correctly posted to accounts.

5. Auditor can also verify the inventory records to check for slow moving items.


Related Solutions

Most grocery stores use bar code scanning technologies that interface with cash registers used to process...
Most grocery stores use bar code scanning technologies that interface with cash registers used to process customer purchases. Cashiers use the scanners to read bar code labels attached to each product, which the system then uses to obtain unit prices, calculate transaction totals, including sales taxes, and update perpetual inventory databases. Similarly, cashiers scan bar codes on coupon or member discount cards presented by the customer to process discounts. Along with the scanning technologies, groceries use point-of-sale technologies that allow...
9-28 2 6 Most grocery stores use bar code scanning technologies that interface with cash registers...
9-28 2 6 Most grocery stores use bar code scanning technologies that interface with cash registers used to process customer purchases. Cashiers use the scanners to read bar code labels attached to each product, which the system then uses to obtain unit prices, calculate transaction totals, including sales taxes, and update perpetual inventory databases. Similarly, cashiers scan bar codes on coupons or member discount cards presented by the customer to process discounts. Along with the scanning technologies, groceries use point-of-sale...
A chocolate bar manufacturer with stores in most country towns and cities is interested in trying...
A chocolate bar manufacturer with stores in most country towns and cities is interested in trying to estimate how daily sales are influenced by the price of their product. To do this, the company randomly chooses 6 stores in country towns and cities and offers the chocolate bar at different prices. Using chocolate bar sales as the dependent variable, the company will conduct a simple linear regression on the data below: City Price ($) (X) Sales (Y) Toowoomba 1.30 100...
Decide on the two grocery stores to use in this activity Decide on the 15 products...
Decide on the two grocery stores to use in this activity Decide on the 15 products you want to compare. The brand name, product, and size have to be exactly the same at each store. Therefore, do not compare generic brands as they have different names at different stores. You may have to wait until your visit to the first store to determine the “size” as you may not be aware of the different size packages for different products. Use...
Question 3. Describe memory types used in the MIPS assembly. Explain registers used in the MIPS...
Question 3. Describe memory types used in the MIPS assembly. Explain registers used in the MIPS assembly. Differentiate between assembly source code and machine code. Write a note on MIPS instruction formats.
Use pseudo code to plan a programming solution for the following: A GUI interface to ensure...
Use pseudo code to plan a programming solution for the following: A GUI interface to ensure a user is old enough to play a game. See additional resources above for additional resources. Properly formatted prompts to input name, address, phone number, and age. Instructions to ensure that the information is displayed back to the user. Also, the user must be 21. So, include instructions to display an appropriate message about whether or not the user can continue. Instructions that will...
Associated Grocery Stores (AGS) has always used paper bags for sacking groceries in its chain of...
Associated Grocery Stores (AGS) has always used paper bags for sacking groceries in its chain of retail supermarkets. Management has noticed that some competitors are offering reusable bags to their customers. AGS management isn’t certain just how strongly consumers in its markets feel about having to bring the reusable bags every time they visit the supermarket. Select two projective techniques. First, defend your use of a projective technique. Second, describe in detail how your two chosen techniques would be applied...
Jake’s cheese Company produces gourmet cheese for resale at local grocery stores. Jake’s expected to use...
Jake’s cheese Company produces gourmet cheese for resale at local grocery stores. Jake’s expected to use 0.50 direct labor hours to produce one unit (batch) of product, and the variable overhead rate is $5.00 per hour. Actual results are in for last year, which indicates 45,000 batches of cheese were produced and sold. The company's direct labor workforce worked 27,500 hours, and variable overhead costs totaled $144,000. Required: (1) Calculate the variable overhead spending variance. (2) Calculate the variable overhead...
Jake’s Cheese Company produces gourmet cheese for resale at local grocery stores. Jake’s expected to use...
Jake’s Cheese Company produces gourmet cheese for resale at local grocery stores. Jake’s expected to use 3.0 pounds of direct materials to produce one unit (batch) of product at a cost of $8 per pound. Actual results are in for last year, which indicates 45,000 batches of cheese were sold. The company purchased 160,000 pounds of materials at $7.50 per pound and used 145,000 pounds in production. (13 Points) Required: (1)       Calculate the materials price variance.     (2)       Calculate the materials quantity variance.           ...
Jake’s cheese Company produces gourmet cheese for resale at local grocery stores. Jake’s expected to use...
Jake’s cheese Company produces gourmet cheese for resale at local grocery stores. Jake’s expected to use 0.50 direct labor hours to produce one unit (batch) of product, and the variable overhead rate is $5.00 per hour. Actual results are in for last year, which indicates 45,000 batches of cheese were produced and sold. The company's direct labor workforce worked 27,500 hours, and variable overhead costs totaled $144,000. Required: (1)       Calculate the variable overhead spending variance.      (2)       Calculate the variable overhead efficiency variance.    ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT