Blog

Trumped-Up Development: Investment Capital Allocation using Excel

Trumped-Up Development: Investment Capital Allocation using Excel

In 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 goal is to allocate the firm’s capital in a fashion which maximizes the investment’s net present value while adhering to cumulative capital limits within the firm. The post Trumped-UpRead more about Trumped-Up Development: Investment Capital Allocation using Excel[…]

Monster Machines, Inc: Product Logistics using Excel

Monster Machines, Inc: Product Logistics using Excel

In 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 the firm’s shipping lanes in a manner that minimizes shipping costs while meeting customer demand and utilizing full production capacity. The post Monster Machines, Inc: Product LogisticsRead more about Monster Machines, Inc: Product Logistics using Excel[…]

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

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

In this video I walk you though how to set up and solve a cash flow problem in Microsoft Excel using the Solver Add-In. The goal is to manage Penn Interest’s cash flow during an economic downturn. To meet it’s cash flow needs, the business must borrow funds from it’s bank, JK Moregain. Our goalsRead more about Penn Interest: Cash Flow Modeling Using Excel (Part 1: Problem Summary)[…]

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

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

In this video I walk you though how to set up and solve a cash flow problem in Microsoft Excel using the Solver Add-In. The goal is to manage Penn Interest’s cash flow during an economic downturn. To meet it’s cash flow needs, the business must borrow funds from it’s bank, JK Moregain. Our goalsRead more about Penn Interest: Cash Flow Modeling Using Excel (Part 2: Problem Setup)[…]

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

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

In this video I walk you though how to set up and solve a cash flow problem in Microsoft Excel using the Solver Add-In. The goal is to manage Penn Interest’s cash flow during an economic downturn. To meet it’s cash flow needs, the business must borrow funds from it’s bank, JK Moregain. Our goalsRead more about Penn Interest: Cash Flow Modeling Using Excel (Part 3: Problem Solution)[…]

Deliver2You: Product Logistics and Distribution using Excel

Deliver2You: Product Logistics and Distribution using Excel

In 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 the firm’s shipping lanes in a manner that minimizes shipping costs while meeting warehouse demand. However, the shipping arcs in this problem carry capacity constraints. Some productRead more about Deliver2You: Product Logistics and Distribution using Excel[…]

Merrari Motors: Auto Part Distribution Network Maximization in Excel

Merrari Motors: Auto Part Distribution Network Maximization in Excel

In 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 the firm’s shipping lanes in a manner that MAXIMIZES the amount of product that can be shipped given intrinsic constraints within the network’s capacity. The post MerrariRead more about Merrari Motors: Auto Part Distribution Network Maximization in Excel[…]