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

MIS excel project - Assignment ExampleAdditionally the total quantity of stock is calculated.The gross sales sheet of paper provides data on sales of the items in stock by the respective customers. The sales argon recorded and the total sales are also calculated. The sheet also stores details of the respective customers. The panorama up function is used in the item column to march the item with its principle 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,Table1Code,Table1Selling 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 stocky 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 expectant financing sheet. In this sheet, the total capital required to establish the business is estimated. A list of manageable financing options is also provided together with the percentage of financing. Additionally, the interest rate and the amount to be repaid is