Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like to know how to figure out the SprintyPrint Context Diagram This is the scenario for this question: SprintyPrint pays a year-end bonus

I would like to know how to figure out the "SprintyPrint Context Diagram" This is the scenario for this question:

SprintyPrint pays a year-end bonus to its top three executives (CEO, CFO, COO). The bonus is based on the companys 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 companys financial performance falls. The bonus structure incentivizes executives by providing increasingly higher bonuses for achieving improvement over the prior years performance. The following is an example of the basic bonus structure for the CEO:

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

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

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

Tier 4: The bonus is equal to 50% of the CEOs annual salary PLUS 0.1% of Gross Profit if the companys 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 Committees 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Security And Auditing Protecting Data Integrity And Accessibility

Authors: Hassan A. Afyouni

1st Edition

0619215593, 9780619215590

More Books

Students also viewed these Accounting questions

Question

Identify traditional external recruitment methods.

Answered: 1 week ago

Question

Describe alternatives to recruitment.

Answered: 1 week ago