Free Essay

Test

In: Other Topics

Submitted By Movies
Words 4615
Pages 19
Analysis of Costs and Income of the M.S.U.F.C.U ATM Network*

Brian R. Armstrong
Jeffery K. Barron
Jeffrey D. Elgas

April 26, 2002

Abstract. We examined the profitability of the automated teller machine (ATM) service provided by the Michigan State University Federal Credit Union (M.S.U.F.C.U) for one month. The cost of operating each M.S.U.F.C.U ATM in the 76-machine network was determined. We constructed a tool for determining the monthly profit for the M.S.U.F.C.U ATM network. Observations were made concerning the relationship between ATM profitability and distances from the M.S.U.F.C.U. Simulations of surcharges for guest transactions were performed.

* Work done for the Michigan State University Federal Credit Union under the direction of Jeffrey G. Jackson, Vice President of Finance, in partial fulfillment of the requirements of Michigan State University MTH 844, advised by Professor Gábor Francsics.
Table of Contents

Introduction…………………………………………………………………………..…… 3

Experimental Data From the M.S.U.F.C.U ATM Network………………………..… 3

Experimental Data Analysis of Revenue…………..………………………………..… 4

Experimental Data Analysis of Costs….…………...………………………………..… 5

Experimental Analysis of Distance versus Profitability ……………………………... 5

Experimental Analysis of Surcharges….……………..……………………………..… 6

Recommendations……………………………………………………………………..… 8

Future Work……………………………………………...……………………………..… 8

References………………………………………………………………………………... 9

Appendix A. ATM Specifications and SCC Pricing.………………………………..… 10

Appendix B. ATM Specifications and NYCE Pricing…………………………..…….. 11

Appendix C. ATM Revenue………..…...…………………………………...……..…… 12

Appendix D. ATM Revenue, Costs, and Profit……………………………………..… 13

Appendix E. Summary of Surcharge Results.….…………………………………..… 15

Appendix F. Jersey Giant Locations and Distances from M.S.U.F.C.U…...………..… 16

Disclaimer. The data used in the experiment of this project is not actual data measurements or observations of the Michigan State University Federal Credit Union. However, by the direction of the M.S.U.F.C.U, the project experiments have been performed and conclusions have been drawn as though the data were actual for one month.
Introduction

One of the leading services that the Michigan State University Federal Credit Union (M.S.U.F.C.U) provides its members is a 76-unit network of automatic teller machines (ATM). The credit union, like most financial institutions, provides the ATMs as a convenience to customers (members and guests) that need remote banking services [1]. The M.S.U.F.C.U’s machines are available in many locations throughout the MSU campus, the greater Lansing area, and greater Detroit area to increase availability of service. This service, however convenient to credit union members, is expensive due to network charges, maintenance, and upkeep. Our goal was to analyze this service system and determine the profitability of each ATM. Once the data for the month of December 2001 was obtained from the credit union, we used it to hypothesize about changes that could be made to the system in order to better serve customers, yet retain profitability for the credit union. There were several variables to consider: (1) Users of the machines (members or guests or both), (2) What cost is associated with each transaction made, (3) What is the profitability for each ATM, and (4) what is the cost of maintaining each ATM (i.e., maintenance, service, etc.). The formulas for computing revenue are shown in Tables 1 and 2. These were evaluated with Microsoft Excel using the Network data that appears in Appendices A and B. The results are tabulated in Appendix C.

Experimental Data from the M.S.U.F.C.U ATM Network

The data used in the analysis of the ATM Network was in the form of an Excel worksheet provided by the credit union [3]. We had information about every ATM location, the number and types of transactions made, and the charge from the network of each transaction (see Appendices A and B). Costs are related to who uses the machine (i.e., members and nonmembers) and what kinds of transactions are made. Members of the M.S.U.F.C.U who use the ATM's are not charged for the transaction. However, there is a cost to the credit union from the network each time a transaction is made. The MAC/SC24 Us-On-Us network charges $ 0.075 for each member transaction (see Appendix A). This charge is paid by the M.S.U.F.C.U, so the credit union loses money on member transactions. Nonmembers, or guests, are also not charged by the credit union to use ATM's. A network cost is still involved, but the credit union charges the guest’s home financial institution. So the credit union, in general, makes a profit on guest transactions. The charge per transaction can be seen in Appendix A. Our goal was to analyze the profitability of each ATM. We hypothesized that the credit union would lose money on ATM transactions. This idea was based on the fact that most machines are located in areas where the prominent users are anticipated to be members. We would hope, however, that nonmembers would also use the machines, and thereby generate some revenue, but only enough to lighten the financial burden of the credit union. Through our testing, we rejected our hypothesis and found that there is an overall positive profitability from ATM transactions, with the mainstream of profitability stemming from the Quality Dairy stores.

Experimental Data Analysis of Revenue

The first step in analyzing the data was to understand the Excel workbook [3]. We found that the book was split up into two main categories: transactions and pricing. There were two different pricing standards: (1) Service Center Corporation (SCC) pricing and (2) New York Cash Exchange (NYCE) pricing. The “Transaction Count,” “SCC Pricing,” and “NYCE Pricing” are separate sheets in the Excel workbook. We used Excel to aid in the computations of the revenue. The algorithm for the computation is:

| |
|Transaction Count = TC |
|SCC Pricing = SCC |
| |
|Network Revenue for ATM # = (TC inquiry) * (SCC inquiry) |
|+ (TC account list) * (SCC account list) |
|+ (TC denial) * (SCC denial) |
|+ (TC deposit) * (SCC deposit) |
|+ (TC envelope entry) * (SCC envelope entry) |
|+ (TC payment transfer) * (SCC payment transfer) |
|+ (TC withdrawal) * (SCC withdrawal) |
|+ (TC transfer) * (SCC transfer) |
| |
|Inquiry = account balance |
|Account List = list of all accounts |
|Denial = wrong PIN, insufficient funds, etc. |
|Deposit = depositing money into account |
|Envelope Entry = entering an envelope into machine slot |
|Payment Transfer = moving funds from one account to pay a bill |
|Withdrawal = taking funds from an account in the form of cash |
|Transfer = moving funds from one account to another |

