00:00Let's go.
00:30Open natin.
00:32Close natin ang homepage para wala po tayong distraction.
00:35Tapos, i-maximize natin.
00:37Makikita natin dito, may itong quantity at saka amount, which is familiar na po tayo.
00:43Ilan yung bilang na nabenta at yung halaga nito.
00:47Pero ano po itong percent of sales, average price, COGS, average COGS, gross margin,
00:58at cross margin na may percentage.
01:03Isa-isahin natin.
01:05Unahin muna natin itong section na ito.
01:08Focus tayo sa duck egg tray na large.
01:12Again, focus po muna tayo sa section na ito.
01:18Tapos, huwag nyo mo nang pansinin itong percent of sales.
01:22Para ma-analyze itong report na ito, dito sa section lang na ito,
01:26ang nangyari po dito, mayroon po tayong 100 na quantity na nabenta
01:31sa ating duck egg tray na large.
01:34Tapos, 8 pesos ang isa nito.
01:36Kaya po, ang 100 pieces na nabenta na nagkakalaga ng 8 pesos each equals 800.
01:43Kaya, yun po yung nakikita natin sa amount.
01:47Ngayon naman po, dito naman tayo sa section ng COGS.
01:50Duck egg tray na large pa rin po tayo ha.
01:53By the way, ang COGS po ay abbreviation na ang ibig sabihin cost of goods sold.
01:59Ngayon po sa section na ito para ma-analyze natin,
02:02ibig sabihin po nito, mayroon po tayong bilang ng 100 pieces na nabenta.
02:06Kaya, yung 100 pieces, imumultiply natin sa ating average cost na 7 pesos.
02:13Kaya, 100 times 7 equals 700.
02:17Kaya po, itong 700 na nakikita natin sa COGS,
02:20yan po yung overall total.
02:22Nang ating cost of goods sold.
02:24Ibig sabihin, tinotal po ni QuickBooks yung cost natin.
02:29Kasi nga po, itong section na ito,
02:31benta po natin sa sales price.
02:33At ito namang section na ito,
02:35benta po natin sa ating cost o puhunan.
02:38Ngayon po, dahil pinaghiwala yung benta natin sa SRP
02:41at benta natin sa cost o puhunan,
02:44nagkaroon tayo
02:45ng margin.
02:47Kaya po, sa item natin na duck egg tray na large,
02:50sa pagitan po ng amount natin na 800,
02:53which is ang SRP,
02:54at ang COGS natin na 700,
02:56meron pong 100 na gross margin.
02:59Tinotal po lahat ng QuickBooks yung gross margin natin,
03:02dito sa gross margin na column.
03:04Ito pong gross margin,
03:05ito po yung patong natin sa ating items.
03:08Dahil nga po, ang puhunan natin sa ating duck egg tray na large,
03:11kung tinotal natin lahat ng benta natin,
03:13700 po.
03:14At kung kasama po yung patong natin,
03:16ito po yung 800.
03:18Kaya po, kung ililas natin yung ating puhunan
03:20na 700,
03:22sa ating benta na 800,
03:25meron po tayong 100 na gross margin.
03:27Ito po yung hiniwalay
03:28na patong natin.
03:30Kaya dito sa gross margin na column,
03:32makikita natin
03:36yung benta natin
03:37o yung tubo natin.
03:38Tinotal lahat dito
03:39yung benta natin sa ating tubo
03:41o sa ating patong.
03:44Kung baga, in short,
03:46dito sa section na ito,
03:47tinotal po lahat ng SRP,
03:48tapos dito,
03:49tinotal po lahat ng cost price
03:51o yung puhunan natin.
03:52Kung baga,
03:53kung ibibenta natin yung ating mga items
03:55na walang patong,
03:56ito po yung halaga.
03:58Tapos kung ibibenta naman natin
03:59yung mga items natin
04:00na merong patong,
04:01ito po yung halaga.
04:03Ngayon po,
04:04ito namang percent of sales.
04:06Dito natin makikita
04:07sa pag-generate natin
04:08ng report na ito,
04:10ng 100%,
04:11binubuo po ito
04:12ng iba't ibang klaseng percentage
04:14para maging 100%
04:16yung total na ating report.
04:18Kaya dito makikita natin
04:19malaki yung benta natin
04:21sa ating
04:23egg tray na large
04:24kasi siya po yung
04:25pinakamay malaking percentage.
04:2738.1
04:28na bumubuo
04:29sa 100% na sales
04:30sa ginawa nating report.
04:32Kaya po sa ating
04:33sales by item na summary
04:34na report
04:34na 2,100
04:35ng 100%,
04:37ang benta po niya
04:38na contribution
04:38is 38.1%.
04:41Kaya yun po ang ibig sabihin
04:43nitong sales by item summary.
04:46Meaning ng COGS,
04:47cost of goods sold.
04:49Kaya ganun lang po kasimple
04:50kung paano basahin
04:51itong report natin
04:52sa sales by item summary.
04:54Meron din po akong warning
04:55regarding sa average cost
04:57na pwede magbago ito
04:58at hindi pareho
04:59sa cost ng ating mga items.
05:01Sa ngayon,
05:02pareho pa ito.
05:03Tulad nitong
05:05duck egg tray natin
05:06na large.
05:08Kasi nakalagay dito
05:107 pesos.
05:12Kaya kung titignan natin
05:13yung ating duck egg tray
05:14na large
05:14sa ating item list,
05:19ayan po,
05:207 pesos po
05:21yung cost niya.
05:26Ngayon po,
05:27ano naman po
05:27itong gross margin
05:28na may 12.5%.
05:31Madali lang po
05:32yung computein.
05:34So dito lang muna tayo
05:35sa duck egg tray na large
05:36para po makompute natin
05:38itong 12.5%.
05:39Ang computation po dito
05:41ay ganito.
05:43Ito pong 800 na amount
05:44minus
05:45700
05:46na cost of goods sold
05:47or COGS
05:48equals
05:49100.
05:50Ngayon,
05:51itong 100
05:52i-divide natin
05:53dito sa amount
05:54na 800.
05:56Kaya po,
05:57naging
05:5712.5%
05:58kasi
05:59ang total
06:00is
06:000.125.
06:05Ang maganda dito,
06:07na-extract
06:08or
06:08nahiwalay natin
06:10yung patong natin
06:11sa ating mga items
06:12in total
06:13of sa ating benta.
06:15Kaya yun po
06:16ang gamit
06:16ng sales by item
06:17summary
06:18sa ating mga items.
06:19Kaya po,
06:20napaka-importante
06:23sa ating item list
06:25para sa ating mga
06:26inventory part na items
06:28na tama
06:33ang cost
06:34at selling price
06:35or sales price
06:36sa ating inventory items.
06:43Kaya po,
06:44i-enjoy ninyo
06:44yung pag-compute
06:45sa ating gross margin
06:46gamit ang sales by item
06:47summary na report.
06:49la-
06:49la-
06:49la-
Comments