0% found this document useful (0 votes)
199 views75 pages

Medallon Computer Hardware & Repair Shop

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
199 views75 pages

Medallon Computer Hardware & Repair Shop

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 75

Medallon Computer Hardware & Repair Shop

A Business Plan Prepared and Submitted in Partial Fulfillment

For the Requirement in AS 41: Entrepreneurship

Rico B. Barrameda

Paulo P. Rellon

2017

1
I. PROJECT IDENTIFICATION

Name of the Enterprise/Business: Medallon Computer

Hardware & Repair Shop

Name of the Entrepreneurs: Rico B. Barrameda

Paulo P. Rellon

Form of Business: Partnership

Nature of Business: Products and Services

Contact Number: 09123456789

Project Location: San Juan, Polangui, Albay

Financial Source: Partner’s Equity

Project Cost: Php 2,500,000.00

Project Duration: Seven Months

Business Objectives:

1. To create Employment

2. To provide computer services to the citizens of Polangui, Albay

3. To gain profit to sustain the operation of the business

2
II. BRIEF DISCRIPTION OF THE PROJECT/ BUSINESS

The proposed project will be named as “Medallon Computer Hardware &

Repair Shop”. The word “Medallon” came from the combination of the

surnames of the entrepreneurs which is BarraMEDA and ReLLON. The project

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

and professional services to help the customers in repairing computer

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

offered by the business have very good specifications.

3
MARKETING

PLAN

4
Product Description

The business will accommodate the needs of the customer in repairing

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:

 ASRock Fatal1ty H97 Performance LGA

1150 Intel H97 ATX Motherboard

 ASRock Super Alloy

 Gaming Armor

 Supports 5th Generation Intel® Core™

i7/i5

 Supports New 4th and

4th /i3/Pentium®/Celeron®Processors

(Socket 1150) Generation Intel® Xeon®/Core™

i7/i5/i3/Pentium®/Celeron® Processors (Socket 1150)

 1 PCIe 3.0 x16, 1 PCIe 2.0 x16, 2 PCIe 2.0 x1, 3 PCI

 Supports AMD Quad CrossFireX™ and CrossFireX™

 Graphics Output Options: D-Sub, DVI-D, HDMI

 7.1 CH HD Audio with Content Protection (Realtek ALC1150 Audio Codec),

Supports DTS Connect

 Price: Php 5950.00

6
Specifications:

 MSI Z97I Gaming AC Features

 Supports 4th and 5th Gen Intel Core /

Pentium / Celeron processors for LGA

1150 socket

 Supports DDR3-3300(OC) Memory

 USB 3.0 + SATA 6Gb/s + eSATA 6Gb/s

 Audio Boost 2: Reward Your Ears with True Quality

 Killer Ethernet: Kill Your Lag

 USB Audio Power: Sure Stable 5V Power & Better Signal Transmission over USB

 XSplit Gamecaster: Show off Your Skills and Achievements

 Guard-Pro: Improved Protection and Power Efficiency

 OC Genie 4: Overclock in 1 Second

 Gaming App: Boost Your Frame Rate

 Click BIOS 4: Easily Fine-tune Your System

 Sound Blaster Cinema 2: Realistic Surround Sound Experience

 Gaming Device Port: Optimized with Triple Gold-plating for High Polling Rate

Gaming Devices

 Wi-Fi 802.11ac, Bluetooth 4.0, Intel® Wireless Display

 Price: 10,800.00

7
Intel Core I3-6100 Processor

Specifications:

 # of Cores: 2

 # of Threads: 4

 Processor Base Frequency: 3.7Ghz

 Cache: 3MB

 TDP: 51W

 Instruction Set: 64-bit

Price: Php 5,700.00

Intel Core I5-6400 Processor

 # of Cores: 4

 # of Threads: 4

 Processor Base Frequency: 2.7Ghz

Max Turbo Frequency: 3.3Ghz

 Cache: 3MB

 TDP: 65W

Price: Php 9,000.00

8
Intel Core I7-6700K Processor

 LGA 1151

 Unlocked Processor

 DDR4 & DDR3L Support

 Display Resolution up to 4096×2304

 Intel Turbo Boost Technology

Price: Php 16,800.00

Specifications:

 MSI GTX 1050 TI 4G OC SF

Core/Memory

 Boost Clock / Base Clock

1455 MHz / 1341 MHz

 4096 MB GDDR5 / 7008 MHz

Memory

Video Output Function

 DisplayPort x 1

 HDMI x 1

 Dual-link DVI-D x 1

Features

 DirectX 12 Ready

 Gamestream to NVIDIA® SHIELD

 Price: PHP 8,910.00

9
ASUS GeForce GT 730 2GB 128-bit DDR3 GPU

Specifications:

 Memory clock: 800MHz

 Memory Bandwidth: 25.6 GB/s

 6.42 inches (163 mm) x 4.37 inches (111

mm)

 Price: Php 3050.00

