Free Essay

Sample of Pivot Table

In: Business and Management

Submitted By parves190
Words 3420
Pages 14
[pic]

A REPORT ON
BUSINESS COMMUNICATION PROCESS
OF
BASIC BANK LIMITED

MGT 242: Business Communication

Prepared for

Afrins Farid

Faculty, School of Business

Prepared by

Syed Wahidur Rahman 10310423
Sabiqun Nahar 10310432
Nasrin Akter 08410021 Parvez Ahmed 10310371
MD. Mahtab Hossain 10310388 Kazi Arif Hossen 10310439

University of Information Technology & Sciences (UITS)
April 09th, 2011

Acknowledgement:
I would like to give thanks to those people who helped us to prepare this report and we are very much grateful to them for their cordial assistance, helpful co-operation and essential suggestion.
At first we would like to express deep gratitude to our honorable course instructor Afrins Farid , Faculty, School of Business, University of Information Technology & Sciences (UITS), for her sincere guideline and valuable remarks, thoughtful comments and essential suggestions. She inspired us and gave us encouragement to complete this report.
We would also like to express our gratitude to the all managers and employees of the organization, where we have gone to collect information for preparing my report. We are really grateful to them.
All of the persons stated above played a great role by helping us to make this report a successful one. So again, a special thanks to all of them.

IV

Letter of Transmittal:

April 09th, 2011

Afrins Farid
Faculty, School of Business
University of Information Technology & Sciences (UITS).

Dear Madam,

Here is a report on “BASIC BANK LIMITED”, which you asked us to prepare on the January 31st, 2011. To know about the communication process we have gone to the Gulshan branch of the bank, which we observed as relevant to the topic of the report. The information provided by you in your class lectures was also helpful to us.
In this report, we have tried our best to know about the different communication process played by the bank. Also we have collected information about the background and recent activities of the bank.

Therefore, I hope that our report will fulfill the need to understand the basic communication process that BASIC bank performs. We assure you that the report is totally self- explanatory.

We will be available anytime if you face any difficulty to translate any meaning of this report. Sincerely yours,

1. ………………. 4. …………………
Syed Wahidur Rahman Nasrin Akter
ID: 10310423 ID: 08410021

2. ………………. 5. …………………
Sabiqun Nahar Parvez Ahmed
ID: 10310432 ID: 10310371

3. ………………. 6. …………………
MD. Mahtab Hossain Kazi Arif Hossen
ID: 10310388 ID: 10310439 III

TABLE OF CONTENTS:

|Content |Page |

|A. Introduction | 1-6 |
|Origin of the report |2 |
| 2. Purpose of the report |2 |
| 3. Scope of the report |3 |
| 4. Limitations |3 |
| 4.1. Branch problem |3 |
| 4.2. Shortage of time |3 |
| 4.3. Other problem |3 |
| 5. Background |4 |
|6.Methodology |5 |
|7. Method of collecting data |5 |
|8. Report preview |6 |
|B. Report body |7-17 |
|1.Basic bank and its communication process |7-17 |
|2.Internal communication |9-13 |
|2.1. Formal communication |10-11 |
|2.1.a. Vertical communication |11 |
|2.1.b. Horizontal communication |11 |
|2.2. Informal communication |12 |
|3.Grapevine |13 |
|4. External communication |14-16 |
|4.1. Clients/ Accounts holder |14 |
|4.2.Correspondent banks |14-15 |
|4.3. NGO |16 |
|4.4. Regulatory Authority |16 |
|4.5. Share holder |16 |
|4.6. Financial institution |16 |
|5. Barrier |17 |
|C. Report Ending |18-19 |
|1. Conclusion |18 |
|Content |Page |
|2. Recommendation |19 |
|D. Appended parts |20- |
|1.Appendix |20-23 |
|1.1. Visiting Card |20 |
|1.2. Account opening form |21-22 |
|1.3. Business Letter |23 |
|2.Bibliography |24 |
| | |
|E. Figures | |
|1.Chain of command |8 |
|2. Internal communication forms |9 |
| | |

Executive Summary: the Report
BASIC Bank Limited started its business in 1991 and their goal was to reach banking system more closely to the general people. And this made this bank up to this time. Now BASIC Bank Limited is an improved and modernized bank where the banking system has been easier than the continuing banking system.
Basically BASIC Bank Limited performs major four types of functions – Term Loans to Industries, Full-fledged commercial banking service, Technical Support to Small Scale Industries (SSIs), and Micro-credit to urban poor.

In this report we have discussed in detail about the communication process of BASIC Bank Limited. For this purpose we contacted with Muhammad Kabir Hossain, Assistant Manager, BASIC Bank Limited and we used our text books as references.

1 A. Introduction: 1. Origin of the report:
Afrins Farid , Faculty, School of Business, University of Information Technology & Sciences (UITS), the honorable course instructors of ‘Business Communication’, assigned us to prepare a report on January 31st , 2011 about the “Communication Process of BASIC BANK LIMITED”. The date of submission of this report is April 09th, 2011.
PURPOSE OF THE REPORT:II
2. Purpose of the report:
We are very much passionate to be an executive of the coming days. So, we have to gather more experience beside our study. We do not want to concentrate our lessons only in classroom but to implement it in my practical life that will help me in my professional life. The purposes of preparing of this report are-

