Now you are supposed to use one of non routine experimentation skill to work on this assignment as following:
Suppose your boss give you an excel file ( see the attachment), and ask you to
1) fill in the blanks to the cells with pink highlights
2) draw a column chart that shows the top five selling items based on annual sales
Hints: 1) You are only asked to write some simple functions according to the given information, for example, as a future business professional, you are supposed to know how to calculate the annual sales after you are given unit sales price and average unit sales (=unit sales price * average unit sales), you are supposed to know how to use functions to find the lowest annual sales, average, or highest annual sales , and Gross Margin Per Unit means the difference between unit sales price and unit cost.