Table 1. Network Revenue Formula.

We multiplied the transaction count by the SCC pricing to calculate the machine revenue for a particular network (CIRRUS for example). The process was repeated for each network. We only needed to make a template of formulas for one network and copied these formulas to the other networks within Excel. The only exception to this template is the NYCE network. The credit union pays for the service for NYCE users before billing NYCE (which amounts to a profit). The following adjustment to the algorithm was made:

| |
|Transaction Count = TC |
|SCC Pricing = SCC |
|NYCE Pricing = NYCE |
| |
|NYCE Revenue for ATM # = (TC inquiry) * (SCC inquiry) * (NYCE inquiry) |
|+ (TC account list) * (SCC account list) * (NYCE account list) |
|+ (TC denial) * (SCC denial) * (NYCE denial) |
|+ TC deposit) * (SCC deposit) * (NYCE deposit) |
|+ (TC envelope entry) * (SCC envelope entry) * (NYCE envelope entry) |
|+ (TC payment transfer) * (SCC payment transfer) * (NYCE payment transfer) |
|+ (TC withdrawal) * (SCC withdrawal) * (NYCE withdrawal) |
|+ (TC transfer) * (SCC transfer) * (NYCE transfer) |
| |
|Inquiry = account balance |
|Account List = list of all accounts |
|Denial = wrong PIN, insufficient funds, etc. |
|Deposit = depositing money into account |
|Envelope Entry = entering an envelope into machine slot |
|Payment Transfer = moving funds from one account to pay a bill |
|Withdrawal = taking funds from an account in the form of cash |
|Transfer = moving funds from one account to another |

Table 2. NYCE Network Revenue Formula.

The sum of the network profitabilities is the total revenue for each individual ATM. We found that the most efficient way to evaluate these calculations was to utilize Excel. After writing a formula in Excel, we found the revenue for each machine, which can be found in Appendix C. The total revenue for all machines was $ 193,949.59.

Experimental Data Analysis of Costs

After finding the total revenue of each ATM, we then turned our analysis to the costs associated with each machine. We had to consider maintenance, service, and rent. Every machine had a maintenance cost of $1200 and a service or cash-handling fee of $300 (less the two machines in the lobby of the credit union). There was rental fee of $1000 on the ATMs stationed in the Quality Dairy Stores. We subtracted these associated costs from the calculated revenue resulting in a profit or loss for each ATM. The total profit for the M.S.U.F.C.U ATMs was $51,047.09.

Experimental Analysis of Distance versus Profitability

In the next part of the project we found the profitability to distance ratio of each ATM [5]. All distances were measured form the M.S.U.F.C.U on 600 Crescent Road, East Lansing. The distance versus profitability is plotted in Figure 1. We can see from the graph that the most profitable machines are located between 2.4 and 15.1 miles from the credit union.

[pic]
Figure 1. Distance vs. Profitability.

Experimental Analysis of Surcharges

The next phase of the project was to simulate the effect of surcharging guests for use of ATM’s. In this section we hypothesize the effect of surcharges of three different amounts: $1.50, $2.00, and $2.50. Note, we inquired about any previous analysis that had been done with respect to surcharging, however, there had not been any performed. Therefore, our simulation was done on a strictly hypothetical basis. In order to aid in the profitability calculation, we calculated that on average the M.S.U.F.C.U loses $0.08 per member transaction and gains $0.54 per guest transaction. We have that the number of member and guest transactions for this month were 527,614 and 435,606, respectively. Our first simulation was in respect to a surcharge of $1.50. First, we needed to hypothesize the amount of customers that each ATM would lose, and secondly, the number of guests that would join the credit union in order to forgo the surcharge. We expect that the surcharge would increase the number of member transactions by 2%, but decrease the number of guest transactions by 5%. The simulations for surcharges of $2.00 and $2.50 were done in a similar fashion. The following table represents the results.

|Surcharge |Decrease in Guest |Increase in Member |Revenue |Initial Profit |Profit with |
|Amount |Transactions |Transactions | | |Surcharge |
|$ 1.50 |5% |2% |$181,482.13 |$38,282.13 |$659,020.68 |
|$ 2.00 |10% |3% |$169,410.39 |$26,210.39 |$810,301.19 |
|$ 2.50 |15% |4% |$157,338.65 |$14,138.65 |$939,801.40 |

Table 3. Summary of Surcharge Simulations.

Initially, we were shocked by the size of the hypothetical profits that resulted from surcharging since our original profit is $51,047.09. This inspired us to test several different surcharge/member-increase/ guest-decrease values. Even after assessing somewhat bizarre surcharge statistics, such as an 80% decrease in guest transactions with zero percentage member gain, a profit was still realized with a surcharge as low as $1.50. The large number of transactions (963,220 in our one-month data sample) substantiates the size of the profits. The supporting data for Figure 2 can be found in Appendix E.

[pic]

Figure 2. Simulation Results and Comparisons.

Recommendations for ATM System Alterations

Should the M.S.U.F.C.U decide to install more machines, it would be best served (statistically) by placing them in the 2.4 to 15.1 mile radius from the M.S.U.F.C.U on 600 Crescent Road, East Lansing. For the best interest of the credit union and its members, there should be a $1.50 surcharge for guest transactions. We recommend that the Excel worksheet we created be used with future data.

Future Work

We recommend that there be future consideration on the statistical analysis of adding surcharges to guest transactions. There is potential for a large profit without sacrificing member service. The M.S.U.F.C.U can service its members with the same quality while simultaneously increasing profit. On request from Jeff Jackson, we did preliminary work on the possible partnership with Jersey Giant Submarines, a submarine sandwich store chain with eight locations in the greater Lansing area. The most profitable ATMs were those placed in the Quality Dairy stores, therefore forming a partnership with another local chain is worth investigating. We found that six of the Jersey Giant Submarine facilities are located in the optimal ATM profitability region (2.4 to 15.1 miles from M.S.U.F.C.U). These locations and distances can be found in Appendix F. Other interesting research that could be performed, as a continuation of the work seen above, would be that of investigating the surcharges of other credit unions and banks. Also, one could review studies done in the fields of economics or finance pertaining to the effect of increasing banking fees. In closing, the work performed above might be further substantiated by constructing data for several months.
References

