Medallon Computer Hardware & Repair Shop
Medallon Computer Hardware & Repair Shop
Rico B. Barrameda
Paulo P. Rellon
2017
1
I. PROJECT IDENTIFICATION
Paulo P. Rellon
Business Objectives:
1. To create Employment
2
II. BRIEF DISCRIPTION OF THE PROJECT/ BUSINESS
Repair Shop”. The word “Medallon” came from the combination of the
will be located at the San Juan, Polangui, Albay which is near the college
universities, schools and other businesses. The project aims to put up trusted
peripherals and also sells computer parts. The repairing services will reach
the satisfactory of the customers and also offer upgrades of their computers/
laptops but it will depend on the customers if they want to. The products
3
MARKETING
PLAN
4
Product Description
their Home PC computers, laptops and other computer peripherals. The repair
shop will not only offer computer repairs but will also offer limited software
installation. Since software is evolving much more rapidly than hardware, our
clients will have such diverse software needs that we couldn't possibly keep up
with all of them. The following products are the items to be replaced or sold in
the business:
5
Specifications:
Gaming Armor
i7/i5
4th /i3/Pentium®/Celeron®Processors
1 PCIe 3.0 x16, 1 PCIe 2.0 x16, 2 PCIe 2.0 x1, 3 PCI
6
Specifications:
1150 socket
USB Audio Power: Sure Stable 5V Power & Better Signal Transmission over USB
Gaming Device Port: Optimized with Triple Gold-plating for High Polling Rate
Gaming Devices
Price: 10,800.00
7
Intel Core I3-6100 Processor
Specifications:
# of Cores: 2
# of Threads: 4
Cache: 3MB
TDP: 51W
# of Cores: 4
# of Threads: 4
Cache: 3MB
TDP: 65W
8
Intel Core I7-6700K Processor
LGA 1151
Unlocked Processor
Specifications:
Core/Memory
Memory
DisplayPort x 1
HDMI x 1
Dual-link DVI-D x 1
Features
DirectX 12 Ready
9
ASUS GeForce GT 730 2GB 128-bit DDR3 GPU
Specifications:
mm)
Specifications:
Capacity: 8GB
Cas Latency: 15
Voltage: 1.2V
ECC: No
10
Kingston 4GB PC3 DDR3 1333/1600 LV SODIMM
Specifications:
Capacity: 4GB
Cas Latency: 15
Voltage: 1.2V
ECC: No
11
Aerocool STRIKE-X 600W
Power Supply
Input Frequency
50Hz - 60Hz 6 Pin Connectors 2
Range
12
Western Digital Purple WD10PURX 1TB SATA Hard Drives
Specifications
Performance
Cache (MB) 64
13
Western Digital Caviar Blue WD5000AAKX 500GB SATA Hard Drive
Specifications:
• Buffer Size 16 MB
• Capacity 500 GB
14
Sandisk Cruzer Blade USB Flash Drive (4GB, 8GB,
16GB, 32GB)
Specifications:
15
DeepCool CK-11502 INTEL Socket 65W CPU
Cooler
Specifications:
Noise 30.2dB(A)
16
DeepCool Ice Edge 200U Ultra Silent 2
Specifications:
Noise 28.1dB(A)
17
Logitech K120 USB
Wired Keyboard
Specifications:
Type: Wired
Multimedia Keyboard
Specifications:
Ambidextrous design
18
Target Market
Computer Hardware and Repair Shop is very important for those people
who have their own computers. It is very useful nowadays in terms of making
school projects, doing researches and in storing data. The repair shop will offer a
service for affordable price which depends on the damage of the computer.
The Students
We can say that most of the students in this generation have their own
laptops. So that they can make their projects in school and it can be used in
reporting to class. As the time pass by, the number of students who have laptops
and desktop computers are increasing. They have desktop computers with
Business Users
The known business whose using computers are the computer shops in
Polangui. Many of them have their own computer technicians to check and for
maintenance of the computers. But if the technicians cannot fix the computer it
is recommended to go to the repair shop to run diagnostics and will know the
damaged part.
19
The Residents
In this generation, there are always people who are using computers in an
area. The residents who are inside the location’s area are one of the target
markets of the business. There are about 90% of the populations who are using
computers.
Terms of Sale
Computer
Repair Shop
Customer
The service will be directly in the shop. The customer will go to the
computer repair shop to give service which will help them to repair the damaged
computer parts. Some of the problems will took more time because the
technicians will run some tests to identify the damage part of the computer.
20
Price and Pricing
The pricing will depend on the damage. If it’s not that hard to repair or no
need to replace parts it will be affordable. The profit must balance so it will avoid
bankruptcy and to maintain its service to the customer. Table 1A, Table 1B and
laptops and home PC’s. Installation of different programs like MS Word, Adobe
21
The major repair includes the formatting of laptops or desktop personal
latest version.
fee
Video Card ASUS GeForce GT 730 2GB Php 3660.00 Php 500.00
SODIMM
1333/1600 LV SODIMM
22
Power Supply Aerocool STRIKE-X 600W Php 4,788.00 Php 500.00
Power Supply
Western
Internal Hard Digital Purple WD10PURX 1TB Php 4,066.00 Php 500.00
Hard Drive
Keyboard
23
Replacement of parts includes the labor fee. The labor fee depends upon
Projected sales
The estimated sales are stated in daily, weekly and monthly. The tables
will show the projected customers who will buy the product and will come to the
Table 2. Daily
Minor and Major Repair
Number of
Quantity
Computer Viruses
Computer
Operating System
24
The Replacement of parts will not be displayed in the daily sales because
the items to be sold in this category are expensive and not everyone wants to
buy these products. It will be projected in the weekly but not all of the items are
being sold. In the projected sales in monthly, all of the products will be sold.
Number of
Quantity
Computer Viruses
Computer
Operating System
25
Table 3B. Weekly
SODIMM
1333/1600 LV SODIMM
Power Supply
Western 0 0
26
Disk Drive SATA Hard Drives
Hard Drive
Keyboard
The weekly sales of the Replacement of Parts, displays that only the USB
Flash drive will only be sold because we cannot assume that every week the
27
Table 4A. Monthly
Number of
Quantity
Computer Viruses
Computer
Operating System
28
Table 4B. Monthly
Fee
CPU Processor
Processor
Processor
Video Card SF
SODIMM
29
RAM Kingston 4GB PC3 DDR3 1 Php 200.00 Php 1,980.00
1333/1600 LV SODIMM
Power Supply
Western
(8GB)
30
(16GB)
(32GB)
Keyboard
Mouse
6,400.00
SALES
In the monthly sales of the Replacement of Parts, the products are sold to
31
Table 5A. Yearly
Number of
Quantity
Computer Viruses
Computer
Operating System
Table states the yearly projected sales in Minor and Major Repair. We
look after the number of customers on the monthly sales and multiplied it by the
32
Table 5B. Yearly
Fee
6,000.00
Processor 6,000.00
Processor 6,000.00
SODIMM 2,400.00
33
RAM Kingston 4GB PC3 DDR3 12 Php Php 23,760.00
Western
(8GB)
34
(16GB)
(32GB)
Keyboard
Mouse
76,800.00 1,153,740.00
SALES
The yearly sales in the Replacement of Parts are the same on the previous
35
TECHNICAL
PLAN
36
Project Location
and Repair Shop will be located at Centro Occidental, Polangui, Albay which is in
the middle of Casa Cazuela and The Planet of the Vapes and near at Polangui
South Central Elementary School. The total area of the land is 80 square meters
which will cost Php 104,500.00. The location is well suited for the business
because it is just near from the schools, residential areas and other
computers or laptops.
Building Requirements
37
Figure 2A. Perspective View (Back and Left)
38
Figure 2B. Perspective View (Front and Right)
39
Residential Residential Residential
Building
Building Building
1 1
1
1
10
Figure 4. Floor Plan
41
Technical Production Process
Expected total cost for the building process including the labor for
42
Utilities and Tools
Electricity
Electricity is the most needed and vibrant factor in running this kind
Water
establishment and for the use of the comfort room. The fixed payment for
Table 7.
43
Table 8.
Household Equipment
Equipment Price
Table 9.
Other Equipment
Equipment Price
44
Labor Requirements
(3) computer technicians, one (1) saleslady and also one (1) cashier for
Job Description
or specifications of the products and how to use them. The cashier must
be a math-geek and knows how to take a good care of all the money.
Qualifications
Computer Technicians
2. College Graduate
6. Presentable
45
Saleslady
7. Presentable
Cashier
7. Presentable
46
MANAGEMENT
PLAN
47
Form of Business Organization
Owner/Manager
Computer
Cashier
technicians
Owners/Manager
48
Computer technicians
Saleslady
Sales talk
Cashier
Issues receipt
49
FINANCIAL
PLAN
50
FINANCIAL ASSUMPTION
51
Total Projected Cost
A. Fixed Assets
Land and Building Cost 340,000.00
Machine Equipment and Tools 169,500.00
Furniture 15,000.00
Total Fixed Assets 524,500.00
B. Working Capital (One Year Basis)
Purchases (Supplies) 960,780.00
Household Supplies 11,280.00
Utilities Requirement 368,482.80
Salaries and Wages 503,108.40
Office Supplies 25,440.00
Total Working Capital 1,869,091.20
C. Pre-operating Expense
Business Plan 3,000.00
Taxes, Permits and Licenses 2,295.00
Total Pre-operating Capital 5,295.00
D. Contingencies
A = 509,797.00 X 5% 26,225.00
B = 1,869,091.20 X 5% 93,454.56
C = 5,295 X 5% 264.75
Total Contingenccies 119,944.31
52
FINANCIAL SCHEDULES
A. Projected Sales and Cost of Sales (2018)
Number of
Category Customers/ Price Total Price (Annual)
Quantity
Removing of 540 Php 300.00 Php 162,000.00
Computer Viruses
53
Replacement of Parts and other products
Items Brand/Category Quantity Unit Cost Purchase Unit Selling Labor Total Sales
Cost Price Fee (Annual)
ASRock Fatal1ty H97 Php
Performance LGA 1150 12 5,950.00 Php 71,800.00 Php 7,180.00 Php 6,000.00 Php 86,160.00
Motherboard Intel H97 ATX
MSI Z97I Gaming 12 Php Php 129,600.00 Php 12,960.00 Php 6,000.00 Php 155,520.00
10,800.00
Intel Core I3-6100 12 Php Php 68,400.00 Php 6,840.00 Php 6,000.00 Php 82,080.00
CPU Processor 5,700.00
Intel Core I5-6400 12 Php Php 108,000.00 Php 10,800.00 Php 6,000.00 Php 129,600.00
Processor 9,000.00
Intel Core I7-6700 12 Php Php 201,600.00 Php 20,160.00 Php 6,000.00 Php 241,920.00
Processor 16,800.00
MSI GTX 1050 TI 4G OC 12 Php Php 106,920.00 Php 10,692.00 Php 6,000.00 Php 128,304.00
Video Card SF 8,910.00
ASUS GeForce GT 730 12 Php Php 36,600.00 Php 3,660.00 Php 6,000.00 Php 43,920.00
2GB 128-bit DDR3 GPU 3050.00
Kingston 8GB DDR4 2133 12 Php Php 33,600.00 Php 3,360.00 Php 2,400.00 Php 40,320.00
SODIMM 2,800.00
RAM Kingston 4GB PC3 DDR3 Php Php 19,800.00 Php 1,980.00 Php 2,400.00 Php 23,760.00
1333/1600 LV SODIMM 12 1,650.00
54
Internal 1TB SATA Hard Drives
Hard Disk
Western Digital Caviar Php
Drive
Blue WD5000AAKX 500GB 12 2,199.00 Php 26,388.00 Php 2,639.00 Php 6,000.00 Php 31,668.00
SATA Hard Drive
DeepCool CK-11502 INTEL 12 Php 650.00 Php 7,800.00 Php 780.00 Php 6,000.00 Php 9,360.00
Socket 65W CPU Cooler
CPU Fan DeepCool Ice Edge 200U
Ultra Silent 2 HeatPipes 12 Php 950.00 Php 11,400.00 Php 1140.00 Php 6,000.00 Php 13,680.00
Universal 95W CPU Cooler
Sandisk Cruzer Blade 48 Php 245.00 Php 11,760.00 Php 300.00 Php 14,400.00
(4GB)
Sandisk Cruzer Blade 24 Php 325.00 Php 7,800.00 Php 390.00 Php 9,360.00
USB Flash (8GB)
Drive Sandisk Cruzer Blade 12 Php 699.00 Php 8,388.00 Php 840.00 Php 10,080.00
(16GB)
Sandisk Cruzer Blade 12 Php 999.00 Php 11,988.00 Php 1200.00 Php 14,400.00
(32GB)
Keyboard Logitech K120 USB Wired 12 Php 550.00 Php 6,600.00 Php 660.00 Php 7,920.00
Keyboard
Mouse Logitech M105 Optical 12 Php 350.00 Php 4,200.00 Php 420.00 Php 5,040.00
Mouse
SUB-TOTAL 288 Php 960,780.00 Php 76,800.00 Php
1,153,740.00
TOTAL Php
2,592,540.00
55
A. Projected Sales and Cost of Sales (2019)
Number of
Category Customers/ Price Total Price (Annual)
Quantity
Removing of 550 Php 300.00 Php 165,000.00
Computer Viruses
56
Items Brand/Category Quantity Unit Cost Purchase Unit Selling Labor Total Sales
Cost Price Fee (Annual)
ASRock Fatal1ty H97 Php
Performance LGA 1150 Intel 14 5,652.50 Php 79,135.00 Php 6,783.00 Php 6,000.00 Php 94,962.00
Motherboard H97 ATX
MSI Z97I Gaming 14 Php Php Php 12,312.00 Php 6,000.00 Php
10,260.00 143,640.00 172,368.00
Intel Core I3-6100 Processor 14 Php Php 75,810.00 Php 6,498.00 Php 6,000.00 Php 90,972.00
5,415.00
CPU Intel Core I5-6400 Processor 14 Php Php Php 10,260.00 Php 6,000.00 Php
8,550.00 119,700.00 143,640.00
Intel Core I7-6700 Processor 14 Php Php Php 19,152.00 Php 6,000.00 Php
15,960.00 223,440.00 268,128.00
MSI GTX 1050 TI 4G OC SF 14 Php Php Php 10,157.40 Php 6,000.00 Php
Video Card 8,464.50 118,503.00 142,203.60
ASUS GeForce GT 730 2GB 14 Php Php 40,565.00 Php 3,476.50 Php 6,000.00 Php 48,671.00
128-bit DDR3 GPU 2,897.50
Kingston 8GB DDR4 2133 14 Php Php 37,240.00 Php 3,192.00 Php 2,400.00 Php 44,688.00
SODIMM 2,660.00
RAM Kingston 4GB PC3 DDR3 Php Php 21,945.00 Php 1,881.00 Php 2,400.00 Php 26,334.00
1333/1600 LV SODIMM 14 1,567.50
57
Internal SATA Hard Drives
Hard Disk
Western Digital Caviar Blue Php
Drive
WD5000AAKX 500GB SATA 14 2,089.05 Php 29,246.70 Php 2,506.86 Php 6,000.00 Php 35,096.04
Hard Drive
DeepCool CK-11502 INTEL 14 Php Php 8,645.00 Php 741.00 Php 6,000.00 Php 10,374.00
Socket 65W CPU Cooler 617.50
CPU Fan DeepCool Ice Edge 200U Php
Ultra Silent 2 HeatPipes 14 902.50 Php 12,635.00 Php 1083.00 Php 6,000.00 Php 15,162.00
Universal 95W CPU Cooler
Sandisk Cruzer Blade (4GB) 50 Php Php 11,637.00 Php 279.30 Php 13,965.00
232.75
Sandisk Cruzer Blade (8GB) 26 Php Php 8,027.50 Php 370.50 Php 9,633.00
USB Flash 308.75
Drive Sandisk Cruzer Blade (16GB) 14 Php Php 9,296.70 Php 796.86 Php 11,156.04
664.05
Sandisk Cruzer Blade (32GB) 14 Php Php 13,286.70 Php 1138.86 Php 15,944.04
949.05
Keyboard Logitech K120 USB Wired 14 Php Php 7,308.00 Php 626.40 Php 8,769.60
Keyboard 522.00
Mouse Logitech M105 Optical Mouse 14 Php Php 4,655.00 Php 399.00 Php 5,586.00
332.50
SUB-TOTAL 328 Php Php 76,800.00 Php
1,062,843.60 1,275,405.20
TOTAL Php
2,747,205.20
58
B. Projected Sales and Cost of Sales (2020)
Number of
Category Customers/ Price Total Price (Annual)
Quantity
Removing of 560 Php 300.00 Php 168,000.00
Computer Viruses
59
Items Brand/Category Quantity Unit Cost Purchase Unit Selling Labor Total Sales
Cost Price Fee (Annual)
ASRock Fatal1ty H97 Php Php
Performance LGA 1150 Intel 16 5,369.88 Php 85,918.08 Php 6,443.90 Php 6,000.00 103,102.40
Motherboard H97 ATX
MSI Z97I Gaming 16 Php Php Php 11,696.40 Php 6,000.00 Php
9,747.00 155,952.00 187,142.40
Intel Core I3-6100 Processor 16 Php Php 82,308.00 Php 6,173.10 Php 6,000.00 Php 98,769.60
5,144.25
CPU Intel Core I5-6400 Processor 16 Php Php Php 9,747.00 Php 6,000.00 Php
8,122.50 129,960.00 155,952.00
Intel Core I7-6700 Processor 16 Php Php Php 18,194.40 Php 6,000.00 Php
15,162.00 242,592.00 291,110.40
MSI GTX 1050 TI 4G OC SF 16 Php Php Php 9,649.56 Php 6,000.00 Php
Video Card 8,041.30 128,660.80 154,392.96
ASUS GeForce GT 730 2GB 16 Php Php 44,043.20 Php 3,303.24 Php 6,000.00 Php 52,851.84
128-bit DDR3 GPU 2,752.70
Kingston 8GB DDR4 2133 16 Php Php 40,432.00 Php 3,032.40 Php 2,400.00 Php 48,518.40
SODIMM 2,527.00
RAM Kingston 4GB PC3 DDR3 Php Php 23,826.08 Php 1,787.00 Php 2,400.00 Php 28,592.00
1333/1600 LV SODIMM 16 1,489.13
60
Hard Disk Western Digital Caviar Blue Php
Drive WD5000AAKX 500GB SATA 16 1,984.60 Php 31,753.60 Php 2,381.52 Php 6,000.00 Php 38,104.32
Hard Drive
DeepCool CK-11502 INTEL 16 Php Php 9,385.60 Php 704.00 Php 6,000.00 Php 11,264.00
Socket 65W CPU Cooler 586.60
CPU Fan DeepCool Ice Edge 200U Php
Ultra Silent 2 HeatPipes 16 857.40 Php 13,718.40 Php 1028.88 Php 6,000.00 Php 16,462.08
Universal 95W CPU Cooler
Sandisk Cruzer Blade (4GB) 52 Php Php 11,502.40 Php 265.44 Php 13,802.88
221.20
Sandisk Cruzer Blade (8GB) 28 Php Php 8,212.40 Php 352.00 Php 9,856.00
USB Flash 293.30
Drive Sandisk Cruzer Blade (16GB) 16 Php Php 10,092.80 Php 757.00 Php 12,112.00
630.80
Sandisk Cruzer Blade (32GB) 16 Php Php 14,425.60 Php 1082.00 Php 17,312.00
901.60
Keyboard Logitech K120 USB Wired 16 Php Php 7,934.40 Php 595.08 Php 9,521.28
Keyboard 495.90
Mouse Logitech M105 Optical Mouse 16 Php Php 5,054.40 Php 379.08 Php 6,065.28
315.90
SUB-TOTAL 368 Php Php 76,800.00 Php
1,152,302.48 1,374,198.64
TOTAL Php
2,878,998.64
61
C. Salaries Expense for per year (2018-2020)
62
D. DEPRECIATION EXPENSE
63
E. TAXES, PERMITS AND LICENSES
F. UTILITIES
64
G. BUSINESS TAX
H. INCOME TAX
65
I. OPERATING EXPENSE
66
K. WITHHOLDING TAX
67
J. FACTORY OVERHEAD
68
Gross Income 1,631,760.00 1,684,361.60 1,726,696.16
69
MEDALLON COMPUTER HARDWARE & REPAIR SHOP
STATEMENT OF FINANCIAL POSITION
For the year 2018-2020
70
LIABILITIES AND PARTNER’S EQUITY
71
MEDALLON COMPUTER HARDWARE & REPAIR SHOP
CASH FLOW STATEMENT
For the year 2018-2020
Cash Flow Provided by
Operation Schedule 2018 2019 2020
Net Income SFP 54,830.30 313,071.88 325,438.134
Add: Depreciation E 79,611.75 106,149.00 106,149.00
Increase (Decrease)
In Liabilities 377,848.60 266,509.33 28,181.444
Net Cash Provide
By Operation 522,582.75 685,730.21 459,768.578
Cash Flow from Investment
Acquisition of Property,
Plant and Equipment (524,500.00)
Disposal of Fixed -
Assets
Net Cash Provide By Investment (524,500.00)
Cash Flow from Financing
Activities
Partnerships Investment TPC 2,508,240.51 - -
Withdrawals - - -
Net Cash from Financing 2,508,240.51
Activity
Net Cash Flow 2,506,323.26 685,730.21 459,768.578
Add: Cash Beginning - 2,506,323.26 3192053.47
CASH BALANCE, END 2,506,323.26 3,192,053.47 3,651,822.048
72
Table 11. FINANCIAL ANALYSIS
YEAR NET INCOME NET SALES
73
c. Return of Sales = Average Net Income X 100
Total Net Sales
= 234,544.138 X 100
2,739,581.28
= 8.56%
74
Conclusion
The payback period of the proposed business project is approximately 10 years and 6 months. It will be a success
75