Free Essay

Inventory Summary Paper

In:

Submitted By wsilva
Words 827
Pages 4
Inventory Systems Summary
QRB 501- Quantitative Reasoning for Business /MBAA0PUHA2
June 7, 2010

Inventory Systems Summary Inventory characterizes one of an organization’s largest operating cost and the maximum prospect for improving profits. With inventory systems, organizations are able to centralize control of inventory across today’s multi-channel environment. Each team member will describe his or her inventory systems with the advantages and disadvantage of each system.
Description of Each Inventory System
Sage Accpac Inventory System Crossroads is a 501(c) (3) nonprofit public benefit corporation that has served the Sacramento region since 1978 with specialized employment and placement services, and custom-tailored facility management solutions (Crossroads Diversified Services Inc., 2009). Crossroads consist of two divisions: Crossroads Employment Services concentrates on finding employment opportunities, responsible for governmental and commercial services. Crossroads use Sage Accpac for the organization inventory system. Sage Accpac provides the organization with a strong accounting and reporting potential with a flexible, yet affordable system. Sage Accpac inventory system that helps organization manages operational, accounting and customer relationships. The Sage system allows Crossroads accomplish more with few resources, allows Crossroads to grow quicker and saves the organization time and money. Sage manages IT cost, facilitates a secure system with accessible utilization virtualization programs, with a built-in AR inquiry tool to improve cash flow, good management of Crossroads inventory to decrease operation cost, improve workflow to gain accurate view of cash status, improves the organization productivity, reduces the risk of fees and penalties by means of the improve function in payroll.

Advantages • Sage Accpac reaches a larger customer base • Allows for cash-flow improvements • Option for flexibility by web, on-premise or host • Other resources are easily integrated • Customization with ease of development
Disadvantages
• Part of the system requires staff to be trained in administrative, technical and fraud prevention procedures • Must quickly adapt to system to maintain all the features
Point of Sale Inventory System A commonly inventory system used in most retail establishments like Wal-Mart, Kmart, and even in some hospitals is the Point of Sale Inventory system. Point of Sale system t is an electronically scanned system that scans each item at check out. The system can calculate how many items sold between ordering periods and set automatically to order products on a specific date with a little extra for variance. The system used in hospitals in surgery and each item scanned before surgery begins so that each item recorded. Once the surgery ends each item, including sponges and each surgical tool scanned while putting away before the patient surgery is completed. The idea is to keep items from left in patients and causing surgical error, infection and even death. The system here calculates how many sponges and non-reusable items are accounted. The hospitals just have to pull a report for items used, how many are ordered and current supply.

The system connects to QuickBooks, which allows the organization in the retail business to track invoices of incoming shipments of supplies and inventory tracking sheets of items sold. This allows for forecasts of sales to develop by the companies. These forecasts are given to their suppliers and the thus the suppliers know who much demand is needed to be met in the future. Point of Sale has helped to decrease costs by not having a surplus of some items in stock creating inventory costs and shortage of other items with decrease in sales. The point of sale system integrates with most credit/debit card systems, cash registers and even gas stations, which mean easier access for organization to adopt and use the system.
Advantages

Disadvantages

It is a system that runs total of all inventory at cost is kept by regularly add all purchases to and subtracting all sales from the quantity hand. It accurately track medicines in hospital pharmacy and other pharmaceutical companies, it automatically tracks multiple inventory reconcile using bar code technology. It reduce tax and insurance overpayments by eliminating cost damaged or stolen goods. Easy invoicing track sales, expenses that saves time and helps forecast for the next period and gives figure to be subtracted from sales. Patients order on line for in-store to pick up or choose medication to be dropped at residences. The system control operation in connection with quickbook that allow the pharmacy to track how many orders are in and out to patients. So forecasting would be easy by looking at the balance in the system. This help decrease price, give option to patience which brand they can afford. The systems control daily operation accurately, charge insurance automatically, patients are able to use debit, credit, or medicare and so on.
On the other hand the disadvantage is information can be lost if power fail and if the query is done or high level of exposure. Or if the order is not accurate, for example if the patient make mistakes, or typo and wrong prescription dropped it can cost more and less costumer satisfaction.

