I’m working on a computer science project and need support to help me understand better.PART #1: For this assignment, you will use the Vinho Winery Case Study and other course resources to review raw data sets that summarize the production, sales,
and distribution of wine. You will need to analyze the various types of wine and different distribution centers to determine their financial impacts on the
organization’s total revenue. All of your analyses need to be submitted in an annotated Excel file, and each analysis needs to include a rationale.
Specifically, the following critical elements must be addressed:
A. Using a pivot table, determine the percentage of wine varieties sold from each distribution center. Illustrate your results in the form of a pie chart. Hint:
Create a pivot table using the data spreadsheet as its basis. B. Generate a labeled bar chart that illustrates the sum of wine varieties sold to each distribution center. C. Using a pivot table, calculate the total amount of revenue generated for each distribution center. Illustrate your results on a bar chart. Hints: Production
cost data is provided in the Costs and Distances tab. Make sure you don’t mix your units of measurement (i.e., pallets, cases, or bottles).
D. Using the IF function, calculate the central tendencies (mean, median, and mode) of shipment volume for each distribution center. Illustrate your results
in a table. (Do NOT use a pivot table or manually identify each cell to be evaluated.)
E. Analyze the frequency of shipment by size using a histogram. Use the following bin sizes (number of pallets): 72, 48, 24, 18, 12, 6, 3, 1.
F. Create a shipment histogram to show the distribution of shipments for Portland and Riverside. Use the same bin sizes as you did in Part E. Hint: Use the
alphabetical sort for the destination column, and select Data Analysis to plot the frequency of pallet shipments using the bin sizes listed for the two
destinations separately.
G. Provide a summary statement that describes the inefficiencies in the organizational sales analysis. In your response, explain why this information is
important for influencing management decisions. PART 2: For this milestone worksheet assignment, complete the following: Review the Milestone One Rubric. Address the following three parts of the Milestone One Worksheet: o Describe SNHU Clothing’s business needs and identify what types of data can help best address SNHU Clothing’ business needs. o Identify the current client systems in use at SNHU Clothing and illustrate how they interrelate. o Describe how you will access the data you need, how you will know what information is currently available, and how and where the data is
stored. Upload your completed and saved worksheet file, along with any flowcharts, to the learning environment. PART#3: Specifically, the following critical elements must be addressed:
I. Project Proposal. The project proposal should contain enough detail so that relevant stakeholders (who will vary depending on your selected case
study) can determine if the proposed solution is feasible and will address the needs or gaps in the current operating environment. The following
sections should be included: A. Problem Statement: Craft a clear, accurate problem statement that highlights the information technology-related aspects of the challenges you
are facing. B. Significance: Analyze the significance of this problem and what a solution could mean to you, the company or group, and the discipline or area
of interest within information technology. In other words, describe the significance that this project has to your discipline or area of interest
within information technology and your development as a practitioner. This will be your chance to sell this project idea so that it is exciting for
your imaginary stakeholder audience, and also for your real-world instructor, peers, and potential employers. C. Objectives: Describe the scope, goals, and objectives of your project. If you are addressing only a part of the overarching problem, state this in
this section. Make sure that your objectives are reasonable (i.e., could be accomplished without exorbitant resource usage, an irrational
timeline, etc.). D. Deliverables: Propose your overall solution, highlighting the key deliverables that you will create to solve the problem or challenge the
statement. E. Methodology: Establish the methodology and techniques that you intend to use throughout the design phase of your project, with support as to
how each is appropriate for the situation.
F. Risks: Analyze the problem and your own solution proposal to highlight any risks that may prevent successful completion of your solution
design. Include risks that result from the project not fulfilling the objective to solve the information technology problem. In other words, what
risks are present and how would they impact the potential for a successful information technology solution? ALL RUBRICS WILL BE SEND ONCE ITS ACCEPTED.
Requirements: As required | .doc file