Kingston 8GB DDR4 2133 SODIMM

Specifications:

 Capacity: 8GB

 Type: 260-Pin DDR4 SO-DIMM

 Speed: DDR4 2133 (PC4 17000)

 Cas Latency: 15

 Voltage: 1.2V

 ECC: No

 Price: Php 2,800.00

10
Kingston 4GB PC3 DDR3 1333/1600 LV SODIMM

Specifications:

 Capacity: 4GB

 Type: 260-Pin DDR4 SO-DIMM

 Speed: DDR4 2133 (PC4 17000)

 Cas Latency: 15

 Voltage: 1.2V

 ECC: No

 Price: Php 1,650.00

11
Aerocool STRIKE-X 600W

Power Supply

Capacity 600W +12V Output 50A

Form Factor ATX12V +12V Count 1

80 Plus Rating Bronze Fan Size 140mm

Efficiency at 100% 82.57% Modular no

Efficiency at 50% 86.87% Silent no

Efficiency at 20% 86.13% 24 Pin Mobo


yes
Connector

4+4 Pin CPU


Localization United States yes
Connector

Input Voltage 100V - 240V 8 Pin Connectors 3

Input Frequency
50Hz - 60Hz 6 Pin Connectors 2
Range

+3.3V Output 24A 4 Pin Connectors 5

+5V Output 24A SATA Connector 4

Price: Php 3,990.00

12
Western Digital Purple WD10PURX 1TB SATA Hard Drives

Specifications

Model number WD10PURX

Formatted capacity 1TB / 1000GB

Form factor 3.5-inch LFF

Advanced Format (AF) Yes

RoHS compliant Yes

Performance

Data transfer rate (max)

Buffer to host 6 Gb/s

Host to/from drive (sustained) 110 MB/s

Cache (MB) 64

Rotational speed (RPM) 5400 RPM Class

Price: Php 3,388.00

13
Western Digital Caviar Blue WD5000AAKX 500GB SATA Hard Drive

Specifications:

• Rotational Speed 7,200 RPM (nominal)

• Buffer Size 16 MB

• Read Seek Time 8.9 ms (average)

• Buffer To Disk 128 Mb/s (Max)

• Formatted Capacity 500,107 MB

• Capacity 500 GB

• Interface SATA 6 Gb/s

• User Sectors Per Drive 976,773,168

Price: Php 2,199.00

14
Sandisk Cruzer Blade USB Flash Drive (4GB, 8GB,

16GB, 32GB)

Specifications:

 Compatibility: Windows® XP, Windows Vista®,

Windows 7, Mac OS X v10.5+ and Linux

 SanDisk SecureAccess™ software: Windows XP,

Windows Vista, Windows 7 and Mac OS X v10.5+

 Capacities: 4GB, 8GB, 16GB, and 32GB

 USB port: USB 2.0 port required for high-speed transfer

 Material: Silicone and plastic

 Dimensions: 41.50mm x 17.60mm x 7.40mm (1.63 x 0.69 x 0.29 in)

 Operating temperature: 0°C to 45°C

 Storage temperature: -10°C to 70°C

 Support: Five-year limited warranty

 Price: Php 245.00 (4GB)

 Price: Php 325.00 (8GB)

 Price: Php 699.00 (16GB)

 Price: Php 999.00 (32GB)

15
DeepCool CK-11502 INTEL Socket 65W CPU

Cooler

Specifications:

Overall Dimension 97.5X97.5X54mm

Fan Dimension 100X100X25mm

Net Weight 244g

Bearing Type Hydro Bearing

Rated Voltage 12VDC

Operating Voltage 10.8~13.2VDC

Started Voltage 7VDC

Rated Current 0.11�10%A(MAX)

Power Input 1.32W

FAN Speed 2200�10%RPM

MAX.Air Flow 38.1CFM

Noise 30.2dB(A)

Price: Php 650.00

16
DeepCool Ice Edge 200U Ultra Silent 2

HeatPipes Universal 95W CPU Cooler

Specifications:

Overall Dimension 123.5X77X129mm

Fan Dimension 92X92X25mm

Net Weight 409g

Bearing Type Hydro Bearing

Rated Voltage 12VDC

Operating Voltage 10.8~13.2VDC

Started Voltage 7VDC

Rated Current 0.10�10%A(MAX)

Power Input 1.2W

FAN Speed 2200�10%RPM

MAX.Air Flow 39.58CFM

Noise 28.1dB(A)

Price: Php 950.00

17
Logitech K120 USB

Wired Keyboard

Specifications:

 Type: Wired

Multimedia Keyboard

 Interface/Connectivity: USB interface

 Installation: Plug and Play

 Compatibility/System requirements: Windows 8, Windows 7, or Windows Vista,

