NEED URGENT HELP!!!! PLEASE SOMEONE BID ON THIS ASSIGNMENT…NEED HELP! MUST HAVE MICROSOFT ACCESS TO COMPLETE!I have completed steps 1-3, I need someone to open the project instructions attachment below and complete steps 4 and 5 based on the information I’ve already compiled in steps 1-3. I have also attached a sample of Step 4…you can use this just revise it a bit. Will need access to the Microsoft Access program to complete Step 4. Both steps 4 and 5 need to be complete in full with no plagiarism. I have also attached a copy of the case study to reference to. THANKS!
project_business_analysis_1_3.docx
project_folder_access_database.zip
project_instructions.pdf
wilcoconstruction_case_study.pdf
Unformatted Attachment Preview
Wilco Construction Project
By:
April 19, 2017
1
Table of Contents
Questions and Answers …………………………………………………………………………. 3
DFD ……………………………………………………………………………………………… 5
EFD ……………………………………………………………………………………………… 6
Explanation.……………………………………………………………………………………… 7
2
Questions
1.
List some of the major problems facing Wilco Construction Company.
There are various problems at Wilco Construction Project Company. They include the use of a
manual system in carrying out its operations, nepotism and corruption in giving out employment
opportunities. Further, the company neither offers attractive salaries nor does it have any benefits
to its employees. Still the company does not maintain updated records making it difficult to have
reliable sources of information for future reference.
2.
Which is the main problem affecting Wilco? Why do you think so?
The main problem facing Wilco however, is the use of a manual system to run the programs and
operations of the company. In the time that the current society is operating in, the use of a
manual system is outdated and already considered obsolete. The use of a manual system as a
result has caused delay in operations, un-updated company records since manual work is time
consuming and involves a lot of paperwork, also difficulty in conducting, determining and
evaluating the actual value of the company assets, finally, the company is unable to adhere to the
government laws and regulations since most of these laws requires a well computerized system.
Currently, all the government policies, transactions and regulations have been computerized by
the government. This therefore means that in order to carry out or in other words comply with
the laws and regulations by the government, every company must be using a computerized
system in carrying out its operations.
3. In your opinion, what should be the scope of the current project? Give your reasons.
The input of this project should be to determine the issues and factors affecting the construction
industry in United States of America. This is because, the findings, conclusions and the
recommendations can be applied to help people in this industry and those who desire to join to
know, be informed and understand better the construction industry and ensure to avoid such in
the future.
4.
What should be the main areas and factors to consider when implementing a new system
and its applications? Why?
The main areas to consider when implementing a system are the finance and human resource
departments. This is because these are the departments that handle the most sensitive information
and operations that matter most in a company. The system should therefore be able to capture all
the financial operations such as the general ledger daily transactions, reconciliations, cash
transactions, the assets, and more. For the human resource department, the system should ensure
that the employee contracts, personal details and other important information relating to the
3
employees is well captured and there is a backup of the same. Another important aspect to
consider is the internet connectivity such that the system can be able to carry out its operations
online especially those relating to government compliance. Other factors to consider while
implementing a computerized high quality technology system are; to ensure that the system will
record and keep accurate and updated track of the project’s activities and operations for easy
running of the company, the use of a computerized and reliable system is the speed and less time
consumed in carrying out operations, the accuracy of the records, it is also easier to update
records such as the employee contracts, the payroll, the cash reconciliations, and more.
5. Are there other relevant applications to consider implementing in the future? Give reasons
Other kinds of applications include an automated system that ensure the employees are
responsible in time management, also these automated systems capture the data and
automatically update and save it in the individual employee hours worked records. There are also
the time clocks to be used by the employee to check in and out at any time and thus keep a
record of their working behavior and time.
4
DFD
5
ERD
6
Explanation:
1. Every employee must have an hour or more worked.
2. Every hour worked must be checked in by an employee.
1. An employee must have single project information.
2. Project information must be worked on by one or more employee.
1. Each employee may check out one or more inventory.
2. Each inventory must be checked out by one or more employee.
DFD:
The DFD is an illustration of an ideal system. The system shows the different areas that
information must flow to have the system accurately operate within the company. There are
various procedures involved in the DFD such as recording of new employees’ information, new
project information, creating timecards for the employees, summary of the weekly pay, creating
an EEOC Compliance file and recording the hours worked by each employee. Each of the above
procedure has a sub-system functioning in it for example; the new employee information is
recorded by updating the personal details on the employee in the system and then allocate a
project number. For the timecard, it is given to an employee for the purpose of keeping track of
hours worked while the EEOC file is used to maintain the information for the employees and
ensure that this information is up to date and accurate.
7
Instructions for the Term Project: Develop an EEOC compliance system for
the Wilco Construction Company
MGMT 4207 Systems Analysis and Design
Purpose: Develop an EEOC compliance system for Wilco Construction Company (the Wilco
EEOC Information System)
As a team perform the following steps:
Step 1> Read the case and answer the 5 questions below, as a team.
1. What are the problems at Wilco?
2. What do you believe to be the most pressing problem facing Wilco? Why?
3. What do you think should be the scope of the current project? Why?
4. What do you think should be the priorities for implementing the system and its
applications? What makes you think so?
5. What other kinds of applications might be built into the system in the future?
Step 2> Analyze the information in this case and generate the requested deliverables:
1. Create a data model using Entity-Relationship diagrams for the Wilco Construction
Company EEOC system. The E-R diagrams should be complete, in that they represent
real things in the Wilco environment. You should also specify entities, entity
descriptions, attributes, attribute descriptions, unique identifiers, and relationships (and
their descriptions). The deliverable will be your E-R diagrams and supporting
documentation.
2. Create a set of leveled (context level, level 0, and level 1) data flow diagrams (DFDs) for
the Wilco Construction Company EEOC system. You should also specify processes, data
stores, external entities, and data flows. The deliverable will include your set of leveled
data flow diagrams, along with any explanatory documentation.
Step 3> Design the input forms and reports for the Wilco Construction Company EEOC
compliance system. The form should be aesthetically pleasing, and should insert all relevant
information into the appropriate tables (entities) in the database. For example, you should make
certain that your input form makes appropriate use of zoning and navigation flow between fields.
The output reports should be designed such that they describe fully the appropriate information.
The form should be neat, clean, easily readable, and communicate clearly and quickly the
relevant information.
Step 4> Build tables, forms and reports in Microsoft Access. The database tables, reports, forms,
and any processing logic should be implemented fully in the database. This includes (but is not
limited to) assignment of foreign keys, data types, and field lengths. This also includes the
assurance of referential integrity between your tables. At the completion of this assignment,
everything should be done except the programs and interfaces.
Wilco Construction Part 1
2
Bonus Step 5> Build the necessary programs and interfaces that will enable end-users to fully
and effectively use the Wilco EEOC compliance system. This step of your term project requires
you to put everything together, and make it work. This includes building things like combo
boxes and menus. It also means doing up documentation to explain to the user how to use the
system. It also involves using test data provided to develop sample reports.
There are several elements to this part of term project. First, you will be required to generate
queries to create tables with the information necessary to create the EEOC reports. This will
require that you draw out the appropriate data, do some calculations, and then make this
available to the Access report generator to print out the reports. The final report should have all
of the general data and proper formatting. Don’t worry about the graphics from the original case,
but do put in nice headers, boxes, etc., where applicable. The report should take the project ID
and description from the project table. You’ll need to build another query to do this. These are,
by the way, the correct numbers for the Adams County Project. You should generate a report for
all three projects. The reports should include all of the information Mary would need to fill out
the EEOC compliance reports.
What you should do is imagine that Wilco has submitted the reports generated from your
database to the EEOC, and they have been noted. Because regulations require that Wilco use 10
percent women and 10 percent minorities on all projects and in all skill classifications.
Deliverables
As a team, turn in 2 files, one MS Word file and one MS ACCESS file, to the dropbox in D2L:
1. Your MS Word file must contain the following items in order:
a. A cover page with Course title, date, all members name, weight and description of each
member’s contribution to this project
b. An ERD
c. A DFD at context level, a DFD at level 0, and a DFD at level 1
d. A list of the names and purposes for the objects (tables, forms, reports, and queries)
implemented in your ACCESS database.
e. Minutes of your group’s meetings/ records of group’s communications
2. Your ACCESS file must contain the following objects:
a. Table objects
b. Quesry objects
c. At least an EEOC Compliance report object
Wilco Construction Company
“State Qualified Contractors”
Term Project for the MGMT4207 Systems Analysis and Design
Cast of characters
Jack Wilson, Partner
Bob Wilson, Partner
Frank Borman, Job Site Supervisor
Mary Wilson, Office Manager
Sue Wilson (Jack and Mary’s daughter), Commerce Undergrad (MIS Major) at Massive State
University
Background
Wilco Construction Company is a State Qualified Highway Contractor in Ohio. The company
got its start about 20 years ago when Jack and Bob Wilson decided to go into business together
rather than work for other companies. Both Jack and Bob were veterans in the highway
construction business, having worked for larger firms for several years prior to setting out on
their own. Wilco will take on any road construction job within their capacity, however, they
specialize in small bridge projects. They will also do related construction jobs for local
governments or private concerns, such as setting beams, pouring concrete foundations, or largescale landscaping.
In its early days, the firm benefited from two major advantages: Jack and Bob’s experience in the
field, and extremely low overhead. In fact, the brothers did much of the work on the early
projects themselves, with the assistance of Bob’s friend Frank Borman (who he met while in
military service), and a few hired laborers. Many of the laborers who worked on those early
projects (and/or their children) are still with the firm today. Jack’s wife Mary served as
bookkeeper in the early days, and took over the office management duties a few years ago.
While there are others, Wilco’s major client is the State of Ohio, Highway Division, which
accounts for approximately 90% of Wilco’s business (the rest is divided between private work
and city, township and county government work). Projects are allocated by the state using a
competitive bidding process: Wilco and other companies bid on various projects let by the state.
The company with the low bid receives the project. They are then paid by the state at the
completion of various stages of the project, such as foundation, structure, deck, roadway,
drainage, and final completion. State construction inspectors who are assigned to every state
highway job assess the completion.
In a good year, the company will win about 4-5 road building projects, worth roughly 1 million
dollars each. The company can expect between 3.5 and 5 million dollars in gross revenue in a
given year. Net revenue, after salaries, other expenses, and taxes, can be expected to be between
5-10 percent of gross revenue.
Wilco Construction Case
2
While the core business hasn’t changed much since Jack and Bob bought their first backhoe 20
years ago, the legal and regulatory environment has changed significantly, leading to a marked
increase in the amount of paperwork. Mary has noticed that she spends a lot more time in the
office than she used to, just to keep up. In particular payroll, which Mary has traditionally done
by hand, has become an extremely complex undertaking. The company would like to expand its
operations, but the sheer complexity of complying with various State and Federal wage scales
and regulations (see the work and the environment, below) makes this quite difficult given the
present system of information management. At present Wilco employs about 50 workers.
Organization
Wilco has a fairly organic structure, in that there are very few official titles, and the titles do not
really mean anything. While Jack and Bob make the strategic decisions and manage the job sites
(along with Frank), Mary handles the day-to-day operation of the office. She is the sole
employee in the office, and nearly all of the information in the firm at one point or another will
pass through Mary’s hands. Mary handles anything not directly related to administration of a
specific job site. Consequently, she is charged with a great deal of responsibility in the company.
The work and the environment
Most projects proceed in the following manner. Every month, the State publishes “the book,”
which highlights the projects to be let that month. The company requests plans for jobs for which
they may bid. Jack, Bob and Frank review the plans and at least one of them makes a site visit.
The bids are then completed and submitted to the state. During the bid writing process, suppliers
for various line items (concrete, steel, paving material, paint, etc.) are contacted for their prices.
Since the suppliers are qualified by the state as well, this is a simple matter of calling up and
asking for the unit price for the material. In fact, since the suppliers are privy to the same
information as the contractors (as well as who has requested plans), they will often call up Wilco,
with the total cost (unit cost and amount already calculated) for a line item on a particular job.
If Wilco is “low-bid” on a project, they assign a supervisor, who is responsible for the site
administration. The supervisor (Jack, Bob, or Frank) takes a crew to a job site, and accomplishes
the various tasks needed to complete the job over the few months that the project will run. The
job site supervisor is the final authority on the administration of his particular job. The client will
also assign an inspector (usually an administrator and/or an engineer) to the job site as well.
Equipment and trucks are owned by the company, which can be moved to the various job sites
by tractor and trailer. In some cases the job site supervisor needs a piece of equipment that is too
specialized for the company to need on every job, hence equipment is sometimes rented.
Wilco Construction is an open shop, that is, employees may or may not belong to a craft or trade
union. Jack and Bob believe that the decision to join a union should be up to the employee. The
bulk of Wilco’s employees are not union, however, simply because there usually is not enough
specialized work within one trade to keep any worker busy all of the time. The State mandates
that all workers be paid a union scale per hour rate based on the skill classification for the job
that they are doing at any given time. Consequently, there is no financial advantage to joining a
union. The varying pay scales make for a complex payroll calculation. For instance, if a worker
Wilco Construction Case
3
spends 2 hours as general labor ($11 per hour), 3 hours as a carpenter ($12 per hour), 1 hour in
masonry work ($13 per hour), and 2 hours as a heavy equipment operator ($15 per hour) in a
given day at a given job site, then their wage would be calculated by taking the amount they
earned in each classification and summing those totals. In this instance the worker would gross
$101 dollars for that day. Additionally, the wage scales can change from job to job (based on
distance from the nearest union hall). For example, on a job 10 miles from a union hall, the union
scale for an iron worker would be $14 per hour, while for a job 50 miles away from a union hall,
the scale for an iron worker would be $15 per hour. The scale for each job is supplied by the
state with the construction plans. Employees working on non-state projects (or at the shop)
receive $10 per hour, regardless of job classification.
Wilco’s workers are extremely flexible, and move from skill to skill and job site to job site on a
daily, even hourly basis. The only constant at a given job is the job site supervisor. For example,
last week when Frank’s crew was getting ready for a big bridge deck pour, Jack spared a few of
his workers to help out, as his project was temporarily delayed (heavy rain had flooded a footer
hole, which had to be pumped out before work could proceed). Consequently, a worker may
have worked at multiple sites, in up to 5 skill classifications (general labor, carpentry, masonry,
ironwork, and equipment operation), in any given week. All of this has to be taken into account
to generate a payroll statement. The job site supervisor is responsible for keeping track of most
of the movement of employees from job to job and site to site, however, trusted employees who
have been with Wilco for several years keep their own time cards. At any rate, all information
relevant to payroll eventually gets turned into Mary.
Recently, employment equity legislation has also become an issue in the construction industry.
Currently, legislation dictates that employers use certain percentages of visible minorities and
women for each job skill classification on each job. A report stating how many hours (on each
job, in each skill classification) were worked by women and visible minorities has to be sent to
the Ohio Equal Employment Opportunity Commission (EEOC) every two weeks to demonstrate
compliance. Currently, 10 per cent of all hours in each skill classification at each job (although
the wages are not consistent across jobs, the skill classifications are) have to be worked by a
woman or visible minority to be in compliance with the regulation. Failure to comply could
mean that Wilco would be stripped of its qualification, making it ineligible to bid on state
contracts. In addition, as governments change, the legislation changes, and hence the reporting
requirements change as well.
The p …
Purchase answer to see full
attachment
Recent Comments