ISYS2059 Business Computing Sem 2 2019: HOLDinONE Report Analysis

This report analyzes the financial data and operational aspects of the HOLDinONE company, a provider of golfing services to the Royal Corroboree Frog Golf Course (RCFGC). The analysis includes a detailed examination of equipment costs, instructor costs, and service codes. The report presents findings on the base fees and expense costs of various equipment, such as golf ball vending machines, golf carts, and walk-behind buggies, highlighting the impact of nominal leasing fees. It also assesses the costs and session numbers of different instructors, identifying the most profitable instructors. Furthermore, the report examines service codes and discounted prices, providing recommendations to maximize profits by optimizing equipment purchases and instructor selection, and by considering the impact of discounted service codes on overall revenue. The report concludes with recommendations for the HOLDinONE company to improve profitability and efficiency.

BUSINESS INFORMATION SYSTEMS
STUDENT NAME/ NUMBER
BUSINESS COMPUTING 1
ISYS2059
TUTOR’S TIME AND NAME

Table of Contents
Results and Discussions...............................................................................................................................2
Equipment’s base fee and expense cost..................................................................................................2
Instructor’s cost and number of sessions................................................................................................3
Service codes and discounted price.........................................................................................................4
Recommendations.......................................................................................................................................4

Results and Discussions
Equipment’s base fee and expense cost
Table 1
Row Labels Sum of Base
Fee
Sum of Total Expense
Cost
Golf Ball Vending Machine 20000 50000
Golf Cart 1500 15000
Golf GPS 550 5500
Nominal Leasing Fee 4000 10000
WalkBehind Buggy 800 16000
Grand Total 26850 96500
From the table 1 above the total amount used on the Golf Ball Vending Machine is $ 50,000
which is the highest amount on the expense cost. The least amount on expense cost is $ 5,500
which is for Golf GPS. The total expense cost on the above equipment’s including the nominal
leasing fee is $ 96,000. The base fee of Golf Ball Vending Machine is still higher than that of
Golf Cart, Golf GPS and Walk Behind Buggy. Furthermore its base fee is $ 20,000. The Golf
GPS had the least base fee of $ 550. The quantity of Walk Behind Buggy was the highest and
Golf Ball Vending Machine had the least quantity which was 20 and 4 respectively.
From the results above for maximum profit to be achieved, the equipment which had the highest
quantity that is the equipment which is needed in large quantity should have a base fee and
expense cost is relatively affordable so that they are purchased. Moreover, the nominal leasing
fee is very higher hence contributing to the grand base fee and expense cost to be higher as well
which reduces the maximum profit achieved.

Instructor’s cost and number of sessions
Table 2
Row Labels Sum of Total Instructor
Cost
Sum of No of
Sessions
A 3600 1724
K 4250 2105
T 3200 1712
V 3750 2196
Grand Total 14800 7737
From table 2 above, there are four instructors which have been coded as A, K, T and V. Each
instructor have different number of sessions with instructor V having the highest number of
sessions followed relatively close by instructor K and instructor T had the least number of
sessions. In addition, instructor K was very costly while instructor T was relatively cheap.
Instructor V had the highest gross profit of $1980 whereas instructor A had the least gross profit
of $ 984. Both the instructor K and T had a gross profit which was relatively close. The grand
total gross profits that were made by the four instructors were $ 5,828.

Service codes and discounted price
Graph 4
Sum of Discounted Price
B40 B80 D10
D20 GC1 GPS
WB1
From the graph 4 above, the service code B80 had the highest discounted price of 72 followed
closely by the service B40 which had discounted price of 36. The following service codes didn’t
have the discounted price; they include WB1, GPS and GCI. Services codes that didn’t have the
discount prices, their base price resulted into their total income. The service code GCI had no
discounted price and therefore had the highest base price of $ 160. Furthermore, service code
B80 had the highest discounted price with a base price of $ 80. This could be as a result of the
discounted price hence making the base price to increase as well.
Recommendations
From the results on table 1 it is observed that the Golf Ball Vending Machine was costly and
their quantity were few while Walk Behind Buggy was relatively cheap. However, their
quantities were very huge. This was because Golf Ball Vending Machine was expensive.
Therefore, maximum profit would only be achieved by the HOLD in ONE company by ensuring
that the quantities of Golf Ball Vending Machine that were purchased were few this ensures that

there quantities as well decreases. In addition, the quantity of Walk Behind Buggy was high
simply because of low cost hence they were purchased mostly by the firm. Therefore, I would
recommend the purchase of Walk Behind Buggy equipment’s to the Golf Ball vending M achine
based on their cost.
From the results above instructor V had many sessions but low cost as compared to instructor K
who had many sessions as well but high cost. Only instructor T had fewer sessions with less cost.
Therefore, the HOLD in ONE company could only maximize profit if they prefer hiring
instructor V. This is because this instructor had many lessons at a low instructor cost. I would
recommend instructor V to be considered for the lessons as he or she contributes to the company
in maximizing the profit.
Furthermore, I would recommend that for higher income the service codes should not be
discounted. However if the company want to maximize profit I would recommend the
introduction of discount on the service codes.

Appendix
Figure 1 – Screenshot of vlookup function