USE SPREADSHEET GIVEN TO SOLVE ANSWER/FILL IN SPREADSHEET.(SCREENSHOT PROVIDED)

Newmarket International Manufacturing Company (NIMCO) was founded by Marcia Blakely only two years after leaving graduate school. Her knowledge of mass customization was the driving force behind starting NIMCO. The company produces three major custom products. Volume on the products is high even though each item is customized specifically for the customer. The products are processed through up to four different work centers. Even though each item is unique, the processing time at each work center is constant due to the sophisticated equipment used. Todays Opportunity Joe Barnes has just left the staffing meeting. The information you provided was quite helpful, and he believes he has adequate resources to accomplish the required manufacturing for the second quarter. Effective capacity levels (including regular time and planned overtime) for each work center are shown here, as is the amount of time required for each product at each work center. The demand forecasts for each product are also shown.

Effective Weekly Capacity Levels
Work Center 1			Work Center 2			Work Center 3			Work Center 4
920	hours		740	hours		920	hours		725	hours

Product Standard Time by Work Center
Product		Standard Hours at Works Center 1		Standard Hours at Works Center 2		Standard Hours at Works Center 3		Standard Hours at Works Center 4		Total Standard Time (Hours)
A		0.06				0.14		0.04		0.24
B		0.15		0.13				0.10		0.38
C		0.03		0.08		0.12		0.06		0.29

Quarter 2 Demand Forecasts
Week		Demand for Product A		Demand for Product B		Demand for Product C			Week		Demand for Product A		Demand for Product A		Demand for Product C
14		3600		4000		2000			21		4300		3600		3000
15		4000		4000		2500			22		4000		3600		3000
16		4300		4000		2800			23		4000		3800		2800
17		4400		3800		3100			24		3600		3800		2800
18		4500		3800		3200			25		3200		3800		2600
19		4500		3800		3200			26		3000		4000		2600
20		4400		3600		3200

QUESTIONS: (solve answers with the spreadsheet given)

1. Joe now needs a rough-cut capacity check to determine whether the capacity at each work center is adequate to support the expected demand. Using the forecasted demand as your proposed master schedule, calculate the load profile for each work center for each week of the second quarter. Highlight any weeks in which problems might occur.

2. Joe knows from past experience that he has some flexibility in his workforce. Therefore as long as the total capacity needed does not exceed the total available, the master schedule should be feasible. He also knows that he can increase his capacity total an additional 2.5% through extra overtime and still be within his budget. Given this new information, what recommendations do you have for Joe? What weeks are likely to be problems, and how should he use the capacity in those weeks? How important to NIMCO is it to have a flexible workforce?

Newmarket Case XLSX File Edit View Insert View Insert Format Data Tools Help Share Last edit was seconds ago 100% $ % .0 .00 123 Default (Ca... 11 B I . A S. ES Etli IED Dav - fx F G H 1 J K L M N O Q R Week Center 1 Center 2 Center 3 Center 4 Total 14 876 680 744 664 2964 3205 15 16 3364 17 3399 18 3452 19 3452 20 3352 21 3270 22 3198 23 3216 24 3120 25 2966 26 2994 ME Case Expl e here to search O BI 48F ^ () o 1 To 1x CA