Executive Summary of Burbank Boards
TABLE OF CONTENTS
EXECUTIVE SUMMARY 3
PROBLEM DEFINITION 4
NEW SYSTEM OBJECTIVES 6
NEW SYSTEM CONSTRAINTS 7
NEW SYSTEM PERFORMANCE CRITERIA 8
TEXAS INSTRUMENT - COMPOSER 9
ENTITY-RELATIONSHIP DIAGRAMS 10
ACTIVITY HIERARCHY DIAGRAMS 11
EXECUTIVE SUMMARY
Introduction
Current System
New System
· objectives
· recommendation
· advantages of new system
· how it will solve problems
· implementation
· tools used to document the new system ie.. ERD
PROBLEM DEFINITION
The main problem at Burbank Boards: Management has not continued to use an out-dated computer based system without realizing the importance of using efficient information systems to gain a competitive edge.
Symptoms of the problem at Burbank Boards:
1. Redundacy of effort
· Telemarketing operators enter order data on sales order forms and then key much of the same data into their terminals.
· Buyers fill out Purchase Order Requisition forms and then data entry operators key in the same data.
· Manufacturing orders are placed using paper forms and this data is then keyed into the computer.
2. Poor responsiveness of the system
· Customer orders are not filled as they are received. Instead they are held until the order batches are processed by the order entry, inventory, and billing systems.
· Buyers are notified of the need of raw material replenishment the day after the computer detects that the reorder point has been reached.
3. High credit risks
· The current credit classes have resulted accepting several poor credit customers and in turn, several bad debts have been incurred.
4. Lack of production standards and controls
· Production workers often do not accurately record start and completion times for their jobs sheets.
· The production schedule prepared by production planning and control is only a close approximation to what can be expected.
5. High buyer turnover
· It is extremely difficult to train new buyers who need to be highly skilled at negotiating. Lack of sufficient information may lead to poor purchases.
· Low morale could be contributing to the high turnover. Loss of a buyer leads to loss of valuable experience and expertise that is hard to compensate for.
6. Delayed deliveries by suppliers
· Late delivery dates have caused the company to reschedule...
... middle of paper ...
... will be listed in this report.
This type of report is important when the structure of the entities are being developed, and later when they are being coded. Heavy documentation of those areas is necessary to ensure cohesion and consistency throughout the use of the entities.
Activity Hierarchy Diagrams
Activity Hierarchy Diagramming (AHD) identifies the lowest-level processes of interest to the business through decomposition. AHD shows levels of increasing detail for each function and process until activities decompose to the lowest level (elementary processes). A process is a defined business activity whose executions may be identified in terms of the input and output of entities of specific types.
Analyzing business activities independently of data helps you understand:
· The activities of the business
· The nature of information required and produced by these activities, independent of the organizational structure and the existing information systems
An accurate and complete activity model lays the foundation for subsequent system design and implementation efforts. More specifically, the upcoming phases require this information in one form or another.
Accuracy: All Purchases are authorized at the appropriate level. All invoices prices and quantities are compared with purchase orders and receiving reports. Journal entries are review at the appropriate level. All the Financial statements are review and approved by the senior level.
3. After gathering the required information, the prescription will then be entered into the pharmacy's computer system. This is to ensure proper tracking, product selection and pricing.
The system requires companies to manufacture products based on predicted customer demand, rather than the real demand. This is because of the lag-time associated with manufacturing products by batch and queue technique. In many cases the system is very inefficient and wasteful. This is mainly due to substantial WIP, placed on hold when other functional teams ready their units. Figure below captures flow of production in a batch and queue
Employee turnover costs are very costly to a company. Turnover not only affects the bottom line but also affects the company’s morale. We are analyzing the problems within our company that are causing our employees to become unsatisfied with their job. Then we are going to find solutions. And then do the cost estimates of the turnover costs and the turnover savings after our solutions are implemented.
Build the capability of Pharmaceutical company?s system to accept the delivery and confirmation data from supplier in a measurable format.
Information on vendors can be updated at any time in the future. The user may record purchase orders, bills, and payments made. Both the revenue and expenditure cycle components keep track of what is happening to inventory. Example:. If a user wants to pay for a product for which his or her company has already been invoiced and which the company has received, the user needs only enter the vendor and the invoice being paid.
their dispatch of customer orders are promptly and accurately. We can see this with this case when they timely started the removal of contaminated products ( Tylen...
The super computer, Telson records all the sales. The order is automatically generated that evening. At midnight, the warehouse fills that order and it sits back on the shelves on the following night or the next morning. However, this inventory system has a huge effect on producers since the speed of delivery is faster and the order is always available to costumers.
“Employee turnover is a critical cost driver for American business. The cost of recruiting and filling vacancies, lost productivity from vacant jobs, and the costs of training new employees increase operating costs, reduce output, and cut into profits.” (Orville 5-7)
O’Reilly Auto Parts utilizes replenishment software to achieve this goal. The economic downturn, resulted in negative effects for Cisco Systems and Black & Decker. However, at O’Reilly’s, the economic downturn provided an increase in business. Obviously, when the economy is in a nosedive consumers and businesses will severely limit what they choose to purchase. Therefore, instead of spending money on technology or home improvement supplies, consumers purchased auto parts to repair their old vehicles. Consequently, O’Reilly’s goal was to increase customer support and replenish inventory on a nightly basis. However, to accomplish this, the company uses software from Manhattan Associates Inc to collect data every half-hour, and, send updates every night to its distribution centers. Thus, the company could immediately fulfill request, while freeing up over $50 million by reducing its inventory levels (O 'Brien, & Marakas,
Inventory management is a method through, which a business handles tangible resources and materials to ensure availability of resources for use. It is a collection of interdisciplinary processes including a full circle from the demand forecasting, supply chain management, inventory control and reverse logistics. Inventory management is the optimization of inventories of manufactured goods, work in progress, and raw materials. According to Doucette (2001) inventory management can be challenging at times; however, the need for effective inventory management is largely seeing more as a necessity than a mere trend when customer satisfaction and service have become a prime reason for a business to stand apart from its competition. For example, Wal-Mart’s inventory management is one of the biggest contributors to the success of the company;
As part of developing the need in the initial investigation step in the systems development life cycles (SDLC) process, a constructive method is use case. Use case is a technique for capturing requirements with written scenarios in non-technical terminology that describe how a system interacts with a user or another system (University of Phoenix, Course Syllabus, 2006). There are two fundamental pieces, along with how they relate, to bear in mind: the actors and the goals. The actors are everyone and everything that will use (or be used) by the project progress reports, and the goals, which are what the actors want to achieve. The use case will describe the goals achieved by the actors who perform tasks (Carr & Meehan, 2005).
and is especially popular among eBay customers. Fig.1 briefly illustrates Company’s business. The system enables its
In the first weeks, our inventory could keep up with the incoming orders in the supply chain which is the ultimate affect of the uncertain customer demand. As the wholesaler, I was dealing with the orders of the retailer who is responsible for the direct customer orders which was stable at
In manufacturing process there are different steps and jobs needs to be done in specific ways and time such as sourcing the parts we need in the production, make the items, and shipping it for the customers.