Mac OS X 10.5 or later, USB Port

 Number of keys: 104 keys

Price: Php 550.00

Logitech M105 Optical Mouse

Specifications:

 Plug and play

 Ambidextrous design

 1000 dpi for smooth and precise cursor control

 Comfortable, contoured shape

 1.5 meter cable length

 Works with Windows XP, Vista, 7 and 8

Price: Php 350.00

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

printer to get the output copy of the document.

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

Figure 1. Channel of Distribution

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

Table 1C states the pricing of the shop in different categories.

Table 1A. Minor Repair

Minor repair Price

Removing of computer viruses Php 300.00

Software installation Php 500.00

Disk cleanup Php 200.00

Hardware cleanup Php 300.00

Minor repair includes the basic removing of viruses in USB Flashdrive,

laptops and home PC’s. Installation of different programs like MS Word, Adobe

Photoshop, AutoCAD and many more programs.

Table 1B. Major Repair

Major repair Price

Formatting computers Php 1000.00

Upgrading of OS Php 1000.00

21
The major repair includes the formatting of laptops or desktop personal

computers. The upgrading of computer OS if they want to change their OS to

latest version.

Table 1C. Replacement of Parts and Other Products

Items Brand/Category Price Labor

fee

ASRock Fatal1ty H97

Performance LGA 1150 Intel Php 7,180.00

Motherboard H97 ATX Php 500.00

MSI Z97I Gaming Php 12,960.00

Intel Core I3-6100 Processor Php 6,840.00

CPU Intel Core I5-6400 Processor Php 10,800.00 Php 500.00

Intel Core I7-6700 Processor Php 20,160.00

MSI GTX 1050 TI 4G OC SF Php 10,692.00

Video Card  ASUS GeForce GT 730 2GB Php 3660.00 Php 500.00

128-bit DDR3 GPU

Kingston 8GB DDR4 2133 Php 3,360.00

SODIMM

RAM Kingston 4GB PC3 DDR3 Php 1,980.00 Php 200.00

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

Disk Drive SATA Hard Drives

Western Digital Caviar Blue Php 500.00

WD5000AAKX 500GB SATA Php 2,639.00

Hard Drive

DeepCool CK-11502 INTEL Php 780.00

Socket 65W CPU Cooler

CPU Fan DeepCool Ice Edge 200U Php 500.00

Ultra Silent 2 HeatPipes Php 1140.00

Universal 95W CPU Cooler

Sandisk Cruzer Blade (4GB) Php 300.00

USB Flash Sandisk Cruzer Blade (8GB) Php 390.00

Drive Sandisk Cruzer Blade (16GB) Php 840.00

Sandisk Cruzer Blade (32GB) Php 1200.00

Keyboard Logitech K120 USB Wired Php 660.00

Keyboard

Mouse Logitech M105 Optical Mouse Php 420.00

23
Replacement of parts includes the labor fee. The labor fee depends upon

the part to be changed.

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

business site to fix their damaged computers.

Table 2. Daily
Minor and Major Repair
Number of

Category Customers/ Price

Quantity

Removing of 2 Php 500.00

Computer Viruses

Software Installation 2 Php 1,000.00

Disk Cleanup 2 Php 200.00

Hardware Cleanup 1 Php 150.00

Formatting of 1 Php 750.00

Computer

Upgrading of 1 Php 1,000.00

Operating System

TOTAL 9 Php 3,600.00

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.

Table 3A. Weekly

Minor and Major Repair

Number of

Category Customers/ Price

Quantity

Removing of 15 Php 3,750.00

Computer Viruses

Software Installation 8 Php 4,000.00

Disk Cleanup 8 Php 800.00

Hardware Cleanup 8 Php 1,200.00

Formatting of 4 Php 3,000.00

Computer

Upgrading of 4 Php 4,000.00

Operating System

TOTAL 29 Php 16,750.00

25
Table 3B. Weekly

Replacement of Parts and Other Products

Items Brand/Category Quantity Price

ASRock Fatal1ty H97

Performance LGA 1150 Intel 0 0

Motherboard H97 ATX

MSI Z97I Gaming 0 0

Intel Core I3-6100 Processor 0 0

CPU Intel Core I5-6400 Processor 0 0

Intel Core I7-6700 Processor 0 0

MSI GTX 1050 TI 4G OC SF 0 0

Video Card  ASUS GeForce GT 730 2GB 0 0

128-bit DDR3 GPU

Kingston 8GB DDR4 2133 0 0

SODIMM

RAM Kingston 4GB PC3 DDR3 0 0

1333/1600 LV SODIMM

Power Supply Aerocool STRIKE-X 600W 0 0

Power Supply

Western 0 0

Internal Hard Digital Purple WD10PURX 1TB

26
Disk Drive SATA Hard Drives

Western Digital Caviar Blue