1] Jackson, Jeffrey G. Project Summary. “Analysis of Costs and Income from an ATM Network.” Michigan State University Federal Credit Union. . 2002.

2] MacCluer, C. R. Industrial Mathematics, Modeling in Industry, Science, and Government. Prentice Hall, New Jersey. 2001.

3] Mendoza, Kim. M.S.U.F.C.U Project Data. “Machine List, Transaction Count, SCC Pricing, and NYCE Pricing.” Excel Workbook. Michigan State University Federal Credit Union. 2002.

4] Michigan State University Federal Credit Union. . 2002.

5] Yahoo!, Inc. “Maps and Driving Directions.” . 2002

6] YellowPages.com, Inc. “Business Search.” . 2002.

Appendix A. ATM Specifications and SCC Pricing
|NETWORK |INQUIRY |ACCOUNT LIST |DENIALS |DEPOSIT |ENVELOPE ENTRY |
|45 |Q.D. 8512 W. Saginaw |$ 5,628.02 |670 |Q.D. 720 W. Jolly |$ 5,843.39 |
|47 |600 East Crescent Road (Inside) | $ 31.46 |671 |Q.D. 1200 W. Willow | $ 4,054.28 |
|630 |1925 W. Grand River (Inside) |$ (77.15) |672 |Q.D. 645 S. Waverly | $ 6,036.69 |
|631 |1925 W. Grand River (Outside) | $ 264.37 |673 |Q.D. 917 E. Cavanaugh | $ 5,057.35 |
|632 |MSU International Center-Right | $ 1,631.71 |674 |Q.D. 2121 W. Holmes | $ 6,285.17 |
|633 |Oakland - Kresge Library | $ 133.39 |675 |Q.D. 4500 W. Saginaw | $ 7,622.66 |
|634 |Oakland - 3625 East Pontiac | $ 1,139.07 |676 |Q.D. 947 Trowbridge | $ 1,263.03 |
|635 |600 East Crescent Road (Drives-West) | $ (215.61) |677 |Q.D. 173 Maple | $ 4,199.43 |
|636 |Oakland - 3000 University Drive | $ 843.05 |678 |Q.D. 5100 S. Waverly | $ 6,088.55 |
|640 |MSU The College Store-4790 S. Hagadorn | $ 201.48 |679 |Q.D. 5930 Marsh Road | $ 3,265.21 |
|641 |Q.D. 1109 E. Grand River (Front Machine) | $ 1,868.46 |680 |Q.D. 6099 South M.L.K. Blvd. (Logan) | $ 8,291.23 |
|642 |Oakland Center | $ 1,948.20 |681 |Q.D. 2233 S. Cedar | $ 7,783.73 |
|643 |MSU International Center-Left | $ 1,250.02 |682 |Q.D. 7120 Lansing Road | $ 4,316.93 |
|644 |MSU Union-Right (Post Office Side) | $ 1,249.59 |683 |Q.D. 500 E. Saginaw | $ 6,959.73 |
|645 |MSU Clinical Center | $ 317.69 |684 |Q.D. 808 E. Michigan | $ 2,919.78 |
|646 |MSU Breslin Center-1 Birch Road | $ 217.08 |685 |Q.D. 2600 S. Cedar | $ 7,778.91 |
|647 |MSU Brody Commons | $ 1,221.42 |686 |Q.D. 680 Lansing Road | $ 4,577.71 |
|648 |MSU Union-Left (Next to phones) | $ 1,510.20 |687 |Q.D. 118 N. Main Street | $ 8,106.97 |
|649 |MSU Kellogg Center | $ 452.02 |688 |Q.D. 6400 W. St. Joseph | $ 5,595.71 |
|650 |MSU McDonel Hall | $ 882.45 |689 |Q.D. 2400 E. Michigan | $ 4,906.25 |
|651 |MSU Owen Graduate Hall | $ 763.17 |690 |Q.D. 804 W. Willow | $ 6,150.20 |
|652 |MSU Holmes Hall West | $ 1,019.27 |691 |Q.D. 3332 Lake Lansing Road | $ 2,786.21 |
|653 |MSU Akers Hall West | $ 1,063.07 |692 |Q.D. 2625 E. Jolly Road | $ 7,355.78 |
|654 |MSU Hubbard Hall North | $ 1,077.54 |693 |Q.D. 1109 E. Grand River (Back Machine) | $ 2,913.24 |
|656 |523 E. Grand River (Lobby) | $ 196.37 |694 |Q.D. 1699 W. Grand River | $ 3,038.67 |
|657 |MSU Case Hall North | $ 816.36 |696 |Q.D. 10850 E. Second | $ 2,184.62 |
|658 |MSU Wonders Hall North | $ 1,011.34 |749 |600 East Crescent Road (Drives-East) | $ (233.13) |
|659 |MSU Holden Hall-East | $ 1,185.34 |753 |Oakland - Vandenberg Hall | $ 691.05 |
|660 |MSU Shaw Hall West | $ 0 |766 |MSU Library | $ 619.39 |
|661 |MSU Phillips Hall | $ 483.06 |767 |Oakland - 1899 N. Squirrel Rd. | $ 71.74 |
|662 |MSU Mason-Abbott Hall | $ 275.33 |768 |MSU Parking Ramp # 5 | $ 28.54 |
|663 |MSU Wilson Hall East | $ 876.50 |793 |Oakland - 4141 Continental Dr. | $ 473.02 |
|664 |MSU Administration Building | $ 52.82 |831 |Oakland - 1700 Atlantic Blvd. | $ 682.71 |
|665 |523 E. Grand River (Front) | $ 1,494.50 |832 |Oakland - 3800 Giddings Road | $ 889.70 |
|666 |Q.D. 400 S. Pennsylvania | $ 5,864.32 |867 |Not in service | |
|667 |Q.D. 2100 N. Larch | $ 6,320.15 |885 |523 E. Grand River (Back) | $ 2,015.79 |
|668 |Q.D. 1412 W. Mt. Hope | $ 6,300.03 |888 |Oakland University | $ 913.30 |
|669 |Q.D. 700 N. Pine | $ 3,414.78 |897 |MSU Brody Commons - Was #647 | $ 2.75 |
| | | | | | |
| | | | |Total Revenue |$ 193,949.59 |

