Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

2103 summerland heights ln santa barbara ca 93108

23/11/2021 Client: muhammad11 Deadline: 2 Day

Accounting Information System Homework Assignment

DATE:

7/5/2018

MEMORANDUM FOR:

Young & Jolly, LLC Merger Project Consultants

FROM:

Smart-Buy

SUBJECT:

Merger Project ETL Parameters

Now that the contracts are signed, we are providing more detailed guidance for the team that will help us with our Merger Project. This memo addresses the following topics:

· Background Information

· Specific Files Provided

· Deliverables

Background Information
Recently, Largemart, Incorporated and Bullseye, Incorporated, two large, regional retailers, went through a merger. The newly formed company operates under the name Smart-Buy, Incorporated. Smart-Buy, Inc. is a large retailer with $11.5B USD in annual sales and 80,000+ employees. Smart-Buy is in the process of merging its operations,

Currently, Smart-Buy has retail stores on the West Coast, as well as in Plain and Southern states, but intends to expand into other regions. The company is in the process of determining where its new headquarters will be, so Smart-Buy executives are splitting their time between Largemart’s and Bullseye’s headquarters in California and Oklahoma, respectively. The combined company has retails stores, transportation and distribution centers, as well as a few manufacturing plants.

There were many factors weighed by the company executives and board of directors prior to merging the two companies. One company had distribution centers and manufacturing plants that could prove to be advantageous to the combined company since there would be no need to ramp up new facilities or create facilities from green fields. And, the fact that Largemart already have retail stores in California, meant that the newly formed company would have a Human Resource and Legal Department already well versed in the strict workplace laws and regulations used in California. Additionally, with a significantly larger workforce and store locations, the executives saw that the new combined revenue and synergies between the two companies would be a powerful force to take into the marketplace.

Smart-Buy’s workforce has full-time, part-time, and seasonal workers. During the holiday sales period, their levels generally peak since this is the time of year that Smart-Buy generates their highest sales.

Smart-Buy is in the process of changing its store banners (e.g. Largemart store and Bullseye store signage and related company logos) and implementing SAP as their enterprise resource planning (ERP) system. It has taken a considerable longer time to implement the new system as Smart-Buy works through taking on new best practices as it relates to their business processes and upgrading their technical infrastructure to support the larger company. In the meantime, financials, including payroll, are still being done in separate legacy systems. While this is cumbersome, Smart-Buy’s Chief Information Officer (CIO), thinks that it was more strategic to get the new ERP system implemented as quickly as possible, than to have his limited information technology (IT) teams concurrently working on an interim solution that will be thrown away once the new ERP system was fully functional. As a result, each quarter and annually, there is a manual process of combining financials and reporting. This manual process has caused earning restatements and delays in providing financial information to executives.

We chose Young & Jolly (Y&J), LLC, a Big 6 Accounting Firm to help expedite payroll reporting. It is critical that Y&J completes this task as expeditiously as possible, especially taking into account all of the recent employment regulation changes. As Y&J Consultants, your team has been asked to tackle this assignment. The Managing Partner of the Oklahoma City practice specifically asked for your team to work on this effort because of the outstanding results she saw on your last assignment and because she knows that you do not take shortcuts or wait until the last minute to get your work done. The Managing Partner also gave your team specific instructions to get started on this assignment now because of the large amount of data.

“This is more data than we typically work with,” she said. “This is Big Data!”

Specific Files Provided
Smart-Buy has provided you with employee files. The employee files consist of demographic information. Each company provided files from separate legacy systems. In addition, Smart-Buy has provided you with quarterly payroll files from fiscal year 2016 for each of the two companies. Specifically, you should have the following files for each company:

· Addresses

This file contains address information sorted by employee id. Both large-mart and Bulls-Eye will provide these files to Young&Jolly Inc. Any queries that need to understand the location of the employee by city, state or zipcode, should use this table as all employees have an address record. These files will need to be merged together. The address_id will be the primary key for the merged file.

· Calendar

This file contains information about the calendar utilized to calculate payroll. Pay checks are cut for hourly employees on the 1st and the 15th of each month. This means that the number of hours available to work in any given pay period must be calculated based on the number of week days in the pay period. The calendar file will provide the number of hours available for an employee to work in a pay period. Both companies will provide this file. If the files are exact matches, only one of these files are required for use in your new database. Usually only one of these files is necessary. This file will be useful for limiting the results by period, month or quarter.

· Departments

The departments at both companies will have the same names; however, not both of the companies have all departments. For reporting and data integrity purposes, please merge the department files provided. The Department_IDs from each company uses a different naming convention, and therefore the department_ID is a unique identifier of each row of data.

· Employee Information

Employee Files are provided by each company and we would like one Employee file as part of the merger. Not all employees are assigned to a store as those in support jobs, like human resources and accounting do not work for just one store. This means that there are nulls in the data for Store_ID for many employees. Pay attention to how access brings this field over as it is a foreign key and must be a number. For querying anything that has to do with an employee city or state, the address table should be used. The store information is useful for understanding how many employees are assigned to a store, etc. Another field to watch is the SSN, please ensure the SSN is brought over in a format that works for both companies. The employee_id uniquely identifies each row in this table.

· Payroll Register

Payroll information has been downloaded quarterly for each company. This means that Large-Mart has 5 Payroll files and Bulls-Eye has 5 Payroll files that need to be combined into one large payroll file (this may exceed 1,000,000) records. Each employee has multiple payroll records in this file. It is sorted by employee_id, which repeats and cannot be used as a primary key.