-To relate my theoretical report writing knowledge with the practical working experience. -To know about the functions played by the bank.

-To know about the Communication Process of the bank.

-To gather experience of working as a group.

-To get good grades in particular course.

2
3. Scope of the report:
We have collected data from the Gulshan branch of BASIC Bank in Dhaka ; we have mainly tried to cover all the information needed to know about the communication process followed by the bank as well as the various functions played by the bank. We are benefited by working with such an organization which will help us not only to get good grades but also to gather practical experience . The entire interviews are taken from the Managers or various upper level officers of the bank.TIONS
OF THE REPORT
4. Limitations of the report:
Though we are lucky to get the chance to prepare this report but unfortunately we have faced some difficulties. We tried to overcome the difficulties and gave our best effort. When preparing this report, some difficulties we faced a. Branch problem: Some employees of the bank told us that they are not authorized to tell anything about the matter. They also told that only the head office can provide information about this. So it becomes a problem working within branch office. The managers are also very busy, so it was hard to bring their concentration on the matter. b. Shortage of time: This extensive type of report needs too much time to prepare it. But we had to prepare this report within a very short span of time; moreover we had other term paper submission to do. c. Other problem: Some other problems like,
-Traffic jam delayed us in road. -Load shedding caused trouble to work flawlessly. -Non sufficient information in website made the job more difficult. -Being student bearing the related expenditures were tough. 3
5. Background:
BASIC Bank Limited (Bangladesh Small Industries and Commerce Bank Limited) registered under the Companies Act 1913 on the 2nd of August, 1988, started its operations from the 21st of January, 1989. It is governed by the Banking Companies Act 1991. The Bank was established as the policy makers of the country felt the urgency for a bank in the private sector for financing small scale Industries (SSIs). At the outset, the Bank started as a joint venture enterprise of the BCC Foundation with 70 percent shares and the Government of Bangladesh (GOB) with the remaining 30 percent shares. The BCC Foundation being nonfunctional following the closure of the BCCI, the Government of Bangladesh took over 100 percent ownership of the bank on 4th June 1992. Thus the Bank is state-owned. However, the Bank is not nationalized; it operates like a private bank as before.
BASIC Bank Limited is unique in its objectives. It is a blend of development and commercial banks. The Memorandum and Articles of Association of the Bank stipulate that 50 percent of loan able funds shall be invested in small and cottage industries sector.

4

6. Methodology:

-Sources of collecting data:

The report is based on data & information, which have been collected from various sources. They are stated below: a) Primary source
- Interview
- Search through the internet
b) Secondary sources
- Various books related with Business Communication. - Various website.
-Method of collecting data:
7. Method of collecting data:
To do this report first we have gone to the Gulshan branch of the bank. We have also collected information about the banks past history on the internet. Then we have related all those information with the currently studying course “Business Communication.”

5
8. Report preview:

6 B. Report Body:

BASIC Bank and its business communication process:

Communication is a process of interrelated elements working together to achieve a desired outcome or goal. Since communication is a process this means it is dynamic ever changing and unending.
Business communication is the communications which happen in business.

BASIC Bank Limited (Bangladesh Small Industries and Commerce Bank Limited) is a business organization which is a bank in criteria but owned by government of Bangladesh. It is a state owned scheduled bank which works for the progress of Small Scale Industries. Each branch has four departments of Basic Bank such as 1. Foreign exchange 2. General Banking 3. Credit division 4. Desk pass.

Organizational goals:

-To employ funds for profitable purposes in various fields with special emphasis on small scale industries.
-To undertake project promotion on identify profitable areas of investment.
-To search for newer avenues for investment and develop new products to suit such needs.
-To establish linkage with other institutions which are engaged in financing micro-enterprises.
-To cooperate and collaborate with institutions entrusted with the responsibility of promoting and aiding SSI sector.

Chain of Command: BASIC Bank Limited

C=Chairman, BD=Board of Director, MD=Managing Director, GM=General Manager, AGM=Assistant General Manager, M=Manager, DM=Departmental manager, AM=Assistant Manager, OFFICER, AO=Assistant Officer. 7
[pic]8

According to these departments communication happens in two ways: 1. Internal Communication 2. External Communication In below the whole communication process is described:

1. Internal Communication: Communication occurring within the same organizational structure is called internal communication. The internal communications of BASIC bank happen between the branches and within the branch.

