Use Excel's Data tables when you cannot decide which supplier is really cheaper with different prices and rebate structures.
Email questions to: learnaf@outlook.com
Full Course:
Access full course, including presentation, practice files and solved Excel file for P&L analysis: [ Ссылка ]
FP&A playlist: [ Ссылка ]
Take the poll: [ Ссылка ]
Looking for more personalized help?
Connect:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Subscribe: [ Ссылка ]
In this video, we perform a supplier cost analysis by comparing two vendors, who offer different price per Unit, but also different rebate structures. We will create an Excel model to automatically calculate the cost (less applicable rebate) at different purchased quantities. We will then turn this calculation into Excel's powerful Data Tables, which calculate for us at different points, what will be the cost, less rebate amounts, for each vendor.
We then convert this information into a nice visualization (a line chart) to show us the evolution of cost at increasing purchased quantities. The chart makes it very clear, what decision we should make at different purchase volume levels. This type of financial analysis is great if you are an FP&A analyst or an accounting and finance professional. You business team will thank you for the simplified analysis that helps them make the right financial decision for the company.
Course Alert:
If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyze and present the results of the variances to management and will be able to download solved variance calculation Excel templates. [ Ссылка ]
Videos you may like:
Learn sales and profitability analysis in detail here: [ Ссылка ]
Gross profit and gross profit margin explained: [ Ссылка ]
How calculate selling price and profits on Etsy: [ Ссылка ]
Standard Margin and Actual Margin - the Difference: [ Ссылка ]
How calculate selling price and profits on Etsy: [ Ссылка ]
Some Recommendations:
Are you a First Time or New Manager? Check this out: [ Ссылка ]
Learn pivot table data crunching business skills here: [ Ссылка ]
Learn all about Excel in one place: [ Ссылка ]
Learn what financial numbers really mean here: [ Ссылка ]
Accounting explained in 100 pages or Less: [ Ссылка ]
Note: At no extra cost to you, I may receive some commission if you purchase using the links above.
Although, we perform this analysis or cost less rebate comparison for only two vendors, but you can apply the lessons learnt to multiple vendors and multiple scenarios. This way for analysing information is synonymous to scenario analysis, but it helps you make a decision with much more concrete information.
Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.