Similar Documents

Premium Essay

Data Table Analysis

...fare ranging from bakery and pastry products to cheese and specialty dairy products. The purpose of this paper is to evaluate the design elements of the data tables from an accounting perspective and to recommend improvements to the existing data tables. The paper will also explain how the information in the pivot table may improve decision making for management at KFF. When glancing at KFF’s data tables they seem to be easy to understand by someone with or without an accounting background. The inventory table consists of the components that make up an inventory item. This table is used for managing the inventory and determining the availability of all ingredients that are needed to prepare items. The inventory items are displayed according to the following description items: item ID, inventory ID, perishable, nonperishable, department, category, description, unit of measure, quantity on hand, unit cost, master pack quantity, supplier ID, assembly line, substitute item, and tagalong item. There are changes that can be made to further develop the inventory data at KFF. Entity diagrams are used to illustrate the relationship between entities and their corresponding associations. The different shapes are used to signify the relationships. There are lines that connect the rectangles, diamonds, and ovals that represent the associations. In the diagram attached to this paper, the rectangles represent the entities or concepts about the data that is stored. Diamonds represent the...

Words: 654 - Pages: 3

Premium Essay

Project Management Final Paper

...Pizzaderia Inventory Management System 1.2 Project Context On March 27, 2007, the friends and neighbors of Alberto Biaño in Cebu City were treated to the first serving of Mr. Biaño's famous pizza.  This core group became his first loyal customers, as news spread far and wide of the pizza with the great homemade taste that everyone could afford.  Inspired by the resounding success of his initial offering, Alberto Biaño continued to develop his recipes to improve his pizzas' quality and taste until a perfect blend of crispy dough and aromatic sauce was achieved for everyone to enjoy. Another innovation was the concept of the “pizzaderia”, which  combined the words “pizza” and “carenderia”, to describe the little streetside eateries where Biaño’’s delicious but affordable pizzas were enjoyed by  people from all walks of life. Whether for birthdays, anniversaries, celebrations and get-togethers, everyone wanted to make a Biaño’s pizza part of their special treat. From that little pizzaderia in Mabolo, Mr. Biaño soon branched out to Capitol, Tabunok, USC Main, Mandaue and Mactan, making Biaño's pizza a truly well-loved snack in Cebu.  Realizing the potential for such great value in an affordable price, many franchisers from different places all over the country such as Cagayan de Oro, Oroquieta City, Butuan soon became part of the Biaño's Pizzaderia family 1.3 Statement of the Problem As of now, Biano’s Pizzaderia only does their inventory manually, and as manual inventory system...

Words: 3731 - Pages: 15

Premium Essay

Kudler

...Access as the database to help track inventory, sales, orders, employees, and customers. Kudler’s inventory consist of perishable products, therefore inventory needs be accurately tracked. This paper will evaluate the design elements of the data tables from an accounting perspective, create an entity relationship diagram including a pivot table, recommend improvements to the data tables, and explain how the new diagrams will improve Kudler’s decision making for management. Table Analysis The data table analysis is vital to Kudler’s success. The data is organized into general ledger codes, inventory item, summary line item, and the total amount of the item’s transaction. The data provided in the analysis table, which are viewed by the users, shows how much money is spent on what product and which store. The description of the data table gives the total amount and quantity on hand for an item and calculating average price for an item. From an accounting perspective, the data tables are simple and easy to read. There are four headings. They include the GL Code, inventory item, summary line item and the amount. The GL Code helps to identify which store the item is located. For example, 12 stands for La Jolla, 13 identify the store in Del Mar, and 14 identify the Encinitas store. The inventory items identify what items are in the inventory. At a quick look, every manager can see what is in inventory at each store. The third column is the summary line item. This column identifies...

Words: 567 - Pages: 3

Premium Essay

Executive Summary

