Financial Spreadsheet and WSSI

I used Microsoft Excel to create my financial spreadsheet and WSSI.

I firstly had to figure out my quantities,  how many garments per size I wanted to order. With Miss Selfridge ranging from size 4-16 I wanted to make sure I covered all sizes. I also decided that my range would just go into the 'top 8' stores, the flagship A grade stores.

I also calculated my shipping costs for each of dresses, tops, shorts, skirts and jackets.

I then calculated what my cost price would be using the formula: RRP - VAT (20%) divided by 2.5.

This information all went into my financial spreadsheet along with other information about COO, fabric  etc.

With my range going in two phases, the first on the 10th March 2014 and then 8 weeks later on the 12th May. I worked out my forecasted sales in my WSSI and specified when there would intake of stock, which will be on week 4 of 16 units (each store having 2 units per garment), halfway through the 8 weeks of selling time.