StudentShare
Search
Free

# MIS {excel project } - Assignment Example

Summary
The business plans to invest \$100,000 to purchase the items and carry out advertising. The source of the capital is from government grants,…

## Extract of sample "MIS {excel project }"

Number: MIS Excel project The project is an analysis and decision tool for Capital electronics a business start-up that deals with retail sale of electronics. The business plans to invest \$100,000 to purchase the items and carry out advertising. The source of the capital is from government grants, business loan and personal savings. The business loan and the Government grants will be repaid in a period of two years at an interest rate of 8 and 1.4 % respectively.
The tool is made of six worksheets named products, sales, summary of sales, quantity of sold items, Cash flow and capital financing. The sheets contain different data and information.
The excel project keeps records of all the items that are sold in the business in a sheet called Products.
It allows one to add new items and the quantity together with the buying price. The selling price is then calculated by using a profit margin of 1.3 %. 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 calculated.
The cash flow sheet analyses the net income for the business from sales and after deductions of the expenditures such as loan interests and advertisements. Read More
Cite this document
• APA
• MLA
• CHICAGO
(“MIS {excel project } Assignment Example | Topics and Well Written Essays - 500 words”, n.d.)
(MIS {excel Project } Assignment Example | Topics and Well Written Essays - 500 Words)
https://studentshare.org/management/1637184-mis-excel-project.
“MIS {excel Project } Assignment Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/management/1637184-mis-excel-project.
Click to create a comment or rate a document

## CHECK THESE SAMPLES OF MIS {excel project }

### Excel Project

...from that, the rest of the companies reported the positive returns in the given time frame. Results One basis of the results computed on the Microsoft Excel sheet along with the graphs, the analysis of 120 trading days’ activity clearly reflects that SAP performed remarkably well earning a gain of around \$90,000, whereas Microsoft turned out to be the worst among all five participants reporting a net loss of around \$55,000. The other three software designing firms produced mediocre results, presenting net gains \$15,000, \$9,000 and ?12,000 by oracle, Intuit and Sage respectively. Source Yahoo! Finance was used as the data source from the stock price data was retrieved. The reason for choosing this financial database is...
6 Pages(1500 words)Essay

### MIS Project

...MIS Project: My Digital Shelf Business The project is an online bookstore, called Lib Cafe, which will allow the clients, trade directly used books without using traditional brick and mortar bookstores. The sellers will be able to receive more for their books while the buyer will also pay less. On top of books, the clients can also sell used CDs, accessories, computers, class notes, tutoring services, old tests, and other products. The site also seeks to offer professional evaluations, classifieds, retail, and specialized content. Business Plan Mission/Vision The Lib Cafe’s mission involves the provisions of a unique and valuable source of information, services, and products for the...
4 Pages(1000 words)Essay

### Risk Management (article Critique)

..., developing & re-engineering business processes. CITS judged the process inefficiency and ineffectiveness due to excel sheets based transactions and decided to implement a database system with web enabled front-end. CITS worked towards two different options of achieving the MIS system - procuring a ready to deploy software and in-house development of the MIS software from scratch. After assessment of pros & cons and the cost benefit analysis CITS decided to develop the MIS system in-house. However, this decision caused trouble times due to attrition of key people and lack of specialists. The project was finally completed with the help of final year...
4 Pages(1000 words)Case Study

### Excel Project

...grains & cereals showed an increase in 2005, its sales performance decreased in 2006. Graphic Recommendation It is recommended that the company shall focus on the top 5 performing product categories. A more focused and less diverse product portfolio would make the company more efficient and effective. The top 5 performing categories are the sales generating and revenue drivers of the company. The other products that do not perform are becoming more of a liability than an asset to the company. SELF ASSESSMENT From completing the Excel project, I learned the advantage of organizing the data before doing any analysis. Organizing the data makes it easier to read. Applying formats would make it even more...
3 Pages(750 words)Essay

### MIS

... 09 February MIS: It remains an acclaimed reality that globalization is such an amazingly powerful phenomenon which is rapidly changing the world and profoundly influences one’s career and life in the long term. Globalization has made the word smaller due to which now it can be described in terms of a global village. People from all over the globe can rapidly get in touch with each other due to which important strategies can be accomplished in a little time with the help of people having world-class skills residing in countries thousands of miles away. According to (Friedman), globalization has entered a whole new phase and this reality can be judged from the speed with which technology is connecting different countries in a way... 09...
2 Pages(500 words)Essay

### MIS

... The DFD above shows about 5 or more processes, although formally, there is no limit. The same data store or another external entity may be shown more than once for instance customer as long as it clearly indicates the flow of data. This is feasible because the DFD does not attempt to show time dependency of data flows. The data flow diagram may be applicable in many organisations and especially so the corporate firms. It clearly indicates the processes within a business entity when an employee is involved with either a client/customer or a supplier. In the diagram the main entities are customer, supplier and the accounts clerk. One is able to follow through the procedure where the supply supplies the business goods... The DFD above shows...
1 Pages(250 words)Assignment

### Database Management system project (MIS)

...Number: Lecturer: Database Management system project (MIS) This report documents the development of a database system using Access. A database management system is essential for the safe storage, processing, retrieval and analysis of organizational data. The paper documents the development of an airline company database. The first part of the report will document the analysis of the business case to identify data management and processing issues and challenges facing the organization. The second part documents the design of a solution that includes the database strategy to define the business rules that govern the relationship between entities and a data dictionary. With the help of an entity relation...
10 Pages(2500 words)Assignment

### Excel

...INFS 3100 EXCEL ASSIGNMENT DUE: Wednesday, February 11 (beginning After 12:50 pm the assignment is considered a day late. See syllabus for late policy. Helpful Hint: Don’t forget to “Lock Cells” (Use absolute cell references) as needed when doing calculations for this assignment. Instructions: (use formulas or functions unless otherwise noted) 1. Download and open the template found on D2L. (Filename: 3100 Excel Assignment 1 Outline Spring 2015) 2. Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” Cell. 3. Set the value of January “Production” equal to the “Initial Production” Cell. 4. Set the value of January “Units Sold” equal to the “Initial Units Sold” Cell. 5. Management predicts... “Not...
1 Pages(250 words)Assignment

### Excel

.../1/2019 35.0000 1/1/2020 1,135.00 Price of Bond = c × F ×  1 − (1 + r)-t + F r (1 + r)t Present Value of Interest Payments = c × F ×  1 − (1 + r)-t r Present Value of Face Value of Bond = If the r is the interest rate prevailing in the market, c is the coupon rate on the bond, t is the time periods occurring over the term of the bond and F is the face value of the bond, the present value of interest payments is calculated using this formula. References Epmc, Inc. (2013). Project portfolio management a view from the management trenches. Hoboken, N.J., Wiley. http://rbdigital.oneclickdigital.com. Treynor Jack L., (1965)."How to Rate Management of Investment Funds", Harvard Kan, R. and Zhang, C. (1999),...
11 Pages(2750 words)Essay

### MIS

...and communication skills aimed at articulating business needs. Emphasis is much more on the systems knowledge Skills required include: analytical, design and problem-solving which are geared towards supporting the business performance (Vongsavanh, 2008) c. Skills and personal traits of a successful business analyst. Analytical skills, Vast experience in organizational concepts, Good communication skills Part 2. Need of system Project planning Requirements of User Design of System Feedback System definition phase entail the application of management statements of the needs of the system so as to...
2 Pages(500 words)Assignment