...Macy’s: Executive Summary Macy’s, Inc. Macy’s, Inc. is known as the one of the leading retail corporations worldwide. It offers its customers a wide range of products including clothing, footwear, jewelry, beauty products, and even home décor. Macy’s has opened more than 800 stores across the U.S. and reported fiscal year (FY) 2009 sales of $23.5 billion. Although Macy’s is a prominent retailer today, their success had to start somewhere. In this summary we will take a glance at Macy’s history as well as their prior and current financial information. Brief History of Macy’s, Inc. Before Macy’s, Inc became a household name Rowland H. Macy, the founder of Macy’s Inc., started a dry-goods store in 1851 in Haverhill, Massachusetts where he made $11.06 on its first day. Since then, R.H. went through his share of retail failures and various store relocations. It was not until 1877, when R.H. Macy & Co. started accumulating its high sales, that it made its mark as a retail giant. For example, Macy’s made business history when they were the first to promote a woman in an executive position. Macy’s was also the first to hire an in-store Santa Claus. In 1924, upon the completion of the new 7th Avenue addition, Macy’s Herald Square became known as the “World’s Largest Store” with more than one million square feet (Macy’s, Inc., 2010). In addition, the company also produces their annual Macy’s Thanksgiving Day Parade and Fourth of July fireworks display that fills the hearts...

Words: 1585 - Pages: 7

Premium Essay

None

...|[pic] |Class Syllabus | | |School of Business | | |ACC/290 Version 3 | | |Principles of Accounting I | Copyright © 2011 by University of Phoenix. All rights reserved. Course Description This course covers the fundamentals of financial accounting as well as the identification, measurement, and reporting of the financial effects of economic events on an enterprise. Students will learn to examine financial information from the perspective of management. Other topics include decision making, planning, and controlling from the perspective of a practicing manager. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning...

Words: 2422 - Pages: 10

Premium Essay

No Se Lo Que Es Pero Es Bueno

...|[pic] |Syllabus | | |School of Business | | |ACC/290 Version 3 | | |Principles of Accounting I | Copyright © 2011 by University of Phoenix. All rights reserved. Course Description This course covers the fundamentals of financial accounting as well as the identification, measurement, and reporting of the financial effects of economic events on an enterprise. Students will learn to examine financial information from the perspective of management. Other topics include decision making, planning, and controlling from the perspective of a practicing manager. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning...

Words: 2436 - Pages: 10

Premium Essay

Star Brite Stores Mini Case Study

...Modeling Submitted to: Dr. Phillip Rokicki Date of Submission: May 13, 2015 Title of Assignment: Star Brite Stores – Mini Case Study CERTIFICATION OF AUTHORSHIP: I certify that I am the author of this paper and that any assistance I received in its preparation is fully acknowledged and disclosed in the paper. I have also cited any sources from which I used data, ideas or words, either quoted directly or paraphrased. I also certify that this paper was prepared by me specifically for this course. Student’s Signature: ************************************************************** Instructor’s Grade on Assignment: Instructor’s Comments: Executive Summary We have been hired to help Mack Stewart, the CEO and president of Star Bright Stores assess data to recommend the best type of franchise he should pursue for this company. The future success of the company is dependent on growing the business. In order to do so, he needs to attract potential franchises to purchase stores. Using the statistics he has been keeping on 27 different franchise owners with different characteristics. Using various excel functions, we have determined that the best type of franchise for Star Bright Stores has 5.5 thousand square feet, $540 thousand in inventory, spends $9.6 thousand on advertising, has 9.7 thousand families, and at least 14 competing stores within each district. The data below outlines how we came to these conclusions. Problem We have been hired to...

Words: 1513 - Pages: 7

Premium Essay

Data Table Analysis

...Kudler Fine Food are fresh and the inventory must be correctly tracked. It is very vital to the company in becoming successful. This paper will address the following regarding Kudler Fine Foods: evaluating the design elements of the data tables from an accounting perspective, recommend improvements to the data tables and explain how the information in the pivot table may improve decision making for management at Kudler Fine Foods; include an example from the data. It will also include an entity relationship diagram illustrating the existing data tables and a pivot table on Kudler inventory data from the company intranet. Evaluation of the design elements of the data tables from an accounting perspective Data Table is very basic but yet play a very big role in the achievement of Kudler Fine food. The company uses this data to decide when to order more inventory and also to manage inventory. The design of data tables categorizes the financial information into financial codes, items, department and the sums of total amount of transaction. It contains four columns: the GL Code, Inventory Item, Summary Line Item, and Amount. The GL codes consist of six numbers. The first two are store numbers and the last four numbers represent the department the item is located in. The summary line item column provides the store and department where the item is located. The amount column is the quantity amount in dollars of the item described in that row. Inventory item column gives a description of...

