• 1.Data Analysis : Two Pivot tables.
• 2.Prepare BPMN Activity Model. ta.

The objective here is to produce valid financial analysis of various data properly accounted for in Excel. Use appropriate financial formatting and analytical conventions. Focus attention on numerical formatting conventions and data organization, e.g., text justification, typeface consistency.

a. Using the PAYROLL table, prepare a Pivot table that displays the following as columns:

– Gross pay

– Employee fica

– Employer fica

– Federal tax withheld

– State tax withheld

– Net Pay

1 Pivot table

Below the columns all values will be summed up as totals.

Using the PAYROLL table, add the following rows to the above Pivot table:

– Jan

– Feb

– Mar

Add emp # as a Pivot filter.

b. Using the Pivot table data prepare a Pivot clustered column graph that depicts:

– Jan data

– Feb data

– Mar data

Each month in column style bar graph, vertically with legend.

1 can be a Pivot table: BUDGET ACTUAL

c. Using the Budget sales(Budget) & Cash receipts(Actual) tables, prepare a budget variance

analysis by month & total displaying actual, budget, variance amount & variance %.

– Jan data displaying Actual less Budget & the variance as $ and % of budget

– Feb data displaying Actual less Budget & the variance as $ and % of budget

– Mar data displaying Actual less Budget & the variance as $ and % of budget

– Total for 3 months & variance for all 3 months.

Company: Sy’s Fish Company

After gaining an understanding of Sy’s business processes, document each current process with a business process activity diagram using Business Process Modeling Notation (BPMN). You should have five different processes and five BPMN activity diagrams. Using PowerPoint, Word, Visio or Excel.

Use Business Process Modeling Notation (BPMN) as your guide for BPM

N diagrams. This can be done in PowerPoint, Word even Excel or any CAD program. The diagram will require the use of shapes, lines, notations and proper BPMN symbols. You may use 5 processes: Selling Fish, Purchasing Fish, Paying employees, Purchasing misc. supplies and Providing refunds to customers. On landscape paper.

a) is already completed. the answers are in the attachment. only BPMN Model is required (5 )

– For each process try & think of the 1st activity and the last one

– Then think about which employees or departments are involved

– Establish swim lanes

– Keep it logical and sequencial.

– Keep the BPMN rubric in mind