Gross margin and sales projection excel file and brief explanation
Create a gross margin and sales projection on Excel file for an online fashion store that sells only blazers- include brief explanation of the excel file. Sales projection will be for 5 years (starting from year 2020) The selling price of the blazer is 600 euros The production cost of one blazer is of 70 euros per unit. Cost of materials: fabrics= 4.90 euros the meter (you need 2 meters for 1 blazer) , lining fabric=1.30 euros for 1meter (you need 1meter40 for one blazer) You can estimate all the rest of the data and have to include marketing costs, influencers and celebrity endorsement costs, digital campaigns and social media costs, model costs for photoshoots, photoshoot costs and any other data that seems important. Please note that this is a start-up online fashion store- there is no physical store- costs and projections have to be realistic.
Leave a Reply
Want to join the discussion?Feel free to contribute!