Questions On A Company Accountant Design Spreadsheets

I declare that the work contained in this assignment is my own, except where acknowledgement of sources is made.

Office Depot uses multiple inventory strategies to order products. 90% to 95% of goods are ordered through automatic replenishment, manual replenishment, pull replenishment, and global sourcing are also used depending on channel, volume, velocity and cost. (Office Depot, 2015). The accuracy of the inventory from both a DC and store perspective is critical to the organizations success. Heizer and Render (2014) state that record accuracy is a prerequisite to inventory management, production scheduling, and sales. Accuracy is maintained by either periodic or perpetual systems (p.479). In Office Depot, the stores are required to cycle-count technology items such as laptops, desktops computers, and tablets five days a week. Discrepancies are entered in the system and bounced off the local DC’s on-hand inventory discrepancies. Office Depot is a “blind receive” organization meaning the stores receive pallets of products and simply unwrap and put them away. The only way a store knows if a product is missing is through the cycle-count program. This system was put into place to speed up the receiving process and eliminate unnecessary steps once the product was received at the store level. Office Depot conducts a full physical inventory once a year through a third party and trues up the inventory shrink at this time.

In accordance to the annual report of Woolworths Limited 2016, the current accounting practice that is applied to the business regarding its inventory disclosure includes; a perpetual inventory system which continually updates the information by increasing or decreasing inventory from reports throughout the year to verify accounting records (Bragg 2016). A perpetual inventory system in comparison to a periodic inventory system is more efficient and effective for larger corporations. With entities like Woolworths, many transactions occur between themselves and other stakeholders, so by utilising a perpetual inventory system, it saves time and also money (Woolworths 2016)

3. Have the user go to TOOLS command on the menu bar and select options

point of sale system. The POS system is a perpetual inventory counting method that electronically records items immediately upon their point of sale (Stevenson, 2015, pg. 552). In other words, as a cashier scans a customer 's groceries, each scanned item is automatically recorded in the system and deducted from the store’s inventory. Implementing a point of sale would benefit a business’s inventory management function in several ways. First, the POS system will provide managers with a continuous flow of updated information (Stevenson, 2015, pg. 552). As a result, the information will provide more accuracy when used for sales forecasts and analysis, which substantially affect inventory decisions. Continuously, this inventory system would also allow greater flexibility in the sense that it can be wirelessly linked to the main company’s inventory system, creating a network of the company’s inventory systems. The POS system is capable of tracking many operations at once and can be modified according to management’s needs (MacCarthy, n.d.). This flexibility would undoubtedly benefit a large company like Wegman’s with many store locations. Lastly, the system is able to help businesses maintain a high level of customer service. Because the system gives customers a receipt with the price and quantity of each item purchased, the customer is able to see exactly what he or she purchased. This practice

2. (a) What is the importance of using Conditional Formatting for data? (b) Why would a worksheet need to contain Data Bars?

I have taken it upon myself to test two inventory management systems and have found a system that will yield the least cost to Parts Emporium Inc. The two systems I have tested are the Continuous Inventory System and the Periodic Inventory System. Using data that I have gathered from the products DB032 and the EG151, I have compiled calculations and have concluded a continuous inventory system would be best for our corporation. Attached you will find said calculations; I would like to take this moment and present the continuous inventory system and recognize all of the relevant costs. The following is an explanation of each calculation under the continuous inventory system:

*Being able to use specialize computer software for bookkeeping, which will have accounts payable and receivable entered into it. The use of spreedsheets

The con of periodic system is the system does not keep continuous record of its inventory on hand. This make seller hard to do the stock check and they are not clear about the number of the inventory.

1) The company should install perpetual systems (on-line systems) so that the transactions such as stacked cartons list is updated immediately which can aid in transfer of control stock on real time basis. The advantage of on-line systems is that they are always up-to-date.

After extensive last minute digging, I finally found a manager who trusted me enough to supply me with the name of the inventory system that is used. Unfortunately for me this is all I could uncover from my employer, but it is a start. Wal-Mart uses the SMART system. Because of the way it is spelled I can only assume that it is an acronym. I have been searching for over an hour on Google.com and finally produced some meager results, but here they are.

7. Customers acquire more interesting itemized receipts with a spot of sales devices. Many cash registers can only just print the time and the quantity of the deal, but since point of deal devices are linked in to the inventory control system they provides much more specific information, including a explanation of that, the list price and the sales price.

Company use store ledger card to record the movement of of inventory known as (stock).There are two method use to record the inventory there are known as (FIFO) FIRST –IN –FIRST- OUT and the second method is FIRST-OUT.

Nowadays, in an era that has advanced technology and a place in the world. Everything can be linked only at your fingertips in the times of rapidly developing with the sophisticated technology of today. Therefore, an inventory system is also not lagging behind in introducing a method of keeping an inventory data systematically and safely. The system plays a very important role in improving the competitiveness of a business. Usually, organizations today face too many challenges to achieve the cost, speed and reliability. Efficient inventory system really help in order to make sure the store’s performance and data record is always in good condition and secured from abusers. The system basically to ease the admin to manage the

2) The system keeps track of removals from inventory on a continuous basis, so the system can provide information on the current level of inventory for each item