3024-Chap4 - 4. WORKING WITH MULTIPLE WORKSHEETS AND...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
4. WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS IN EXCEL As we saw in the last chapter, worksheets are used in xcel to enter and manipulate lists Excel to enter and manipulate lists. When we have a set of lists (or other data) to work with, it often easier to work with the data if we use a separate is often easier to work with the data if we use a separate worksheet for each list. In such case, we need to know how to work with multiple worksheets within the same workbook. 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
dditionally we often eed share data between Additionally, we often need to share data between multiple workbooks to solve some problem. Thus, we also need to know how to work with multiple workbooks at the same time. In this section, we’ll see how these activities can be performed using Excel. his will again be done in the context of a single This will again be done in the context of a single problem scenario, using four Excel files. 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 2
Background image of page 2
4.1 Capacity Planning at AnJoCa Corporation AnJoCa Corporation manufactures 3 different products. The master production schedule (MPS) specifies the quantity of each item to make each month, for the next eight months. This information is maintained in the Excel workbook MPS.xlsx (also referred to as the MPS workbook). The date on the MPS table refers to period 1. 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2010 John P. Shewchuk ISE 3024 Course Notes 4 – 4
Background image of page 4
o determine how much manpower (capacity) is To determine how much manpower (capacity) is required to make the products per the MPS , the capacity bills method is used. For each product, the bill-of-capacity shows the hours needed, in each workcenter , to make one item. This ata is stored in the Excel workbook APBILLS xlsx data is stored in the Excel workbook CAPBILLS.xlsx . 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
he apacity planner ses PS nd APBILLS ata for The capacity planner uses MPS and CAPBILLS data for capacity planning, i.e., to determine how many hours to run each workcenter each period. The planner records this information in the xcel workbook Excel workbook WORKPLAN.xlsx . 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 6
Background image of page 6
o perform the necessary calculations a separate To perform the necessary calculations, a separate workbook, CAPACITY.xlsx , is used. This workbook shows • the capacity required for given MPS and CAPBILLS data, and • the capacity differential (i.e., how much capacity xtra or short) if a given work plan is then used extra or short) if a given work plan is then used, as shown on the following page. 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
MPS Capacity Bill 00 00 Capacity Available MPS CAPBILLS WORKPLAN 1 2 A2 0 4 0 B3 0 5 100 200 A 0.5 0.8 B 0.1 - 1 2 100 40.0 80.0 200 40.0 40.0 C 10 50 C 1.2 0.4 APACITY Required Capacity Capacity CAPACITY 1 2 100 25.0 80.5 200 20.0 52.0 1 2 100 +15 -0.5 200 +20 -12.0 2010 John P. Shewchuk ISE 3024 Course Notes 4 – 8
Background image of page 8
s a new Industrial Engineer at nJoCa you have
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 49

3024-Chap4 - 4. WORKING WITH MULTIPLE WORKSHEETS AND...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online