From the course: Excel: Business Process Analysis
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Determine capacity given a specific batch size
From the course: Excel: Business Process Analysis
Determine capacity given a specific batch size
- [Instructor] Many manufacturers make multiple versions of the same product. Perhaps changing the flavor of ice cream, or making different colors of an item. Because they need to change from one product to another, companies will divide production into batches. In this movie I'll describe how to calculate the capacity of a process, given various constraints. My sample file is the Capacity Given Batch Size Workbook, and you can find it in the Chapter 3 folder of the Exercise Files Collection. This workbook contains all of the information we need to know, and those are the three items in B3 through B5. The first is the batch size. That's the number of units it will make before needing to reset the machine. Setup time, is how long it takes to reset the machine. So for example, if we need to do any cleaning or we need to replace any consumable parts, that would be part of setup time. And finally, there is the processing time per unit. Here given in hours, as is the setup time. So we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.