[pic] Figure: Flow of Internal Communication
Internal Communication are of two types: a. Formal Communication b. Informal Communication 9
a. Formal Communication: The formal communication in Basic Bank occurs within the organizational framework to maintain the formal rules of communication. The formal communication are given below which is followed by Basic Bank.
** Memos: A memo provides a format for a concise message. It reflects information, makes request and provides responses and presents informal reports of the Basic Bank Limited.
** Interview: sometimes the management of Basic Bank resort to an interview or conversation to exchange their views on different issues.
** Telephone: The size, scope and nature of Basic Bank affect the use of telephone for formal communication.
** Report: The Basic Bank creates a report based on investigation is sent to the authority concerned.
** Notice board: Such a board is used by head office of Basic Bank to send messages to the branches. It must be kept up-to-date and attractive and should be placed where employees make assembly.
** Face to face discussion: Executive officers and employees of Basic Bank many times call for a discussion and interchange views regarding the current problems. This discussion may be regular or irregular and formal or informal depending on the situation.

** Questionnaire and survey: Information about employee attitude, moral and relationship between management and subordinates etc. may be collected by the Basic Bank through the use of questionnaire and surveys.

** Fax: When departments, branches of Basic Bank are scattered in different places then fax is used for communication.

10
** Internet: To create effective and fast communication Basic Bank uses internet.

There are two parts of formal communication
1. Vertical communication
2. Horizontal communication

a.1: Vertical communication:

The vertical communication of BASIC bank exists between supervisors to subordinates.
There are two parts of vertical communication…
-Upward communication
-Downward communication

When the vertical communication of BASIC bank flows from downward to upward (from subordinate to superior ) it is called upward communication.

When the vertical communication of BASIC bank flows from upward to downward (from superior to subordinate) it is called downward communication.

a.2: Horizontal communication: Information exchange between departments or functional units, as means of coordinating their activities.
BASIC Bank maintains horizontal communications between its employees.

11

2. Informal Communication: The informal communication in Basic Bank occurs within the organizational framework to maintain the informal rules of communication. The informal communication are given below which is followed by Basic Bank :

