I have an independent insurance business, and would like excel spreadsheets built out showing production count and premium amount for each insurance carrier I use on a monthly and annual basis. With this information I can compare which carriers I'm using more than others as well as peak/slow months of production. For example, Sally's Clothing Co. sells four shirt brands at different price points, 5 shoe brands at different price points and 6 shorts brands at different price points. Sally wants to know how many of each brand she sold, total revenue for each brand and total revenue for each type of inventory. Brand A sold 80 shirts for a total of $2000, 60 shoes for a total of $1500 and 25 shorts for a total of $200. I imagine this info would be set up on 13 tabs labeled for each month and the last tab would populate annual totals. Maybe a 14th tab showing plot graphs and line graphs. One last kicker - I have to pay a parent company 20% on commissions up to the first $85k of each month. After $85k I make 100%. It would be nice to incorporate this for more accurate results.
30 freelance font une offre moyenne de $187 pour ce travail
Hello, I am good at excel and able to deliver quality work. Let's discuss more details over chat. Best regards, Hoang Relevant Skills and Experience Excel Proposed Milestones $100 USD - Excel work