Project 1 Please use this file as your template to complete project 1 using the information provided in Part 1 and Part 2 worksheets to develop your solutions to each independent part. Name: TYPE in your name here Save your file using your first initial, last name, and name of Project. Upload your solution by clicking on the project 1 assignment link. Make sure you type your name in cell A2 You should always verify that your project has been loaded correctly by either going back to the assignment and clicking on Ok and you should see the file you uploaded and you can also go to view grades and click on the exclamation to see the file you have loaded. Remember it is your responsibility to take the time to verify that your file has uploaded correctly. If there are problems, please email me immediately with your completed Project attached. You will be graded on the accuracy of your answer and the usage of excel. You must use excel cell referencing in all of your calculations and use the data analysis tool in development of your regression tables. The project 1 solution is worth a total of 30 pts. I have support material demonstrations in the chapter 2 and 3 folders in the weekly area. I have extensive tutorials on regression analysis and scattergraphs in the chapter 3 support material folder. I do not pregrade projects, so if you have questions please make sure you ask a specific question. Project 1- Objectives Part 1-Preparation of Statements 1. Develop a statement of cost of goods manufactured. 2. Develop a statement of cost of goods sold. 3. Develop an income statement. Part 2-Regression Analysis 1. Develop scattergraphs, simple regression output tables, and multiple output table. 2. Develop cost estimation based on your regression analysis. 3. Analyze results and recommend the best approach for the cost estimation.