Words: 769 - Pages: 4

Premium Essay

Revenue Cycle

...INFS7004 Accounting Information Systems Lecture 4 Transaction Cycles: The Revenue Cycle 1 The Conceptual System The Revenue Cycle The revenue cycle is the set of activities in a business which brings about the exchange of goods or services with customers for cash. Most business transactions are conducted on a credit basis. Cash is received after goods are shipped to the customer. 2 Sales Order 1 Credit / Customer Service 2 REVENUE CYCLE (SUBSYSTEM) Cash Receipts/ Collections 6 Shipping 3 Billing/ Accounts Receivable 4/5 Journal Vouchers/Entries: How do we get them?  Billing Dept. prepares a journal voucher: Accounts Receivable Sales DR CR  Inventory Control Dept. prepares a journal voucher: Cost of Goods Sold Inventory DR CR  Cash Receipts Dept. prepares a journal voucher: Cash Accounts Receivable DR CR 4 Sales Order Procedures  Sales order procedures include the task involved in receiving and processing a customer order, filling the order and shipping products to the customer at the proper time, and correctly accounting for transaction. 5 Receive Order  At this point, sale process begins indicating the type and quantity of merchandise desired by customer.  It may or may not be a physical document  Orders may arrive by mail, by telephone, or from a field representative who visited the customer  After creating the sales order, a copy of it is placed in the customer open order file. 6 Check Credit  For...

Words: 2302 - Pages: 10

Premium Essay

Client Understanding

...responsibilities that are required are to analyze the work papers for one of the clients of the organization. This client is not clear about why the company is asking for information on the following topics: adjusting lower cost of market inventory on valuation; capitalizing interest on building construction; recording gain or loss on asset disposal; and adjust goodwill for impairment. This paper will strive to answer these questions for the client. Adjusting Lower Cost of Market Inventory on Valuation One of the requirements of the Generally Accepted Accounting Principles (GAAP) is that inventory be recorded at lower of cost or market rule, also known as LCM. In a company’s’ financial statements, assets are generally stated in the financial statements according to the cost principle. However, when it comes to inventory, cost principle is abandoned and lower of cost or market rule takes its place. The LCM states that inventory should be measured at the lower of cost or market value (Accounting Explained). What market value means basically is the replacement cost of the company’s inventory. This replacement cost can be in the form of a purchase cost or a manufacturing cost; simply stated, market value is the amount a company would have to pay to acquire their inventory of the same quantity and quality through purchase or through manufacturing. There are upper limits (ceiling) as well as lower limits (floor) on the market value of inventory. These are fairly simple to figure. The upper...

Words: 1328 - Pages: 6

Premium Essay

Accounting Information System

...manufacturing organizations. Purchase processing procedures Purchases procedures include the tasks involved in identifying inventory needs, placing the order, receiving the inventory and recognizing the liability. In general, these procedures apply to both manufacturing and retailing firms. It differs only in the way purchases are authorized. | Manufacturing firms | Merchandising firms | Purchase authorization | Production planning and control function | Inventory control function | Monitor inventory records The inventory control monitors and records finished goods inventory levels, when inventories drop to a predetermined reorder point, a purchase requisition is prepared and sent to the prepare purchase order function to initiate the purchase process. Prepare purchase order The prepare purchase order function receives the purchase requisitions, which are sorted by vendor if necessary. Next, a purchase order (PO) is prepared for each vendor. A copy of the PO is sent to the vendor. In addition, a copy sent to the set up of accounts payable (AP) function for filing temporarily in the AP pending file and a blind copy is sent to the receive goods function, where it is held until the inventories arrive. The last copy is filed in the open/closed purchase order file. Receive Goods The next event in the expenditure cycle is the receipt of the inventory. Goods arriving from the vendor are reconciled with the blind copy of the PO. Blind copy contains no quantity or price information...

Words: 2312 - Pages: 10

Premium Essay

Amazon

