Hello,
I was given the following financial task in excel.
To be honest i tried to solve it, but i would appreciate some help from your side in order to be sure.
Please see attached excel file.
1. Please add a column in "Sales analysis" in order to calculate the gross profit of each product code based on the cost per unit in sheet "Avg cost"
2. With the use of a formula please calculate the total sales of segment "Foundry" of all companies in the highlighted cell C5
3. Please create a pivot table in a new sheet which gives the revenue and gross profit figures of all Business Units per Segment.
Bookmarks