00:00Let's go.
00:30Subukan natin.
00:31Bago tayo mag-upisa, same item pa rin po yung gagamitin natin.
00:35Yun po yung egg na small.
00:36Tapos, balikan po natin yung ating report sa ating inventory evaluation summary.
00:45I-filter muna natin sa ating item na egg na small.
00:49Punta muna tayo sa custom report na button.
00:52Tapos, galing display na tab.
00:54Lipa tayo sa filters.
00:56Tapos, dito sa filters na tab.
00:59I-search natin yung item.
01:03Pag na-search na natin, dito po sa filter, i-highlight lang natin itong item.
01:08Tapos, hanapin na natin yung item na egg na small dito sa item na drop down arrow.
01:14Egg chicken small, nakita na natin.
01:17Then, click OK.
01:19Ang total quantity po sa ating egg na small ay 15 pieces.
01:23Tapos, ang average cost ay 480.
01:26Na kung kukumpitin po natin, 15 pieces na on hand times average cost na 4.80 equals 72 na asset
01:33value.
01:36Balik tayo sa homepage.
01:37Tapos, mag-transact tayo.
01:39Dito sa receive inventory with bill or
01:43sa write checks.
01:46Receive inventory muna tayo.
01:49Or kahit write checks yung piliin ninyo, OK lang po.
01:51Wala pong problema.
01:52Kahit saan sa dalawa, OK lang po.
01:58Center ko lang.
01:59Tapos, si vendor name 2.
02:02Chicken egg na small.
02:04Tapos, 3 pieces pa rin.
02:096 pesos po ang cost nito,
02:11base po sa ating last transaction,
02:13sa ating last lesson.
02:16Main po, itong item natin na chicken egg na small,
02:19bumagsak po ang presyo.
02:20From 6 pesos na cost,
02:22naging 2 pesos na lang.
02:23Kaya itong 6 pesos,
02:25papalitan natin ng 2 pesos.
02:27So, nagbagsak presyo po si vendor name 2.
02:29Click natin sa ibang field para makommit.
02:33Natitek ulit ni QuickBooks kasi nga,
02:35From 6 pesos na cost,
02:37naging 2 pesos na lang.
02:39Yes natin.
02:40Tapos, hindi pa rin natin papansinin
02:41itong current price.
02:43Focus pa rin po tayo dito sa ating cost.
02:46OK natin.
02:48Tapos, save and new.
02:50Bago natin i-save and new,
02:52lagyan muna natin ito ng indicator,
02:54kunwari, batch 5.
02:56Save and new natin.
02:58Tapos, balikan natin yung ating report.
03:01Refresh natin.
03:03I-click natin ng yes
03:04para ma-refresh yung ating report.
03:06Kung makikita ninyo,
03:07yung 50 na on hand,
03:08naging 80 na
03:09kasi nadagdagan ng 3 pieces.
03:11Tapos, yung ating average cost,
03:12galing 4.80,
03:14naging 4.33 na lang.
03:16Bakit naging 4.33?
03:18Compute natin.
03:22Bago po tayo nag-transact,
03:24yung ating on hand ay merong 15 na quantity.
03:26At ang halaga ng 15 na quantity na ito
03:28ay 72 pesos.
03:30Ngayon po,
03:31dumagdag itong 3 pieces na itlog natin
03:32galing kay vendor name 2,
03:34na nagkakahalaga ng 2 pesos each.
03:36Kaya ang total value nito
03:37ay 6 pesos.
03:39Ngayon po,
03:40yung current value natin
03:41sa ating mga itlog na 72 pesos,
03:43dinagdagan po ng 6 pesos
03:44sa pag-purchase natin ngayon.
03:46Kaya 72 plus 6 pesos
03:48equals 78.
03:50Tapos, yung 15 pieces natin
03:52na dagdagan ng tatlo,
03:53kaya 15 plus 3
03:54equals 18.
03:56Ngayon naman po,
03:57itong total value natin na 78
03:59i-divide natin sa total quantity natin
04:01na 18 pieces.
04:02Kaya 78 divided by 18
04:04equals 4.33.
04:07Diba?
04:08Same procedure pa rin.
04:09Mas bumaba nga lang po
04:10yung ating average cost.
04:12Gawa pa tayo na isa pang transaction.
04:17Dito pa rin tayo sa bill.
04:20Kay vendor tree naman.
04:21Same item pa rin.
04:24Chicken egg na small.
04:253 pieces pa rin.
04:30Tapos, tinapatan ni vendor name tree
04:32yung cost ni vendor name 2.
04:34Ginawa na lang niyang piso.
04:36Kaya tagpiso na lang
04:37yung egg na small.
04:39Kaya po,
04:40pag-click natin sa ibang field
04:41para makommit,
04:43makikita ni Quickbox dito
04:44na na-detect niya
04:45from current cost na 2 pesos,
04:47piso na lang.
04:48Yes natin.
04:49Tapos, hindi pa rin natin
04:50papansinin itong price.
04:53Click natin ng OK.
04:55Tapos,
04:56lagay natin dito,
04:58batch 6.
04:59Nilalagyan ko po ng batch number
05:01yung ating reference number
05:02para makita po natin
05:03sa ating mga future reports
05:04itong ginagawa natin na
05:05average costing.
05:08Tapos dito,
05:09save in yun na natin.
05:11Tapos,
05:12balikan natin yung ating report.
05:14I-click lang natin ng yes
05:15para ma-refresh.
05:16Makikita natin dito,
05:18lumate po yung ating average cost.
05:203.86 na lang.
05:22At ang ating on-hand,
05:2321 pieces na.
05:25Paano nangyari ito?
05:26Compute na ulit natin.
05:30Ang ending balance po natin
05:31sa ating last purchase
05:32ay 18 pieces
05:33na may value
05:34na 78 pesos.
05:36Ngayon po,
05:37pag-purchase natin
05:38ng tatlong itlog
05:38na nagkakalagan ng 3 pesos,
05:40in-add po natin
05:41yung current value
05:42ng ating itlog
05:42na 78
05:43sa 3 pesos.
05:45Kaya 78
05:45plus 3 pesos
05:46equals 81.
05:48Tapos,
05:49ang 18 pieces,
05:50dinagdagan natin ng tatlo.
05:51Kaya 18
05:52plus 3
05:52equals 21.
05:54Kaya po,
05:55itong 81 na total value,
05:56ididivide natin
05:57sa total quantity
05:58ng ating mga itlog,
05:59which is 21 pieces.
06:01Kaya 81 na value
06:02divided by 21 pieces
06:04equals
06:043.857.
06:07At dahil 2 decimals lang po
06:08yung ating report
06:09sa ating average cost,
06:10i-round off po ni QuickBooks
06:11to 3.86.
06:14Kaya yun po
06:14ang naging current
06:15na average cost
06:16ng ating chicken egg
06:17na small.
06:22Ang asset value niya
06:24is 81
06:24dahil 21 pieces
06:26na on hand
06:26times 3.86
06:28equals 81.
06:29Kaya 81 po
06:30yung asset value
06:31ng ating mga itlog
06:32or 81 yung total value
06:34ng mga itlog natin.
06:35Dito naman po
06:36sa ating sales price,
06:384 pesos pa.
06:40Hindi pa tayo lugi
06:41dahil
06:423.86
06:43at 4 pesos
06:44yung paggita nila.
06:47Kung gusto natin
06:47baguhin yung sales price,
06:49puto lang po tayo
06:50sa ating item list.
06:54Open natin.
06:57Makikita nyo rin
06:58yung ating cost
06:59na update na ito piso.
07:02Pero hindi po ito
07:03ang kinukumpiti QuickBooks.
07:05Dito po sa ating report.
07:09Na inventory valuation summary.
07:11Ito pong ginagamit niya
07:12at 3.86.
07:14Kaya po kung gusto natin
07:15piso yung ating patong
07:16against 3.86,
07:18pwede po natin
07:19i-edit itong sales price
07:20into 4.86.
07:26Kaya itong sales price,
07:27baguhin lang natin
07:30to 4.86
07:32kung gusto kong
07:32ma-maintain
07:33yung piso
07:33na patong ko.
07:35Okay lang.
07:38Refresh natin
07:39yung ating report
07:40para ma-update.
07:41At automatic,
07:43nakompute na kagad
07:44ni QuickBooks
07:44yung pagitan
07:45between
07:453.86
07:47at 4.86.
07:49Kaya ganun lang po
07:50ang pag-compute
07:50ng ating average cost,
07:51pa-increase man
07:52or pa-baba
07:53yung cost
07:54ng ating mga vendors.
07:56Kung gusto nyo po
07:57mag-exercise
07:58para ma-practice kayo
07:59at maramahitindihan nyo pa,
08:00sumukan nyo lang po
08:01mag-transact
08:01ng pa-baba
08:02at pa-increase
08:03sa pag-purchase ninyo
08:04sa ating vendor,
08:05maparate check man
08:05or receive inventory
08:07with bill.
