Now you are supposed to use one of non-routine experimentation skill to work on this assignment as follows: Suppose your boss gives you an excel file ( see the attachment), and ask you to fill in the blanks to the cells with pink highlights 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.

Leave a Reply

Your email address will not be published. Required fields are marked *