WD5000AAKX 500GB SATA 0 0

Hard Drive

DeepCool CK-11502 INTEL 0 0

Socket 65W CPU Cooler

CPU Fan DeepCool Ice Edge 200U

Ultra Silent 2 HeatPipes 0 0

Universal 95W CPU Cooler

Sandisk Cruzer Blade (4GB) 2 Php 600.00

USB Flash Sandisk Cruzer Blade (8GB) 1 Php 390.00

Drive Sandisk Cruzer Blade (16GB) 0 0

Sandisk Cruzer Blade (32GB) 0 0

Keyboard Logitech K120 USB Wired 0 0

Keyboard

Mouse Logitech M105 Optical Mouse 0 0

TOTAL 3 Php 990.00

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

customers will buy the rest of the products.

27
Table 4A. Monthly

Minor and Major Repair

Number of

Category Customers/ Price

Quantity

Removing of 45 Php 13,500.00

Computer Viruses

Software Installation 45 Php 22,500.00

Disk Cleanup 35 Php 7,000.00

Hardware Cleanup 35 Php 10,500.00

Formatting of 30 Php 30,000.00

Computer

Upgrading of 30 Php 30,000.00

Operating System

TOTAL 200 Php 113,500.00

The monthly sales show that there is an increase in number of the

customers that go to the business establishment.

28
Table 4B. Monthly

Replacement of Parts and Other Products

Items Brand/Category Quantity Labor Price

Fee

ASRock Fatal1ty H97

Performance LGA 1150 1 Php 500.00 Php 7,180.00

Motherboard Intel H97 ATX

MSI Z97I Gaming 1 Php 500.00 Php 12,960.00

Intel Core I3-6100 1 Php 500.00 Php 6,840.00

CPU Processor

Intel Core I5-6400 1 Php 500.00 Php 10,800.00

Processor

Intel Core I7-6700 1 Php 500.00 Php 20,160.00

Processor

MSI GTX 1050 TI 4G OC 1 Php 500.00 Php 10,692.00

Video Card SF

ASUS GeForce GT 730 1 Php 500.00 Php 3,660.00

2GB 128-bit DDR3 GPU

Kingston 8GB DDR4 2133 1 Php 200.00 Php 3,360.00

SODIMM

29
RAM Kingston 4GB PC3 DDR3 1 Php 200.00 Php 1,980.00

1333/1600 LV SODIMM

Power Aerocool STRIKE-X

Supply 600W 1 Php 500.00 Php 4,788.00

Power Supply

Western

Digital Purple WD10PURX 1 Php 500.00 Php 4,066.00

Internal 1TB SATA Hard Drives

Hard Disk Western Digital Caviar

Drive Blue WD5000AAKX 500GB 1 Php 500.00 Php 2,639.00

SATA Hard Drive

DeepCool CK-11502 INTEL 1 Php 500.00 Php 780.00

Socket 65W CPU Cooler

CPU Fan DeepCool Ice Edge 200U

Ultra Silent 2 HeatPipes 1 Php 500.00 Php 1,140.00

Universal 95W CPU Cooler

Sandisk Cruzer Blade 4 Php 1,200.00

USB Flash (4GB)

Drive Sandisk Cruzer Blade 2 Php 780.00

(8GB)

Sandisk Cruzer Blade 1 Php 840.00

30
(16GB)

Sandisk Cruzer Blade 1 Php 1,200.00

(32GB)

Keyboard Logitech K120 USB Wired 1 Php 660.00

Keyboard

Mouse Logitech M105 Optical 1 Php 420.00

Mouse

TOTAL 24 Php Php 99,345.00

6,400.00

TOTAL Php 105,745.00

SALES

In the monthly sales of the Replacement of Parts, the products are sold to

the customers with its labor fee.

31
Table 5A. Yearly

Minor and Major Repair

Number of

Category Customers/ Price

Quantity

Removing of 540 Php 162,000.00

Computer Viruses

Software Installation 540 Php 270,000.00

Disk Cleanup 420 Php 84,000.00

Hardware Cleanup 420 Php 126,000.00

Formatting of 360 Php 360,000.00

Computer

Upgrading of 360 Php 360,000.00

Operating System

TOTAL 2400 Php 1,362,000.00

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

number of months per year.

32
Table 5B. Yearly

Replacement of Parts and Other Products

Items Brand/Category Quantity Labor Price

Fee

ASRock Fatal1ty H97 Php

Performance LGA 1150 12 6,000.00 Php 86,160.00

Motherboard Intel H97 ATX

MSI Z97I Gaming 12 Php Php 155,520.00

6,000.00

Intel Core I3-6100 12 Php Php 82,080.00

CPU Processor 6,000.00

Intel Core I5-6400 12 Php Php 129,600.00

Processor 6,000.00

Intel Core I7-6700 12 Php Php 241,920.00

