I consider my skill level with the Office Suite to be Advanced, but while I've been making efforts to demonstrate other skills I feel I haven't done enough to show work in more standard business skills. Here I'll compile a few problems I enjoyed working on in Excel.

Examples

Two Product Transportation Network

Here's a model for a company processing two products in its network of three plants, two warehouses and two customers. Transportation costs for each possible transfer are given as well as various constraints on demand, storage space and production rate. The optimal supply chain volumes are calculated.

Plant Selection

This model looks at a national company which has received customer orders at various bid prices in multiple cities. Since the company has a large production network they wish to minimize shipping costs while satisfying all customer orders. The optimal production plants are calculated to allow for the maximum profit while satisfying all customer orders.

Vendor Selection

Here a university is choosing computers from various vendors seeking to minimize total cost while acquiring all that they need. They have to take into account vendor constraints and prices. Here they arrive at the optimal vendor selection and order amounts.

5 Job Sequence

I chose some of the nicer easier to understand samples so far, so here's one on job shop scheduling. It iterates a heuristic to calculate optimal job configuration.

I hope these work samples were fun to look over, there are a lot more I left out which weren't as friendly looking. For my degree, among other tools, I used Excel to solve assignments and projects for three years.