michele only

300​ ​words​ ​or​ ​more ● A​ ​detailed​ ​description​ ​of​ ​your​ ​individual​ ​innovation​ ​solution.​ ​​ ​Your​ ​solution​ ​should​ ​be​ ​a

potentially​ ​viable​ ​solution​ ​when​ ​compared​ ​to​ ​the​ ​customer​ ​requirements​ ​(CRs).​ ​Your description​ ​should​ ​a​ ​discussion​ ​of​ ​the​ ​advantages​ ​and​ ​disadvantages​ ​of​ ​your​ ​solution​ ​with respect​ ​to​ ​the​ ​project​ ​CRs​ ​(rather​ ​than​ ​as​ ​compared​ ​to​ ​the​ ​other​ ​solutions).

o Design​ ​solution ▪ Working​ ​at​ ​night

● Help​ ​the​ ​factory​ ​to​ ​reduce​ ​the​ ​number​ ​backlog​ ​from​ ​past​ ​orders ● Help​ ​the​ ​factory​ ​to​ ​meet​ ​customer​ ​demand

▪ Hire​ ​more​ ​people ● Help​ ​the​ ​factory​ ​to​ ​reduce​ ​the​ ​number​ ​backlog​ ​from​ ​past​ ​orders ● Help​ ​the​ ​factory​ ​to​ ​deliver​ ​their​ ​customer​ ​order​ ​in​ ​time ● Help​ ​the​ ​factory​ ​work​ ​in​ ​other​ ​product

600​ ​word​ ​or​ ​more.​ ​Also​ ​include​ ​a​ ​conclusion

● A​ ​detailed​ ​description​ ​of​ ​the​ ​innovation​ ​solution​ ​that​ ​your​ ​team​ ​is​ ​proposing​ ​to​ ​move​ ​forward with​ ​including​ ​the​ ​rational​ ​for​ ​selecting​ ​this​ ​solution.

o The​ ​team​ ​​ ​is​ ​proposing​ ​to​ ​move​ ​forward​ ​with​ ​data​ ​collecting ▪ information​ ​on​ ​Customer​ ​Requirement​ ​&​ ​KPI

Customer​ ​Requirements

Requirement​ ​ID Customer​ ​Requirement Weightings (Out​ ​of​ ​100)

1 Design​ ​a​ ​basic​ ​database​ ​in​ ​excel​ ​to​ ​store​ ​data​ ​for​ ​use​ ​by​ ​the​ ​company and​ ​future​ ​consultants. 20

2 Include​ ​tables​ ​in​ ​the​ ​database​ ​for​ ​Product​ ​Orders,​ ​Shipments,​ ​Raw Materials,​ ​and​ ​Machines.

20

3 Enforce​ ​Data​ ​integrity. 20 4 Incorporate​ ​a​ ​Graphic​ ​User​ ​Interface​ ​(GUI)​ ​that​ ​is​ ​easy​ ​to​ ​use. 16

5 Include​ ​forms​ ​and​ ​reports​ ​in​ ​the​ ​GUI​ ​to​ ​assist​ ​in​ ​informed​ ​decision making​ ​in​ ​production. 14

6 Include​ ​forms​ ​and​ ​reports​ ​in​ ​the​ ​GUI​ ​to​ ​assist​ ​in​ ​informed​ ​decision making​ ​in​ ​material​ ​planning. 10

Key​ ​Performance​ ​Indicators​ ​(KPIs): KPI​ ​#​ ​1 Justification:

● Maintaining​ ​consistent​ ​and​ ​accurate​ ​records​ ​of​ ​machine​ ​downtimes​ ​(e.g.​ ​changeovers, breakdowns,​ ​and​ ​maintenance)​ ​will​ ​assist​ ​the​ ​company​ ​in​ ​determining​ ​root​ ​causes,​ ​utilization, and​ ​​effective​ ​production​ ​time.

● Current​ ​State​ ​Performance:

● The​ ​current​ ​procedure​ ​for​ ​recording​ ​machine​ ​downtimes​ ​is​ ​on​ ​paper,​ ​and​ ​many​ ​downtimes​ ​are not​ ​recorded.

● The​ ​workers​ ​entering​ ​the​ ​records​ ​often​ ​report​ ​the​ ​explanation​ ​for​ ​downtimes​ ​in​ ​Spanish​ ​which hinders​ ​the​ ​owners​ ​and​ ​managers​ ​from​ ​tracing​ ​root​ ​causes.

Goal: ● Transfer​ ​the​ ​record​ ​keeping​ ​procedure​ ​to​ ​a​ ​paperless​ ​process. ● Implement​ ​a​ ​list​ ​of​ ​options​ ​for​ ​the​ ​reason​ ​downtimes​ ​occur​ ​that​ ​is​ ​translated​ ​in​ ​both​ ​English​ ​and

Spanish. KPI​ ​#​ ​2 Justification:

● Maintaining​ ​accurate​ ​records​ ​of​ ​shipping​ ​invoices​ ​will​ ​allow​ ​the​ ​company​ ​to​ ​track​ ​progress​ ​in filling​ ​orders​ ​and​ ​make​ ​informed​ ​decisions​ ​on​ ​the​ ​production​ ​floor.

Current​ ​State​ ​Performance: ● Several​ ​shipping​ ​invoices​ ​are​ ​lost​ ​or​ ​missing​ ​from​ ​April​ ​–​ ​November​ ​of​ ​2017. ● ​ ​Many​ ​of​ ​the​ ​shipping​ ​invoices​ ​include​ ​the​ ​incorrect​ ​order​ ​ID​ ​on​ ​the​ ​form,​ ​preventing​ ​accurate

tracking​ ​of​ ​order​ ​fulfillment. Goal:

● ​ ​Design​ ​a​ ​GUI​ ​functionality​ ​within​ ​the​ ​database​ ​for​ ​entering​ ​shipping​ ​information​ ​and​ ​generating progress​ ​reports​ ​on​ ​the​ ​status​ ​of​ ​orders.

KPI​ ​#​ ​3 Justification:

● Maintaining​ ​records​ ​of​ ​material​ ​waste​ ​will​ ​enable​ ​the​ ​company​ ​to​ ​accurately​ ​order​ ​required amounts​ ​of​ ​raw​ ​materials.

Current​ ​State​ ​Performance: ● The​ ​company​ ​is​ ​using​ ​outdated​ ​forecasts​ ​for​ ​material​ ​waste​ ​to​ ​estimate​ ​material​ ​requirements.

The​ ​previous​ ​forecasts​ ​were​ ​based​ ​on​ ​a​ ​different​ ​raw​ ​product​ ​vendor. Goal:

● Design​ ​a​ ​GUI​ ​functionality​ ​within​ ​the​ ​database​ ​for​ ​entering​ ​board​ ​ft.​ ​of​ ​raw​ ​material,​ ​and​ ​board ft.​ ​of​ ​sellable​ ​finished​ ​product,​ ​and​ ​generating​ ​a​ ​report​ ​for​ ​the​ ​estimated​ ​raw​ ​material requirement.

SWOT Strengths:

● Allows​ ​for​ ​informed​ ​decision making

● Provides​ ​a​ ​basis​ ​for​ ​improvement ● Allows​ ​for​ ​production​ ​and​ ​material

planning

Weaknesses:

● The​ ​data​ ​entered​ ​is​ ​not​ ​accurate,​ ​correct, or​ ​useful.

● It​ ​cannot​ ​directly​ ​improve​ ​quality ●

Opportunities:

● Allow​ ​expansion​ ​into​ ​other​ ​markets

Threats:

● Cost​ ​of​ ​raw​ ​material​ ​increasing ● ​ ​Price​ ​of​ ​goods​ ​decreasing ● Decrease​ ​in​ ​demand