Processor 6,000.00

MSI GTX 1050 TI 4G OC 12 Php Php 128,304.00

Video Card SF 6,000.00

ASUS GeForce GT 730 12 Php Php 43,920.00

2GB 128-bit DDR3 GPU 6,000.00

Kingston 8GB DDR4 2133 12 Php Php 40,320.00

SODIMM 2,400.00

33
RAM Kingston 4GB PC3 DDR3 12 Php Php 23,760.00

1333/1600 LV SODIMM 2,400.00

Power Aerocool STRIKE-X

Supply 600W 12 Php Php 57,456.00

Power Supply 6,000.00

Western

Digital Purple WD10PURX 12 Php Php 48,792.00

Internal 1TB SATA Hard Drives 6,000.00

Hard Disk Western Digital Caviar

Drive Blue WD5000AAKX 500GB 12 Php Php 31,668.00

SATA Hard Drive 6,000.00

DeepCool CK-11502 INTEL 12 Php Php 9,360.00

Socket 65W CPU Cooler 6,000.00

CPU Fan DeepCool Ice Edge 200U

Ultra Silent 2 HeatPipes 12 Php Php 13,680.00

Universal 95W CPU Cooler 6,000.00

Sandisk Cruzer Blade 48 Php 14,400.00

USB Flash (4GB)

Drive Sandisk Cruzer Blade 24 Php 9,360.00

(8GB)

Sandisk Cruzer Blade 12 Php 10,080.00

34
(16GB)

Sandisk Cruzer Blade 12 Php 14,400.00

(32GB)

Keyboard Logitech K120 USB Wired 12 Php 7,920.00

Keyboard

Mouse Logitech M105 Optical 12 Php 5,040.00

Mouse

TOTAL 288 Php Php

76,800.00 1,153,740.00

TOTAL Php 1,230,540.00

SALES

The yearly sales in the Replacement of Parts are the same on the previous

table which is also multiplied by the number of months each year.

35
TECHNICAL

PLAN

36
Project Location

One of the most important factors of a business in order for it to be

profitable is the project location. The business, Medallon Computer Hardware

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

establishments where lots of students, teachers, residents, and businessmen use

computers or laptops.

Building Requirements

The building is designed simple but will be built strongly.

37
Figure 2A. Perspective View (Back and Left)
38
Figure 2B. Perspective View (Front and Right)
39
Residential Residential Residential
Building
Building Building

Figure 3. Vicinity Map


40
2

1 1
1

1
10
Figure 4. Floor Plan

41
Technical Production Process

Expected total cost for the building process including the labor for

the constructors is Php 220,000.00.

Table 6. Materials for the Building

Materials Market Price Quantity Total Cost

Cement (Class A) Php 235.00/m3 19m3 Php 4,465.00


Gravel (Class A) Php 500.00/m3 37m3 Php 18,500.00
Sand (Class A) Php 400.00/m3 26m3 Php 10,400.00
Stir ups (16 mm2) (9m) Php 285.00/piece 34 pieces Php 9,690.00
Stir ups (16 mm2) (12m) Php 379.00/piece 47 pieces Php 17,813.00
Stir ups (16 mm2) (6m) Php 190.00/piece 54 pieces Php 10,260.00
Floor Tiles 40x40 Php 18.25/piece 1000 pieces Php 18,250.00
Boysen Paint 16L Php 2,304.00 80L Php 11,520.00
Nails Php 45.00/kilo 20 kilos Php 900.00
Flush Valve Toilet Php 5,399.00 1 piece Php 5,399.00
8’’ Concrete Hollow Block Php 12.00 250 pieces Php 3,000.00
Coco lumber 2x3x12 Php 95.00 100 pieces Php 9,500.00
Plywood Php 300.00 50 pieces Php 15,000.00
Tie Wires Php 60.00/kilo 10 kilos Php 600.00
Electrical works Php 47,860.00 --- Php 47,860.00
Water Distribution System Php 6,980.00 --- Php 6,980.00
Window Php 370.00/set 7 sets Php 2,590.00
Doors Php 3,400.00 4 sets Php 3,400.00
Glass Walls Php 10,000.00 --- Php 10,000.00
Total Php 206,127.00

42
Utilities and Tools

Electricity

Electricity is the most needed and vibrant factor in running this kind

of business. It will be supplied by Albay Power Electric Cooperative (APEC)

where Php 6.7682 is the rate per kilowatt.

Water

Water is needed for maintaining the cleanliness of the

establishment and for the use of the comfort room. The fixed payment for

the water is Php 250.00.

Table 7.

Annual Electricity and Water Consumption

Depreciation Monthly Cost Yearly Cost

Electricity Php 30, 456.90 Php 365,482.80

Water Php 250.00 Php 3,000.00

Total Php 30,706.90 Php 368,482.80

43
Table 8.

