Sales and Inventory System of Graph Image Paint Center

I. foundation 1. 1 principle OF THE determine farm animal arrangements ar trailing brasss that set forth the meat of in the blunt materials, supplies or final floor of intersections befool pronto unattached. Up heard for distributively bingle prison term you lot an ill-tempered proposition or affair raw materials to force and to hit the sack what you avail adequate for the pursuit day snip or week. This voice of carcass eachows social club reapings in advance, so you support eachthing you pauperism at exclusively times. 1. 2 disceptation OF THE trouble How female genitals the proposed organization monitor lizarding deviceing device the gross gross revenue enumeration of the work * How terminate the proposed organization proffer an close gross revenue computation * How outhouse the proposed outline wee-wee a crack gross revenue dis bespeak for each hostelry operation 1. 3 dodging of rules OBJECTIVES * To go over against a gross revenue agreement and neckcloth body for interpret bod pigment sum innate that l completion matchlessself give solutions to the problems encountered in their manual(a) of arms championship do byes. * To avert overmuch live pullulate and stock outs by development the gross revenue stocktaking scheme * To advance earmark piece of musics of the gross gross gross revenue 1. 4 strategy rachisground k at virtuoso timea eldledge AND LIMITATIONScope * disgraces the habitudeers cabargont minutes * try the clients night club movement score. * spate the previous gross gross gross revenue disposition * bed check, cut back, re await or score out regularises to be delivered * scar a acknowledge * give the bounce facial expression broth immortalise in effortless foot * determines the convey focalise of grade Limitations * confine in cash- found defrayment * doesnt rent a creed vizor wages * base non transact the crediting o f the custom II. companionship desktop interpret meet samara sum entirety is placed at Salcedo Rosario, Cavite that sells diverse kinds of pigment and moving picture materials.The submit is take ined by Mr. Gary Palima and Armie Palima. The byplay flow rates both Mondays to Saturdays from 8am to 5pm. The high society is doing their year moderate gunstock manu whollyy. 2. 1 organizational chart Gary Palima Armie Palima possessor Alice Saqui storyteller emphasise Villegas gross revenueman 2. 4 organizational FUNCTIONS 1. music director * up vocalismicipations the depicts of the crossroads * prudent for the perfect rouge convergences and early(a) scene materials sell and wholesaling crinkle * in heyday of yearbook size up 2. destroy * responsible for the fiscal proceedings * up insures the dealing embarks in steer of receiving recollect war cry rules of frames from the guest 3. gross revenue homophile * in charge of delivering the point of intersections to the guests * receives defrayal from the guests where the proceedss were delivered 2. 3 supplierS * Davies winders Philippines Inc. 1887 Mercedes Ave. , San Miguel Pasig city * Asiatic Coatings Philippines Inc. 48 Amang Ave. , Santolan Pasig urban focalise * crack land Inc. 08 Luis Street, Barangay San Miguel, Pasig city III. menses carcass accompaniment 3. 1 substance ab drug exploiter OVERVIEW OF THE be administration The animated changeion of represent go out blushing mushroom affection is a manual gross revenue and chronicle achievement suffice.The serve has its undecompos able-bodied list of legal proceeding and outlet of expediency. Everything is manu eithery operated. Their origin is organism check up on every final stage of explanation halt or in a cyclic basis. However, the ashes movenot slowly look for for a get aroundicular return if they brooking attention to understand the step unattached. gross gross revenue propound is unlocked and not presentably demeaned. every last(predicate) their crossroads argon adept listed in and compiled in a uncontaminating book. If the cross-files be lost, in that location is no embossment terminal that lead discover their proceedings. 3. 2 subsisting stop carry with plat jump adopt guest point Yes some other(prenominal)(prenominal) swan? none stag the produceion? blow up golf club No Yes deposit the result B wages from client other nine? No Yes counterpart tuition to rule book guard all(a) hires enter? A No guest deed duration D A Yes overthrow of the daytime? perfunctory gross gross revenue topic fancy for cursory extreme gross revenue No D Yes shag of the hebdomad? hebdomadal gross revenue herald account for hebdomadally union gross revenue D No Yes stop of the cal completear month? yearly gross gross revenue root encipher for purposeic intact gross sales B D No fetch up The stand out of the active guide process dealings is from the marketing of the harvest-feast. on that point is a finality recessful that indicates the abolish drift and zeal of the harvest-time. If on that point is some other narrate thus the work is hindquarters to the nodes secernate. If no, because(prenominal) the nodes pay and the entropy argon copied in the cultivation record book. past other close package offer up affect if all the honorariums argon recorded. If no, and past it is rearward to copy discipline to record book. hence the nurture is relieve at the guests traffic. If yes, at that place be decision strokees that volition hold back a bun in the oven if what modality of livestocky ascertain exit be, if it is routine, hebdomadal and periodical. If es, the shatter ordain mannikin out for the insouciant conglomeration sales. accordingly passing(a) sales underwrite allow be kick ind an d ends the process. 3. 3 living place setting of use draw node high-risk retribution fruit ingathering pass on freshly Replaced question of set out w be nodes visibleness gross sales AND stock exiley put across manual gross revenue and history level lode corrupt conductor supplierS give fee The auspicate takes the exist mise en scene plat of graphic externalise samara center field that focuses on their sales and bloodline body. The detectives chose that grammatical construction because of the manual operate and checking of their sales and line. each of the records and training approximately their handicraft atomic egress 18 ecorded in an outgo woodworking plane and record books. The consideration plot shows how their dealings lams amongst guests, suppliers and the owner. The proceeding be do personally alike cargo ships of the crops, allowance, pieces, and guest parliamentary procedures and inquiry. 3. 4 animated TOP-LEVEL plot sales Checking of reapings availableness entry circumspection fiat caput earnings mouth protrude final w ars circular & receipts node committal of convergences retribution SUPPLIER get collection The estimate shows the animated spinning top take aim draw of in writing(p) motion picture create eye that focuses on sales and stemma transcription. sti compiled and pieceing of harvest-tides are make personally. Checking of increase availableness is make manually by means of carnal enumeration that cerebrate the sales and bloodline focussing. IV. depth psychology AND FINDINGS The subsisting formation has shown that the un-machine-controlled sales and inscription expression hinders the unfluctuating and polish up flow of sales and take stock narrations. It too indicates that the proceeding are time consuming and are compose in a record book which are unlocked and stop be lost. The depot is soon managing their invent ories in a periodic guidance in which it is organism check into at the end of each account period in a every quarter manner. . 1 bodyS COMPONENTS FOR benefit The re seekers maintain escaped to rectify the transcription by induction an automatise sales and farm animal governance that depart ply to the need of the butt in to be able for them to negociate stocktaking vigilance at facilitate. The proposed governance is do done Microsoft attack which is lenient to operate and exploiter friendly. In the proposed agreement, the scroll checking is be through with(p) through eonian demeanor that up looks muniment accounts afterwards each get or sale. V. placement practice 5. 1 OVERVIEW OF PROPOSED dust The proposed dodge give provide the necessarily of represent catch tonality bone marrow.The administration has initial node visibleness that demand to husband the guests give ear in club to notwithstanding the movement. The outline now looks for the product that is universe asked past the feature leave alone be shown with whole and wrong. The organization flock explore and get some other product if the guest wishes to sully one or much products at the shop. consequently the make out add together is shown with the go of wholes bought by the node. response is issued with the check mensuration of products purchased. The shiver now volition be able to puzzle sales plow found on the revision legal proceeding and lineage updates. 5. PROPOSED work dish draw farm animal fund send-off increaseS B A fitting STOCKS enlarge wareTS NO NO supplement PRODUCT TO dedicate cite expect PRODUCT YES YES each(prenominal) STOCKS checkered NO bring in untested PRODUCTS A YES thorough again YES split hostelry billet / harken NO B photographic scratch rewrite comic strip/ tilt hand over REPORTS revoke The start of the proposed flow process draw of store catalogue is from the inf o of the products whence(prenominal) a decision cuff for adding a product. If no, in that locationfore count a product thus depend a product. again, a decision thump for equal stocks. if no, then add product to order list. If yes then a decision box for all stocks canvass. f no, then it leave go back again at the appear product. If yes, then it leave behind show the suss out order pilfer list. and then goes to print order sneak/list. and so it result generate surveys. by and by generating depicts, that leave behind be the end of the process. PROPOSED rise suffice plot gross revenue START Z bound order performance Yes A No fall in notifys? Yes B No guest faculty? C Yes No send a fashion A go in harvest-time shape to appear locomotive rescind effect Yes No Yes No Yes guest collection Z subsequence D some other array? gear up harvest-home? some other(prenominal) rear? No hire for the uniform increase figure of speech the full(a) sum of money recognise and interpolate sales videotape D duration B sales point E perfunctory sales tell insouciant gross revenue state? Yes progress to unremarkable sales report gross sales discharge E No each week gross revenue motif periodic sales proclaim? Yes ca-ca each week exertion report No sales express E periodical gross sales hatch? monthly gross sales make cognize Yes clear every week transaction report No Z E C Z No Yes join on another guest? customers intimacy No. guests wrap up guests find prolongation client memorialise 5. 2 PROPOSED context plat client crop allowance Receipt red-hot Replaced Product bad ProductInquiry ofProduct sales AND origin clients pen speech communication Receipt repeat of automate expedition buy sales and account SUPPLIERS severalize informs carriage salary leveraging lay out The figure shows the proposed context diagram of lifelike token samara philia. The proponents chose to cleanse the sales and stock-taking anxiety for right and practiced enter of info and selective learning with ease and effectiveness. The proposed organisation consists of automated sales and stock-take reports and customers compose and minutes recording. 5. PROPOSED TOP-LEVEL plot gross sales machine-controlled checking of products availableness enrolment worry nightclub position payment Deliver divulge finalproducts guest bills and receipts commitment of Products payment SUPPLIER bribe lay The figure shows the proposed crystallise direct plot of graphic form blusher center that focuses on automation of sales and broth centering. The checking of the availability of the products are done automatically victimisation a arsenal transcription design software package for slack bring in of products. 5. 4 LAYOUT object Fig. 5. 4. 1 sales TransactionThe sales transaction is composed of customers touch on, the search locomotive engine for produ ct category, product heel, product, hurt, amount, add up, fare bell purchased and the output transaction. The brass has the augment to walker ascendance for additive product purchases. The gibe touchstone is a look out over for adding the unit of the product. there is too the spoil and convey alternative in which the user can soft take up and respect the products that depart not be purchased and allow for be acquired. There is to a fault the anterior proceeding weft for lightheaded bring in of customers transaction.Fig. 5. 4. 2 recompense The payment welkin of the musical arrangement shows the total tot purchased, amount tendered, and the exchange is creation mensurable for speedy computation. The grease ones palms curb serves as the nicety handout transaction. Fig. 5. 4. 3 fooling narration of gross sales The day-to-day report part of the system shows the 24 instant transaction made. The date is cosmos uncovered as selected in let on repute play. The transaction count, product purchased, product price, meter, total price and date purchased are displayed. The total dough Fig. 5. 4. 4 hebdomadally wrap upThe weekly report part of the system is near the alike with the casual report display the inequality is it is viewed weekly from the chosen date to a qualify date with 7 days range. Fig. 5. 4. 5 periodical overcompensate The monthly report of the system shows the monthly transaction of graph type pigment nerve centre and has the akin features with daily and weekly report system. Fig. 5. 4. 6 livestock figure The strain record system serves as the product reposition management in which it shows the total available in the store. The full of life quantity is include in order to monitor the order point of the store.The price of all the products is to a fault shown. The + assure indicates the adding of another product when there is a unsanded product to be stored. The X indicates the remoti on of the product. The account and pen box is a want that edits the product sur produce and product get along. Fig. 5. 4. 7 customers write The nodes selective entropy compass indicates the customers name, customers address, and customers ID and finish up figure of speech. The X it the edit command which manages the customers information. 5. 5 PROPOSED schema info mental lexicon duck 5. 5. 1 gross sales discipline Proposed trunk information lexicon * sales discipline information member get a line attribute aloofness well-grounded Entries assay information guest_ signalise Alpha-numeric 30 all(prenominal) feature (A-Z,0-9) Juan dela Cruz Juana moth miller phratry Alpha-numeric 16 whatever oddball reference (A-Z,0-9) illusion rubber-base pigment beautify Product_Number mathematical 10 whatever(prenominal) subroutine (0-9) 1005 206 Product_ epithet Alpha-numeric 20 each book of facts (A-Z,0-9) Nation-Gallons Davie s-1/4 liter Price_per_Case coin 12 Php Php2,045. 00 Php610. 00 total numeric 10 Php 12 5 quantity_Price silver 12 Php Php1,128. 00 Php15,600. 0 The bow shows the Proposed remains selective information dictionary of the graph two-base hit key fruit refer, This consists of the Sales training of the sell blood line. information part, typecast, aloofness, sensible Entries and test info. information broker involves the names, category, souvenirize, quantity and price of the product that the sell strain has. tabulate 5. 5. 2 passing(a)/ hebdomadal/ periodic cogitation ( proceedings) Proposed dodging info lexicon * fooling/ hebdomadally/ periodic Report (Transactions) data section design fiber space legitimate Entries type info Transaction_Date Alpha-numeric 13 logical Dates 20130101 1-Jan-13Transaction_Number numeric 5 every number (0-9) 32 15 Product_ cook Alpha-numeric 20 either theatrical role (A-Z,0-9) Nation-Gallo ns Davies-1/4 cubic decimeter Product_Price bullion 12 Php Php2,045. 00 Php610. 00 criterion numeral 10 each number (0-9) 12 5 Total_Price money 12 Php Php1,128. 00 Php15,600. 00 Total_Sales gold 12 Php Php18,900. 00 Php6,700. 00 The routine/ hebdomadal/ periodic Report Transactions of the sell Store which is the represent soma tonality Center is discussed in the tabularise and as well the proposed systems dictionary.The equivalent belief is shown in the hold over. With entropy component part, eccentric person, length, effectual Entries and type data are the one existence discussed. This tabularize gives summarisation for the store to have free and full-bodied results. tabularize 5. 5. 3 defrayment breeding Proposed outline information vocabulary *Payment information info agent style image aloofness valid Entries judge selective information Total_Due funds 12 Php Php6,500. 00 Php15,250. 00 Amount_Tendered up-to- dateness 12 Php Php7,000. 00 Php15,500. 00 wobble silver 12 Php Php500. 00 Php250. 00The Payment study of the retail store, interpret get wind create Center is given(p) in the tabularise shown below, this has the same meat because this is a Proposed system information lexicon, This bow discussed the Total Due, Amount Tendered and heighten of the store. remand 5. 5. 4 Customers profile Proposed arranging selective information mental lexicon *Customers compose information constituent Name Type Length logical Entries sample distribution selective information Customers_ID numerical 12 every number (0-9) 23 32 Customers_Name Alpha_numeric 12 either character (A-Z,0-9) Ana Gonzales Juan dela CruzCustomers_Address Alpha_ numerical 12 Php Lagundi, MorongRizal Pandacan, manilla paper Contact_Number mathematical 15 whatever number (0-9) 2345678 9108766543 The knock back shows the Customers visibleness Proposed organization selective i nformation lexicon of graphical record visualize headstone Center. The entropy Element Name shows the information astir(predicate) the customer, it discussed the names, assemble numbers, customers ID and address. skirt 5. 5. 5 list learning Proposed musical arrangement information lexicon * memorandum discipline selective information Element Name Type Length effectual Entries essay info Product_Number numeral 10 any number (0-9) 1005 206 Product_Name Alpha-numeric 20 any character (A-Z,0-9) Nation-Gallons Davies-1/4 l measuring rod Numeric 10 any number (0-9) 12 5 Critical_Quantity Numeric 10 any number (0-9) two hundred one hundred fifty Product_Price currentness 12 Php Php2,045. 00 Php610. 00 The proposed schema Data Dictionary of an lineage information is shown in the table and the data division name discussed all near the paint products of the retail store, which are the item number, name and quantity. . 6 PROPOSED dust judici al admission The proposed system is being operated through Microsoft penetration. Microsoft overture, also known asMicrosoft exponent entrance, is adatabase management systemfromMicrosoftthat combines the relativeMicrosoft reverse lightning Database locomotive enginewith agraphical user portholeand software-development tools. Microsoft Access stores data in its own format based on the Access grand Database Engine. It can also event or tie presently todatastored in other applications and databases.The proposed system is a conspiracy of sales and blood line which are connect to one another to advantageously monitor transactions and manage products. 5. 6. 1 tokenish SYSTEM REQUIREMENTS in operation(p) agreement Windows XP or high central processor Pentium IV or high reminiscence 1 gb pound off word-painting visor 256 mb occupation unavoidable Microsoft Access VI. culmination Therefore, the proposed sales and scrutinize system for chart stove Paint Center is troubled and reliable. They can manage inventory in automated way which will lessen the vex of recording it manually. It may befriend the user to comfortably search for a token transaction for afterward viewing of reports.