Data Analysis

Анульовано Опубліковано %project.relative_time Оплачується при отриманні
Анульовано Оплачується при отриманні

Analyze the data based on the questions below

1. Inventory

Examine the inventory data; graphically display the cycle count trends that were recorded for the year.

Which inventory group (A, B, or C) has the worst cycle count accuracy? Does this fit the context provided?

2. Production Recipes

a) Usually processing time for a product is related to its complexity (number of parts). Graphically display the relationship between processing time and product complexity (number of parts) for all products. Indicate the products that have longer than expected processing times on the chart.

b) Some of the machine operators claim that the products with long processing times spend too much time waiting for missing parts. Is there any connection between inventory and longer than expected processing times? If so, what is this relationship?

3. Forecast vs Actual

a) Consider the Sales forecast data. Are there any trends or relationships among the products in the sales forecast? If yes, graphically display these trends.

b) On a new sheet that you label “Process Time Required,” create a composite dataset that shows the process time required for each product in order to meet the weekly sales forecast. This should show all products, quantity for each product each week (sales forecast), and processing time for each machine each week. This worksheet will be a tool for answering some of the following questions. It should be clear, but it will necessarily be a little crowded with data.

c) The plant runs three shifts (7am – 3pm; 3pm – 11pm; 11pm – 7am), 5 days a week. The weekends are dedicated to machine maintenance. The plant is also closed on the weekdays indicated on the inventory tab (inventory counts were made only on the days that the plant was open). Considering this and the total processing time required per week, can the product demand (sales forecast) be met each week if there is only one machine of each type? Which weeks are problematic? Which machines are over capacity? Show your results graphically.

d) Consider the Parts Shipped. Are there any trends in this data? Does the sales forecast match actual shipped? Graphically display the trends you see.

e) The manufacturing plant is in a location that had an unusually warm summer which resulted in several machine breakdowns during the summer. Based on Parts Shipped, was the company able to recover from these maintenance problems to actually achieve the forecast amount?

f) How many extra machines of each type does the company need in order to achieve the Shipped Parts quantities?

Data Analytics Excel

ID Проекту: #15843020

Про проект

11 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

Доручено:

$45 USD за 10 дні(-в)
(5 відгуків(-и))
4.0

11 фрілансерів(-и) готові виконати цю роботу у середньому за $43

rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks. Relevant Skills Більше

$43 USD за 3 дні(-в)
(1 відгук)
0.9
imannhussain

Hi ... I am expert in this and have done this type of work before I will provide you a quality work on time according to your requirement kindly consider my proposal

$35 USD за 1 день
(0 відгуків(и))
0.0
kamrul9494

Hello, i will complete your project perfectly. Thanks Stay tuned, I'm still working on this proposal.

$45 USD за 10 дні(-в)
(0 відгуків(и))
0.0
balaji2656

Dear Employer We will give you the best result by using my Past experience and excellent academic skills on your project. you can chat with me and let's get started. Relevant Skills and Experience Dear Employer We Більше

$45 USD за 6 дні(-в)
(1 відгук)
0.2
hossameldinDiab

I can do the job within four days for $ 43 with my pleasure. Relevant Skills and Experience my basically work is converting the data from system to excel, And export of reports daily on a continuous basis with the coo Більше

$45 USD за 10 дні(-в)
(0 відгуків(и))
0.0
Vineet212

May i do it for you?

$35 USD за 6 дні(-в)
(0 відгуків(и))
0.0