﻿ Management Excel Videos
Welcome

# Management Excel

• 26:20

### California Dreaming: Production Facility Expansion in Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-pDIn this video I walk you though how to set up and solve a binary integer programming (BIP) problem in Microsoft Excel using the Solver Add-In.

• 20:52

### Monster Machines, Inc: Product Logistics using Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-lHIn this video I walk you though how to set up and solve a logistics problem in Microsoft Excel using the Solver Add-In. The goal is to utilize

• 24:26

### Deliver2You: Product Logistics and Distribution using Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-niIn this video I walk you though how to set up and solve a logistics problem in Microsoft Excel using the Solver Add-In. The goal is to utilize

• 22:13

### JIT Corporation: Panicked Product Development in Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-otIn this video I walk you though how to set up and solve a shortest-time-to-completion problem in Microsoft Excel using the Solver Add-In. JIT

• 25:40

### Call Center Staffing and Cost Reduction using Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-jeIn this video I walk you though how to set up and solve a simple staffing / cost reduction problem in Microsoft Excel using the Solver Add-In.

• 17:02

### Penn Interest: Cash Flow Modeling Using Excel (Part 3: Problem Solution)

Penn Interest: Cash Flow Modeling Using Excel (Part 3: Problem Solution)The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-mCIn this video I walk you though how to set up and solve a cash flow pr

• 28:16

### Fortunate Graduate: Car Purchase Cost Minimization in Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-o7In this video I walk you though how to set up and solve a cost minimization problem in Microsoft Excel using the Solver Add-In. A recent high

• 24:21

### Trumped-Up Development: Investment Capital Allocation using Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-koIn this video I walk you though how to set up and solve a simple capital allocation problem in Microsoft Excel using the Solver Add-In. The go

• 25:07

### Penn Interest: Cash Flow Modeling Using Excel (Part 2: Problem Setup)

Penn Interest: Cash Flow Modeling Using Excel (Part 2: Problem Setup)The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-mCIn this video I walk you though how to set up and solve a cash flow probl

• 23:14

### Super Troopers: Shortest Route Problem in Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-o1In this video I walk you though how to set up and solve a shortest route problem in Microsoft Excel using the Solver Add-In. The Dance Barn ca

• 32:08

### Sugar High Grain: Advertising Mix Using Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-kVIn this video I walk you though how to set up and solve a simple advertising mix problem in Microsoft Excel using the Solver Add-In. The goal

• 12:25

### Penn Interest: Cash Flow Modeling Using Excel (Part 1: Problem Summary)

Penn Interest: Cash Flow Modeling Using Excel (Part 1: Problem Summary)The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-mCIn this video I walk you though how to set up and solve a cash flow pro

• 21:03

### Merrari Motors: Auto Part Distribution (EXPANDED) Network Maximization

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-nTWe were not happy with the distribution network capacity in our first Merrari Motors problem. Therefore we expanded our network to include 4 m

• 22:48