Please click here for the word document
Please click here for the excel sheet
I just wanted to explain something so that you do not think I have abandoned you. I have answered the question you have posted and I have full addressed the requirements. If there were other parts to the question, you should have noted that when you first posted the question because experts decide whether or not to work on the questions posted based on whether or not they feel qualified to answer the post and also based on the amount offered. I have sent you a message through management to advise you of that. If you have additional parts pertaining to this question, please make a new post and post those questions. Also, it is against Just Answer policy to exchange personal information with students (such as email addresses and phone numbers), but you can either upload the chart to www.mediafire.com (then copy & paste the share link here)or email the chart to firstname.lastname@example.org and ask them to forward the message to BusinessTutor.
Finally, please note that Amol is no longer with Just Answer so he will not be able to help
Next, consider Micro Chip's Consolidated Statement of Operations for the year ended September 25, 2008 (click here to download) and answer questions 1 and 2.
To receive full credit on this assignment, please show all work, including formulae and calculations used to arrive at financial values. Students who are using Excel must provide an adequate explanation of the methodology used to arrive at that answer.
Next, consider Micro Chip's Consolidated Statement of Operations for the year ended September 25, 2008 and answer questions 1 and 2.Use the Percentage Sales Method and a 20% increase in sales to forecast Micro Chip's Consolidated Statement of Operations for the period September 26, 2007 through September 25, 2008. Assume a 15% tax rate and restructuring costs of 2% of the new sales figure.