Management Information Systems Term Paper

Open, View, and/or
Download this Document

Total Length: 2034 words ( 7 double-spaced pages)

Total Sources: 0

Page 1 of 7

Management Information Systems

Worksheet with Formulas

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

PurchasePrice*10%

Solicitor's Fees (including VAT)

SolicitorFee+(SolicitorFee*17.5%)

Stamp Duty Applicable

IF (PurchasePrice>StampDutyLimit, PurchasePrice*StampDutyRate,0)

Total initial costs

Deposit+SolicitorFeeIncVAT+StampDutyApplicable

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Council tax

VLOOKUP (PurchasePrice,$B$11:$C$13,2)

Insurance premiums

AnnualInsurancePremium

House maintenance

AnnualHouseMaintenance

Travel to and from work

DistanceOfHouseFromWork*2)/PetrolConsumption)*CostOfPetrolPerLiter)*

DaysWorkedPerYear

Initial renovation

InitialRenovationExpense

Mortgage repayments

1)*PMT (MortIntRate, MortRepayPeriod, MortPerc*PurchasePrice)

Personal loan repayments

Less bank account interest

AmtPlacedInBank*BankDepIntRate)*(-1)

Total continuing costs

CouncilTax+InsurancePremium+HouseMaintenance+Travel_to_and_from_work+

InitialRenovation+MortgageRepayments+PersonalLoanRepayments+

LessBankAccountInterest

CAPITAL COSTS

Interest on savings lost

Savings*BankDepIntRate)+LessBankAccountInterest

END OF YEAR SUMMARY

Total costs during year

TotalContinuingCost+InterestOnSavingsLost

Total monthly cost during year

TotalCostsDuringYear/12

Total costs to date at end of year

TotalCostsDuringYear

Value of house at end of year

PurchasePrice+(PurchasePrice*AnnualHouseAppreciationRate)

HOUSE A VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Continuation of House A Travel to and from work

Initial renovation

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

HOUSE B

VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Continuation of House B

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Travel to and from work

Initial renovation

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

HOUSE C

VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Continuation of House C

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%) Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Travel to and from work

Initial renovation

Continuation of House C

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

HOUSE D

VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Continuation of House D

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Travel to and from work

Initial renovation

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

Ways in which Scenario Manager and other Excel features can aid in the process of decision making.

Stuck Writing Your "Management Information Systems" Term Paper?

View All Our Example Management Information Systems Term Paper

Have A Custom Example Essay Written



The Scenario Manager used in the house-buying examples is a method that can facilitate a buyer's process of decision-making. Through the tabular form of expected expenses and expected value of the houses, a buyer can easily see the differences between each house, as well as whether the values match the buyer's financial capabilities.

The Excel features also serve as useful tools that facilitate computations. Such features become handy especially when certain values need to be changed. Through the Excel's capability of storing formulas, automatic computation is made possible. This feature eliminates the need for redundant computations should a value in the variable area of our examples' Scenario Manager is changed.

Aside from the ability to facilitate computations, the Scenario Manager and the Excel features eliminates the time-consuming process of waiting for the essential computational results before a decision can be made. As in our examples, the Scenario Manager and the Excel features can aid a buyer in his decision-making process through a presented organized view of the necessary factors, particularly the expected amount of expenses and liabilities when buying a house, before coming up with a decision.

Every process of decision-making entails the need for a detailed and clear presentation of information to allow a decision-maker see the advantages and disadvantages between available options. This necessity is the fundamental feature that our examples' Scenario Manager provides. Through the organized structure of a house's details and computations, a buyer can easily pre-decide in just a brief study of the information provided by the Scenario Manager.

Implications and Relative Advantages and Disadvantages of Buying Each House

Each house presented has relative advantages and disadvantages to a buyer. Following is a discussion of these factors based on each house and based on comparison of each with the other houses.

Buying house A, being the least expensive of the four houses in terms of purchase price, offers the most financial convenience to a buyer in terms of initial costs. Compared to the other three houses, house A requires….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


Related Essays

IBM Supply Chain Concerns

Executive Summary This document considers the various points of correlation between human resources, management information systems, and supply chain management in relation to critical IBM concepts of managing an organization. It identifies how these three areas intersect and their long term value for organizations as a whole. Ultimately, they are vital aspects of operations in the contemporary business world. Introduction There are a number of eminent facets involved in the management of contemporary organizations. Encompassing a wide range of characteristics, the most notable of these pertain to information technology, resource allocation, and varying elements of procurement. Effecting competitive advantage today no longer requires… Continue Reading...

360 Method of Evaluation of an Internship

internship also aimed to improve my awareness of different record keeping methods used in warehouses, increasing familiarity with warehouse management information systems. Mastery of these systems is crucial for success in a logistics field. During this internship, I have been contributing information that has been instructive for designing and developing future warehouse management systems that use sophisticated methods of material management. These systems add an extra layer of protection from potential crises. As Sheffi (2001) points out, logistics managers need to build in redundancies to mitigate threats; dealing with the contingencies of additional security concerns does, however, imply potentially “less reliable lead times and less certain demand scenarios,” (p.… Continue Reading...

sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Management Information Systems" (2004, January 21) Retrieved May 19, 2024, from
https://www.aceyourpaper.com/essays/management-information-systems-161383

Latest MLA Format (8th edition)

Copy Reference
"Management Information Systems" 21 January 2004. Web.19 May. 2024. <
https://www.aceyourpaper.com/essays/management-information-systems-161383>

Latest Chicago Format (16th edition)

Copy Reference
"Management Information Systems", 21 January 2004, Accessed.19 May. 2024,
https://www.aceyourpaper.com/essays/management-information-systems-161383
   

Open, View, and/or
Download this Document
order custom essay example