Question-   Assignment on A1 Windows

Solution-

Answer

A1 Windows is a small company located in the GTA. The company employs 60 employees in its one location. The company competes based on reasonable prices, competitive delivery times and aims to ship all orders within two weeks. Orders are sent to small building companies for new homes as well as some orders to retrofit entire houses. The Operations Manager is very concerned about the increasing problem with rejected products found during the manufacturing operation. You have been asked to help review and analyze the quality data for A1. Process Overview: There are three assembly areas where employees and machines assemble production runs of various orders of windows. There is always one inspector in each area who performs 100% inspection, and another employee who packages the products and loads them onto skids for delivery to customer’s facility or job site. Each order may contain as few as six items, or for a larger customer, up to 60 items. It is important that each order is shipped complete or a separate truck may have to be dispatched with the missing item(s). This happens all too often and adds extra cost and rushing. Currently, products that are found faulty by each of the inspectors are to be sent to a special team of 2 employees, in the repair department. These employees are responsible to evaluate, repair and document their work. Some product cannot be repaired and is designated as “scrap” and sent to the garbage. The remainder is repaired. Often product needs to be repaired right away so the entire order is not delayed. There is a constant supply of products waiting to be evaluated by the repair team. Scheduling the work in this department and the number of “rush” jobs is problematic. Components to assemble the windows are received in large quantities from Canadian and American suppliers. After inspection and storage, quantities for one day's production are sent directly to the different production areas, every night for the next day's production. Goods that do not pass receiving inspection are held, and sent back to suppliers. There is a backlog of goods waiting to be returned to suppliers. Frequently, a product is returned from the customer due to an error in the dimension of a product or a poor fit, or a missed defect. This becomes a priority to replace, as it can hold up an entire installation. 1. Open an EXCEL document. Complete a Pareto Table and graph. Remember to identify your charts/graphs- Main Titles, X-Axis and Y-Axis. 2. Choose the top two defects from your Pareto analysis. For each one of these, produce a run (line) chart. Have the x axis with the days of the month, and the y axis with the number of times that defect occured. This will give you information about the occurance of each of those two defects. 3. Insert a text box. In the text box give your top two recommendations to A1 Windows on how to improve their quality performance. Use a maximum of two paragraphs.

January Quality Data

Date

Colour

Edge

Label

Glass

Latch

Glue

Trim

Scratch

2

1

1

1

 

1

2

1

3

3

3

 

1

3

  

2

2

4

2

2

2

2

2

2

2

2

5

4

4

 

1

    

6

   

2

    

9

2

2

2

4

2

1

2

2

10

  

1

3

    

11

   

5

    

12

1

2

 

2

   

1

13

2

  

3

 

1

 

2

16

 

2

2

3

2

   

17

1

4

 

5

3

 

2

 

18

3

3

 

3

 

1

 

1

19

 

2

 

4

    

20

 

3

 

2

2

1

1

 

23

1

4

 

1

1

1

1

1

24

        

25

 

2

1

3

   

2

26

 

1

 

1

2

 

2

 

27

2

3

1

2

1

 

2

2

Explanations

Colour - the aluminum can have an inconsistent colour

Edge - often an edge has not been properly finished, can be shap

Label - incorrect placement results in item being rejected

Glass - can be a bad spot causing an inconsistent looking

Latch - the locking mechanism may not be level, or could be defective

Glue - sometimes there is glue where it should not be, hard to remove

Trim - often glue does not hold the trim down tightly Scratch - the paint has a scratch, cannot be sold that way

Click here to download the complete solution

Our happy customers

They are fast in responding to homework questions. they have the best technical writers. Thanks for helping me with my programming doubts.

studentDyana
5  stars image

I contact to disklib for homework, they help me out, despite there was some technical issue they gone through extra mile for me and provide me good quality work in first priority. 100% recommended.

studying on laptopAsif Waheed
5  stars image

Desklib's study resources are best & unique. Their study database is easy to access and easy to use.
100 % recommended.

library and studentsMike Taylor
5  stars image