Introduction:

The objective of this assignment is to provide the opportunity to learn and utilize new functionality in the development of a spreadsheet workbook and analyze the results in order to make a sound business decision.

Overview:

You are the Productions Manager responsible for the development of widgets, jobbers, and, thing-a-ma-jigs. Your company has enjoyed exclusive rights to supply these products for several years and it is your responsibility to ensure your customers continue to be happy with the products and services. Each of the products you produce has a different manufacturing team.

Your customer has determined their weekly needs for materials and provided you with a spreadsheet that is contained in the file need em parts (supplied by instructor). You have tracked your weekly deliveries and this information has been added to the file in the column titled delivered.

Requirements:

The customer has contacted your supervisor and expressed concern over the ability to meet their demand for materials. Your supervisor has requested you provide the following:

1. Perform an analysis of the number of Widgets, Jobbers and Thing-a-ma-jigs delivered from the beginning of the year until now. Calculate the following information, using cell arithmetic, and put it in the table of the provided workbook titled Analysis:
   1. Total accumulated Orders and Delivered items for each product.
   2. Calculate the difference between the total accumulated weekly orders and total accumulated weekly delivered items.
   3. Change the format of the date field to be in the mm/dd/yy format.
   4. All number fields should contain the , separator for numbers larger than 1,000.
2. Generate a single line chart (graph) to show the weekly difference for each of the products. Make sure your chart contains the following:
   1. Chart on a separate worksheet titled Difference Chart.
   2. Legend at the bottom with the names each product.
   3. Proper axis labels (e.g., dates for the X axis).
   4. Appropriate chart title.
3. Generate a written report describing containing the following:
   1. Summary Short explanation of the reason you are writing the memo.
   2. Methodology Explanation of the use of the spreadsheet and the steps used to analyze the data.
   3. Findings Conclusions drawn from analyzing the data.
   4. Recommendations Actions recommended to your supervisor.

50 71 62 73 64 63 52 59 61 72 45 94 73 72 686 5 4 94 3 2 1 2 5 94 73 56 76 56 67 56 76 56 70 48 57 59 100 74 85 59 100 74 52 82 66 83 62 63 92 82 66 83 52 63 84 62 73 63 81 87 71 85 59 100 74 52 82 87 71 62 73 64 63 52 59 85 90 75 80 80 80 97 78 89 68 67 76 75 86 70 64 68 59 58 58 55 73 72 61 81 61 54 62 73 64 63 75 44 75 85 59 100 74 52 82 66 83 52 63 52 82 66 83 52 63 44 62 73 66 81 76 82 66 83 70 87 71 85 59 100 74 52 82 83 52 63 44 62 59 100 74 63 44 62 3 4 63 46 91 57 67 86 75 73 59 46 59 73 82 66 83 52 63 81 87 71 85 59 100 123456789 10 1 2 3 4 5 6 7 8 9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 1 2 3 4 5 6 7 8 9 50 51 52 53 54 55 Widgets Thing-a-ma-jigs Jobbers Week 1/2312 52 283 4 217 66 50 71 62 73 64 63 52 59 61 72 45 94 73 72 686 5 4 94 3 2 1 2 5 94 73 56 76 56 67 56 76 56 70 48 57 59 100 74 85 59 100 74 52 82 66 83 62 63 92 82 66 83 52 63 84 62 73 63 81 87 71 85 59 100 74 52 82 87 71 62 73 64 63 52 59 85 90 75 80 80 80 97 78 89 68 67 76 75 86 70 64 68 59 58 58 55 73 72 61 81 61 54 62 73 64 63 75 44 75 85 59 100 74 52 82 66 83 52 63 52 82 66 83 52 63 44 62 73 66 81 76 82 66 83 70 87 71 85 59 100 74 52 82 83 52 63 44 62 59 100 74 63 44 62 3 4 63 46 91 57 67 86 75 73 59 46 59 73 82 66 83 52 63 81 87 71 85 59 100 123456789 10 1 2 3 4 5 6 7 8 9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 1 2 3 4 5 6 7 8 9 50 51 52 53 54 55 Widgets Thing-a-ma-jigs Jobbers Week 1/2312 52 283 4 217 66