The owner of a small snack food and potato chip manufacturer, California Crunch Company, has asked you to investigate a possible issue with the company’s payroll.? They have provide
The complete Writing Project and Presentation is found in Getting Started. Upload the portion of the project due this week.
Requirements:
Writing, using software, and interpreting results is a large part of your learning experience. These assignments are designed to improve your use of technology and communication skills. Using proper business English and resources from the library you will comment and share your research with your classmates. Make sure you note your source in proper APA format.
Project Information:
The owner of a small snack food and potato chip manufacturer, California Crunch Company, has asked you to investigate a possible issue with the company's payroll. They have provided you with this year and last year's income statements and two payroll files. The “HR Master” file gives you important information about each employee. The “Payroll” file detailsthe company’s payroll for the last 5 pay periods of the year. You will be conducting some audit procedures for California Crunch and analyzing the results.
Week 1 Writing Assignment Part 1:
This project is split into four (4) parts with one (1) part due each week of the course. Based on your readings, use of technology, research of literature, and other sources do the following:
Week 1: Review the income statements given to you by the owner of California Crunch Company. Based on the AICPA Code of Professional Conduct prepare a 2-3 page summary of how you plan to proceed to address the owner's concerns and what specific steps you would take to audit this company.
Due Dates: This project is completed over several weeks so be sure to follow the due dates carefully.
Grading Rubric: Please refer to the grading rubric specific requirements.
Criteria
Points
Description
Content
0-55
Thoroughness: A majority of the paper is related to the topic assigned. Discussion of the topic is accurate and includes relevant examples. Related sources are used to explain the topic but a majority of the paper (roughly 80%) is the student's own ideas. Creative solutions and/or recommendations are based on the issues presented and a review of the sources used. Timeliness: Assignment submitted by the assigned due date.
Sources
0-20
The paper contains the minimum number of scholarly/authoritative sources from the KU library and/or authoritative sources such as applicable standards, laws, regulation, etc. required.
Formatting
0-15
The paper is logically organized, follows proper APA format including cover page, abstract, introduction, proper headings, conclusion, references, exhibits if applicable, etc. In-text citations and references conform to APA standards.
Writing
0-10
Paper is written at the university level. Error-free writing is clear and thoughts are organized into complete sentences and paragraphs.
Library Assistance
Link to Keiser's elibrary resources: http://kesu-verso.auto-graphics.com/MVC/
PowerPoint instruction on how to use the Keiser elibrary: Keiser Slide show Library-Orientation-login-and-navigate-lesson1.pptx Keiser Slide show Library-Orientation-login-and-navigate-lesson1.pptx – Alternative Formats
Guidance on how to log in and use the Keiser elibrary: KU Library login guide2014October3.pdf KU Library login guide2014October3.pdf – Alternative Formats
How to cite work from the library: How to cite work from the library.docx How to cite work from the library.docx – Alternative Formats
This link helps with APA format: https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/general_format.html
Graded Activity:
Click on Getting Started to review the requirements for the writing project. Then click the title link above labeled "Week 1 Writing Project – Part 1" to upload part 1 of the writing project.
Income Statement
California Crunch Company | |||||||||
Statements of Income | |||||||||
For the year ended December 31, | 2018 | 2017 | |||||||
Net Sales (less returns & allowances) | $ 8,353,542 | $ 7,998,832 | 4% | ||||||
Cost of Goods Sold | 3,745,623 | 3,621,532 | 3% | ||||||
Gross Margin | 4,607,919 | 4,377,300 | 5% | ||||||
Operating Expenses: | |||||||||
Advertising | 115,325 | 113,452 | 2% | ||||||
Bad Debt Expense | 65,232 | 62,585 | 4% | ||||||
Depreciation and Amortization | 75,210 | 73,565 | 2% | ||||||
Dues & Subscriptions | 600 | 575 | 4% | ||||||
Insurance | 60,800 | 60,600 | 0% | ||||||
Licenses & Fees | 300 | 285 | 5% | ||||||
Marketing & Promotion | 52,632 | 51,025 | 3% | ||||||
Meals and Entertainment | 25,030 | 24,345 | 3% | ||||||
Office Expenses | 14,325 | 14,652 | -2% | ||||||
Office Supplies | 24,003 | 23,458 | 2% | ||||||
Salaries & Wages | 2,380,105 | 2,192,032 | 9% | ||||||
Professional Fees | 39,700 | 38,500 | 3% | ||||||
Property Taxes | 19,220 | 19,000 | 1% | ||||||
Rent | 85,230 | 84,360 | 1% | ||||||
Repairs & Maintenance | 1,450 | 1,500 | -3% | ||||||
Shipping Delivery | 770 | 730 | 5% | ||||||
Travel Expenses | 75,830 | 73,560 | 3% | ||||||
Utilities | 35,230 | 34,250 | 3% | ||||||
Leased Equipment | 44,000 | 43,750 | 1% | ||||||
Other | 15,320 | 14,756 | 4% | ||||||
Total Operating Expenses | 3,130,312 | 2,926,980 | 7% | ||||||
Operating Income | 1,477,607 | 1,450,320 | 2% | ||||||
Interest Expense | 84,658 | 83,950 | 1% | ||||||
Other Income (interest, royalties) | 5,920 | 5,725 | 3% | ||||||
Income Before Taxes | 1,398,869 | 1,372,095 | 2% | ||||||
Income Taxes | 489,604 | 480,233 | 2% | ||||||
Net Income | $ 909,265 | $ 891,862 | 2% |
,
HR Master
EMP_ID | FIRSTNAME | LASTNAME | SSN | HIREDATE | TERMINATIONDATE | ADDRESS | CITY | STATE |
748 | Juan | King | 9531291 | 8/31/07 | 400 Melbourne Road | San Diego | CA | |
482 | Emily | Martinez | 9979842 | 7/7/08 | 110 Tudor Road | San Diego | CA | |
834 | Terry | Gray | 9213929 | 4/8/09 | 183 Almond Court | San Diego | CA | |
885 | Phyllis | Kelly | 4988752 | 10/2/09 | 10/30/18 | 325 Church Road | Carlsbad | CA |
382 | Johnny | Cox | 4777763 | 6/25/10 | 426 Regent Road | San Diego | CA | |
804 | Kevin | Williams | 1301030 | 6/15/11 | 421 The Causeway | Escondido | CA | |
373 | Bruce | Roberts | 8959739 | 1/6/12 | 249 Ivy Court | San Diego | CA | |
590 | Frances | Green | 1390469 | 2/3/12 | 411 Wharf Road | San Diego | CA | |
182 | Evelyn | Diaz | 4701550 | 5/10/12 | 491 Shelley Court | Escondido | CA | |
712 | Martha | Sanders | 9320000 | 10/3/12 | 98 Parklands Avenue | Carlsbad | CA | |
338 | Amy | Lewis | 2267770 | 9/27/13 | 211 Bell Drive | La Mesa | CA | |
278 | Heather | Miller | 1817500 | 11/10/14 | 295 Kings Road | Del Mar | CA | |
353 | Charles | Clark | 2765340 | 11/18/14 | 358 Sutton Road | San Diego | CA | |
330 | Keith | Moore | 8624259 | 1/26/15 | 68 Bramble Court | San Diego | CA | |
341 | Kathryn | Wood | 6363057 | 7/15/15 | 486 Preston Road | San Diego | CA | |
668 | Catherine | Allen | 9798798 | 10/14/16 | 160 Carr Lane | Del Mar | CA | |
431 | Wayne | Robinson | 3572858 | 10/21/16 | 63 Scott Court | San Diego | CA | |
212 | Julie | Campbell | 5875948 | 11/15/16 | 3/25/18 | 232 Woodstock Road | Carlsbad | CA |
491 | Eugene | Anderson | 7616476 | 1/31/17 | 492 Mill Street | La Mesa | CA | |
874 | Deborah | Brooks | 7977825 | 5/15/17 | 202 Windsor Street | Del Mar | CA | |
336 | Brandon | Nelson | 6385852 | 6/14/17 | 327 Ashley Court | San Diego | CA | |
179 | Kimberly | Hughes | 2666315 | 8/2/17 | 479 Orchard Road | San Diego | CA | |
217 | Roger | Cook | 4005884 | 8/18/17 | 236 Rectory Lane | San Diego | CA | |
962 | Ralph | Rodriguez | 4129921 | 1/16/18 | 73 Water Lane | Carlsbad | CA | |
381 | Joshua | Jenkins | 9198893 | 6/7/18 | 446 Warwick Court | Escondido | CA | |
778 | Sarah | Wilson | 3020458 | 2/21/06 | 141 Market Square | Escondido | CA | |
407 | Alice | Torres | 9277267 | 6/7/06 | 508 Kenilworth Road | San Diego | CA | |
162 | Aaron | Bryant | 1433932 | 8/31/06 | 449 Middle Road | San Diego | CA | |
644 | Chris | Turner | 7620118 | 9/14/06 | 275 Grasmere Road | San Diego | CA | |
476 | Marilyn | Johnson | 1531344 | 3/9/07 | 473 Park Avenue | San Diego | CA | |
710 | Gerald | Harris | 7237065 | 9/24/07 | 253 Norfolk Road | Carlsbad | CA | |
319 | Debra | Peterson | 4145637 | 10/6/08 | 258 Crown Street | San Diego | CA | |
608 | Gregory | White | 7206123 | 10/27/08 | 401 Vicarage Gardens | Escondido | CA | |
357 | Howard | Price | 8204814 | 1/21/09 | 487 Spring Gardens | San Diego | CA | |
613 | Jerry | Ross | 7916621 | 7/6/09 | 469 Central Avenue | San Diego | CA | |
867 | Jessica | Henderson | 5340544 | 8/2/10 | 208 Harrow Road | La Mesa | CA | |
682 | Stephanie | Sanchez | 2025855 | 10/18/10 | 493 Oaklands Drive | La Mesa | CA | |
368 | Ashley | Thomas | 5946416 | 11/14/11 | 427 Derwent Avenue | Escondido | CA | |
520 | Ruth | Russell | 2640169 | 8/10/12 | 441 Maltings Drive | San Diego | CA | |
781 | Diana | Watson | 4645210 | 8/14/12 | 177 Swan Court | Carlsbad | CA | |
277 | Jimmy | Long | 9890118 | 10/8/12 | 158 Scott Street | Coronado | CA | |
425 | Carolyn | Bell | 8861807 | 10/18/13 | 259 Church Drive | Coronado | CA | |
525 | Diane | Alexander | 2711538 | 1/29/14 | 270 Spencer Court | San Diego | CA | |
954 | Todd |