MIS {excel project } Assignment Example | Topics and Well Written Essays - 500 words

MIS {excel project } - Assignment Example Additionally; the total quantity of stock is calculated. The sales sheet provides data on sales of the items in stock by the respective customers. The sales are recorded and the total sales are also calculated. The sheet also stores details of the respective customers. The look up function is used in the item column to march the item with its code in the products sheet: =LOOKUP (H4, Products!$A$3:$A$13,Products!$B$3:$B$13). The look up function is also used to determine the price of each item: =LOOKUP ([@[Item Code]],Table1[Code],Table1[Selling Price]). It is in this sheet that the total sales are also calculated and the data sorted according to item code in ascending order. A pivot table called sales summary is generated from the sales sheet. In this sheet, the summary of sales of each item is displayed. The total sales of each item and all the items are totalled. A graph is then generated showing the quantity of items sold. Capital financing analysis is done on the capital financing sheet. In this sheet, the total capital required to establish the business is estimated. A list of possible financing options is also provided together with the percentage of financing. Additionally, the interest rate and the amount to be repaid is