Household Equipment

Equipment Price

2 Soft broom Php 120.00

Mop Php 400.00

CR Cleaning Tools Php 500.00

Total Php 1,020.00

Table 9.

Other Equipment

Equipment Price

7 CCTVs Php 87,500.00

4 air conditioners Php 42,000.00

Tools in repairing Php 5000.00

Office Packaged Computer Set Php 35,000.00

Office supplies Php 2,120.00

Furniture Php 15,000.00

Total Php 186,620.00

44
Labor Requirements

The proposed project will have 5 laborers. It will compose of three

(3) computer technicians, one (1) saleslady and also one (1) cashier for

8:00 A.M. to 8 P.M. They will be considered as regular employees if they

attained 24 working hours.

Job Description

The computer technicians, saleslady and cashier must all have a

pleasing personality. The computer technicians must be also an expert in

repairing computers. The saleslady must be knowledgeable on the details

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

1. Male of legal age (18-35 years old)

2. College Graduate

3. Has no Pejorative Record

4. Must have a good moral character

5. Must be hard working, loyal and punctual

6. Presentable

45
Saleslady

1. Female of legal age (18-25 years old)

2. At least high school graduate

3. Has no Pejorative Record

4. Must have a good moral character

5. Must be hard working, loyal and punctual

6. Knowledgeable with the products

7. Presentable

Cashier

1. Female of legal age (18-25 years old)

2. At least high school graduate

3. Has no Pejorative Record

4. Must have a good moral character

5. Must be hard working, loyal and punctual

6. Must be good in computations

7. Presentable

Table 10. Wages

Employee Wage per Day

Computer Technicians Php 250.00 each

Saleslady Php 240.00

Cashier Php 250.00

46
MANAGEMENT

PLAN

47
Form of Business Organization

Owner/Manager

Computer
Cashier
technicians

Figure 5. Organizational Chart

Organizational Structure and Activities

The business will be managed by the owner and have 3 computer

technicians and 1 cashier.

Owners/Manager

Duties and Responsibilities

 Formulates marketing strategies.

 Maintaining the quality control of the business.

 Has authority and responsibilities on his employees.

48
Computer technicians

Duties and Responsibilities:

 Run diagnostics on the computers.

 Repairs the damaged computers.

 Software installation and formatting of computers.

 Replace parts of the computer hardware.

Saleslady

Duties and Responsibilities:

 Sales talk

 Keeping the products clean and safe

 Accompanying the customers

Cashier

Duties and Responsibilities:

 Issues receipt

 Computes and records total transactions.

 Processes payments from the customers.

49
FINANCIAL
PLAN

50
FINANCIAL ASSUMPTION

1. Contingencies are assumed to be 5% of working capital.

2. Products are assumed to decrease 5% annually.

3. Preparation of business plan is estimated Php 3,000.

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

TOTAL PROJECTED COST Php 2,508,240.51

52
FINANCIAL SCHEDULES
A. Projected Sales and Cost of Sales (2018)

Minor and Major Repair

Number of
Category Customers/ Price Total Price (Annual)
Quantity
Removing of 540 Php 300.00 Php 162,000.00
Computer Viruses

Software Installation 540 Php 500.00 Php 270,000.00

Disk Cleanup 420 Php 200.00 Php 84,000.00

Hardware Cleanup 420 Php 300.00 Php 126,000.00

Formatting of 360 Php 1000.00 Php 360,000.00


Computer

Upgrading of 360 Php 1000.00 Php 360,000.00


Operating System

TOTAL 2640 Php 1,362,000.00

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

Power Aerocool STRIKE-X Php Php 47,880.00 Php 4,788.00


Supply 600W 12 3,990.00 Php 6,000.00 Php 57,456.00
Power Supply
Western Php
Digital Purple WD10PURX 12 3,388.00 Php 40,656.00 Php 4,066.00 Php 6,000.00 Php 48,792.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)

Minor and Major Repair

Number of
Category Customers/ Price Total Price (Annual)
Quantity
Removing of 550 Php 300.00 Php 165,000.00
Computer Viruses

Software Installation 550 Php 500.00 Php 275,000.00

Disk Cleanup 430 Php 200.00 Php 86,000.00

Hardware Cleanup 430 Php 300.00 Php 129,000.00

Formatting of 370 Php 1000.00 Php 370,000.00


Computer

Upgrading of 370 Php 1000.00 Php 370,000.00


Operating System

TOTAL 2460 Php 1,395,000.00

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

Power Aerocool STRIKE-X Php


Supply 600W 14 3,790.50 Php 53,067.00 Php 4,548.60 Php 6,000.00 Php 63,680.40
Power Supply
Western Php
Digital Purple WD10PURX 1TB 14 3,218.60 Php 45,060.40 Php 3862.32 Php 6,000.00 Php 54,072.48

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)

