80.2K

Verified Solution

Link Copied!

Several years ago, Roberson Robotics outsourced component BF-365, a key component of many of its products. At the time, CFO Sam Summers concluded that outsourcing was the correct decision, but she decided to revisit that decision after overhearing some conversations on the factory floor and in the cafeteria. Based on these conversations, she has gathered information about the materials quantity variance for the part, as well as on-time delivery information of the part from the supplier and on-time delivery of the finished products to customers. Roberson Robotics uses a just-in-time inventory system, so it receives multiple shipments of BF-365 each day. Summers has asked you to examine the data and provide insights about the continued desirability of outsourcing component BF-365 .

Required:

1. 1. Prepare a scatterplot of late deliveries from the supplier over time and a scatterplot of missed customer delivery dates over time. What do you learn from these graphs?
   2. Calculate the percentage of late deliveries from the supplier and the percentage of missed customer delivery dates.
   3. Calculate the proportion of unfavorable materials quantity variances. How has the proportion of favorable to unfavorable variances changed over time? What do you infer about the quality of the outsourced component BF-365?

What other information would you like to examine before providing your insights about the outsourcing decision to Summers?

DATA

Week	BF-365 QuantityVariance
1	$ 1,704	F
2	$ 1,188	U
3	$ 1,999	F
4	$ 1,814	F
5	$ 1,743	F
6	$ 1,153	F
7	$ 1,101	U
8	$ 1,162	U
9	$ 208	F
10	$ 647	U
11	$ 1,511	F
12	$ 812	F
13	$ 1,090	F
14	$ 545	U
15	$ 793	F
16	$ 555	F
17	$ 1,253	U
18	$ 1,641	F
19	$ 1,157	F
20	$ 1,668	U
21	$ 933	F
22	$ 64	F
23	$ 1,075	U
24	$ 492	F
25	$ 497	F
26	$ 1,058	U
27	$ 1,502	U
28	$ 443	U
29	$ 1,216	F
30	$ 325	U
31	$ 1,801	F
32	$ 1,035	F
33	$ 653	F
34	$ 301	U
35	$ 320	F
36	$ 1,834	F
37	$ 610	F
38	$ 567	U
39	$ 198	F
40	$ 1,909	F
41	$ 756	U
42	$ 774	F
43	$ 1,272	U
44	$ 847	F
45	$ 626	U
46	$ 1,921	U
47	$ 1,229	F
48	$ 354	U
49	$ 413	F
50	$ 59	F
51	$ 183	F
52	$ 1,305	F
53	$ 898	U
54	$ 1,066	U
55	$ 627	F
56	$ 963	F
57	$ 602	F
58	$ 1,949	U
59	$ 826	F
60	$ 328	U
61	$ 1,074	U
62	$ 1,827	F
63	$ 1,379	U
64	$ 201	F
65	$ 444	U
66	$ 1,474	U
67	$ 1,127	U
68	$ 993	F
69	$ 196	U
70	$ 1,158	F
71	$ 92	F
72	$ 1,296	U
73	$ 1,800	F
74	$ 649	F
75	$ 388	F
76	$ 340	F
77	$ 1,858	U
78	$ 668	U
79	$ 270	F
80	$ 1,602	U
81	$ 1,092	U
82	$ 1,533	F
83	$ 1,996	F
84	$ 1,453	U
85	$ 452	U
86	$ 1,966	F
87	$ 1,622	U
88	$ 1,803	U
89	$ 1,930	U
90	$ 691	U
91	$ 366	U
92	$ 1,479	F
93	$ 1,076	U
94	$ 1,286	U
95	$ 1,176	U
96	$ 464	F
97	$ 935	U
98	$ 1,993	U
99	$ 61	U
100	$ 725	U
101	$ 1,154	U
102	$ 334	U
103	$ 1,303	U
104	$ 1,010	U

Week	Total number of BF-365 shipments received	Number of late BF-365 shipments	Total number of customer shipments	Number of missed customer delivery dates
1	34	5	138	1
2	15	6	169	2
3	22	3	183	7
4	10	4	108	2
5	23	5	60	8
6	30	2	132	1
7	10	4	25	4
8	35	3	47	5
9	33	0	118	3
10	37	6	109	5
11	32	0	32	8
12	19	2	149	5
13	24	6	125	5
14	23	0	29	7
15	23	2	169	0
16	21	6	98	4
17	33	0	188	3
18	38	0	152	5
19	25	6	161	0
20	32	4	135	0
21	17	5	106	6
22	37	4	163	0
23	11	3	64	5
24	22	2	167	1
25	38	5	183	3
26	11	2	37	5
27	16	4	28	3
28	17	5	172	6
29	16	5	152	0
30	26	5	139	8
31	23	1	164	4
32	18	2	114	3
33	33	0	146	8
34	31	6	166	8
35	26	5	170	5
36	15	5	168	0
37	11	3	81	7
38	19	2	171	3
39	12	5	25	6
40	10	0	48	7
41	28	6	115	1
42	13	3	90	6
43	32	3	138	4
44	36	4	151	6
45	30	4	53	7
46	17	3	86	6
47	28	2	132	8
48	16	6	146	5
49	14	6	25	6
50	26	2	200	3
51	16	0	167	1
52	15	1	190	8
53	34	0	100	3
54	39	4	91	4
55	19	3	83	3
56	14	1	171	3
57	13	4	46	8
58	25	5	46	7
59	30	5	153	5
60	36	0	108	7
61	22	2	116	8
62	18	6	92	6
63	32	4	135	5
64	30	5	141	3
65	10	0	70	2
66	36	0	54	4
67	13	4	169	2
68	40	2	80	8
69	18	3	110	3
70	37	3	178	6
71	36	2	146	2
72	38	9	132	1
73	19	3	112	0
74	10	6	111	3
75	30	5	132	3
76	36	9	70	0
77	22	12	109	3
78	18	12	20	2
79	17	8	100	0
80	35	8	129	7
81	10	4	68	6
82	39	11	157	6
83	27	9	31	7
84	21	7	117	6
85	33	6	83	2
86	34	5	162	12
87	12	3	113	10
88	17	6	161	20
89	10	4	148	7
90	34	12	55	6
91	24	8	28	18
92	15	4	112	19
93	34	11	160	7
94	25	4	85	15
95	23	9	36	19
96	17	4	34	15
97	34	8	186	8
98	26	10	196	15
99	25	10	148	20
100	32	12	102	9
101	35	10	29	10
102	24	12	63	4
103	19	12	30	12
104	30	14	133	20

Answer & Explanation Solved by verified expert

See Answer