Appendix D. ATM Revenue, Costs, and Profit

|ATM |Location - Status - Space |Revenue |Costs |Profit |Distance |
| | | | | |(miles) |
|45 |Q.D. 8512 W. Saginaw |$5,628.02 |$2,500.00 |$3,128.02 |11.5 |
|47 |600 East Crescent Road (Inside) |$31.46 |$1,200.00 |($1,168.54) | |
|630 |1925 W. Grand River (Inside) |($77.15) |$1,500.00 |($1,577.15) |3.1 |
|631 |1925 W. Grand River (Outside) |$264.37 |$1,500.00 |($1,235.63) |3.1 |
|632 |MSU International Center-Right |$1,631.71 |$1,500.00 |$131.71 |1.5 |
|633 |Oakland - Kresge Library |$133.39 |$1,500.00 |($1,366.61) |93.0 |
|634 |Oakland - 3625 East Pontiac |$1,139.07 |$1,500.00 |($360.93) |89.0 |
|635 |600 East Crescent Road (Drives-West) |($215.61) |$1,500.00 |($1,715.61) | |
|636 |Oakland - 3000 University Drive |$843.05 |$1,500.00 |($656.95) |89.2 |
|640 |MSU The College Store-4790 S. Hagadorn |$201.48 |$1,500.00 |($1,298.52) |1.8 |
|641 |Q.D. 1109 E. Grand River (Front Machine) |$1,868.46 |$1,500.00 |$368.46 |2.9 |
|642 |Oakland Center |$1,948.20 |$1,500.00 |$448.20 |89.0 |
|643 |MSU International Center-Left |$1,250.02 |$1,500.00 |($249.98) |1.5 |
|644 |MSU Union-Right (Post Office Side) |$1,249.59 |$1,500.00 |($250.41) |1.5 |
|645 |MSU Clinical Center |$317.69 |$1,500.00 |($1,182.31) |1.9 |
|646 |MSU Breslin Center-1 Birch Road |$217.08 |$1,500.00 |($1,282.93) |0.8 |
|647 |MSU Brody Commons |$1,221.42 |$1,500.00 |($278.58) |1.4 |
|648 |MSU Union-Left (Next to phones) |$1,510.20 |$1,500.00 |$10.20 |1.5 |
|649 |MSU Kellogg Center |$452.02 |$1,500.00 |($1,047.99) |1.1 |
|650 |MSU McDonel Hall |$882.45 |$1,500.00 |($617.56) |1.9 |
|651 |MSU Owen Graduate Hall |$763.17 |$1,500.00 |($736.83) |1.8 |
|652 |MSU Holmes Hall West |$1,019.27 |$1,500.00 |($480.73) |2.4 |
|653 |MSU Akers Hall West |$1,063.07 |$1,500.00 |($436.93) |1.9 |
|654 |MSU Hubbard Hall North |$1,077.54 |$1,500.00 |($422.46) |2.2 |
|656 |523 E. Grand River (Lobby) |$196.37 |$1,500.00 |($1,303.64) |2.1 |
|657 |MSU Case Hall North |$816.36 |$1,500.00 |($683.64) |1.0 |
|658 |MSU Wonders Hall North |$1,011.34 |$1,500.00 |($488.66) |0.8 |
|659 |MSU Holden Hall-East |$1,185.34 |$1,500.00 |($314.67) |0.7 |
|660 |MSU Shaw Hall West |$0.00 |$1,500.00 |($1,500.00) |1.9 |
|661 |MSU Phillips Hall |$483.06 |$1,500.00 |($1,016.94) |1.9 |
|662 |MSU Mason-Abbott Hall |$275.33 |$1,500.00 |($1,224.67) |1.9 |
|663 |MSU Wilson Hall East |$876.50 |$1,500.00 |($623.51) |0.8 |
|664 |MSU Administration Building |$52.82 |$1,500.00 |($1,447.18) |1.6 |
|665 |523 E. Grand River (Front) |$1,494.50 |$1,500.00 |($5.50) |2.1 |
|666 |Q.D. 400 S. Pennsylvania |$5,864.32 |$2,500.00 |$3,364.32 |2.9 |
|667 |Q.D. 2100 N. Larch |$6,320.15 |$2,500.00 |$3,820.15 |5.1 |
|668 |Q.D. 1412 W. Mt. Hope |$6,300.03 |$2,500.00 |$3,800.03 |4.2 |
|669 |Q.D. 700 N. Pine |$3,414.78 |$2,500.00 |$914.78 |5.5 |
|670 |Q.D. 720 W. Jolly |$5,843.39 |$2,500.00 |$3,343.39 |5.7 |
|671 |Q.D. 1200 W. Willow |$4,054.28 |$2,500.00 |$1,554.28 |5.8 |
|672 |Q.D. 645 S. Waverly |$6,036.69 |$2,500.00 |$3,536.69 |6.3 |
|673 |Q.D. 917 E. Cavanaugh |$5,057.35 |$2,500.00 |$2,557.35 |4.1 |
|674 |Q.D. 2121 W. Holmes |$6,285.17 |$2,500.00 |$3,785.17 |5.3 |
|675 |Q.D. 4500 W. Saginaw |$7,622.66 |$2,500.00 |$5,122.66 |7.8 |
|ATM |Location - Status - Space |Revenue |Costs |Profit |Distance |
| | | | | |(miles) |
|676 |Q.D. 947 Trowbridge |$1,263.03 |$2,500.00 |($1,236.97) |1.4 |
|677 |Q.D. 173 Maple |$4,199.43 |$2,500.00 |$1,699.43 |13.2 |
|678 |Q.D. 5100 S. Waverly |$6,088.55 |$2,500.00 |$3,588.55 |8.6 |
|679 |Q.D. 5930 Marsh Road |$3,265.21 |$2,500.00 |$765.21 |6.6 |
|680 |Q.D. 6099 South M.L.K. Blvd. (Logan) |$8,291.23 |$2,500.00 |$5,791.23 |9.9 |
|681 |Q.D. 2233 S. Cedar |$7,783.73 |$2,500.00 |$5,283.73 |6.3 |
|682 |Q.D. 7120 Lansing Road |$4,316.93 |$2,500.00 |$1,816.93 |10.5 |
|683 |Q.D. 500 E. Saginaw |$6,959.73 |$2,500.00 |$4,459.73 |4.4 |
|684 |Q.D. 808 E. Michigan |$2,919.78 |$2,500.00 |$419.78 |1.2 |
|685 |Q.D. 2600 S. Cedar |$7,778.91 |$2,500.00 |$5,278.91 |3.5 |
|686 |Q.D. 680 Lansing Road |$4,577.71 |$2,500.00 |$2,077.71 |23.6 |
|687 |Q.D. 118 N. Main Street |$8,106.97 |$2,500.00 |$5,606.97 |21.5 |
|688 |Q.D. 6400 W. St. Joseph |$5,595.71 |$2,500.00 |$3,095.71 |9.4 |
|689 |Q.D. 2400 E. Michigan |$4,906.25 |$2,500.00 |$2,406.25 |2.2 |
|690 |Q.D. 804 W. Willow |$6,150.20 |$2,500.00 |$3,650.20 |15.1 |
|691 |Q.D. 3332 Lake Lansing Road |$2,786.21 |$2,500.00 |$286.21 |4.0 |
|692 |Q.D. 2625 E. Jolly Road |$7,355.78 |$2,500.00 |$4,855.78 |3.2 |
|693 |Q.D. 1109 E. Grand River (Back Machine) |$2,913.24 |$2,500.00 |$413.24 |2.9 |
|694 |Q.D. 1699 W. Grand River |$3,038.67 |$2,500.00 |$538.67 |5.0 |
|696 |Q.D. 10850 E. Second |$2,184.62 |$2,500.00 |($315.38) |31.7 |
|749 |600 East Crescent Road (Drives-East) |($233.13) |$1,500.00 |($1,733.13) | |
|753 |Oakland - Vandenberg Hall |$691.05 |$1,500.00 |($808.96) |89.0 |
|766 |MSU Library |$619.39 |$1,500.00 |($880.61) |1.6 |
|767 |Oakland - 1899 N. Squirrel Rd. |$71.74 |$1,500.00 |($1,428.26) |89.4 |
|768 |MSU Parking Ramp # 5 |$28.54 |$1,500.00 |($1,471.46) |1.3 |
|793 |Oakland - 4141 Continental Dr. |$473.02 |$1,500.00 |($1,026.99) |89.8 |
|831 |Oakland - 1700 Atlantic Blvd. |$682.71 |$1,500.00 |($817.29) |89.8 |
|832 |Oakland - 3800 Giddings Road |$889.70 |$1,500.00 |($610.30) |91.8 |
|867 |Not in service | |$0.00 |$0.00 | |
|885 |523 E. Grand River (Back) |$2,015.79 |$1,500.00 |$515.79 |2.1 |
|888 |Oakland University |$913.30 |$1,500.00 |($586.71) |89.0 |
|897 |MSU Brody Commons - Was #647 |$2.75 |$1,500.00 |($1,497.25) |1.4 |
| | | | | | |
|1,000 |Total | $193,949.59 | $143,200.00 |$51,047.09 |1200.9 |

