- 13 minutes ago
Category
📚
LearningTranscript
00:08normal po na napaka challenging ang pag monitor ng ating mga cost
00:11dahil sa pabago-bago ng presyo ng ating mga vendors
00:14minsan pababa, madalas pa-increase
00:17buti na lang meron po tayong accounting system tulad ng QuickBooks Desktop
00:20at si QuickBooks na po ang bahala mag-compute nito
00:22sa ating previous lesson, pinakita ko po sa inyo
00:25paano natin ina-update yung mga cost during purchase
00:27at isa lang po yun sa mga steps para mas makuha natin ng tama yung kita natin sa each item
00:33dahil po ngayon ang gagawin naman natin, kukunin natin yung average cost ng ating mga items during pag-purchase
00:38para makapag-upisa, pili mo na tayo ng item na gagamitin natin
00:42putap po tayo sa homepage sa section ng company
00:45tapos i-click natin, itong items and services
00:49dito po, ang gagamitin natin, itong chicken egg na small
00:54kung i-double click natin ito para ma-edit
00:56makikita natin dito na
00:58meron po itong cost na 3 pesos
01:00at selling price na 4 pesos
01:04update mo na rin po yung columns natin dito
01:06kasi wala pong cost na column
01:11ayan po, magkatabi na sila
01:14cost na 3 pesos at selling price na 4 pesos
01:16transact na natin
01:19ang gagamitin po natin na transaction
01:21ay itong receive inventory with bill
01:24at itong write checks
01:28unahin muna natin dito sa receive inventory with bill
01:32kay vendor name 2
01:34kay vendor name 2 tayo magpapurchase
01:36na ang purchase number ay batch 1
01:45items na pipili natin
01:48chicken egg na small
01:50itong ating item na chicken egg na small
01:52meron pong mga unit of measurement
01:53kaya pang maglagay ako ng quantity dito
01:56meron pong dozen, half dozen, piece at tray
01:59ang pipiliin ko po, yung base unit of measurement natin
02:02na 3 pieces
02:04na nagkakalaga ng 3 pesos each
02:06kaya 3 times 3 pesos equals 9 pesos
02:09save natin
02:12pag save natin, silipin natin sa ating reports
02:14dito sa menu bar
02:16by clicking report
02:18tapos inventory
02:20tapos inventory evaluation summary
02:24dito po sa ating report
02:25napakaraming item
02:26focus lang po tayo sa ating chicken egg na small
02:28kaya i-click po natin
02:29itong customize report na button
02:31dito sa pinaka upper left
02:34tapos dito sa modify report
02:37kalipot tayong display na tab
02:38lipot po tayo sa filters na tab
02:41center ko lang
02:42dito po sa search
02:44type natin item
02:46nung lumabas na yung item sa ating filter
02:48i-click na lang natin para ma-highlight ng green
02:51pagkatapos po ma-highlight ng green
02:53dito naman po sa item na meron drop down arrow
02:55hanapin natin yung chicken egg na small
03:03ayan po
03:04click natin
03:06pagkatapos nyan
03:07pwede natin i-click ang ok
03:09kaya ngayon nakafocusan tayo
03:11sa chicken egg na small
03:12makikita nyo po dito
03:13nag-purchase tayo ng tatlo
03:15na nagkakalaga ng 3 pesos
03:17which is tama dahil 9 pesos ang asset value
03:19or total value
03:20wala po tayong ginalaw during pag-transact natin
03:22kundi yung quantity lang
03:24makikita nyo dito sa ating average cost
03:263 pesos po
03:27kasi 3 pesos each
03:28yung ating binili
03:31ngayon naman
03:31magpapurchase tayo
03:34gamit ang write checks
03:36write checks naman ngayon
03:38dahil pareho po ito ng ating bill
03:40pag-purchase din
03:41or pa-stock in din
03:42dahil pareho po na ang ating bill
03:43stock in din po ito
03:47ngayon naman
03:47si vendor name 3
03:51tapos ang ilalagay natin sa ating number
03:52is batch 2
03:56same procedure
03:57pero ang write checks
03:58bayad gagad
03:59same item pa rin yung pipili natin
04:03same quantity pa rin po
04:053 pieces
04:07pero ngayon
04:08itong si vendor name 3
04:10mas mahal po ng piso
04:11kaya yung cost binago natin
04:13into 4 pesos
04:16pag-click po natin sa ibang field
04:18madedetect ni QuickBooks na
04:19nagbago po yung ating cost
04:21kaya tatanungin tayo kung
04:23i-update ba natin
04:24yes lang natin
04:26dito po sa price na section
04:28hindi muna natin gagalawin
04:29focus na po muna tayo
04:30dito sa ating cost
04:31kaya pag-click nyo ng yes
04:33ok lang
04:34tapos save in you
04:37balikan natin yung ating report
04:38na inventory valuation summary
04:39at kailangan natin itong i-refresh
04:41kasi nag-transact ulit tayo
04:45yes lang
04:46dahil 3 yung pinarches natin
04:48nadagdagan ng 3
04:49yung ating previous 3
04:50na quantity on hand
04:51kaya naging 6
04:52pero pakit yung ating average cost
04:54naging 3.50
04:55diba dapat 4 pesos
04:57kasi po 4 po yung last purchase
04:59natin sa ating right checks
05:013.50 yung nakalagay dito
05:02dahil po ito sa ating average cost
05:04or nag-average cost
05:06yung ating cost
05:06paano nangyari?
05:08ganito po
05:09sa ating unang purchase
05:10gamit ang bill
05:11kay vendor name 2
05:12nagkarontay ng tatlong itlog
05:13na nagkakahalaga
05:15ng 3 pesos each
05:16kaya po kito total natin
05:18yung value nito
05:18is 9 pesos
05:20pangalawang purchase natin
05:21gamit naman ng check
05:22kay vendor name 3
05:23nagkaroon din tayo
05:24ng tatlong itlog
05:25pero ang halaga nito
05:26ay 4 pesos each
05:28kaya po
05:29kung pagsasamayin natin
05:30yung value ng tatlong itlog
05:31nagtag 4 pesos each
05:32nagkakahalaga po ito
05:33ng 12 pesos
05:33ngayon po
05:35paano kinupiti quickbox
05:36yung average cost?
05:37simple lang
05:38una
05:38in-add nyo muna
05:39yung mga quantity ng itlog
05:40kaya 3
05:41sa ating previous purchase
05:42tapos 3
05:43sa ating bagong purchase
05:45total of 6 pieces
05:46ngayon po
05:47pagkatapos nyo ma-add yung quantity
05:48in-add naman nyo yung mga value
05:50yung value ng first purchase natin
05:52na 9 pesos
05:53at yung pangalawang purchase natin
05:54na 12 pesos
05:559 plus 12
05:56equals 21 pesos
05:58ngayon naman
05:59itong 21 pesos
06:00dinivide ni quickbooks
06:01sa 6 quantities
06:02na itlog natin
06:03kaya 21
06:04divided by 6
06:05equals 350
06:10diba
06:11ganun lang kasimple
06:12purchase tayo ulit
06:15ngayon naman
06:16balik tayo sa ating bill
06:18e vendor name 2
06:20same item pa rin
06:22chicken na small
06:23same quantity pa rin
06:263 pieces
06:30kita ninyo
06:31nag-update na yung cost natin
06:32kasi 4 pesos
06:33yung last purchase natin
06:34at ni-yes natin
06:35para ma-update
06:364 na po yung lumalabas dito
06:37ngayon naman
06:38mas nagmahal
06:39si vendor name 2
06:42naging 5 pesos na
06:46yes natin to ulit
06:47tapos hindi mo natin
06:48papansinin
06:49itong selling price
06:50so from 4 pesos
06:52naging 5 pesos
06:52yung cost natin
06:54ok natin
06:55tapos save
06:56and new
06:58balikan natin
06:59yung ating report
06:59sa ating inventory
07:00evaluation summary
07:03refresh din natin
07:05so yung last purchase
07:06po natin
07:06is 5 pesos
07:07ang cost
07:07pero nakikita natin
07:08dito
07:09yung average cost
07:10natin
07:104 pesos na
07:11at dahil pangatlong
07:12purchase na natin
07:13to ng tag-tatlo
07:149 na po
07:14yung ating quantity
07:16paano po ulitokin
07:17yung quickbooks
07:18napakadali lang
07:20dahil po meron
07:20tayong 6 na 8 log
07:21sa ating previous
07:22purchase
07:22na tag-350 pesos
07:23each
07:24kaya 21
07:25ang total value
07:26nadagdagan naman po
07:27ng another 3
07:28na itlog
07:29kaya total po
07:30pag-i-add natin
07:31yung mga itlog
07:31is 9 pieces
07:32tapos
07:33itong 21 na value
07:34natin sa ating
07:35previous purchase
07:36nadagdagan po
07:36ng 15 pesos
07:37kasi itong 15 pesos
07:39value po ito
07:40ng tatlong itlog
07:41na pinurchase natin
07:41kaya 15
07:42plus 21
07:43equals 36
07:44kaya noong
07:45natotal natin
07:45yung lahat ng value
07:46i-divide natin to
07:48sa quantity
07:48ng mga itlog natin
07:49kaya 36
07:50divided by 9
07:51equals 4 pesos
07:53ganun lang
07:53paulit-ulit po
07:54balik po tayo
07:56sa ating transaction
07:58ayan po
07:59transact tayo ulit
08:00tapos
08:01exaggerate natin
08:01ng konti
08:04write checks
08:05naman tayo
08:06or balikan natin
08:06ng write checks
08:07tapos
08:08piliin natin
08:09sa vendor name tree
08:13same item pa rin
08:14na chicken egg na small
08:16tapos
08:16this time
08:17exaggerate natin
08:19gawin natin
08:196 pieces
08:245 pesos po
08:25yung ating last transaction
08:26kaya 5 pesos po
08:27yung cost natin
08:28sa vendor name tree
08:29nag-increase siya
08:30ng piso
08:30so 6 pesos na
08:31at mas mahal na
08:34click natin
08:35sa baba
08:35para makommit
08:37i-update natin
08:38yung ating cost
08:39from 5 pesos
08:40to 6 pesos
08:41tapos
08:42hindi natin
08:42isasama
08:43itong selling price
08:44or itong price
08:45click ok
08:47say natin
08:48save and new
08:49balik tayo
08:50sa ating report
08:51tapos
08:52refresh natin
08:54makikita natin
08:55dito
08:55hindi 6 pesos
08:56yung average cost
08:57na nilagay
08:57ng QuickBooks
08:58kundi
08:584.80
08:59at ang ating
09:00on hand
09:0015 pieces na
09:03bakit naging
09:034.80
09:04compute natin
09:07sa ating previous
09:08purchase
09:09meron po tayong
09:099 pieces na itlog
09:10na 4 pesos each
09:11kaya kung ito
09:12total natin
09:1336 po
09:14yung total value
09:14nito
09:15ngayon po
09:16nag-purchase po tayo
09:17ng 6 na itlog
09:17kaya po itong 6 na itlog
09:19idadagdag natin
09:20sa sham
09:20na previous purchase
09:21natin
09:22kaya 9 plus 6
09:23equals 15
09:24tapos itong 6 na itlog
09:25nagkakalagan ng
09:266 pesos each
09:27which is 36
09:28yung total value
09:29kaya po yung value
09:30ng itlog natin
09:31sa ating previous purchase
09:32na 36 din
09:3336 plus 36
09:34equals 72
09:35kaya itong 72
09:37na total value
09:38ng ating mga itlog
09:38ididivide natin
09:39sa 15 pieces
09:41kaya 72
09:42divided by 15
09:43equals 4.80
09:45yan po
09:45ang competition
09:46ni QuickBooks
09:46kaya po
09:47naging 4.80
09:48yung ating average cost
09:51balik tayo
09:52sa ating report
09:54ayan po
09:56bakit ito
09:56ginagawa ni QuickBooks
09:58ginagawa po ito
09:58ni QuickBooks
09:59para makapture natin
10:00ng tama
10:00yung average cost
10:01ng ating mga items
10:02kaya magpabago-bago
10:03pa ang presyo
10:04ng ating mga vendors
10:06kaya ngayon
10:07alam na natin
10:08kung bakit
10:08average cost
10:09ang pangalan
10:09ng column na ito
10:10kaya po
10:11kung gusto nyo
10:11subukan
10:12purchase lang po
10:13kayo gamit
10:13ng receive inventory
10:14with bill
10:14or write checks
10:15at baguhin nyo po
10:16yung presyo
10:17ng cost
10:17tapos gamitin nyo po
10:18yung competition
10:19natin sa ating averaging
10:20kung tama ba
10:21or pareho ba
10:22sa column
10:23ng average cost