MATH 210 Grand Canyon University Written Recommendation End of Day Report

Mathematics

math 210

Grand Canyon University

MATH

Question Description

Full instructions attached

What to Submit

Every project has a deliverable or deliverables, which are the files that must be submitted before your project can be assessed. For this project, you must submit the following:

  1. End of Day Report
    Download this sales report and use it as the basis for your reformatted spreadsheet. Make sure that this an XLS or XLSX file before starting your work. This spreadsheet should include a second worksheet with aggregate data, charts, and graphs.
  2. Written Recommendation
    Write a recommendation (200–300 words) for the top three departments the store should keep.

Unformatted Attachment Preview

MAT-20014-XA120 Spreadsheet Applica!ons 21… Project & Resources Table of Contents Project Announcements Discussions Project Results JG FAQs Calendar Support Tools Project Instruc!ons Project Instruc!ons # " Listen ! Project Overview For this project, you will complete an end of day report and a wri!en recommenda"on. Using spreadsheets and data to analyze a company’s profit is essen!al to keeping a business thriving. The effec!ve use of spreadsheets can help keep sales, purchasing, and profit data organized and accurate. Using spreadsheet applica!ons to account for a company’s informa!on is an essen!al organiza!onal skill. Competency In this project, you will master the following competency: Use spreadsheet applica!ons to interpret informa!on and draw conclusions Scenario You work at All-Store, a large general store. All-Store sells everything from groceries and office supplies to medicine, toys, and books. Unfortunately, the company’s profits have been down for the last six months. This is likely because of compe!!on from other local businesses and online vendors. Jill Oliviera, All-Store’s general manager, has decided to rethink the store’s business strategies. One of these strategies is to focus the business’s efforts on just a few departments. This way, the store can specialize in those areas rather than con!nuing to support all of its current offerings. Jill Oliviera has announced that the company will offer goods from just three departments going forward. All-Store will greatly expand and promote these three departments and gradually get rid of the rest. : To pick which three departments will stay, she thought it would be best to consult with her shi$ managers. To her surprise, they had very different opinions on what the three departments should be. Their observa!ons differed surprise, they had very different opinions on what the three departments should be. Their observa!ons differed depending on what !me they worked and whether they were talking about total revenue or profit margin. Because of this, Jill has asked you to analyze the company data so she can make an informed decision. The store’s point-of-sale system can generate a sales report by department—but frankly, the report is a total mess. Jill needs you to make the report from the last two weeks more presentable. Then you should use your findings to give a recommenda!on that will help her make a decision. Direc"ons Part 1: End of Day Report a. A$er reviewing the learning resources, look at the End of Day Report spreadsheet and consider what the best prac!ces are for reforma%ng the report. How can you make the spreadsheet more informa!ve and easier to read? b. Use effec"ve forma$ng and spacing to make the data look more readable. Specifically, you should use the following: 1. Row and column spacing 2. Row and column alignments 3. Cell forma%ng A thumbnail of the End of Day Report spreadsheet. The full document is available in the Deliverables sec!on of this project. c. Create a new worksheet in the same spreadsheet. Include the aggregated calcula!ons: these are calcula!ons : that combine data from several different places. that combine data from several different places. Your new worksheet should look at both the weekly average and the average for a single day (Monday, Tuesday, etc.) for each of the following areas: 1. The average sales for each department 2. The average cost of purchasing (CoG) these goods for each department Use the appropriate formulas in the spreadsheet. You don’t need to do these calcula!ons yourself (on paper or with a calculator). Instead, use these formulas and func!ons: 1. SUM 2. AVERAGE 3. PRODUCT or mul!plica!on 4. QUOTIENT or division 5. COUNTIF or COUNTA 6. IF d. Use charts and graphs to accurately display the financial data. This will help your manager quickly make sense of the data. For each display, be sure to create an appropriate !tle and to label all data directly on your display so that any reader will be able to understand the informa!on you are sharing. Choose two of these items to represent graphically: 1. A bar chart that shows the average daily revenue (in dollars) for each department 2. A pie chart that shows the average daily gross profit (in dollars) for each department 3. A pie chart that shows the average daily profit margin (in percentages) for each department 4. A bar chart that shows the average profit per day (in dollars) in each department 5. A line chart that shows sales (in dollars) in each department for each day listed in the report Part 2: Wri!en Recommenda"on Finally, send your general manager a short (200–300 words) wri&en recommenda!on. Explain which top three departments the store should keep. Be sure to support your sugges!ons with specific calcula!ons and data from your spreadsheet.When making your recommenda!ons: Think about which departments bring in the most revenue. You should also consider the departments with the highest profit margins. Keep in mind what will be most profitable for the company overall. What to Submit Every project has a deliverable or deliverables, which are the files that must be submi&ed before your project can be assessed. For this project, you must submit the following: 1. End of Day Report Download this sales report and use it as the basis for your reforma&ed spreadsheet. Make sure that this an XLS : or XLSX file before star!ng your work. This spreadsheet should include a second worksheet with aggregate data, charts, and graphs. data, charts, and graphs. Reflect in ePor!olio Download Print Open with docReader Ac"vity Details You have viewed this topic Read all about your project here. This includes the project scenario, direc!ons for comple!ng the project, a list of what you will need to submit, and suppor!ng materials that may help you complete the project. : Last Visited Jan 21, 2021 3:17 PM REPRT RANGE EOD JUN16-JUN29 16-Jun Mon 17-Jun Tue 18-Jun Wed 19-Jun Thu SALES COG SALES COG SALES COG SALES COG ELECTRONICS 732,36 256,33 791,24 276,94 716,02 250,61 859,52 300,83 GROCERY 10571,07 7716,88 10971,26 8009,02 11575,71 8450,27 11859,49 8657,43 HOME 938,56 375,42 894,35 357,74 1011,98 404,79 965 386 OFFICE 1592,4 796,2 1567,49 783,75 1675,17 837,59 1692,52 846,26 PHARMACY 1934,7 1267,23 1910,07 1251,09 1951,81 1278,44 2044,25 1338,99 TOYS 878,08 482,94 963,28 529,8 920,51 506,28 925,96 509,28 BOOKS 312,9 204,95 286,86 187,89 214,5 140,5 348,4 228,2 20-Jun Fri 21-Jun Sat 22-Jun Sun 23-Jun Mon 24-Jun SALES COG SALES COG SALES COG SALES COG SALES 804,72 281,65 1823,56 638,25 2168,72 759,05 803,85 281,35 697,58 12112,78 8842,33 15531,24 11337,8 16950,57 12373,92 11085,97 8092,76 9321,31 1085,5 434,2 1360,2 544,08 1283,04 513,21 886,68 354,67 776,72 1778,26 889,13 1305,6 652,8 1302,17 651,09 1636,31 818,15 1349,35 2047,99 1341,43 1329,44 870,78 1466,51 960,56 1870,21 1224,99 1700,41 967 531,85 1959,95 1077,97 2221,64 1221,9 909,33 500,13 790,75 198,4 129,95 339,92 222,65 449,19 294,22 204,01 133,62 248 Tue 25-Jun Wed 26-Jun Thu 27-Jun Fri 28-Jun Sat COG SALES COG SALES COG SALES COG SALES COG 244,15 874,55 306,09 787,38 275,58 786,89 275,41 1866,82 653,39 6804,55 11729,01 8562,18 10324,98 7537,24 12247,84 8940,93 15150,87 11060,13 310,69 1035,43 414,17 889,47 355,79 1066,96 426,78 1153,32 461,33 674,68 1717,42 858,71 1569,1 784,55 1686,09 843,04 1322,96 661,48 1113,77 2085,98 1366,32 1861,17 1219,06 2159,13 1414,23 1176,24 770,44 434,91 998,53 549,19 858,87 472,38 1058,26 582,04 1915,55 1053,55 162,44 228,32 149,55 273,63 179,23 328,3 215,04 407,66 267,02 29-Jun Sun SALES COG 1695,33 593,37 13782,71 10061,37 1198,06 479,22 1086,88 543,44 1017,22 666,28 1669,67 918,32 229,95 150,62 ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags