StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

MIS {excel project } - Assignment Example

Cite this document
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,…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.1% of users find it useful
MIS {excel project }
Read Text Preview

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.)
Retrieved from https://studentshare.org/management/1637184-mis-excel-project
(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.
  • Cited: 0 times

CHECK THESE SAMPLES OF MIS {excel project }

Project Management Leadership

project Management Leadership project management entails making WBS.... hellip; For example, the matrix organization breakdown structure, using the excel file, shows that mason project manager Bush is responsible for reducing its 130 actual hours used in the concreting department.... Likewise, carpentry project manager Reagan must not evade his responsibility to diminish 145 hours utilized in the Framing department.... The same structure necessitates the carpentry project manager to avoid the same $ 2,900 labor cost in future activities....
3 Pages (750 words) Assignment

Risk Management (article Critique)

The project was finally completed with the help of final year students and an internal mentor who took the responsibility as part time assignment.... The project plan of CITS largely ignored these aspects of risk mitigation and hence faced serious obstructions to the project due to attrition of key people and reluctance of end users in the data entry process.... The documentation by CITS doesn't even include the project risk management part of the overall planning (Rodrigues....
4 Pages (1000 words) Case Study

Information Communication Technologies Strategies

The aim of this project is to design and implement a new improved management information system to serve Chelsea Hotel is owned by Crimson Hotels, which is a fast-growing hotel group, with properties in key locations in the UK, Portugal and UAE currently encompass a prototype management information system, however, its not as effective and efficient as it should be.... Furthermore, Management Information Systems enhance organization performance in numerous ways that will be discussed throughout further chapters of this project....
20 Pages (5000 words) Essay

The Basic Tools in Developing Project

This paper will discuss the basic tools like the AdPM, Gnatt charts, CPM, Pert, and SWOT and RISK analysis, which aid the project manager in organizing, sequencing and developing schedules.... hellip; The PMBOK is an essential tool for the success of any project.... Similarly, for LRH, to successfully participate in the trade show is a project in itself.... The first step involves initiating the project itself – recognizing the need to start or commit oneself to the project....
11 Pages (2750 words) Essay

Westar beverage

Using excel, regression analysis generates the following tables with coefficients.... Regression analysis, as a statistical tool, provides a basis for establishing relationships among variables.... Such relationships can then be used make predictions subject to some… This paper seeks to offer a basis for predicting beverage sales for Westar hotel....
1 Pages (250 words) Statistics Project

Towards a Web-based Application to Resolve Physical Pulse Board Issues

As of present, as far as product developing companies are concerned, the development process has become For instance, in Scrum software development as well as in Lean product development, tools for planning a project using walls and boards have been developed.... A decade ago, Toyota, an automobile manufacturer from Japan, came up with a new production system which started the automobile industry called “Lean manufacturing”....
15 Pages (3750 words) Thesis

Simple leaner regression

2 (excel I21)Coefficient of determination, r2 = 0.... The slope, B1, is the beta coefficient in CAPM model and measures the volatility of an asset's return compared to that of the overall market.... The… The value can be more than 1.... to show that a stock is more responsive to market changes or simply riskier than the market....
2 Pages (500 words) Statistics Project

End User System for Clean Services MS Excel and VBA

The paper "End User System for Clean Services MS excel and VBA" discusses the requirements to use this application, inputting data into excel using the application, smooth running of the computer application, empowering the end-user group, the proper running of the system without hitches.... The user has a wide range of data to choose from He/she has an option of interchanged data through the mainframe of the mis division or create his own original data....
5 Pages (1250 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us