This assignment uses an Excel workbook as the basis for a case study. The case study is a snapshot of the merchandise Item Sales Report in the Small Tools department of a retail hardware business. However, the information contained in the Item Sales Report could apply to any choice of products in any retail category, store, or business. Study and analyze the information in the workbook to complete the instructions below. Bear in mind that financial analysis is more than just determining what the data reveals. Financial analysis requires managers to use the data to make decisions that will influence business results.Instructions:Use the skills you've practiced, and outside research to complete the calculations and answer the following questions regarding the case study. First, you will work with retail math formulas to gain the data required to complete the case study. Click here to access the Excel workbook you will use to complete this assignment. Open the Excel file to the tab labeled Item Sales Report. Study this spreadsheet and examine the mathematical relationships for Mark Up, % Total On Hand, Sell Thru %, and % Total Sales.Using the formulas, calculate the values and fill in the correct percentages for the empty cells in the spreadsheet.Next, you will make determinations based on the business results found in the Item Sales Report spreadsheet. Use the completed Item Sales Report spreadsheet as your data base. Use the data from the completed Item Sales Report spreadsheet to analyze the Small Tool business. When completing the following instructions, include any relevant data/numbers from the Item Sales Report to support your analysis (numbers that would affect change and address opportunities and liabilities in the Small Tool business). Open the Excel file to the tab labeled Observations.In text box 1, analyze the completed Item Sales Report spreadsheet. Identify at least five merchandise items that require attention and action, and explain why this is so.In text box 2, develop and defend at least three recommended action steps to maximize sales or minimize liabilities for the merchandise items. In text box 3, indicate what additional data would have been helpful to you as you analyzed the Small Tool business. Also note what additional information would have helped you determine recommended action steps in response to the business results. Compose your answers on the Observations page of the workbook with a minimum of 8 paragraphs. Copy and paste the contents of both worksheets into a Word document that you will submit as your Peer-to-Peer post. At least one outside research source is required for this assignment.

As you continue on your path to earn a degree in business administration, you will deepen your understanding of how effective management is a crucial aspect of overall business success, especially in today’s complex business world. As business and society continue to evolve, there will continue to be demand for managers who are able to organize their resources and strategically implement the functions of management to achieve the goals of an organization. The final paper for the course is divided into two parts: Final Project One and Final Project Two. Both parts of the assessment will focus on decision making and the fundamental principles of management. In Final Project One, you selected a successful company from the list provided in the Final Project One Document. You analyzed the company’s best practices and effective implementation of the fundamental principles of management. In Final Project Two, with the help of your instructor, you will select a struggling company from the list provided below. You will analyze the company’s ineffective implementation of the fundamental principles of management. Once you analyze the struggling company, your task will be to make recommendations for a management improvement plan explaining how the company’s management team can improve in areas such as decision making, employee performance, and sustainability. Final Project Two consists of the selection of the struggling company (a non-graded task due in Module Five) along with one milestone, which will be submitted to scaffold learning and to ensure quality final submissions. This milestone will be submitted in Module Six. Final Project Two will be submitted in Module Eight. In Final Project Two, you will demonstrate your mastery of the following course outcomes: ?  OL-215-01: Analyze how an organization’s goals influence organizational planning that informs strategic decision making ?  OL-215-02: Analyze the functions of management and ethical principles for executing effective decision making in organizations ?  OL-215-03: Apply management techniques that ensure the continuous improvement of personnel and business processes to measure organizationalperformance ?  OL-215-04: Apply communication techniques aimed at increasing employee performance, thus achieving organizational goals and objectives ?  OL-215-05: Illustrate the important connection between management and organizational culture Prompt The general manager has reviewed your analysis of a successful company and was impressed with your work. As a result, you have been asked to provide recommendations for a management improvement plan for a struggling company. For the second part of the final project, you will focus on a struggling company and make your recommendations in a management improvement plan. Be sure to focus on the company at the time of their struggle. Your recommendations will show how management performance, employee perception, and organizational success intersect. You must select a company from this list of suggested companies. Resources related specifically to the struggling companies listed are provided.  **please use Motorola company ** https://www.chicagomag.com/Chicago-Magazine/Septem... https://www.networkworld.com/article/2277903/10-re...