Complaint and suggestion boxes: At some convenient places in the branch complaint and suggestion boxes are kept so that employees can drop their complaint and suggestions, if any, into the box.
Participation in praying: The authority of BASIC bank give opportunity to the officers and employee for praying. Where they get the chance to informal communication.
Informal gathering: On different occasion BASIC bank arranges `informal gathering or tea meeting where employees are encouraged to talk freely about their day to day concerns.
Idea hunt: The BASIC bank limited such even is organized to allow employee participation for creative ideas for betterment of services offered to clients.

12
Grapevine:

[pic]

It is an informal channel of communication. In other word when communication uses in informal or unofficial network, it is termed as Grapevine.
BASIC Bank conducts this communication process in internal communication. If any employee needs to deliver or receive any information or message they directly conduct with the particular employee.

13

External Communication:
Communication occurring within the different organizational structure is called external communication. The external communications of BASIC bank happen between the clients, suppliers, investor, competitor etc.
In below the external communication perform by BASIC bank are given:

Clients/Account Holder: BASIC bank generally deals with Small- Scale Enterprises as well as full fledge commercial banking service including collection of deposit, short term trade finance, working capital finance in processing and manufacturing units and financing and facilitating international trade. For this purpose they 1. Provide accounts opening for different saving scheme. 2. Loan to develop small industries of the country.
Correspondent Banks: BASIC Bank has correspondence with several banks through which they communicate in foreign trades.

List of Banks:

|Bank of Ceylon | |Banque de Commerce et de Placements SA |
|COLOMBO | |GENEVA |
|SRILANKA | |SWITZERLAND |
|SWIFT NO.: BCEYLKLX | |SWIFT NO.: BPCPCHGG |
|ACCOUNT NO.: 1977950 | |ACCOUNT NO.: 10.601998-0-100-CHF-0 |
|CCY: LKR | |CCY: CHF |
| | | |
|Citibank NA | |Citibank NA |
|MUMBAI | |NEW YORK |
|INDIA | |U.S.A. |
|SWIFT NO.: CITIINBX | |SWIFT NO.: CITIUS33 |
|ACCOUNT NO.: 11507018 | |ACCOUNT NO.: 36022105 |
|CCY: ACU | |CCY: USD |

14
| |
| |
| |
|MashreqBank PSC |
|MUMBAI |
|INDIA |
|SWIFT NO.: MSHQINBB |
|ACCOUNT NO.: 61049778 |
|CCY: INR |
| |
| |
| |
| |
|Sonali Bank Limited |
|KOLKATA (CALCUTTA) |
|INDIA |
|SWIFT NO.: BSONINCC |
|ACCOUNT NO.: CIO2ACUD07 |
|CCY: ACU |
| |
|Sonali Bank Limited |
|KOLKATA (CALCUTTA) |
|INDIA |
|SWIFT NO.: BSONINCC |
|ACCOUNT NO.: C102EUR03 |
|CCY: ACU |
| |
|Sonali Bank (UK) Limited |
|LONDON |
|U.K. |
|SWIFT NO.: BSONGB2L |
|ACCOUNT NO.: 0100000424700 |
|CCY: GBP |
| |
|Sonali Bank (UK) Limited |
|LONDON |
|U.K. |
|SWIFT NO.: BSONGB2L |
|ACCOUNT NO.: 0600000424701 |
|CCY: EUR |
| |
|Standard Chartered Bank |
|FRANKFURT AM MAIN |
|GERMANY |
|SWIFT NO.: SCBLDEFX |
|ACCOUNT NO.: 018105510 |
|CCY: EUR |
| |
| |
| |
| |
| |
|Standard Chartered Bank |
|MUMBAI |
|INDIA |
|SWIFT NO.: SCBLINBB |
|ACCOUNT NO.: 22205243254 |
|CCY: ACU |
| |
|Standard Chartered Bank |
|NEW YORK |
|U.S.A. |
|SWIFT NO.: SCBLUS33 |
|ACCOUNT NO.: 3582040650001 |
|CCY: USD |
| |
| |
| |
| |
| |
|Summit Bank Limited |
|KARACHI |
|PAKISTAN |
|SWIFT NO.: AHRBPKKA |
|ACCOUNT NO.: 1-2-1-20315-931-120524 |
|CCY: ACU |
| |
|The Bank of Tokyo-Mitsubishi UFJ Ltd |
|LONDON |
|U.K. |
|SWIFT NO.: BOTKGB2L |
|ACCOUNT NO.: 3301GBPDTF027508 |
|CCY: GBP |
| |
| |
| |
| |
| |

15

NGO: The bank help different Non- Government Organizations(NGOs) to provide SME and Micro-credit loan to the small entrepreneurs of Bangladesh.

Regulatory Authority: The Board of Directors and Central Bank of Bangladesh are the regulatory authority of BASIC bank.The bank provides accurate financial reports, research papers, other documets to them.

Share holder: As BASIC Bank’s 100% share is owned by government of Bangladesh it has no responsibility to distribute the profits but it works for govt. for the development of people and general economy.

Financial Institutions: BASIC Bank maintains communication with different types of financial organizations. In this process it carry on with proper communication skills.

16

Barriers of BASIC Bank:

Communication barriers are the problems that arise at every stage of the communication process and have the potential to create misunderstanding and confusion.

Different barriers to communication of BASIC Bank are described below:

Government interruption: As BASIC Bank is a state hold organization, the govt. interrupts in its banking process.

Complex organizational structure: The more complex structure that BASIC Bank has, the more problem it faces in communication.

Excessive layering of administration: The administrative level of this bank has more layers which creates communication gap between employees and management.

Conservativeness of executive officers: Sometimes officers of this bank are very conservative and ignore to communicate with the employees. This causes barrier to communication.

Low internet speed: Low internet speed occurs when the employees of this bank try to send or receive information through internet.

Facilities: Basic bank offers less facility to the client that’s why the clients are not interested to communicate with this bank.

ATM: BASIC Bank has few ATM booths that are not enough for the clients to fulfill their needs. For this reason clients are not interested to deal with this bank, which acts as a barrier of communication.

Advertisement Problem: BASIC Bank doesn’t promote itself through advertisement. That’s why this bank is not well known to the public of the country.

Geographical barrier: Geographical distance creates communication gap. Sometimes BASIC Bank communicates with other countries. It creates a huge distance to communicate which acts as a barrier of communication. There are time differences are also one major fact of this.

17 C. Report Ending:

Conclusion: BASIC Bank was established as the policy makers of the country felt the urgency for a bank in the private sector for financing small scale Industries (SSIs). BASIC Bank Limited is unique in its objectives. It is a blend of development and commercial banks. The Memorandum and Articles of Association of the Bank stipulate that 50 percent of loan able funds shall be invested in small and cottage industries sector.

BASIC Bank's services are directed towards the entrepreneurs in the small industries sector. A small industry, as per Industrial policy 1999 approved by the Cabinet, has been defined as an industrial undertaking whose total fixed investment is less than Tk.100 million.
The Bank also supports development of trade, business and other commercial activities in the country. It covers the full range of services to the exporters and importers extending various facilities such as cash credit, export cash credit, packing credit, short term loans, local and foreign bills purchase facilities.
BASIC Bank launched a Micro Credit Scheme in 1994. Micro Credit Scheme provides for the poor for generation of employment and income on a sustainable basis particularly in urban and suburban areas.
The bank also provides funds to investment and leasing companies. The Bank has recently created a venture capital fund for equity support to innovative but risky projects.

BASIC Bank runs its communication process in various ways. Such are Internal Communication, External Communication, Grapevine, etc. By using these different forms of communication BASIC Bank communicates with its employees (upper, middle & lower), clients, regulatory authority, and suppliers. In this report we tried to present the basic communication that has been played by BASIC Bank.

18

Recommendation:

1. Being state hold organization it faces difficulty in administrative communication. 2. Customer focus should be emphasized. 3. Advanced training facilities for employees should be arranged. 4. General banking activities needs to be more developed to attract general people (ATM service increase, different savings scheme, easy information facilities, etc.). 5. More advertisement should be promoted to make the bank familier. 6. New technological improvisation should be installed with the existing

19
D. Appendix:

20

21

20

20

rganizational Goals

Organizational Structure
-----------------------
Upward Communication

Downward Communication

Horizontal Communication

Vertical Communication

Informal Communication

Formal Communication

Internal Communication

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

AM

AM

AM

AM

DM

DM

DM

DM

M

AGM

GM

BD

BD

BD

BD

BD

BD

BD(MD)

C

Similar Documents

Premium Essay

Kudler Foods Data Tables

...Kudler Foods Data Tables Kudler Fine Foods was founded in 1998 by Kathy Kudler as an upscale specialty food store. The first location of Kudler was in La Jolla, CA, followed by stores opened in Del Mar and Encinitas. Kudler Fine Foods offers its customers selections in bakery and pastry products, fresh produce, fresh meat and seafood, condiments and packaged foods, as well as cheese and specialty dairy products. This brief will evaluate the design of Kudler’s current inventory data table, make recommendations for improvements to the current tables, and provide information for effectively using pivot tables. Design Element Evaluation Analysis of Kudler’s data tables by end users is essential to Kudler’s inventory control. End users should be able to use inventory data tables to determine the amount of inventory on hand in each location, which in turn will assist end users in determining the amount of inventory to be ordered to replenish each location. Kudler’s current inventory data table provides its end users with general ledger coding, inventory items, store locations and departments, and the value of each inventory on hand. Users of Kudler’s current inventory data table are able to quickly identify the products store location and department by viewing the general ledger code. The first two numbers of the general ledger code indicate the store location of the inventory, while the third number indicates the department the inventory belongs to, and the last two......

Words: 599 - Pages: 3

Premium Essay

Kudler Data Table Analysis

...items through flow charts or in a similar illustrative way so that it can get its user understood the scheme in no time, but the existing table does not possess this type of quality for accounts receivable sales and payments etcetera. All of this should be in a complete manner that may prove to be a complete manual for the business conduct. Data table on their web site and below Entity Relationship diagram are clearly in support of the process of decision making and pertinent improvement thereto. Based on accounting records the table makes the management up on decision making process. How is the table pertinent to that of accounting records containing the information? Clearly it depicts first off the cost centre namely Department 10 and codifies the items in turn, well sum and quantity direct one on the respective amounts given. Pivot Table also shows total quantity on hand and total amount in a given period Entity Relationship Diagram of Kudler Fine Food Data Table Kudler Database Diagram The above diagram is constructed in such a way that links various items through Variable Characters numbered in a particular way, starting with the table designed for customer data is followed by a table stating information for orders duly codified and assigned a particular ID. The table is adroitly linked with Tax table and Tender that prettily is lin...

Words: 281 - Pages: 2

Premium Essay

Sample

...HANDBOOK of PSYCHOLOGY VOLUME 12 INDUSTRIAL AND ORGANIZATIONALPSYCHOLOGY Walter C. Borman Daniel R. lIgen Richard J. Klimoski Volume Editors Irving B. Weiner Editor-in-Chief 13 THEORIES AND PRACTICES OF ORGANIZATIONAL DEVELOPMENT John R. Austin and Jean M. Bartunek 309 ~ John Wiley & Sons, Inc. CHAPTER 13 Theories and Practices of Organizational Development JOHN R. AUSTIN AND JEAN M. BARTUNEK ORGANIZATION DEVELOPMENT TODAY, NOT YESTERDAY 310 THE CONCEPTUAL 'KNOWLEDGE OF ORGANIZATIONAL DEVELOPMENT 311 Change Process Theories 312 Samples of Contemporary Interventions in Organizational Development 316 Implementation Theories 319 THE CONNECTION BETWEEN IMPLEMENTATION THEORIES AND CHANGE PROCESS THEORIES 321 THE DIVIDE BETWEEN IMPLEMENTATIONTHEORIES AND CHANGE PROCESS THEORIES 322 Barrier 1: Different Knowledge Validation Meth~ 322 Barrier 2: Different Goals and Audiences 323 Barrier 3: Different Theoretical Antecedents 324 STRATEGIES FOR OVERCOMING BARRIERS TO KNOWLEDGE TRANSFER 324 Same-Author Translation 325 Multiple-Author Translation 325 Common Language Translation 326 Translating Implementation Theory to Change Process Theory 326 CONCLUSION 326 REFERENCES 327 From its roots in action research in the 1940s and 1950s (Collier, 1945), and building on Lewin's insight that "there is nothing so practical as a good theory" (Lewin, 1951, p. 169), organizational development has explicitly emphasized both the practice. and the scholarship......

Words: 6321 - Pages: 26

Free Essay

Comparision Table

...Summary Comparison table of dairy ingredients: Fromage frais (Strawberry, Vanilla and Natural) Double Cream and Plain yoghurt Sample | Image | Texture analysis | 1.Fruit puree 30gGelatine (dissolved)30gAfter it is been set mixed with strawberry formage frais 30g | | Nice colour, flavour been rated as OK, texture is not like jelly | 2.Fruit puree 30 gStrawberry fromage frais 30g Gelatine (dissolved)50g | | Not firm set, flavour is there, needs more gelatine, Fromage frais bring pleasant creamy taste, pale colour | 3.Fruit puree 40gStrawberry fromage frais 30gGelatine(dissolved) 40g | | Runny texture, didn’t set well, flavour is there, Fromage frais bring pleasant creamy taste, pale colour | 4.Fruit puree 40gGelatine (dissolved)40gAfter it is been set mixed with plain yoghurt 40g | | Strong overpowering taste of yoghurt, taste a bit sharp, pale colour, texture is not like jelly | 5.Fruit puree 30gGelatine (dissolved)30gPlain yoghurt 50g | | Texture is more like a jelly, but still strong yoghurt taste, pale colour | 6.Fruit puree 30gWhipped cream 30gGelatine(dissolved) 50g | | Pale colour, texture is more like mousse than jelly, whipped cream gives a strong overpowering taste, aftertaste strong creamy, fruit flavour is lost | 7.Fruit puree 30gDouble cream30gGelatine(dissolved) 50g | | Firm set, too strong overpowering cream taste, lost the fruit in the whole composition, pale colour | 8.Fruit puree 10gAgar(dissolved)15gStrawberry fromage frais 5g | | Nice......

Words: 456 - Pages: 2

Premium Essay

Data Table Analysis

...Data Table Analysis ACC/542 May 19, 2014 Data Table Analysis Kudler Fine Foods is an upscale specialty store that is located in the San Diego area. There are three locations: La Jolla, Del Mar, and Encinitas. KFF carries the best domestic and imported fare ranging from bakery and pastry products to cheese and specialty dairy products. The purpose of this paper is to evaluate the design elements of the data tables from an accounting perspective and to recommend improvements to the existing data tables. The paper will also explain how the information in the pivot table may improve decision making for management at KFF. When glancing at KFF’s data tables they seem to be easy to understand by someone with or without an accounting background. The inventory table consists of the components that make up an inventory item. This table is used for managing the inventory and determining the availability of all ingredients that are needed to prepare items. The inventory items are displayed according to the following description items: item ID, inventory ID, perishable, nonperishable, department, category, description, unit of measure, quantity on hand, unit cost, master pack quantity, supplier ID, assembly line, substitute item, and tagalong item. There are changes that can be made to further develop the inventory data at KFF. Entity diagrams are used to illustrate the relationship between entities and their corresponding associations. The different shapes are used to signify...

Words: 654 - Pages: 3

Free Essay

Table

...University of Phoenix Material Website Review Find national, state, and local governmental health agency websites that address the issue you selected in your Week One assignment. Follow the example to document your findings in the table. Health issue: _Teen Pregnancy__________________________ |Website |Website Information Type |Type of Surveillance: |Data changes over time: |Identify two interventions | | | |survey, self report, |Has the incidence |that affect the issue. | | | |statistics, case report, |increased or decreased? | | | | |and so forth | | | |Example: http://www.cdc.gov/media/h1n1flu/index.htm#FAS |Table of contents, search, |Statistics and |Swine flu incidences have |Vaccine, hand washing, and | | |print, videos, surveillance |self-reporting |decreased. There are now |isolation masks ......

Words: 295 - Pages: 2

Premium Essay

Using Pivot Tables

...Total sales by month by Make Sum of Price | Column Labels | | | | Row Labels | Jan | Feb | Mar | Grand Total | BMW | 43800 | 34499 | 142340 | 220639 | Ford | 92361 | 12680 | 25220 | 130261 | GMH | 12400 | 18900 | 22800 | 54100 | Hyundai | 34500 | | | 34500 | KIA | 12800 | 10500 | 19700 | 43000 | Mitsubishi | 3500 | 8600 | 30700 | 42800 | Nissan | | 27600 | 100020 | 127620 | Peugot | 12400 | 19900 | 8532 | 40832 | Renault | 21090 | 30599 | 5600 | 57289 | Toyota | 41855 | 22100 | 43489 | 107444 | Volkswagen | 45700 | 17900 | 70122 | 133722 | Grand Total | 320406 | 203278 | 468523 | 992207 | Difference in total sales from previous month by Make Sum of Price | Column Labels | | | | Row Labels | Jan | Feb | Mar | Grand Total | BMW | | -9301 | 107841 | | Ford | | -79681 | 12540 | | GMH | | 6500 | 3900 | | Hyundai | | -34500 | 0 | | KIA | | -2300 | 9200 | | Mitsubishi | | 5100 | 22100 | | Nissan | | 27600 | 72420 | | Peugot | | 7500 | -11368 | | Renault | | 9509 | -24999 | | Toyota | | -19755 | 21389 | | Volkswagen | | -27800 | 52222 | | Grand Total | | -117128 | 265245 | | Chart of total sales for each region each month, showing amount of sales by each salesperson Total sales and total commission earned (at 5%) for each salesperson, by month Row Labels | Sum of Price | Sum of commission | Jan | 320406 | 16,020 | Hector Smith | 109355 | ...

Words: 398 - Pages: 2

Premium Essay

Data Table Analysis

...Evaluation Data Tables Data Table analysis is essential to the success of Kudler, the information provided in these tables is available for the end user to determine inventory levels and when ordering is needed. The design of data tables organizes the financial data into department, financial codes, items and then sums of total amount of transaction. Data tables maximize the visual and informational presentation for the financial data. The user can easily identify information about each item as belonging to certain department, and how many items were received at the given cost for a certain period. It allows finding total amount and quantity on hand for an item and calculating average price for an item. Entity relationship diagram illustrates the hierarchy of how information reviewed by end users. The data represented in entity relation diagrams (E-R) includes the business entities and the relationship among them. E-R diagrams use four symbols: rectangles to represent entities, diamonds to describe relationship, ovals describe the entity, characteristics, and connecting lines depicts relationships. Recommendation for improvements to the Data Tables The Pivot Table is two-dimensional statistical summay of database information and can be improved by arranging the codes chronologically and sorting the data by compiling the list of product inventory levels. This will facilitate monitoring items for a department that has different items to sell. Data sorting will......

Words: 411 - Pages: 2

Premium Essay

Data Table Analysis

... Data Table Analysis Sonya Cunningham University Of Phoenix Accounting Information System ACC/542 Eva King May 25, 2015 Data Table Analysis Kudler Fine Foods, established in 1998 is a specialty food store. The products at Kudler Fine Food are fresh and the inventory must be correctly tracked. It is very vital to the company in becoming successful. This paper will address the following regarding Kudler Fine Foods: evaluating the design elements of the data tables from an accounting perspective, recommend improvements to the data tables and explain how the information in the pivot table may improve decision making for management at Kudler Fine Foods; include an example from the data. It will also include an entity relationship diagram illustrating the existing data tables and a pivot table on Kudler inventory data from the company intranet. Evaluation of the design elements of the data tables from an accounting perspective Data Table is very basic but yet play a very big role in the achievement of Kudler Fine food. The company uses this data to decide when to order more inventory and also to manage inventory. The design of data tables categorizes the financial information into financial codes, items, department and the sums of total amount of transaction. It contains four columns: the GL Code, Inventory Item, Summary Line Item, and Amount. The GL codes consist of six numbers. The first two are store numbers and the last four numbers represent the department the item is......

Words: 769 - Pages: 4

Free Essay

Tables

...Appendix B: Tables TABLE 1 CUMULATIVE PROBABILITIES FOR THE STANDARD NORMAL DISTRIBUTION Entries in the table give the area under the curve to the left of the z value. For example, for z = –.85, the cumulative probability is......

Words: 8439 - Pages: 34

Premium Essay

Kudler Pivot Table

...Data Table Analysis Data Table Analysis Kudler’s Fine Foods is a gourmet food store that provides specialized products in the Southern California region. Since the inventory of the store is perishable, it is important to have control of the inventory on hand and put in place a procedure for replacing the inventory promptly. If Kudler’s has too much inventory on hand, the loss of revenues due to waste increases. Alternatively, if Kudler’s cannot replace inventory fast enough, they risk alienating customers who count on them to provide gourmet specialty products that are hard to find in the grocery store chains. By evaluating the design elements of the data tables, implementing the recommended improvements to the data tables and utilizing pivot tables to get a more accurate picture of the inventory ordering and processing system, Kudler’s should be able to increase their bottom line. The inventory table that Kudler’s uses contain the components that make up an item. The items listed include a general ledger code, item description, summary line item, and cost (Apollo, 2013). An evaluation of the database tables will provide suggestions for improvements of their data system. One of the most important components of Kudler’s inventory is missing from their database table. A recommendation would be to include a purchase date or an expiration date of each item. Since perishable items are so prominent in the business, the ability to have an alert system for almost expired items,......

Words: 465 - Pages: 2

Premium Essay

Data Table Analysis

...Data Table Analysis Accounting 542 November 6, 2015 Data Table Analysis Organizations rely heavily on receiving accurate data and information to make strategic business decisions. The concept is a critical aspect for modern commerce, since technological advances allows any business to track, trace, and predict inventory usage up to the moment. Each diagram in an analyses alludes to how accurate an organization’s methodology for operations is. Data tables are a useful tool for organizations to determine a cost-effective method for improving inventory control and for creating methods to improve business processes. Evaluate Data Table Design Elements from an Accounting Perspective Kudler’s Fine Foods’ requires the use of data tables for management to perform an accurate analysis for controlling inventory. Personnel must possess information with little effort to perform daily operations. A data table’s ability to organize information is a large contributor in management’s ability to order adequate inventory. The information available also helps management calculate the Just in Time (JIT) inventory method. Supplemental, the inventory information is crucial to determine when to order more inventory and the amount to order as well. The grocery store’s current inventory data table illustrates critical information such as, item codes, inventory items, locations, and the total value of the inventory (and each......

Words: 673 - Pages: 3

Free Essay

Table

...CONVERSION TABLES HOBBY CONVERSION CHART SCALE EQUIVALENTS COMPUTED TO THE NEAREST 1/64” 1” = 100’ 1” = 75’ 1” = 60’ 1” = 50’ 1” = 40’ 1” = 30’ 1” = 20’ 1” = 10’ 1/32” = 1’ 1/16” = 1’ 3/32” = 1’ 1/8” = 1’ 3/16” = 1’ 1/4” = 1’ 3/8” = 1’ 1/2” = 1’ 3/4” = 1’ 1” = 1’ 1:1200 1:900 1:700 1:600 1:500 1:400 1:250 1:125 1:400 1:200 1:125 1:100 1:75 1:48 1:32 1:24 1:16 1:12 ACTUAL SIZE 1” = 1’ 1:12 G 1:24 #1 1:32 2” 4” 6” 8” 10” 1’ 2’ 3’ 4’ 5’ 10’ 5/32” 11/32” 1/2” 21/32” 27/32” 1” 2” 3” 4” 5” 10” 5/64” 11/64” 1/4” 21/64” 27/64” 1/2” 1” 1-1/2” 2” 2-1/2” 5” 1/16” 1/8” 3/16” 1/4” 5/16” 3/8” 3/4” 1-1/8” 1-1/2” 1-7/8” 3-3/4” O 1:48 S 1:64 HO 1:87 TT 1:120 N 1:160 Z 1:250 3/64” 5/64” 1/8” 11/64” 13/64” 1/4” 1/2” 3/4” 1” 1-1/4” 2-1/2” 1/32” 1/16” 3/32” 1/8” 5/32” 3/16” 3/8” 9/16” 3/4” 15/16” 1-7/8” 1/64” 3/64” 1/16” 3/32” 7/64” 9/64” 9/32” 13/32” 35/64” 11/16” 1-3/8” 1/64” 1/32” 3/64” 1/16” 5/64” 3/32” 13/64” 19/64” 13/32” 1/2” 1” 1/64” 1/64” 1/32” 3/64” 1/16” 5/64” 5/32” 15/64” 19/64” 3/8” 3/4” 1/64” 1/64” 1/64” 1/32” 3/64” 1/16” 7/64” 5/32” 7/32” 17/64” 35/64” FRACTION TO DECIMAL CONVERSION CHART FRA. DEC. FRA. DEC. FRA. DEC. FRA. DEC. 1/64 1/32 3/64 1/16 5/64 3/32 7/64 1/8 9/64 5/32 11/64 3/16 13/64 7/32 15/64 1/4 .0156 .0312 .0468 .0625 .0781 .0937 .1093 .125 .1406 .1562 .1718 .1875 .2031 .2187 .2343 .2500 17/64 9/32 19/64 5/16 21/64 11/32 23/64 3/8 25/64 13/32 27/64 7/16 29/64 15/32 31/64 1/2 .2656 .2812 .2968 .3125 .3281 .3437 .3593 .3750 .3906 .4062...

Words: 1180 - Pages: 5

Premium Essay

Data Table Analysis

...Data Table Analysis Crystal Spencer ACC/542 February 27, 2012 Christy Countryman Kudler Fine Food is the fast growing fine food specialty business that was established in 1998, and at each of their stores the company first initially selected Microsoft Access as their AIS to track employees, customer, inventory, orders, and sales. Kudler’s products have perishable inventory that must be properly tracked. This brief will evaluate database tables from an accounting perspective. In addition, gives recommendations for improvement, pivot table, and entity relationship diagram will help the company have a better decision-making process. Assessment of the design elements of the data tables from an accounting perspective. Data Table analysis is vital to the success of the business, the data given in these tables is available for the end user to determine how much inventory is available and when it require to order more inventory. The purpose of the data tables will arranges the financial data into department, financial codes, items, and sums of total amount of transaction. Data table get the most out of the informational and visual presentation for the financial data. The user of the data can easily to identify the item belongs to certain department and how many items were received at the given cost for a certain period. In addition, the data allows in finding quantity and total amount on hand for an item and calculating average price of the item. ...

Words: 874 - Pages: 4

Free Essay

Data Table Analysis

...Data Table Analysis University of Phoenix Accounting Information Systems ACC/542 Anita Rodriguez April 2, 2012 Data Table Analysis Kudler Fine Foods was founded by Kathy Kudler in La Jolla in 1998. In the beginning, Kudler Fine Foods had only one store, causing Kathy Kudler to make the decision to use the Microsoft Access database to monitor and maintain sales, employees, inventory, customers, and orders. Because Kudler Fine Foods inventory was perishable, it was imperative to track properly these items. Possessing too much inventory was always a concern of Kudler Fine Foods, if the inventory information was inaccurate, outdated, or incomplete the information would be of no use to the company. This paper will present suggestions for enhancement, evaluate database tables from an accounting point of view, and generate a pivot table to assist the management of Kudler Fine Foods with preparing improved reports in accounting and enhance the decision-making process. Evaluate the design elements of the data tables from an accounting perspective The inventory tables allow the users to establish when to order additional inventory and what inventory is on hand. The use of data table analysis is of the essence for this process. The data table is intended to categorize the data into departments, financial codes, items, and it adds the total amount for the transaction codes. It also adds the amount of items in the inventory during a specified period. The data table......

Words: 903 - Pages: 4