Adventure Project (1)

Mo Yu sat in the office and met with Secretary Alan to discuss something that bothered him and Alan very much.
Adventure has factories around the world to make different products. As the person in charge of the manufacturing department, Mo Yu needs to know the operation status of each factory every month, for example, whether there is a fault or shutdown, the average unit production cost, and the first piece qualification rate.
"The problem is," mo Yu said. "The people in these factories don't catch a cold in it, and they don't even use Excel. We need to sort out the manufacturing data they send each month !" Alan nodded, because he was the same as Mo Yun, and he had a headache because he had to sort data from the factory every month.

Adventure has multiple manufacturing plants that produce different products in several countries:

• China
  • Shenyang Aircraft Assembly Plant (SY Assembly = Sya)
  • Shenyang Engine Factory, Sy engine = sye
  • Shenzhen electronic equipment assembly plant, SZ electroic = Sze
  • Wuhan shipping company, wh ship = WHS
• Russia
  • Ural optics = UO
  • Izhevsk machine = Im
• Germany
  • Rhein Metal = RM, rhein metal manufacturing plant
  • Krupp machine = km
• USA
  • Lockheed Martin airplane = LMA
  • General Electric Equipment Manufacturing Plant, General Electric = Ge
• Japan
  • Wushi ship manufacturing plant, Kure ship = KS

Currently, each factory provides 10 ~ 20 manufacturing data, which are different from each other, reflects the operation of the factory. The manufacturing data provided by different factories for producing different products is also different.

"Look, this is what we are facing ." "Moreover, these indicators may change every year, new factories will be established, and old factories may be shut down," Mo said ." Alan turned on his laptop and turned the screen to Mo Yun: "The manufacturing data type that the factory needs to provide. I have reorganized the classification. Please take a look ."

Manufacturing data indicators/business fields	Machinery, metal, manufacturing	Aircraft and ship assembly	Optical and electronic devices
Transfer Rate (%)	√	√	√
First pass rate (%)	√	√	√
Manufacturing cost per unit ($)	√	×	√
Material Inventory days	×	√	√
And so on...

Looking at this table, Mo Miao frowned: "You can't waste any time organizing the data. You need to focus on analyzing and coping with the factory manufacturing work ."

Alan thought for a while and thought it was time to ask someone from the IT department for help. After asking for mo Yun's opinion, he opened the address book, contact Ray Ozzie of the adventure IT department collaboration solution group.

Canada room

At 01:45 P.M. on Friday, Alan came to the Canada room in advance to prepare for the meeting.

The Canada room is a medium-sized meeting room located near the parking lot in the manufacturing department office. From the window of the Canada room, it is the garden of the adventure campus and the small river that passes through the small garden. Although it is winter, the sun shines in through the window to make the Canada room very warm.

Of course, Mo Yun's favorite one is because there is a wall that can be wiped and written on a glass whiteboard. It is undoubtedly a good place to spread various ideas and ideas.

The mess

At two o'clock P.M., Ray arrived at the Canada room on time with his coffee and laptop. Mo Yun and Alan are already in the room and chatting.

Alan said hello to Ray when he saw Ray and said, "Ray, we really need your help this time !"

Ray sat down with a smile. "Of course, IT collaboration solutions help everyone. Mo Yun and Alan, let me talk about it ."

Mo Yan was very excited and jumped up from the Chair. "Ray, we know that you are an expert. I am troubled by the data and Excel files. I will tell you what happened first. Then, you tell me what we can do." Then he picked up the whiteboard pen and walked to the white wall to describe his thoughts.

"You see, adventure currently manufactures many different products, including ships, airplanes, engines, and electronic devices. The manufacturing of these products is distributed in different countries and factories. As the manufacturing department owner, I need to understand the operation of these factories and propose improvement requirements ." Mo Yu began to draw the global factory map of adventure on the whiteboard wall:

Adventure plant Map

"I get manufacturing data from these factories every month for analysis ." Mo Yu said.

Ray then raised a question: "Where are the differences between these manufacturing data? The data provided by each factory always has different requirements, right ?"

"That's right. The manufacturing data they provide varies according to the nature of factory manufacturing products. However, there are also data that all factories must provide, such as normal operation rates ." Mo Miao replied, "I have some template files for factory data, all of which are excel and PowerPoint. Do you need them ?"

"Well, send it to me. I need this ." Ray replied.

"Okay, Alan will send the template file to Ray after the meeting. Let me take a look at it, for example, Shenzhen electronics equipment assembly plant Sze (Shenzhen electronic )." Mo Yun thought very quickly and did not want to stop. "Sze is made of electronic devices, so their data will be different from aircraft and engine ."

Factory data

"Well, then, products, production lines, and components are ..." Ray asked.

"Okay, Alan. You can show Ray the Sze product ." Mo Yu said.

Alan is connected to the projection and displays several Sze products to give Ray a clear understanding.

Smart remote control vehicle-component

Smart remote control vehicles-Finished Products

"Then the digital logic analyzer ." Alan continues.

Digital Logic analyzer-finished product

Digital Logic analyzer-Screen

"Even the same product can be manufactured and assembled in different factories or in different production lines of the same factory ." Alan finally showed Ray the Sze production assembly line on the north line.

Sze north line production assembly line

"Very good, very clear ." Ray said, "So other factories are similar, except that different products and components are produced to provide manufacturing data corresponding to their products ?"

"That's right. Think about it. We have so much data every month, and it takes several days to sort and analyze it. It's too much trouble !" Mo Yu said.

"I have a few questions here. Then, I think we can start to discuss how to proceed. Of course, I can't do it by myself. When we figure it out, we will schedule people to execute it ." Ray said. At the same time, he secretly thought that it would be a miracle that a production line like the Sze north line could have a pass rate of over 90% of the first piece! :)