...A summary of the Amazon Company Profile is that Amazon.com is the largest retailer of goods on the Internet and is well positioned to access online markets in developing nations through the use of custom tailored websites. Amazon Company Profile A summary of the Amazon Company Profile is that Amazon.com is the largest retailer of goods on the Internet and is well positioned to access online markets in developing nations through the use of custom tailored websites.  This is a topic suggestion on Amazon Company Profile from Paper Masters. Use this topic or order a custom research paper, written exactly how you need it to be. Amazon.com sells retail goods on the Internet at discount prices, and provides a wide range of additional services to private vendors that use the Amazon website as a marketplace for the sale of goods.  While the majority of the firm's revenues originate from book, CD and DVD sales, it has expanded into toys, beauty products, tools, and services such as film processing.  The firm also generates commission revenues from the sales made by private retailers using the Amazon site a host for auctions and other types of direct vending via the Internet.  The firm uses electronic data interchange system to minimize inventory and expedite delivery. The firm operates websites in several foreign languages and offers distribution of goods from fulfillment centers in the United States and Europe.  The market for the firm’s products and services is expanding rapidly as Internet...

Words: 750 - Pages: 3

Premium Essay

The Pros And Cons Of Inventory Accounting Methods

...The choice of inventory accounting methods, specifically for the case of FIFO and LIFO, has developed into a decision, which includes varying consequences and comes with specific implications and benefits, such as communicating private information with FIFO (Hughes, and Schwartz, 1988, p.42) or tax benefits for the choice of LIFO (Morse and Richardson, 1983, p.125). Every firm and manager has to face the decision of which accounting method to choose, and has to include several aspects into their decision making process and weigh the pros and cons in general. However, the empirical evidence (Frankel and Hsu, 2015, p.48) shows some controversies as to what inventory accounting methods firms decided to use in the past, even though the theory would...

Words: 979 - Pages: 4

Premium Essay

Dollar

...OM 367: Strategic Supply Chain Management Professor Stephen M. Gilbert Classroom: CBA 4.348 Class Meeting Time: TTH 12:30-2:00 Office: CBA 3.424 Phone: 471-9456 (O) e-mail: steve.gilbert@mccombs.utexas.edu Mail Box: Dept. of IROM, CBA 5.202 Fax: 471-3937 (O) Office Hrs: T-TH 10:30-11:30, and by appt. COURSE DESCRIPTION Supply Chain Management involves the flows of materials and information among all of the firms that contribute value to a product, from the source of raw materials to end customers. We will integrate issues from marketing (channels of distribution), logistics, and operations management to develop a broad understanding of a supply chain. By taking a strategic perspective, we will focus on relatively long term decisions involving the investment in productive resources, configuration of processes, product designs, and development of parterships with suppliers and channels of distribution. Although the development of analytical tools is not one of the primary objectives of the course, students should be comfortable with quantitative analysis. By the end of the course, you should have developed an appreciation for the major strategic issues trade-offs in supply chain management as well as the ability to use conceptual frameworks to make decisions. TEACHING/LEARNING METHODOLOGY The detailed course outline starting on page 6 lists, for every class session, the reading(s), case(s), assignment(s), and anything else of importance. Please read this outline carefully...

Words: 3965 - Pages: 16

Premium Essay

Berry's Bug Busters Analysis

...While long term creditors and short term creditors both have interest in profitability ratios and solvency ratios either to see the companies ability to survive over a long period of time or to see the likelihood of growth in stocks and dividends (p 676). Liquidity Ratios The Liquidity ratios reveal that the company paid off its liabilities better in this past year than in 2007 our current ratio went up by 2.42 from 2007 when it was 3.57 to 2008 where it was 5.99. Along with the current ratio the acid test ratio also went up by 2.31 from 2007 where it was 3.01 to 2008 which came to 5.32. Although we see a growth through these set of numbers our companies had a decline with our Receivables turnover and our Inventory turnover by -3.71 with receivables and -6.7 with inventory. These ratios show us that the accounts relievable turn over decreased because the revenue was down and accounts receivables increased during the 2008 period. Berry’s Bug Busters generated more revenue in 2007 to match their accounts receivables whereas in 2008 this did...

Words: 1457 - Pages: 6