company is clothing
Section 2: Company Profile (10 points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. Learners are asked to report based on a fictitious firm. If you are creating this firm for a small business that actually exists, please obtain consent from the ownership team. It is also not your instructor’s business if the firm is “real”. As far as your instructor knows, you will be working on a ‘fictitious’ firm. ?? Name of firm and a brief history of how the firm was first established ?? Information on ownership team ?? Goals/mission for this firm ?? INDUSTRY information. Please perform external research on the industry that this firm operates. ?? For the scope of this assignment, assume that this firm (or the division you are preparing this report for) has only asked you to provide data analysis for 5 products and/or services. This is because they plan to use the ‘how to guide’ that you will be completing, alongside your excel workbook as training material and task their existing staff to complete data analysis for the rest of their product catalog. For the 5 products and/or services that you will be creating this report for, create subheadings and information on each product/service offered. Include (and cite) pictures within this section. When listing the prices for each product/service, please state the price that the firm that has hired you charges. Because this is a fictitious firm, to research market values for comparable products/services and cite this information when stating the final price charged by this firm. A method of determining market price might be to research (and cite) the prices charged by 3 similar firms and charging the average of the 3 prices offered. ?? Outline 2 issues that firms within this industry are facing . In addition to the 2 issues that firms within this industry are facing, outline at least 2 issues that your particular firm is facing. ?? Why this report was created and what the owners can expect to find within Information must be organized in paragraphs. If minimum information is included, your instructor reserves the right to provide a score of 0 for this section. Section 3: Data Entry (10 points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. ?? Include a screenshot of your raw data tab. The screenshot doesn’t have to contain all data, just a snapshot?? Include at least one paragraph to support why the data contained within this tab reflects your critical analysis on why sales figures for each product may fluctuate throughout the year. ?? Provide insight as to why you chose to organize your data within this tab the way that you did, and outline the additional metric included. Details on what should be included within this section can be found within the instruction document for this assignment. Section 4: Sparklines (5 Points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. ?? explain what a sparkline is. ?? Include a screenshot outlining the sparklines created with the raw data from this firm (ensure that this picture is wrapped in between text). ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear steps how you completed this function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. Section 5: Conditional Formatting & IF (or IFs) Function (5 Points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within paragraphs. ?? Complete step 5 (instruction set for this assignment). ?? Explain what ‘conditional formatting’ is. what the IF (or IFs) function is (only describe the function that you utilized for this assignment). Clarify how conditional formatting is linked to the IF(s) function. ?? Explain how you incorporated conditional formatting for this business. Ensure that you include a screenshot (wrapped in between text). ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear steps. how you completed both of these function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. Section 6: Pie Chart & Goal Seek (10 Points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. ?? Complete step 6 (instruction set for this assignment). ?? Include a screenshot of the Pie Chart created within your Excel file. Explain to your client what this pie chart shows. ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear steps how you completed this function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. ?? Explain what the Goal Seek function is and how using this function can be beneficial for this firm. ?? Include a screenshot (wrapped in between text) of the goal seek that you included within your Excel file. ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear steps how you completed this function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. Section 7: Pivot Table (5 Points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. ?? Complete step 7 (instruction set for this assignment). ?? Explain what a pivot table/chart is and how this can be beneficial for the firm you are working with. ?? Include a screenshot (wrapped in between text) of your pivot table/chart that you included within your Excel file. ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear steps how you completed this function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. Section 8: Process Smart Graphic or Funnel Chart (5 Points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. ?? Complete step 8 (instruction set for this assignment). ?? Explain why the tool that you selected for step 8 (process smart graphic or funnel chart) is important and how it can benefit the firm you are working for. ?? Include a screenshot (wrapped in between text) of the tool that you selected for this step. ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear steps how you completed this function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. Section 9: Moving Averages (5 Points) ?? Complete step 9 (instruction set for this assignment). ?? explain what moving averages are, and why they are a useful analysis tool. ?? Include a screenshot (wrapped in between text) of the tool that you selected for this step. ?? Given that this is a critical thinking analysis, please communicate how the tool(s) utilized for this function provide insightful data to the owner. What trends do you notice? What might be reasons for these trends? When analyzing data for sections 4 – 9, please remember that you are evaluating the movement of 5 different products/services. With some sections, you may comment on trends for total revenue, however, it is expected that some of sections within this report, that you highlight your findings (and possible reasons) for the sales movement of each product/service analyzed. ?? Assuming that this document will be utilized as training material for present/future employees of this firm, please communicate in clear stepshow you completed this function using Excel. Assume that your audience is not familiar with Microsoft Excel. For this reason, please break down your steps in an easy-to-understand format. Directions should be complete, and not minimal in nature. Section 10: Recommendations (10 Points) ***Information must be presented in paragraph format. The bullet points below outline what should be included within your paragraphs. ?? Within section 1 of this submission, you outlined 2 issues that firms within your firm’s industry are facing, as well as 2 issues unique to the firm that you are working with. ?? Critical analysis and external research required for this step. a table and include 2 prospective solutions for each issue. Looking for detailed recommendations here References ??
