Retail Planning Part 1

Published on Saturday, October 28, 2017

Retail Planning Application

I have decide that just showing how I am doing the functional exercises would be a little boring. Instead I am going to build an application from the beginning using what I have learned from the Functional Programming in C# book. The application I will work on is a convertion of an Windows application into a web application, at the same time I will open source the code around it. The goal of these excersizes is to create a planning structure capable of handling multiple stores, regions and years, similar to the programs I executed originally for companies like Hot Topic

Domain Description

This application is a planning system for retailers. In this case it for brick and morter stores more than for web based retilers. The data set is rather interesting in that there are several hierarchies of data.

There is a date based one, this a fairly shallow typically.

Example:

Year
Season (Spring, Fall)
Month

The product base hierarchy can be faily deep or not depending on the retailer.

Example:

Company
Division (Men's, Women's)
Category
Class (Pant, Tops, Accessories)
Subclass (Socks, Ties, Belts)

The last hierarchy is the store based, again this depends on the retailer.

Example:

Company
Region
District
Store

For MVP of this site we all be doing a minimuin set of variables for planning. Those will be

Beginning of Period Inventory
Sales
Last Year Sales (Actual)
Markdowns
Receipts
Shrinkage
End of Period Inventory

Some architecture decisions

For this I am going to use some library and tools that I have been wanted to learn more about. For the web api I am using ASP.NET MVC Core. For the database, I am going to use Marten with Postgres.

comments powered by Disqus