Minor and Major Repair

Number of
Category Customers/ Price Total Price (Annual)
Quantity
Removing of 560 Php 300.00 Php 168,000.00
Computer Viruses

Software Installation 560 Php 500.00 Php 280,000.00

Disk Cleanup 440 Php 200.00 Php 88,000.00

Hardware Cleanup 440 Php 300.00 Php 132,000.00

Formatting of 380 Php 1000.00 Php 380,000.00


Computer

Upgrading of 380 Php 1000.00 Php 380,000.00


Operating System

TOTAL 2520 Php 1,428,000.00

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

Power Aerocool STRIKE-X Php


Supply 600W 16 3,600.50 Php 57,608.00 Php 4,320.60 Php 6,000.00 Php 69,129.60
Power Supply
Western Php
Digital Purple WD10PURX 1TB 16 3,057.67 Php 48,922.72 Php 3669.20 Php 6,000.00 Php 58,707.20
Internal SATA Hard Drives

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)

Employees Monthly Salary SSS Phil-Health Pag-ibig Total


Computer Technician 1 Php 7,500.00 552.50 200.00 200.00
Computer Technician 2 Php 7,500.00 552.50 200.00 200.00
Computer Technician 3 Php 7,500.00 552.50 200.00 200.00
Cashier Php 7,500.00 552.50 200.00 200.00
Saleslady Php 7,200.00 515.70 200.00 200.00
Total Php 37,200.00 Php 2,725.7 Php 1,000.00 Php 1,000.00
Multiplied by the 12 12 12 12
number of months
Total Direct Labor Php 446,400.00 Php 32708.4 Php 12,000.00 Php 12,000.00 Php
and Fringe Benifits 503,108.4

D.1 Salaries Expense for Three Years (2018-2020)

SALARIES FOR 3 YEARS (2018-2020)


YEAR 2018 2019 2020
AMOUNT Php 503,108.4 Php 503,108.4 Php 503,108.4

62
D. DEPRECIATION EXPENSE

Particulars Quantity Unit Cost Total Cost Economic Life Annual


(Years) Depreciation
Building Expense 325,297.00 10 Php 32,529.70
Furniture Php 15,000.00 Php 15,000.00 5 Php 3,000.00
Office supplies Php 2,120.00 Php 25,440.00 1 Php 25,440.00
Machine and
Equipment
CCTVs 7 Php 12,500.00 Php 87,500.00 5 Php 17,500.00
Air Conditioners 4 Php 10,500.00 Php 42,000.00 5 Php 8,400.00
Tools in repairing 1 Php 5,000.00 Php 5,000.00 5 Php 1,000.00
(1 set)
Office Packaged 1 Php 35,000.00 Php 35,000.00 5 Php 7,000.00
Computer Set
Household
Equipment
Soft broom 24 Php 120.00 Php 2,880.00 1 Php 2,880.00
Mop 6 Php 400.00 Php 2,400.00 1 Php 2,400.00
CR Cleaning Tools 12 Php 500.00 Php 6,000.00 1 Php 6,000.00
(set)
TOTAL Php 521,077.00 Php 106,149.00

63
E. TAXES, PERMITS AND LICENSES

2017 2018 2019


Barangay Business Permit 150.00 150.00 150.00
Police Clearance 60.00 60.00 60.00
Mayor’s Permit 200.00 200.00 200.00
Health and Sanitary Permit 100.00 100.00 100.00
Garbage Permit 300.00 300.00 300.00
Fire Registration Permit 105.00 105.00 105.00
Business Plate 250.00 250.00 250.00
BIR Annual Registration 615.00 615.00 615.00
DTI Registration 515.00 - -
TOTAL Php 2,295 Php 1,780.00 Php 1,780.00

F. UTILITIES

2018 2019 2020


Electricity 365,482.80 372,791.64 380,247.50
Water 3,000.00 3,060.00 3121.20
Total Php 368,482.80 Php 375,851.00 Php 383,368.70

64
G. BUSINESS TAX

2018 2019 2020

Net Sales Php 2,592,540.00 Php 2,747,205.20 Php 2,878,998.64

Tax Rate 12% 12% 12%

Total Php 311,104.80 Php 329,664.65 Php 345,479.84

H. INCOME TAX

2018 2019 2020

Net Income Before tax 78,329 447,245.55 464,911.62

Multiply: Tax Rate 30% 30% 30%

Total Income Tax Php 23,498.7 Php 134,173.67 Php 139,473.486

65
I. OPERATING EXPENSE

2018 2019 2020

Business Plan 3,000.00 - -


Salaries Expense 503,108.4 503,108.4 503,108.4
Office Supplies 25,440.00 26,712.00 28,047.60
Taxes, Permits and Licenses 2,295.00 1,780.00 1,780.00
Utilities Expense 368,482.80 375,851.00 383,368.70
Business Tax 311,104.80 329,664.65 345,479.84
Building Expense 340,000.00 - -
Total Php 1,553,431 Php 1,237,116.05 Php 1,261,784.54

