Reference no: EM132304488
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:
a) Total accumulated Orders and Delivered items for each product.
b) Calculate the difference between the total accumulated weekly orders and total accumulated weekly delivered items.
c) Change the format of the date field to be in the mm/dd/yy format.
d) 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:
a) Chart on a separate worksheet titled "Difference Chart".
b) Legend at the bottom with the names each product.
c) Proper axis labels (e.g., dates for the X axis).
d) Appropriate chart title.
3) Generate a written report describing containing the following:
a) Summary - Short explanation of the reason you are writing the memo.
b) Methodology - Explanation of the use of the spreadsheet and the steps used to analyze the data.
c) Findings - Conclusions drawn from analyzing the data.
d) Recommendations - Actions recommended to your supervisor.
|
The work done by human experts will change going forward
: What are some business problems that AI + Machine Learning paradigm cannot solve? How do you think the work done by human experts will change going forward?
|
|
Discussing ways to achieve greater balance of power
: Using the U.S. Constitution, library, Internet, or any other available materials, focus your discussion on the following: Discuss 3 ways to achieve greater.
|
|
Write clearly and concisely about issues in law
: Write clearly and concisely about issues in law and the legal system using proper writing mechanics. Include a brief summary of the case
|
|
Identify the branch of government that created lower courts
: In this unit, you are studying the judicial branch of government and the rules that apply to all cases that are filed with a court, such as jurisdiction.
|
|
Perform an analysis of the number of widgets
: You are the Productions Manager responsible for the development of widgets, jobbers, and, thing-a-ma-jigs.
|
|
Why do budgets need frequent reviews and adjustments
: Why do budgets need frequent reviews and adjustments? Who is responsible for ensuring that budgets and other financial documents are accurate?
|
|
In what type of office would you like to work
: Paralegals work in many different settings. Choose three different types of law office settings or three different paralegal specialties, and discuss the pros.
|
|
Develop an effective business continuity plan
: In order for an organization to develop an effective business continuity plan or disaster recovery plan.
|
|
In what ways has jurisdiction implemented specific component
: Review the Sector-Specific Plans and choose one Sector-Specific plan to focus upon. Regarding your chosen sector, identify areas of risk in your local.
|