Appendix E. Summary of Surcharge Results

|Surcharge Amount |Decrease in Guest |Increase in Member |Revenue |Initial Profit |Profit with Surcharge |
| |Transactions |Transactions | | | |
|$0.01 |5% |2% | $ 181,482.13 | $ 38,282.13 | $ 42,420.39 |
|$0.01 |10% |3% | $ 169,410.39 | $ 26,210.39 | $ 30,130.85 |
|$0.01 |15% |4% | $ 157,338.65 | $ 14,138.65 | $ 17,841.30 |
|$0.50 |5% |2% | $ 181,482.13 | $ 38,282.13 | $ 245,194.98 |
|$0.50 |10% |3% | $ 169,410.39 | $ 26,210.39 | $ 222,233.09 |
|$0.50 |15% |4% | $ 157,338.65 | $ 14,138.65 | $ 199,271.20 |
|$1.00 |5% |2% | $ 181,482.13 | $ 38,282.13 | $ 452,107.83 |
|$1.00 |10% |3% | $ 169,410.39 | $ 26,210.39 | $ 418,255.79 |
|$1.00 |15% |4% | $ 157,338.65 | $ 14,138.65 | $ 384,403.75 |
|$1.50 |5% |2% | $ 181,482.13 | $ 38,282.13 | $ 659,020.68 |
|$1.50 |10% |3% | $ 169,410.39 | $ 26,210.39 | $ 614,278.49 |
|$1.50 |15% |4% | $ 157,338.65 | $ 14,138.65 | $ 569,536.30 |
|$2.00 |5% |2% | $ 181,482.13 | $ 38,282.13 | $ 865,933.53 |
|$2.00 |10% |3% | $ 169,410.39 | $ 26,210.39 | $ 810,301.19 |
|$2.00 |15% |4% | $ 157,338.65 | $ 14,138.65 | $ 754,668.85 |
|$2.50 |5% |2% | $ 181,482.13 | $ 38,282.13 | $1,072,846.38 |
|$2.50 |10% |3% | $ 169,410.39 | $ 26,210.39 | $1,006,323.89 |
|$2.50 |15% |4% | $ 157,338.65 | $ 14,138.65 | $ 939,801.40 |

Appendix F. Jersey Giant Locations and Distances from M.S.U.F.C.U

Jersey Giant Submarine Sandwiches Inc.
220 MAC Avenue, East Lansing, MI 48823
(517) 332-2969 1.9 MILES

Jersey Giant Submarine Sandwiches Inc.
529 East Grand River Avenue, East Lansing, MI 48823
(517) 332-2969 2.1 MILES

Jersey Giant Submarine Sandwiches Inc.
3019 East Saginaw Street, Lansing, MI 48912
(517) 351-1616 2.3 MILES

Jersey Giant Submarine Sandwiches Inc.
2546 East Jolly Rd, Lansing, MI 48910
(517) 394-3590 3.3 MILES