66
K. WITHHOLDING TAX

Employee Monthly Salary Excess % Withholding Add: Basic With Withholding


Tax Holding Tax Tax
Computer Php 7,500.00 833.00 15% 208.33 333.28
Technician 1
Computer Php 7,500.00 833.00 15% 208.33 333.28
Technician 2
Computer Php 7,500.00 833.00 15% 208.33 333.28
Technician 3
Cashier Php 7,500.00 833.00 15% 208.33 333.28
Saleslady Php 7,200.00 533.00 15% 208.33 288.28
Total Php 37,200.00 Php 3,865.00 Php 1621.40

67
J. FACTORY OVERHEAD

Particulars 2018 2019 2020


Office Supples 25,440.00 26,712.00 28,047.60
Household Supplies 11,280.00 11,844.00 12,436.20
Utilities 368,482.80 375,851.00 383,368.70
Depreciation 106,149.00 106,149.00 106,149.00
Total Php 511,351.80 Php 520,556.00 Php 530,001.50

MEDALLON COMPUTER HARDWARE & REPAIR SHOP


STATEMENT OF FINANCIAL PERFORMANCE
For the year 2018-2020

Schedule 2018 2019 2020

Net Sales ABC 2,592,540.00 2,747,205.20 2,878,998.64

Less: Cost of Sales ABC 960,780.00 1,062,843.60 1,152,302.48

68
Gross Income 1,631,760.00 1,684,361.60 1,726,696.16

Less: Operating J 1,553,431 1,237,116.05 1,261,784.54


Expense

Net Income Before 78,329 447,245.55 464,911.62


Tax

Less: Income Tax I 23,498.7 134,173.67 139,473.486


(30%)

Net Income After 54,830.3 313,071.88 325,438.134


Tax

69
MEDALLON COMPUTER HARDWARE & REPAIR SHOP
STATEMENT OF FINANCIAL POSITION
For the year 2018-2020

ASSETS Schedule 2018 2019 2020


Current Assets
Cash CFS 2,506,323.26 3,192,053.47 3,651,822.048

Total Current Assets 2,506,323.26 3,192,053.47 3,651,822.048


Fixed Assets
Building Expense L 324,500.00 324,500.00 324,500.00
Machines and Repairing L 169,500.00 169,500.00 169,500.00
Tools
Furniture L 15,000.00 15,000.00 15,000.00

Total Fixed Assets 509,000.00 509,000.00 509,000.00


Less: Accumulated
Depreciation 79,611.75 106,149.00 106,149.00

Net Book Value 429,388.25 402,851.00 402,851.00

TOTAL ASSETS 2,935,711.51 3,594,904.47 4,054,673.048

70
LIABILITIES AND PARTNER’S EQUITY

Liabilities Schedule 2018 2019 2020


Income Tax I 23,498.7 134,173.67 139,473.486
Payable
Withholding Tax K 1,621.40 1,621.40 1,621.40
Business Tax H 311,104.80 329,664.65 345,479.84
Payable
Total Liabilities 336,224.9 644,357.93 672,539.374
PARTNER’S EQUITY
Medallon Computer
Hardware & Repair
Shop
Capital Beginning TPC 2,508,240.51 2,568,514.76 2,881,586.64
Add: Net Income SFP 65,122.40 313,071.88 325,438.134

Total 2,573,362.91 2,881,586.64 3,207,024.774


Less: Withdrawals - - -
Medallon Computer
Hardware & Repair 2,573,362.91 2,881,586.64 3,207,024.774
Shop Capital End
TOTAL LIABILITIES
AND EQUITY 2,909,587.81 3,525,944.57 3,879,564.148

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

2018 65,122.40 2,592,540.00

2019 313,071.88 2,747,205.20

2020 325,438.134 2,878,998.64

TOTAL Php 703,632.414 8,218,743.84

a. Average Net Income = Total Projected Income


Number of years
= 703,632.414
3
= Php 234,544.138

b. Average Net Sales = Total Projected Net Sales


Number of Years
= 8,218,743.84
3
= Php 2,739,581.28

73
c. Return of Sales = Average Net Income X 100
Total Net Sales
= 234,544.138 X 100
2,739,581.28
= 8.56%

d. Return of Investment = Average Net Income X 100


Total Project Cost
= 234,544.138 X 100
2,503,392.36
= 9.37%

e. Cash Payback Period = Total Project Cost


Average Income
= 2,503,392.36
234,544.138
= 10.673438190981349531745704938488
Approximately 10 years and 7 months

74
Conclusion

The payback period of the proposed business project is approximately 10 years and 6 months. It will be a success

but it will take a very long time.

75

You might also like