2024 – Acct 305 Assignment 15 3 You have been hired to evaluate the payroll system for the Skip Rope

Acct 305 Assignment

15.3.You have been hired to evaluate the payroll system for the Skip-Rope Manufacturing Company. The company processes its payroll in-house. Use Table 15-1 as a reference to prepare a list of questions to evaluate Skip-Rope’s internal control structure as it pertains to payroll processing for its factory employees. Each question should be phrased so that it can be answered with either a yes or a no; all “no” answers should indicate potential internal control weaknesses. Include a third column listing the potential problem that could arise if that particular control were not in place. (CPA Examination, adapted)

 (Romney 455)

Romney, Marshall B., Paul Steinbart. Accounting Information Systems, 12th Edition. Pearson Learning Solutions, 1/2011.VitalBook file.

16.8.Excel Problem. Objective: Practice graph design principles.

Required

Use the data in Table 16-3 to create the following graphs:

a.   Sales

b.   Sales and Gross Margin

c.   Earnings per Share

TABLE 16-3      Data for Problem 16-8

2010

2009

2008

2007

2006

Sales

598,000

640,000

575,000

560,000

530,000

Cost of Goods Sold

350,000

400,000

375,000

330,000

300,000

Gross Margin

248,000

240,000

200,000

230,000

230,000

Earnings Per Share

12.52  

12.10  

11.95  

11.66  

10.50  

Which principles of graph design, if any, did you have to manually implement to override the default graphs created by Excel?

 (Romney 485-486)

Romney, Marshall B., Paul Steinbart. Accounting Information Systems, 12th Edition. Pearson Learning Solutions, 1/2011.VitalBook file.