(a)
Reviewed testimony of three of the employees of the GEM Athletic Center along with their wish list.
Answer to Problem PIIIAYKBP
Solution:
Director of the sales says he accounts the new memberships to the club. Payroll manager wants a system that is capable to calculate the payrolls. Ann Logan wants a system that can audit and can determine taxes of each month and quarter.
Explanation of Solution
Given:
Testimony of three employees of the company.
Jim Poulos is director of sales. He says that he has to review the number of memberships sold in their club. Each of his sales executive gets $50 for a new membership sold. Also, they receive 10% of the type of the membership sold. It includes as mentioned below.
Type of Membership | Cost |
Adult | $450 |
Youth | $400 |
Family | $750 |
Senior | $300 |
He says that each executive receives $4.50 per hour and gets 25% bonus for working overtime and holidays as well. Also, if any employee sells more than 200% of the expected sales, then he/she gets 25% bonus on their commission. Also, if the membership solid during the promotion period then the commission is decreased accordingly. Time sheets are used to track the working hours by payroll department. Also, he validates the sheets received from the payroll department. Further he has to draft a separated listing of each employee and their commission for initiation fee and also memberships sold. Also, the sales manager records the number of vacations and sick time. Also, if any of the employees gets leave more than the recommended period then sales manager drafts a letter saying that if the employee quits and he will pay the overpaid amount.
He wants a system that is capable of calculating the amount of commission and able to determine the sales forecast and what if analysis of their sales executives commission rates. He wishes to have a system to tell his employees if they are able to sell more family and one adult membership then they will receive their bonus. Also, he wants the system assist him designing promotions for his most valuable and best customers.
Maggie Cleaver is manager of payroll.
His initial job is to collect the time sheets from all the departments. Also, to figure that the employee signed-in and signed-out at correct time. If any of the employees forgets to sign-out, then she contacts the person’s director and asks for the time the employee should have singed out. His job includes calculating total time on the sheets including net working hours, holiday hours, sick time, vacation time. After the calculation she sends it to the department of sales to be validated.
When sheets are backed after the validation, the calculation for the payments starts. Payments for regular hours, over time and vacations are calculated. Then the commissions are added as they are calculated by the sales department. Further, the aerobic department is paid because they paid by the number of classes they have taken. Further, she sends the payment sheets to the department of taxes. Further, a new time sheets is labeled and returned to the punch clock.
Maggie wishes to have a system that is capable of tracking the employee sick and vacation time. Also, she wants a system that is capable of calculating the regular pay, overtime and holiday pay. Also, the system should be able to validate the time sheets.
Anne Logan is the manager for taxes. She calculates the taxes for city, state and federal. Also, she deducts some health and retirement plan benefits. Further the checks for employees and checks for taxes are cut. Also, W2s and quarterly taxes are check. Also, she checks and updates the personal information related to the residential address of employee. Also, incorrected amounts paid are cut back if paid. Also, she manages and checks the amount of over paid in case of sickness and vacation. Also, she manages the checks from regular salaried employees.
The challenge for her is to correlate the total cash that is debited for all the checks and the total amount that is calculated for all the check. These both number often doesn’t mach.
She is seeking for a system that is capable of determining the taxes on its own along with filing the statements quarterly. Also, she wants the system to perform audits often.
Conclusion:
In conclusion, all the departments have their own preferences. Sales department wants a system that can perform forecasts. Payroll departments wants the system to calculate the number of working hours to be calculated automatically. Further, the taxes department wants the taxes to be calculated automatically and perform the audits.
(b)
Highlight the review of Closing case two. And highlight techniques that can be sued to formulate potential business requirements.
Answer to Problem PIIIAYKBP
Solution:
It tells about the reason of failure of most of the projects. Also, it illustrates an example with comparison of certain statements.
Explanation of Solution
Given:
An article on Reducing the ambiguity in business requirements.
The closing case two initiates by saying that the any project fails due to the bad business requirements. Also, the project fails due to inappropriate ambiguity and insufficient involvement of the customers while the project was under analysis and designing.
It is the sign of unambiguous requirements because if the system has equal interpretation for all the parties. If different parties are involved, then it will result in unmet expectations.
It includes an example as illustrated below.
An ambiguous requirement is that the financial report of the company must illustrate profits in local and US currencies.
Further, the unambiguous requirements are that the financial report must illustrate profits in local and US currencies printed in The Wall Street Journal as per the business day gone past.
An ambiguity is impossible to be removed. For an example requirements of the project may contain some technical implications that are fundamentally required for the IT department and maintenance and operation party but definitely not required for the end user and vice versa
Also, the requirements may include some things which are usual but have different meaning for everyone.
The requirements are generally reflected due explanations which may include several events, perspectives, verbal rephrasing, emotions, selective emphasis and body language as well.
There are certain things and approaches which can be used to create the sold business requirements.
For an example. There must not be any confusing statement like the alarm will ring if the button T is pressed and if the button F are pressed. This may have both meaning that whether any one button is pressed the alarm will initiate or if both the buttons are pressed then only alarm will ring.
Never use always word as it determines a policy. Also, the word never should not be used.
The boundary conditions must be specified.
Conclusion:
Most of the businesses fails due to the certain undefined ambiguity and confusing statements. Hence, while drafting the business requirements the words are which being taken in use must be chosen wisely otherwise various misunderstanding might occur.
(c)
Requirements of the business.
Answer to Problem PIIIAYKBP
Solution:
The sales department wishes to seek for the sales forecast, commission calculation and target track. Payroll department want the system to keep information about hours and payment calculations. Further department of taxes want the system to calculate taxes automatically and also performs audit.
Explanation of Solution
Given:
An institution trying to implement a computing system to manage its various payment issues.
Initially take in account the sales department. It wants the system to compute sales forecast, calculate commission checks and track of the memberships sold.
The requirements of the sales department are a database that can store information of previous years. This information will be used to calculate the sales in upcoming future. Only, the previous track of the sales can help to determine the number of memberships that can be sell in the coming future. Further, it needs a software like IBM Cognos to perform analysis. Also, the software may be customized according to the requirements. Sales manager wishes to calculate the commission. The commission is based on the type of membership sold. Hence, a dashboard can be plotted on each of the employees’ desk to input the type of membership sold. Hence, in this way the manager and the employee will be able to track the what are their commissions up to the data and how many and what type of memberships they have sold yet.
The department will be able to design promotions based on the demand forecasting data. The computation will be including a clause that which type of the memberships was sold during a specified season of time period. For an example during the summer family memberships are obvious to be sold more than any other. Hence, the company may design the promotions during the summer accordingly to attract the customer to sign up for family membership.
Further comes up the payroll department.
The payroll department’s initial need will be a more effective attendance calculating device. A biometric attendance calculator can be deployed to calculate the information of attendance. this can be further connected to computing device. Now the only need of payroll department is to get information from the sales department about the commission payout. Further, in case of the sick leave, the department may ask for the action.
The workers get paid according to per hour. Hence, the software that is designed to calculate the working hour will be able to calculate the same.
The regular payment, overtime payment and vacation payments can be calculated by the software on its own. Biometric scanner calculates the working hours according to the set off time. If an employee is working overtime. He/she will be in offices. In case they forget to sign out the system will automatically sign him out after the business hours.
Further, the taxes department seeks that the system must do company’s taxes. This can be done by putting another feature in the software. Input the rates and collection. The software will tell about the taxes. In this case the machine is doing all the calculations hence, probability of calculation mistakes will not occur.
Further, the system can track and analyze the information from the database or the auditing authority can take a look on the data collected.
Also, the system will need computing resources, database, power supply, human resource to maintain and operate the system.
Conclusion:
In conclusion, if the company can afford the MIS infrastructure, then most of the processes will be eliminated and the processing will be fast. Also, if the company can link a dedicated bank account to the system then there will not be any need of signing checks. Payment can be transferred online.
Want to see more full solutions like this?
Chapter 9 Solutions
PRINT COMPANION - BUS DRIVEN INFO SYS
- Question 8 (10 points) Produce a relational schema diagram that corresponds to the following ER diagram for a Vacation Property Rentals database. Your relational schema diagram should include primary & foreign keys. Upload your relational schema diagram as a PDF document. Don't forget that the relation schemas for "Beach Property" and "Mountain Property" should each have primary keys. FYI: "d" in this notation denotes a subclass. Figure 2: ER Diagram for Question 8 id first RENTER name middle last address phone email 1 signs N id begin date RENTAL AGREEMENT end date amount N street address books city id 1 state address num. rooms PROPERTY zip code base rate type propertyType blocks to beach activity "B" "M" BEACH PROPERTY MOUNTAIN PROPERTYarrow_forwardConsider a round potato being baked in an oven. Would you model the heat transfer to the potato as one, two, or three dimensional? Would the heat transfer be steady or transient? Also, which coordinate system would you use to solve this problem, and where would you place the origin? Explain.arrow_forwardNotes: 1) Answer All Question, 2) 25 points for each question QI Figurel shows the creation of the Frequency Reuse Pattern Using the Cluster Size K: (A) illustrates how i and j can be used to locate a co-channel cell. huster 3 Cluster Cluster 2 X=7(i=2,j1)arrow_forward
- ASSIGNMENT. 1. The following figure is a billboard sketch, design the members. Hint, the billboard is usually designed against wind loads and its own self weight. For the dimensions, you can visit existing billboards to see usual dimensions. 3D Viewarrow_forward0 = 6 a = 25 t = 3 Y b = 30 xarrow_forwardSolve this problem and show all of the workarrow_forward
- In order to solve the frame given below with the Force Method, remove restraints from joints A and G and draw only the bending moment diagrams Mo, M₁, M2 and M3 for this case. (25 Pts.) Note: Only bending moment diagrams that are used for the solution are required. There is no need to do any further calculations. 4 kN B I E D 2 kN/m H 3 m 3 m 4 m + 2 m 4marrow_forwardplease show complete solution with formulaarrow_forwardb = 25 y t = 2 a=10 C = 25arrow_forward
- MATLAB: An Introduction with ApplicationsEngineeringISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncEssentials Of Materials Science And EngineeringEngineeringISBN:9781337385497Author:WRIGHT, Wendelin J.Publisher:Cengage,Industrial Motor ControlEngineeringISBN:9781133691808Author:Stephen HermanPublisher:Cengage Learning
- Basics Of Engineering EconomyEngineeringISBN:9780073376356Author:Leland Blank, Anthony TarquinPublisher:MCGRAW-HILL HIGHER EDUCATIONStructural Steel Design (6th Edition)EngineeringISBN:9780134589657Author:Jack C. McCormac, Stephen F. CsernakPublisher:PEARSONFundamentals of Materials Science and Engineering...EngineeringISBN:9781119175483Author:William D. Callister Jr., David G. RethwischPublisher:WILEY