Concept explainers
a.
Explanation of Solution
Costs and benefits required for implementing Inventory Tracking System at American Labs:
The costs for implementing Inventory Tracking System at American Labs include:
- One-time costs
- It is the cost associated with starting phases of a project during project initiation and planning.
- Recurring costs
- It is the cost that results from present evolution and use of the proposed system.
The benefits for implementing Inventory Tracking System at American Labs:
- Tangible benefits
- These are the benefits that can be estimated properly during the course of the project...
b.
Explanation of Solution
Economic feasibility analysis for implementing inventory tracking system:
Monetary benefits of an
One-time costs = $80,000
Recurring cost = $25,000 per year.
Discount rate = 10%
Time period = 5 years
Present value for benefits and costs can be calculated by using the formula:
Here PVn is the present value and i is the discount rate.
Present value (PV) calculation for benefits:
Benefits starts from year 1, hence calculation of present value starts from year 1.
Net Present Value (NPV) for benefits:
Present Value (PV) for costs:
c.
Explanation of Solution
Modified Economic Feasibility Analysis for implementing inventory tracking system at discount rate(11%):
Monetary benefits of an information system = $50,000 per year.
One-time costs = $80,000
Recurring cost = $25,000 per year.
Discount rate = 11%
Time period = 5 years
Present value for benefits and costs can be calculated by using the formula:
Here PVn is the present value and i is the discount rate.
Present value (PV) calculation for benefits:
Benefits starts from year 1, hence calculation of present value starts from year 1.
Net Present Value (NPV) for benefits:
Present Value (PV) for costs:
Net Present Value (NPV) for costs:
Overall Return on Investment (ROI):
Overall return on investment can be calculated as:
Break-Even Analysis (BEA):
- Break even analysis is carried out by determining NPV of yearly cash flows.
- The yearly cash flows are calculated by subtracting present values of recurring costs from the present value of yearly benefits.
- The overall NPV cash flow is total cash flow of the preceding years.
- After determining NPV yearly cash flows, it is found that break even occurs between years three and four.
- This is because here overall NPV is positive.
Modified Economic Feasibility Analysis for implementing inventory tracking system at discount rate (14%):
Monetary benefits of an information system = $50,000 per year
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
EBK ESSENTIALS OF SYSTEMS ANALYSIS AND
- Many-to-Many ERD CUSTOMER has: customer_id first and last names address TAPE has: tape_id title description length in minutes A CUSTOMER may rent many TAPEs. A TAPE can be rented by many CUSTOMERs. Draw a Crow’s Foot ERD that includes the bridge table between Customer and Tape to account fully for the many-to-many relationship. Course and Class ERD Table name: COURSE COURSE_ID TITLE DESCRIPTION CREDITS ACCT-211 Basic Accounting An introduction to accounting. Required of all business majors. 3 CIS-380 Database Systems I Database design and implementation issues. Uses CASE tools to generate designs and implement in a major RDBMS. 3 CIS-490 Database Systems II The second half of CIS-380. Basic Web database application development and management issues. 4 Table name: CLASS CLASS_ID COURSE_ID SECTION TIME LOCATION 100 ACCT-211 1 8:00 a.m. – 9:30 a.m. T-Th. AA 325 101 ACCT-211 2…arrow_forwardFarmers Marketmen is a regional business that provides wholesale, organic, non-GMO products to private contract vendors who sell products at farmers markets. Farmers Marketmen has a large inventory consisting of truly natural baked goods, cosmetics, toiletries, books, and sustainable educational material. Due to the recent growth of the business, Farmers Marketmen has outgrown its current DBMS and is looking to replace it with a system that will allow for future growth over the next five years. They have budgeted $10,000, aside from consultant costs, to fully implement this new system. You have been hired as a private consultant to assess and evaluate the current DBMSs available on the market (including open source and proprietary solutions) and recommend three BDMSs, ranking them in an order that you believe best suits Farmers Marketmen’s needs and budget. For the initial discussion question, research current DBMSs systems and provide the three that you believe best fit the…arrow_forwardENorm, Inc. has two sites in Pittsburgh that are four miles apart. Each site consists of a large factory with office space for 25 users at the front of the factory and up to 20 workstations in two work cells on each factory floor. All office users need access to an inventory database that runs on a server at the Allegheny Street location; they also need access to a billing application with data residing on a server at the Monongahela site. All factory floor users also need access to the inventory database at the Allegheny Street location. Office space is permanently configured, but the manufacturing space must be reconfigured before each new manufacturing run begins. Wiring closets are available in the office space. Nothing but a concrete floor and overhead girders stay the same in the work cell areas. The computers must share sensitive data and control access to files. Aside from the two databases, which run on the two servers, office computers must run standard word-processing and…arrow_forward
- ENorm, Inc. has two sites in Pittsburgh that are four miles apart. Each site consists of a large factory with office space for 25 users at the front of the factory and up to 20 workstations in two work cells on each factory floor. All office users need access to an inventory database that runs on a server at the Allegheny Street location; they also need access to a billing application with data residing on a server at the Monongahela site. All factory floor users also need access to the inventory database at the Allegheny Street location. Office space is permanently configured, but the manufacturing space must be reconfigured before each new manufacturing run begins. Wiring closets are available in the office space. Nothing but a concrete floor and overhead girders stay the same in the work cell areas. The computers must share sensitive data and control access to files. Aside from the two databases, which run on the two servers, office computers must run standard word-processing and…arrow_forwardGive Authentic And Relevant Answer. (Review these requirements using the checklist and discover possible problems with them. ) A centralized lock control system which controls the locks of all external doors in University buildings is to be implemented. Some requirements for this system are: Req. 1 Staff and students are issued with a card which provides them with access to those buildings which they are authorized to use after normal working hours. Req.2 Access is implemented by wiping a personalized card through a card reader and, if entry is allowed, the door lock is released. Req.3 Users must use the card to both enter and leave locked buildings. Req.4 If a card is lost, it should be reported to the security office that will issue a new card and arrange for all access rights associated with the old card to be cancelled.Review these requirements using the checklist and discover possible problems with them.arrow_forwardAs a large service organization, King Abdullh University Hospital depends on a large number of persons for its continued success. There are four groups of persons on whom the hospital is most dependent: employees, physicians, patients, and volunteers. Of course some common attributes are shared by all of these persons: Person_ID (identifier), Name, Address, Ciy/State/Zip, Birth_Date, and Phone. Each of the four groups of persons has at least one unique attribute of its own. Employees have a Date_Hired, Volunteers have a Skill, Physicians have a Specialty and a Pager# (pager number), and Patients have a Contact_Date (date of first contact with the hospital). Some other persons in the hospital community do not belong to one of these four groups (their numbers are relatively small). However, a particular person may belong to two (or more) of these groups at a given time (for example, Patient and Volunteer). Each patient has one (and one only) physician responsible for that patient. A…arrow_forward
- Cozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person. Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff.The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office. 1.Identify and briefly discuss three main issues that Cozy Inn could face in the absence of an information system to integrate the business processes. 2.Discuss briefly how Cozy Inn can make use of…arrow_forwardCozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person. Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff. The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office 1.When the Cozy Inn decides to use online systems, what is the customer-related information that needs to be protected and what are the major ways by which they should protect individual privacy of…arrow_forwardCozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person. Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff. The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office. List and briefly discuss five of the business processes in the organisation.arrow_forward
- The Marketing Department for CSM Tech Publishing is busy producing videos and print materials (stored in PDF format) for distribution and use by the Sales Department. With new products being introduced and a good bit of marketing testing, marketing materials change often, and there's often a substantial delay before the Sales Department gets access to these changes. The Sales Department is in another site and wants access to the marketing materials, but given the size of files and the number of updates, you're reluctant to give the Sales Department direct access to files across the WAN link. What DFS replication group configuration could you consider for replication and frequency of access?arrow_forwardStonehenge Engineering Works is a small company that specializes in complex engineering consulting projects. Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network. They are going to have two divisions in two different office sites in the same building, (two story office building) Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development. Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication. Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well. ((((((((((( Q1 -3:Draw Backbone Network diagram to…arrow_forwardDraw context level diagram for the below case. • Digitech is a digital TV company that offers high bandwidth TV connection with different options (entertainment package, sports package, etc.). • Customers can get information for promotions by calling and speaking to a live assistant. The information will be given by the assistant who uses the system to retrieve the information. • Assistant asks for the telephone number of the customer, enters the number into the system and receives customer’s general information and then checks the validity of this information with the customer. If the information is not valid, assistant hangs up the telephone and enters an explanation to the system. • When the information is valid, assistant retrieves the promotion information that is available for that specific customer and gives that information to the customer. After this operation assistant retrieves company specified promotions and also gives information about those promotions. If the…arrow_forward
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage