Project dj accounting answers

Analytics Group Project Instructions

OBJECTIVE:

Your objective is to evaluate a company’s processes, develop an integrated accounting database,

produce a simple set of financial reports, and conduct analyses that will add value and enhance the

performance of the company. Ideally, groups will have 3-4 members. You may work with your group in-

person and/or online.

Carefully read the description of Boneless Seafood company. Become familiar with the data contained

in the associated Boneless Seafood Excel data file. Review the instructions below and discuss the

project with your group before you begin work. Although you will divide up the workload, every

student should be familiar with every part of the project. Each aspect should be discussed and agreed

upon, and all members are responsible for producing an integrated final project.

What you’ll turn in:

In class:

Printed report that contains an executive summary, table of contents, and items described in

deliverables A through H. Further details are provided on p. 3 and in subsequent instructions.

One combined, sequential time log that shows dates, activities, and names of group member or

members who completed each activity. You can use a shared Google sheet or any format of your

choice to track your progress.

In my email:

Subject line: 335 HB1 Group Project: Amy Lee, Pat Garcia, and Joe Smith (use your own section

and names)

3 attachments: A single Access database that includes properly numbered and descriptively named

queries, a summary Excel file, and a single Word or PDF document that contains your entire report

(use a scanner or scanning app such as Genius Scan if necessary).

**Important** I change some aspects of my projects each term. If a group submits answers to a

previous term’s assignment, the group will receive a 0 on the project and will be subject to a hearing by

the university’s academic integrity disciplinary committee. You’re investing a lot of time and money to

learn accounting—do your own work so that you can get the knowledge and skills you’re here for.

Keep copies of all of your notes and preliminary work in case you need to provide evidence of the

independence of your work or of your contribution to the group effort.

Suggestions for how to get started

Before you begin, study the instructions, interviews, and data.

Complete part B first, and make sure everyone understands and agrees on the data model. Chapter 8 provides a lot of information that might be helpful as you work through the group project. For example, Figure 8.6 provides a generic data model you can use as a starting point.

Each table in the Excel file will represent an entity in your model, except that the orders_sales file will

need to be broken into its heading and line items components (to see why, look at Atla_O90007.) You

may break down some other event files as well.

2

The table below gives suggestions for how you might want to organize your work. This is a very big

project, and every group member will need to be a full participant.

Part When What Deliverables Split?

A any time

draft 4 BPMNs