Answered Essay: I need help taking this narrative and breaking it apart to figure out what entities and activities are being produced. It woul

I need help taking this narrative and breaking it apart to figure out what entities and activities are being produced. It would be extrememly helpful to have these broken up into the order they are being done with the group that is producing it. I need to create a context, physical, and logical DFD. If it is possible even having the context DFD created would be extremely helpful. I am just a little lost with how to break these up.

SprintyPrint pays a year-end bonus to its top three executives (CEO, CFO, COO). The bonus is based on the company’s financial performance for the year. No other employees in the company receive any form of bonus compensation. The bonus plans for each of the top executives are approved by the Compensation Committee of the Board of Directors each year. For the past 10 years, the basic structure of the bonus compensation scheme has remained the same; however, percentages and thresholds frequently change from year to year and vary based on the executive.

The bonus compensation scheme is a tiered system where executives’ bonus compensation depends on the tier in which company’s financial performance falls. The bonus structure incentivizes executives by providing increasingly higher bonuses for achieving improvement over the prior year’s performance. The following is an example of the basic bonus structure for the CEO:

Tier 1: The bonus is equal to 20% of the CEO’s annual salary if the company’s Gross Profit increases from the prior year by between 1.00% and 1.99%.

Tier 2: The bonus is equal to 25% of the CEO’s annual salary if the company’s Gross Profit increases from the prior year by between 2.00% and 3.99%.

Tier 3: The bonus is equal to 50% of the CEO’s annual salary if the company’s Gross Profit increases from the prior year by between 4.00% and 4.99%

Tier 4: The bonus is equal to 50% of the CEO’s annual salary PLUS 0.1% of Gross Profit if the company’s Gross Profit increases from the prior year by at least 5%.

Calculations required to prepare the bonus accrual entry are performed in an Excel spreadsheet. The Assistant Controller (Jane Roberts) maintains the spreadsheet and updates it each year with the assistance of the Payroll Department. Jane brings the spreadsheet to the Payroll Department Head (Carolyn Baxter) on a USB drive (the file is not emailed due to its sensitive/confidential nature). Using payroll records, Carolyn modifies the spreadsheet to update the current salaries for each of the 3 executives. When she is done, she saves the file and returns it to Jane on a USB drive.

Next, Jane downloads year-end General Ledger information necessary to calculate Gross Profit for the current year and prior year. Then Jane inserts the downloaded data into her spreadsheet and inputs formulas to calculate the Gross Profit percentage change from prior year to current year.

Finally, Jane obtains the Compensation Committee’s report from the Board of Directors. The report shows the approved bonus compensation plans for each of the three executives. Using those plans and her calculations of financial performance change from the prior year to the current year, Jane updates the formulas and percentages within the spreadsheet to calculate the total amount of bonus compensation that should be paid to the three executives.

The bottom of the spreadsheet shows the journal entry that should be made based on the spreadsheet calculations. For example:

Dr. Bonus Expense                  $XX,XXX

Cr. Bonus Payable                                 $XX,XXX

Jane prints the required journal entry and brings the print-out to the Staff Accountant (Derek Abraham) who enters the journal entry into the General Ledger system.

Jane then provides the Excel spreadsheet showing the journal entry to the Controller (Marissa McDonald) for review. Jane also gives Marissa the supporting documentation for the spreadsheet (i.e., Compensation Committee approved/signed report showing bonus and system downloads on performance in the prior and current year). If Marissa finds any errors in her review, she requires Jane to fix the problems, and then Derek must make a correcting journal entry.

Finally, once Marissa reviews and approves the spreadsheet and journal entry, Jane gives Carolyn Baxter (Payroll Department Head) the spreadsheet so that she can prepare to pay the executives in the next payment cycle.

Expert Answer

 

Answer –

Firstly it says that SprintyPrint pays a year-end bonus to its top three executives (CEO, CFO, COO). Sasic bonus structure is mentioned in the problem.

Break up of the activities being completed and the entities that are completing them.

Sl.No. Activities being completed Entities completing them
1. Excel spread sheet contains calculations required to prepare the bonus accrual entry. Jane maintains the spread sheet and updates it each year with help of payroll dept. Assistant Controller – Jane Roberts
2. Carolyn modifies the spreadsheet to update the current salaries for each of the 3 executives. When she is done, she saves the file and returns it to Jane on a USB drive. Payroll Dept. Head – Carolyn Baxter
3. calculate Gross Profit for the current year and prior year. Inputs formulas to calculate the Gross Profit percentage change from prior year to current year. Jane
4. Obtaining the Compensation Committee’s report from the Board of Directors.This report shows the approved bonus compensation plans for each of the three executives. Jane
5. Using those plans and her calculations of financial performance change from the prior year to the current year, updating the formulas and percentages in the spreadsheet to calculate the total amount of bonus compensation that should be paid to the three executives. Jane
6. Entering of the journal entry into the General Ledger system. Staff Accountant -Derek Abraham
7 Review of the journal entry Controller -Marissa McDonald
8 Review of the supporting documentation for the spreadsheet (i.e., Compensation Committee approved/signed report showing bonus and system downloads on performance in the prior and current year) Marissa
9 If any errors are there, the journal entry is sent for correction by Jane Jane
10 The Journal entry is corrected by Derek Derek
11 Final review of the spreadsheet and journal entry after correction Marissa
12 Final spread sheet for preparation of paying the executives in next payment cycle Carolyn Baxter

Thus, as given in the above table various activites and their break up is given to you so that the activities and the entities performing them is clear.

Buy Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Help Me Write My Essay - Reasons:

Best Online Essay Writing Service

We strive to give our customers the best online essay writing experience. We Make sure essays are submitted on time and all the instructions are followed.

Our Writers are Experienced and Professional

Our essay writing service is founded on professional writers who are on stand by to help you any time.

Free Revision Fo all Essays

Sometimes you may require our writers to add on a point to make your essay as customised as possible, we will give you unlimited times to do this. And we will do it for free.

Timely Essay(s)

We understand the frustrations that comes with late essays and our writers are extra careful to not violate this term. Our support team is always engauging our writers to help you have your essay ahead of time.

Customised Essays &100% Confidential

Our Online writing Service has zero torelance for plagiarised papers. We have plagiarism checking tool that generate plagiarism reports just to make sure you are satisfied.

24/7 Customer Support

Our agents are ready to help you around the clock. Please feel free to reach out and enquire about anything.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

HOW OUR ONLINE ESSAY WRITING SERVICE WORKS

Let us write that nagging essay.

STEP 1

Submit Your Essay/Homework Instructions

By clicking on the "PLACE ORDER" button, tell us your requires. Be precise for an accurate customised essay. You may also upload any reading materials where applicable.

STEP 2

Pick A & Writer

Our ordering form will provide you with a list of writers and their feedbacks. At step 2, its time select a writer. Our online agents are on stand by to help you just in case.

STEP 3

Editing (OUR PART)

At this stage, our editor will go through your essay and make sure your writer did meet all the instructions.

STEP 4

Receive your Paper

After Editing, your paper will be sent to you via email.