IIEWAE("E-Way") Analysis

Collection of files

This folder consists of incoming inventory, assets, updates and new releases

These excel sheets will show how the inventory for the company has been updated. They also display the ROI and current sales of that time.

There are calculations for the current and future market of what woudl be best for the inventory. The actions would result in more exposure, but a financial loss in the short term.

Bought Inventory

The bought inventory updates shows what inventory is left over and which size of consumer is buying what by color and type of clothes.

Along with that, there are is the aspect of the change of brand and loss of COGS to get more recognition. This will result in even more hoodies and future products to be sold.

With the new collection, I have decided to display the overall COGS, planned for the sizes based from the previous collection and calculate the margins compared to the general retail profit margins of 36-39% in Q4 2021 and Q1 of 2022.

To compensate for that, I have decided to combine the jogger pants and hoodie together to get a median ROI and better margin that the customer would like too. It is cheaper than a usual jogger set and works with style and price. This resulted in an overall COGS and price point that works for both sides.