Jersey Giant Submarine Sandwiches Inc.
1866 West Grand River Avenue, Okemos, MI 48864
(517) 347-8400 4.6 MILES

Jersey Giant Submarine Sandwiches Inc.
3525 South Martin Luther King, Jr. Blvd. Ste. B, Lansing, MI 48910
(517) 882-2300 4.7 MILES

Jersey Giant Submarine Sandwiches Inc.
3700 West Saginaw Street, Lansing, MI 48917
(517) 323-6800 7.4 MILES

Jersey Giant Submarine 10
516 North Clinton Street, Grand Ledge, MI 48837
(517) 622-4855 16.0 MILES

Similar Documents

Free Essay

Test Taking

...you feel about tests in general? I don’t like taking test because I always get of feeling of nervousness. My stomach gets all tied up in knots. The problem with taking test is a feeling of not remembering. It gets uncomfortable every time I have to take a test whether I study or not. 2. What are your first memories of being in a testing situation? What were your feeling, and why? My first memory of being in a testing situation is in high school. It was finals and I needed to pass this one course to graduate. It was a course that I detested, and I was horrible at it. This course was Trigonometry. I am not good in math period, but this course was a requirement. I felt that I was going to fail the course, and it was going to be a setback. It was a depressing feeling. 3. What make a test “good” and “bad” from your perspective? What make a test good is knowing what kind of test it, what is covered and how much a percentage is geared toward that test. How do I know that the test is good is when the instructor lets you know what is going to be on the test. A test is good when much preparation and work goes into it. The format or the structure of the test also make it good. When I think of a bad test, it mean no preparation, no work or study when into taking the test. A bad test is a test that is not put together well. The organization is not good and the test is very confusing. It can be a bad test when the person taking the test is ill-prepared...

Words: 528 - Pages: 3

Premium Essay

Test

...For • Practicality-This is probably by far, the biggest argument in favor of standardized tests. Aspects include: o Standardized tests are less time-consuming than more complicated assessments that need personal time with every student. o Standardized tests are easier to administer. There are explicit directions given and each student is given the same directions in the same way. o They are easier to grade, machines do it for us. o Very easy to use a computer to track progress and levels of achievement for different groups of students in different subjects. (Holloway) • Objectivity-It is very easy for a test to be objective, it doesn't have emotion or moods or biases. When giving more personal assessments, it is very possible that the teacher or person assessing the student can let their emotions or biases affect how they score that student. • Instigator of change-Standardized tests can be a powerful tool to change classroom and school practices (Gardner). We can use testing to tell us whether we have a problem (Gerstner). When we identify a problem in a classroom, school, or district we can then take active steps in correcting that problem. In addition, achievement data from tests provide teachers with valuable information to improve classroom and student learning (Gardner) • Accountability-Setting high expectations for students and holding them accountable for the same standards, leads to achievement gains. High-stakes testing forces students to take education...

Words: 1000 - Pages: 4

Free Essay

Test

...Quantitative research methods in educational planning Series editor: Kenneth N.Ross Module John Izard 6 Overview of test construction UNESCO International Institute for Educational Planning Quantitative research methods in educational planning These modules were prepared by IIEP staff and consultants to be used in training workshops presented for the National Research Coordinators who are responsible for the educational policy research programme conducted by the Southern and Eastern Africa Consortium for Monitoring Educational Quality (SACMEQ). The publication is available from the following two Internet Websites: http://www.sacmeq.org and http://www.unesco.org/iiep. International Institute for Educational Planning/UNESCO 7-9 rue Eugène-Delacroix, 75116 Paris, France Tel: (33 1) 45 03 77 00 Fax: (33 1 ) 40 72 83 66 e-mail: information@iiep.unesco.org IIEP web site: http://www.unesco.org/iiep September 2005 © UNESCO The designations employed and the presentation of material throughout the publication do not imply the expression of any opinion whatsoever on the part of UNESCO concerning the legal status of any country, territory, city or area or of its authorities, or concerning its frontiers or boundaries. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means: electronic, magnetic tape, mechanical, photocopying, recording or otherwise, without permission ...

Words: 13966 - Pages: 56

Free Essay

Test

...Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category test User Category...

Words: 588 - Pages: 3

Free Essay

Test

...Test Automation Criteria Benefit * How often do you believe the test should be run? * How many minutes are required for one tester to execute the test manually? * Will human intervention still be required to execute the test after automation? * Does the execution of the test require the tester to input a large amount of data (e.g. populating many fields or populating the same fields many times) via the gui interface? * Does the test require an inordinate amount of user interface actions (e.g. mouse clicks, validations)? * Will automating the test increase the productivity of the team? * Will automating the test allow us to increase test coverage? * Will automating the test allow us to increase the accuracy (exactness) and precision ( reproducibility or repeatability) of the test? * Is the execution of this test prerequisite to the execution of multiple other tests? Cost * How many hours of data preparation (e.g. querying data, setup within the application, etc.) is required for this test? * Is the test documented in such a way that someone other than the author can execute it, and is it stored in Quality Center? * What is the average number of times the test needs to be updated (e.g to reflect development changes) within a six month span? * Are the manual test steps currently up to date? * Are the systems and environments in which the test is run stable and consistently available? * Are third party systems involved...

Words: 276 - Pages: 2

Free Essay

Standardized Tests

...Standardized Testing Standardized testing has been a key part in education for awhile now, but how effective is it really? Does it truly grasp the students’ individualities to highlight their unique abilities? Of course it does not, how can it? If this is true, however, why are they still vital to earn a high school diploma? Education was once about the students, not about the score. It was about enjoying the time in the classroom, creating a desire to want to know more. Standardized tests have taken this away from classrooms, they have caused many pupils to not enjoy the material they are taught while also taking the individualism, the one on one individual experiences, out of the classrooms. Education is no longer about the individual student. It is about the student body, making everyone the same or “equal”. Education should be fun. It should make the student desire to learn more. Francine Prose discusses this in her essay, I Know Why the Caged Bird Cannot Read. She talks of how each September she is more and more depressed when she receives her sons’ reading lists for the upcoming school year. Not only have the books they are forced to read not the best choices, but the information from the books is forced down the student’s throats. Students are not given the opportunity to read the books and enjoy them. Upon receiving the their assignments, they are also given worksheets and other assignments,outlining the information and key points they are expected understand...

