...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
...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
...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
...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
...|[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
...|[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
...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
...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
...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
...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
...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
...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
...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
...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
...Overview * Group assignment (replaces a final exam) * In two parts * A 20-30 page report due last class, Dec 1st * Double spaced (excluding exhibits and appendices) * No late papers for this assignment * Worth 30% of your grade * A 45-50 minute presentation on Dec 1st * Worth 20% of your grade * Worth 50% of your class grade (in total) What is a brand audit? * Comprehensive examination of * Brand health and activities * Sources of Brand equity * Current issues/opportunities with recommendations * Includes an external, consumer-focused assessment * Consumer Survey * It includes: * Brand inventory, “exploratory”, recommendations * Suggested Outline Executive Summary * With background about the brand, industry and competitors * Consumer analysis * Trends, motivation, perceptions, needs, segments, behaviors * Brand Inventory * Brand Exploratory * Summary of what you found (good/bad) * Recommendations (including new product) Brand Inventory – * A current profile of the brand * Positioning (company perspective) * Brand elements * Profile of competitive brands * POP’s and POD’s * How supported… (by marketing programs) * Should include: * Your insights on how brand equity may be better managed * Assess consistency (messages, sub-branding) Brand Exploratory -...
Words: 650 - Pages: 3