54,299 views
???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... ???? FREE SPREADSHEET: https://excelentejoao.com.br/wp-conte... How to Make a Product Sales Pricing Spreadsheet Free Spreadsheet to Download In this Excel video lesson, we will learn how to make a product pricing spreadsheet in Excel step by step from scratch with a practical example that can help you a lot in your day-to-day life and in the job market with Excel. 0:00 Explaining the Spreadsheet 2:59 Step by Step You can download the free Excel spreadsheet at the link above. The spreadsheet is free to download. The first part, where we will have all the fixed costs and variable costs of our company. As costs, we can understand, for example, electricity, water, gas, employee salaries, taxes and other expenses. The second part, composed of the sales pricing of the products. Here, we will be able to fill in each of the products we have, the brands of each product, the update date of each product, the unit cost of each product, the sales value of each product and the sales margin of each product. The spreadsheet is made up of two parts. Basically, the first part is where we will have all of our company's fixed and variable costs. As costs, we can understand, for example, electricity, water, gas, employee salaries, taxes and other expenses. In addition, in this first part of the Excel spreadsheet, we will be able to have information such as: Today's updated date, which will always be shown to you automatically. The total monthly cost. Monthly expenses. Daily expenses, considering the total number of days in the current month. And finally, we can still add some observations to our Excel table. The second part of the spreadsheet is made up of the sales pricing of the products. Here, we will be able to fill in each of the products we have, the brands of each product, the update date of each product, the unit cost of each product, the sales value of each product and the sales margin of each product. In addition to this information, we will also have access to the rate we should apply to each of the products so that we can distribute our total cost across each of the sales. This way, we can improve our profit and our margin. At the end of the table, we will have information on the final margin, that is, the margin considering the additional cost of the product, the additional rate of increase for each sale of the product. We will also have a final column with the gross profit. This way, we can have an idea of what the profit will be after the sale of each product. #ExcellentJoão #Excel #Dashboard