Words: 1053 - Pages: 5

Free Essay

Test

...academic scores and to include the family’s social, culture and educational background. Sandel states that the A 700 score for a student who attended poor public schools in the South Bronx has more meaning than that of a student from an Upper East Side of Manhattan. 2. What is the essence of Richard Dworkin's argument in support of affirmative action university admissions policies? b. Dworkin’s idea of the supporting argument on affirmative action in relations to the universities admission policies is stated that possibly the right at stake should be based according to academic criteria alone. The fact of being good at football, or coming from Idaho, or having volunteered in a soup kitchen. Dworkin views the facts of grades, test scores, and other measures of academic promise land me in the top group of applicants, therefore I should be admitted. One should be considered based on academic merit alone. 3. What does it mean to sever the idea of "moral desert" from our notions of what constitutes justice?  Would this be helpful? c. Severing the idea of “moral desert” signifies that our nation should reject the talents that one has that enable them to compete more successfully than others in not entirely one’s own doing. He also states an equally decisive contingency where the quality of societal values at any given time...

Words: 504 - Pages: 3

Free Essay

Standardized Tests

...Standardized Tests Sections I and II Sammy North DeVry University Standardized Tests Sections I and II Brittany, an honors student in Atlanta, Georgia, had worked hard her entire academic career to celebrate what would be her proudest moment in high school: commencement. She wanted to walk across the stage to the flash of cameras and the smiles of her family just like her classmates, and then journey off to a college in South Carolina where she had already been accepted. So she gathered her proud family members from Chicago and Washington, D.C., to come to share in her joy. Brittany watched as her classmates put on their caps and gowns and walked across the stage to receive their diplomas. But she did not, and instead waited all during the day to get a last-minute waiver signed. She continued to wait through the night, but it never came. She began to realize that if she graduated, it would not be quick or easy. Her problem was that she had not passed one of four subject areas in the state’s graduation test, which students must pass to earn a regular diploma. She is not alone. Thousands of students, such as Brittany, every year do not make it across the stage at graduation due to failing these state tests. And many of them, such as Brittany, were honors students who had fulfilled all the other requirements of graduation except this one (Torres, 2010). Stories such as this one are far too common and should not happen. We have the power to change the status quo, so that...

Words: 2702 - Pages: 11

Premium Essay

Standardized Test

...’ve always thought about attending a school where students don’t have to take tests mandated by the government. I just realized that it is possible. In the article “What Schools Could Use Instead of Standardized Test”, by Anya Kamenetz, it recommends that it might come true in future years. As of right now, attorneys and legislators have been trying to draft a bill that could get rid of the desire for a federal bubble test and dismiss the renewal of the rule that states no child left behind, but switching it with fast state wide evaluations. The debate over the elimination of the federal testing comes in conclusion of the increasing concern of the time amount of these students use to take this test and the increasing number of parents deciding to withdraw their children from these tests. The council of chief state school officers and broad and big school districts were in support of decreasing the number of standardized tests students take. Plenty democratic groups have come out and backed this idea. If Schools do drop the mandated government tests, Kamenetz advice of three different choices measuring national students The first choice that Kamenetz...

Words: 631 - Pages: 3

Free Essay

Test

...P a g e |1 BackTrack 5 guide 4: How to perform stealth actions Karthik R, Contributor You can read the original story here, on SearchSecurity.in. In previous installments of this BackTrack 5 how to tutorial, we have discussed information gathering and vulnerability assessment of the target system; explored network assessment, scanning and gaining access into the target; and, delved into privilege escalation tools. In this installment of the tutorial on BackTrack 5, how to perform stealth actions will be discussed. Why stealth? The objective of penetration testing is to replicate the actions of a malicious attacker. No attacker desires discovery of surreptitious entry into the network, and hence employs stealth techniques to remain unnoticed. The penetration tester needs to adopt the same stealth methods, in order to honestly assess the target network. http://searchsecurity.techtarget.in/tip/BackTrack-5-guide-4-How-to-perform-stealth-actions P a g e |2 Figure 1. The ‘maintaining access’ category in BackTrack 5, with a focus on OS backdoors. This installment of the BackTrack 5 how to tutorial deals with the “Maintaining Access” feature, within which are options for OS backdoors, tunneling and Web backdoors, as shown in Figure 1. OS backdoors > Cymothoa: Cymothoa is a stealth backdooring tool on BackTrack 5 that injects backdoor shell code into an existing process. This tool has been developed by codewizard and crossbower from ElectronicSouls. The general...

Words: 1111 - Pages: 5

Premium Essay

Eco 410 Test Bank

...A++PAPER;http://www.homeworkproviders.com/shop/eco-410-test-bank/ ECO 410 TEST BANK ECO 410 Test Bank, All Possible Questions With Answers ECO 410 Week 2 Quiz 1: Chapters 1 and 2 ECO 410 Week 3 Quiz 2: Chapters 3 and 4 ECO 410 Week 4 Quiz 3: Chapters 5 and 6 ECO 410 Week 5 Quiz 4: Chapters 7 and 8 ECO 410 Week 6 Quiz 5: Chapters 9 and 10 ECO 410 Week 7 Quiz 6: Chapters 11 and 12 ECO 410 Week 8 Quiz 7: Chapters 13 and 14 ECO 410 Week 9 Quiz 8: Chapters 15 and 16 ECO 410 Week 10 Quiz 9: Chapter 17 and 18 ECO 410 Week 11 Quiz 10: Chapter 19 and 20 ECO 410 Quizzes and Exam Week 1 - 11 All Possible Questions With Answers ECO 410 Week 2 Quiz 1: Chapters 1 and 2 ECO 410 Week 3 Quiz 2: Chapters 3 and 4 ECO 410 Week 4 Quiz 3: Chapters 5 and 6 ECO 410 Week 5 Quiz 4: Chapters 7 and 8 ECO 410 Week 6 Quiz 5: Chapters 9 and 10 ECO 410 Week 7 Quiz 6: Chapters 11 and 12 ECO 410 Week 8 Quiz 7: Chapters 13 and 14 ECO 410 Week 9 Quiz 8: Chapters 15 and 16 ECO 410 Week 10 Quiz 9: Chapter 17 and 18 ECO 410 Week 11 Quiz 10: Chapter 19 and 20 ECO 410 Quizzes and Exam Week 1 - 11 All Possible Questions With Answers ECO 410 Week 2 Quiz 1: Chapters 1 and 2 ECO 410 Week 3 Quiz 2: Chapters 3 and 4 ECO 410 Week 4 Quiz 3: Chapters 5 and 6 ECO 410 Week 5 Quiz 4: Chapters 7 and 8 ECO 410 Week 6 Quiz 5: Chapters 9 and 10 ECO 410 Week 7 Quiz 6: Chapters 11 and 12 ECO 410 Week 8 Quiz 7: Chapters 13 and 14 ...

