Micro Chip Computer Corporation Selected Financial Data 2008 2007 2006 2005 2004 Micro Chip Computer Corporation Consolidated Statements of Operations For the period September 26, 2007 through September 25, 2008 Sales $8,334.00 Cost of Sales $5,458.00 Gross Margin $2,876.00 Operating expenses: R & D $525.00 Selling, General, and $691.00 Administrative Inprocess R & D Restructuring costs Total Operating Exp $1,216.00 Operating income $1,660.00 Total interest and other $194.00 Income net Income before provision $1,854.00 for Income taxes Provision for income $278.10 Taxes (15%) Net income $1,575.90 Click here to download the selected financial statements for Micro Chip Computer Corporation. Answer questions 1 and 2 below based on the financial data. 1. Determine the year-to-year percentage annual growth in total net sales. 2. Based only on your answers to question #1, do you think the company achieved its sales goal of +10% annual revenue growth in 2009? Determine the target revenue figure, and explain why you do or do not feel that the company hit its target. Next, consider Micro Chip's Consolidated Statement of Operations for the year ended September 25, 2008. Download the file here and answer questions 1 and 2. 1. Use the Percentage Sales Method and a 25% increase in sales to forecast Micro Chip's Consolidated Statement of Operations for the period of September 26, 2008 through September 25, 2009. Assume a 15% tax rate and restructuring costs of 5% of the new sales figure. 2. Discuss your results from question number #1. What assumptions have you made? Do any of your assumptions seem unreasonable? To receive full credit on this assignment, please show all work, including formulae and calculations used to arrive at the financial values. Students using Microsoft Excel must provide an adequate explanation of the methodology used to arrive at that answer. Assignment Guidelines Download the financial statements and consolidated statement of operations by clicking on the links above in the assignment description. Analyze the statements and then answer the four questions listed in the assignment description. Show all work including calculations and formulas. If applicable, provide a detailed explanation of how you used Microsoft Excel to arrive at your answers. Organize your answers, mathematical calculations, and Microsoft Excel data into a Word document of 1-2 pages. Your submitted assignment (120 points) must include the following: A double-spaced Word document of 1-2 pages that contains your answers to the four questions listed in the assignment description, any calculations you performed, and all formulae that were used. Also, provide your Excel data table(s) along with an explanation of how you arrived at your answers if applicable. Grading You will be graded on the accuracy of your financial calculations as well as your demonstrated understanding of financial statement analysis. Please submit your assignment. For assistance with your assignment, please use your text, Web resources, and all course materials. Individual Project Rubric Grading Criteria Percentage Deliverable requirements addressed; understanding of material and writer's message and intent are clear. 40% Calculation methods, where required, are contextually appropriate, fully explained, and presented in a manner that is easy to understand. 10% External research incorporated in the paper, if any, supports 5% the writer's position properly acknowledged and cited; direct quotations may not exceed 10% of the word count of the body of the assignment deliverable (excluded title page, abstract or table of contents if used, tables, exhibits, appendices, and reference page(s).) Inclusion of plagiarized content will not be tolerated and may result in adverse academic consequences. Critical thinking: Position is well-justified; logical flow; examples provided where appropriate. 20% Structure: Includes introduction and conclusion; proper paragraph format; reads as a polished academic paper or professional presentation, as appropriate for the required assignment deliverable. 10% Mechanical: No spelling, grammatical, or punctuation errors. 10% APA: Deliverable is cited properly according to the APA Publication Manual (6th ed.). 5% 5-7 slides with speaker notes of 200-250 words per slide (excluding Title and Reference slides) Objective: Identify methodologies relevant to team building and performance standards for the functions of HRM as they pertain to organizing, controlling, planning, leading, and staffing You, as a HR Generalist, have been asked by your HR Director for your recommendations in terms of what tools your organization could use to better manage the talents of your employees. This will help to develop policies and procedures in managing your human capital. Please develop a PowerPoint presentation to your Director addressing the following: Describe and analyze the broad range of talent management efforts that use software applications to help you Director to make an educated decision. Give some examples of firms that have successfully used these applications. Describe how these efforts are useful in terms of strategic human capital management. Please submit your assignment. Individual Project Rubric Grading Criteria Percentage Deliverable requirements addressed; understanding of material and 35% writer's message and intent are clear. Scholarly research which supports writer's position properly 20% acknowledged and cited direct quotations may not exceed 10% of the word count of the body of the assignment deliverable (excluded title page, abstract or table of contents if used, tables, exhibits, appendices, and reference page(s). Inclusion of plagiarized content will not be tolerated and may result in adverse academic consequences. Critical thinking: Position is well-justified; logical flow; examples provided where appropriate. 20% Structure: Includes introduction and conclusion; proper paragraph 10% format; reads as a polished academic paper or professional presentation, as appropriate for the required assignment deliverable. Mechanical: No spelling, grammatical, or punctuation errors. 10% APA: Deliverable is cited properly according to the APA Publication 5% Manual (6th ed.). 5-7 slides with speaker notes of 200-250 words per slide (excluding Title and Reference slides) Objective: Identify methodologies relevant to team building and performance standards for the functions of HRM as they pertain to organizing, controlling, planning, leading, and staffing You, as a HR Generalist, have been asked by your HR Director for your recommendations in terms of what tools your organization could use to better manage the talents of your employees. This will help to develop policies and procedures in managing your human capital. Please develop a PowerPoint presentation to your Director addressing the following: Describe and analyze the broad range of talent management efforts that use software applications to help you Director to make an educated decision. Give some examples of firms that have successfully used these applications. Describe how these efforts are useful in terms of strategic human capital management. Please submit your assignment. Individual Project Rubric Grading Criteria Percentage Deliverable requirements addressed; understanding of material and 35% writer's message and intent are clear. Scholarly research which supports writer's position properly 20% acknowledged and cited direct quotations may not exceed 10% of the word count of the body of the assignment deliverable (excluded title page, abstract or table of contents if used, tables, exhibits, appendices, and reference page(s). Inclusion of plagiarized content will not be tolerated and may result in adverse academic consequences. Critical thinking: Position is well-justified; logical flow; examples provided where appropriate. 20% Structure: Includes introduction and conclusion; proper paragraph 10% format; reads as a polished academic paper or professional presentation, as appropriate for the required assignment deliverable. Mechanical: No spelling, grammatical, or punctuation errors. 10% APA: Deliverable is cited properly according to the APA Publication 5% Manual (6th ed.)