Monitoring Production

$3\mathrm{.}2\mathrm{.}1\mathrm{.}2$

Raul Ichine, VP of Operations, has identified a significant concern regarding

his ability for oversight of multiple production locations. Mr$.$ Ichine fears he

will no longer have a consistent overview of production operations as he

cannot be at two different sites at the same time and is seeking a meaningful

solution. In order to support Mr$.$ Ichine in the execution of his responsibilities,

Research & Development Analyst Billy Bob has been tasked with drafting a

dashboard design that will address Mr$.$ Ichines concerns:

Building a Production monitoring Dashboard

CBR has identified a few areas of focus that

need to be addressed and monitored through

the construction of a Business Intelligence

$($BI$)$ visualization system that CBR has named

Control Awareness Reporting Engine, or CARE:

B$2$C Sales and production levels

Logistics and Shipping

Forecasting and Analytics

Through elicitation efforts with Mr$.$ Raul Ichine,

the following items have been identified as

primary concerns:

o Looking to measure daily production rates,

seeing $30-$days of production at any time.

o Month$-$to$-$month comparison of production

with trend lines

o Tracking of inventory levels and sales rate to

ensure only in$-$demand products are restocked

Secondary: CBR Executive team

o Wants to see sale projections and

forecasts

o Wants to see OPEX as a live metric

Sources of Data:

Each production employee will be required to

manually log their activities through Excel on

Microsoft Office $365.$ This process will occur

every time a batch order has been completed.

Sales data is automated by the eCommerce

system, which will automatically record all

sales records to a SQL Server Database. The

TPS backend will seamlessly update the Sales

Database as needed and will not require any

direct interaction from any employee.

All data files accessed by CARE are located

centrally on the organizations SharePoint

Data Server which is a separate system from

Microsofts Office $365$ Server system. All data

will be stored on the SharePoint Data Server,

and all Managers will utilize an application

called Microsoft Teams available from the

Office $365$ Server to access Production Logs and

Sales Records. Excel $($available on the Microsoft

Office $365$ Server system$)$ is used to open the

spreadsheets.

Managers will have access to productivity

output records per employee, through

Microsoft Teams, and will maintain the

following rights:

Add new data records

Update, modify and append existing data

$($time logged$)$

Delete records $($logged$)$

Share Excel spreadsheet access with

authorized personnel.Referring to section $3\mathrm{.}2\mathrm{.}1\mathrm{.}2.$ for stakeholder information and section $3\mathrm{.}1\mathrm{.}4.$ for production information, you will:

$1)$ Create a functional Dashboard:

You will need to generate sample data to prove the functionality of your dashboard design.

Generatedata.com will enable rapid development of test data, each graphic should be leveraging at least $20$ records $($rows$)$ of data.

$2)$ Include an EcoSystem map demonstrating the connectivity the dashboard would require to leverage the identified system$($s$)$ for data sharing within the organization $(3\mathrm{.}2\mathrm{.}1\mathrm{.}2.)$