Words: 471 - Pages: 2

Free Essay

Eco 410 Test Bank

...ECO 410 TEST BANK A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=eco-410-test-bank Visit Our website: http://hwsoloutions.com/ Product Description PRODUCT DESCRIPTION ECO 410 Test Bank, All Possible Questions With Answers ECO 410 Week 2 Quiz 1: Chapters 1 and 2 ECO 410 Week 3 Quiz 2: Chapters 3 and 4 ECO 410 Week 4 Quiz 3: Chapters 5 and 6 ECO 410 Week 5 Quiz 4: Chapters 7 and 8 ECO 410 Week 6 Quiz 5: Chapters 9 and 10 ECO 410 Week 7 Quiz 6: Chapters 11 and 12 ECO 410 Week 8 Quiz 7: Chapters 13 and 14 ECO 410 Week 9 Quiz 8: Chapters 15 and 16 ECO 410 Week 10 Quiz 9: Chapter 17 and 18 ECO 410 Week 11 Quiz 10: Chapter 19 and 20 ECO 410 Quizzes and Exam Week 1 – 11 All Possible Questions With Answers ECO 410 Week 2 Quiz 1: Chapters 1 and 2 ECO 410 Week 3 Quiz 2: Chapters 3 and 4 ECO 410 Week 4 Quiz 3: Chapters 5 and 6 ECO 410 Week 5 Quiz 4: Chapters 7 and 8 ECO 410 Week 6 Quiz 5: Chapters 9 and 10 ECO 410 Week 7 Quiz 6: Chapters 11 and 12 ECO 410 Week 8 Quiz 7: Chapters 13 and 14 ECO 410 Week 9 Quiz 8: Chapters 15 and 16 ECO 410 Week 10 Quiz 9: Chapter 17 and 18 ECO 410 Week 11 Quiz 10: Chapter 19 and 20 ECO 410 Quizzes and Exam Week 1 – 11 All Possible Questions With Answers ECO 410 Week 2 Quiz 1: Chapters 1 and 2 ECO 410 Week 3 Quiz 2: Chapters 3 and 4 ECO 410 Week 4 Quiz 3: Chapters 5 and 6 ECO 410 Week 5 Quiz 4: Chapters 7 and 8 ECO 410 Week 6 Quiz 5: Chapters 9 and 10 ECO 410 Week 7 Quiz 6: Chapters 11 and 12 ECO...

Words: 484 - Pages: 2

Premium Essay

Standardized Test Outline

...I. Standardized test give an unfair advantage to some groups, with the contrast only widening throughout the decades. A. The wealthier class are more prepared than the poor class. 1. Since the 1960s, the contrast of standardized test results between those with wealth and those in poverty have widened by 60%. 2. Students in wealthier environments have greater access to methods and classes that help them prepare specifically for standardized tests. B. Whites and Asians have an advantage over Latinos and African Americans. 1. Although the African American and Latino students make up about 70% of the total student body, they are consistent in scoring lower on standardized tests in New York. 2. Schools in Virginia require a smaller percent...

Words: 615 - Pages: 3

Premium Essay

Standardization Test

...these test has become important for teachers since a student may take a least one standardized test per year. And therein lies the problem; relying heavily on standardized test, whether or not these test actually have reliable scores and are worth the extensive focus. Standardized test negatively affect student learning because they focus on certain topics and generate unreliable test scores due to certain factors. These factors include limitation of creativity, narrowing of curriculum, use of outdated methods, repetition, race and gender. In my research I have found significant data supporting my views. But first it is important to understand what standardized tests are. Standardized tests are different from other testing because they have uniform procedure. This means that they have the same time limits, fixed set of questions, and the scoring is also carefully outlined and uniform. Standardized test are usually scored objectively but there can be some questions such as a short answer question or personality questions which can be scored differently. Almost all test can be classified as informal or formal; a test given and create by a teacher is informal, but a standardized test is classified as formal (Mehrens and Lehmannn). There are certain characteristics a test must have to be a standardized test. The first characteristic is that the test must be designed by a specialist. These specialists have been trained in measurement and principles of test development...

Words: 1511 - Pages: 7

Free Essay

Standardized Tests

...Running head: STANDARDIZED TESTS ARE KILLING SOCIETY                  1                Standardized Tests Are Killing Society  Alyssa Masula  Jonathan Alder High School            STANDARDIZED TESTS ARE KILLING SOCIETY                                                            2      ABSTRACT    STANDARDIZED TESTS ARE KILLING SOCIETY     Alyssa Masula          This essay provides an exploration of the harm done to individuals and societies by standardized  testing.  In her studies, the author discovered mixed results, containing both support and rejection  for her original hypothesis. She includes evidence to prove her point true. She provides  information gathered from various sources including published works and studies by Peter  Sacks, Nicholas Lemann, and Jacques Steinberg. As well as these, she has added the support of a  political cartoon and an article from the distinguished newspaper “The Columbus Dispatch”.          STANDARDIZED TESTS ARE KILLING SOCIETY                                                            3  Standardized Tests Are Killing Society  A student sits down at a desk and is given a #2 pencil, a test, and a time limit. Upon him  rests the expectation that his future will will depend on the result of said test.  Overwhelmed by  the idea of failure and a consequential meaningless life, he cannot concentrate and has a panic  attack.  Too much pressure is placed on young people to succeed on tests that are supposed to be  objective, yet in re...

Words: 838 - Pages: 4