· Stores

This file includes information about the stores, including the address of the store and the number of customers in the store’s immediate area (estimated population). The store address does not reflect where employees are located, the address table should be used for this. Store_ID will uniquely identify each row in the table.

· Revenue-Stores

This file includes information about the Revenue brought in by each store. The Revenue is reported using the same calendar that is used to calculate payroll. Each store’s revenue is reported by period, meaning that period cannot be used as a primary key and store_id cannot be used as a primary key.

Smart-Buy provided this picture of how the tables are related:

Deliverables
This memo specifies the requirements to extract, translate and load the data into a database. We refer to that as the ETL Deliverable.

ETL Deliverable: For the purposes of insuring data integrity, we want to understand how you create the database against which you will eventually run your analysis. All the analysis should be run from the same database. So, we ask that you create a database and write a process memo to explain what you have done so that we can ensure the integrity of our data through the Extraction, Translation, and Load Process. This is common requirement for data analysis by consultants or auditors. We have extracted the data, so no write up of the extraction process is necessary. Your memo (word document) should have the following sections:

· Process

In this section we want you to write the steps of creating your database in enough detail that should we need to recreate your work in an audit we are capable of such. A picture of your final tables is required.

· Translation

In this section you will outline any formatting or changes to the data that occurred.

· Load

In this section you will outline the final disposition of the database. This includes screen shots of sample data for each table, and total record counts against your tables. Start by describing the final structure of your database. Tell your audience what tables you now have in the database. A screen shot of the access screen(s) to support this is required.

Technical Specifications:

Given the size of the files, we are keeping them in a dropbox. You will be provided a link to the appropriate files through canvas. There is also an ETL “Quiz” where you will verify that you have loaded your tables correctly by verifying your record counts and answering a few simple database questions. You have 2 attempts at this “Quiz”. Both the word document and the “Quiz” are due at the same time as specified in Canvas. The “Quiz” is worth 10 points and the ETL write-up is worth 10 points for a total of 20 points for the ETL activities.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Writing Factory
Assignment Hub
Instant Assignments
24/7 Assignment Help
A+GRADE HELPER
Homework Tutor
Writer Writer Name Offer Chat
Writing Factory

ONLINE

Writing Factory

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$37 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$18 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$29 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$41 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$44 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$50 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

George polya's steps in problem solving - Lowes proxy statement - Transpac container system ltd - Star wars ccg red 5 - English - On going home joan didion - Bismarck blood and iron speech primary source - Multicultural matrix and analysis worksheet - The road not taken questions with answers - Dsw comenity bank customer service - Business organization - Find the greedy looters remains to the north - Dq response - Culture box project ideas - Role - Is circle geometry in hsc - Bcg matrix of coca cola - What is the atomic radius of helium - Security Architecture & Design - Air jordan market segmentation - Buff dudes cutting plan phase 2 - Operational Excellence - How to calculate couple moment - Under armour swot analysis 2013 - Management 2 - Business process management the third wave - Vollmer manufacturing makes three components - Week Two Discussion One - Code cracker flash version - Which metaphor best captures the role of a project manager - Takeexamsonlinetakeexamsonline - Percentage of casein in cow milk - Ratios and financial planning at east coast yachts solution - Volume of vehicles theory - How do evolutionary change and revolutionary change differ - Energy in food lab report - Osha field operations manual 2011 - Beyond twinkle twinkle using music with infants and toddlers - 09/23/2020 - +91{**}9414601882 lOvE prOblEm sOlutiOn by vashikaran in nAgpuR, nAshik - Discussion on e-bussiness - Interpretive simulations answers - Natural twinning and artificial twinning - Ancient egypt hierarchy ks2 - Genitalia soap note - The regal cycle company manufactures three types of bicycles - Case 3 - James hardie fire insulation - Protec 6300 fire panel - Montana 1948 text response essay - What were the major causes of the great depression - Ayer mis amigos esteban, ana, olivia y yo fuimos al cine a ver la nueva película de javier bardem. - Marty grims net worth - Mckesson hr - Rough and ready pa - Sonnet 73 is written in iambic pentameter - Anchorage port stephens accommodation - Chlorination of alkanes can produce a multitude of products - Homework - Bright child learning center - Hershey bcg matrix - Corfe castle primary school - What is an ethiope - Thermal stability of group 2 carbonates - Exercise 9 12 accounting for estimated liabilities lo p4 - Eric helms 5 day full body - Honey possum small intestine - Cla - Questions about Insurance - Different types of historians - Ap statistics inference portfolio answers - 2 paragraph 10/02/2020 - Food Labels! - Alpha cell deep cycle battery - Apple retail iphone upgrade program - How long has gerber been around - Screwpost portfolio books australia - Classroom and Safety Management Plans - Blades inc case study answers chapter 1 - SUNDAY IS DUE - Tracker software pdf xchange pro - What you eat is your business radley balko - The newsroom america is not the greatest country - Dan chupong and tony jaa - Phet bending light worksheet answers - Resume Assigment - CLA 1 Paper - Data Analysis & Business Intelligence - Toa amplifier p 912mk2 - Ctyclk chimney rock - Surface area of oblique pyramid - Network flow models - To kill a mockingbird chapter summaries ppt - Motor vehicle repairers licence wa - Dan murphy german beer - Corporate finance chapter 12 solutions - Aerial bundled conductor specification - Chemalite case study income statement - Moor green lane medical centre - Anatomical evidence for evolution - House and mitchell path goal theory