1 / 24

Development and Applying of a Brazilian Business Game Using Excel Spreadsheet

Development and Applying of a Brazilian Business Game Using Excel Spreadsheet. Development and Applying of a Brazilian Business Game Using Excel Spreadsheet. 1. INTRODUCTION 2. WHAT IS THE MEANING OF LEARNING: ESSENTIAL, IMPORTANT OR ACCIDENTAL? 3. LEARNING THROUGH S&G

hester
Download Presentation

Development and Applying of a Brazilian Business Game Using Excel Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet Prof. Dr. Luiz Cesar Barçante

  2. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 1. INTRODUCTION • 2. WHAT IS THE MEANING OF LEARNING: ESSENTIAL, IMPORTANT OR ACCIDENTAL? • 3. LEARNING THROUGH S&G • 3.1What are Business Games? • 4. A BRAZILIAN MODEL OF BUSINESS GAME • 4.1 Raw Material • 4.2 Evaluation Criteria • 4.3 The Game Modeling • 4.4 Excel Spreadsheet • CONCLUSIONS • REFERENCES Prof. Dr. Luiz Cesar Barçante

  3. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • INTRODUCTION • Many Brazilian professionals developing and applying games on logistics, HR, finance, marketing, whether or not computer-based, and each author develops and applies the game that is more convenient to them. However, according to the bibliography referenced, there has not been much concern about developing a game based on Excel spreadsheet. Prof. Dr. Luiz Cesar Barçante

  4. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 2. WHAT IS THE MEANING OF LEARNING: • ESSENTIAL, IMPORTANT OR ACCIDENTAL? Essential is something that you will have to take care of immediately. Taking care of the essential is what people should have as a priority. Important is something that is about to become essential, but is not quite there yet. Therefore, preparing for the important is “important”, but not more than taking care of the essential. What about the accidental? That is something that we do not know when or even if is going to happen. If learning is an activity in which motivation plays a significant role, how can someone be motivated to learn something that they consider accidental? Prof. Dr. Luiz Cesar Barçante

  5. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 3. LEARNING THROUGH S&G • According to Barçante (2010) the literature on S&G deems some aspects as critical: • Enabling the immediate application of the material learned; • Promoting the participation of the trainees; • Offering the opportunity of interaction with peers; • Emphasizing the individual as a whole: emotion and cognition; • Creating conditions to get in touch with the environment; • Including situations of variability and uncertainty; • Proposing the exercise in a structured and oriented manner; • Enabling the assessment of the experience by the participants; • Including feedback comments offered by the teacher. Prof. Dr. Luiz Cesar Barçante

  6. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 3. 1 What are Business Games? • Beppu (1984) … as a simplified mathematical abstraction of a situation in connection with the business world … means of management decisions for successive and sequential periods. • Martinelli (1987) … as a method of teaching and personal development, as well as the sequential aspect, which motivates and brings them as close as possible to the business reality which they are trying to simulate. Prof. Dr. Luiz Cesar Barçante

  7. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 3. 1 What are Business Games? • Wilhelm (1997) … as structured corporate systems that by simulating various activities inherent to a company … creating situations that involve issues related to production, distribution and consumption … • Gramigna (1993) … is a previously planned activity … that reproduce their day-to-day reality. Prof. Dr. Luiz Cesar Barçante

  8. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 4. A BRAZILIAN MODEL OF BUSINESS GAME JOGAI (Industrial Administration Game) & JEI (Industrial Engineering Game) are used in the Corporate Simulation subject of the 8th term of the Industrial Administration and Simulation subject of the 10th term of the Industrial Engineering undergraduate program at CEFET-RJ. The classes involve contents such as Vision and Mission; Excellence Principles; Costs x Pricing; Revenues x Expenses; DLP; Assets x Liabilities and Balance Sheet. In general, teams are divided into: Three Mines ; Five Goldsmiths; Three Jewelry Stores ; One Auditor Committee. Prof. Dr. Luiz Cesar Barçante

  9. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet 4.1 Raw Material Elka Magic Pins, “Fig. 1”, are used. They come in five colors and four shapes, for a total of twenty different pins. White – Platinum; Yellow – Gold; Blue – Aquamarine; Green – Tourmaline; Red – Rubellite. Figure 1. Raw Material Prof. Dr. Luiz Cesar Barçante

  10. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 4.2 Evaluation Criteria • TheEvaluationQuestionnaireisbasedontheExcellenceCriteria of theNationalFoundationforQuality, using a scale of 1 (worst) to 5 (best) in eachcriterion. • Leadership – 110 points (AC) • 1. TheVisiondefinedbyseniormanagementisclear. • 2. TheMissiondefinedbytheseniormanagementconsiderstheorganization’svalues, focusonthecustomer, mutual respect and trust, ethicalbehavior, theparticipation of people, and high performance expectations. • 3. The manager assumeshis/her place in thecompany. Abbreviation: AC – Auditor Committee; SM – SupplierMarket; CM – ConsumerMarket; EO – Everyone; GAME – Performance at JOGAI. Prof. Dr. Luiz Cesar Barçante

  11. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • Strategies and Plans – 60 points • 4. Thecompany has performedcustomersatisfactionsurveys. (post-sale) (CM) • 5. Actions are takenbasedonsatisfactionsurveys and customercomplaints. (CM) • 6. Thecompanysearchesto set partnershipswithitscompetitors. (AC) • 7. Thecompanytakesactionsbasedontheanalysis of itscompetitors. (AC) • 8. Thecompanyanalysesthecompetitiveenvironment in search of new opportunities. (AC) • 9. Actions are taken in connectionwiththeanalysis of thecompetitiveenvironment. (AC) • 10. Thecompanysearchesto set partnershipswiththeSupplyingMarkets. (SM) • 11. Actions are takenbasedonthesearchforpartnershipwithSupplyingMarkets. (SM) Prof. Dr. Luiz Cesar Barçante

  12. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • Customers (CM) – 60 points • 12. The company knows the expectations and the current and future needs of Customer Markets. (pre-sale) • 13. The company evaluates and improves its product based on the information from Customer Markets. • 14. The company has a line of products differentiated by quality. Prof. Dr. Luiz Cesar Barçante

  13. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • Society – 60 points • 15. Peoplefromtheworkforce, suppliers and otherstakeholders are madeaware and involved in mattersconcerning social and environmentalresponsibility. (AC) • 16. Thecompany has set anethicscode. (AC) • 17. Thecompanycommunicatestothesocietytheimpacts and informationconcerningitsproducts, processes and facilities. (EO) • 18. Thelevel of satisfaction of thecommunitywiththecompanyisidentified and evaluated. (EO) Prof. Dr. Luiz Cesar Barçante

  14. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet Information and Knowledge – 60 points • 19. Theinformationaboutcompetitorsisusedbythecompany. (AC) • 20. Theinformationaboutproductqualityisusedbythecompany. (AC) • 21. Theinformationfromcustomersisusedbythecompany. (CM) • 22. Theinformationaboutoperational performance isusedbythecompany.. (AC) • 23.The informationaboutfinancial performance isusedbythecompany. (AC) Prof. Dr. Luiz Cesar Barçante

  15. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet People – 90 points (AC) • 24. People are satisfiedwithwhatthey do. • 25. The Business functionisempoweredtoact. • 26. TheProductionfunctionisempoweredtoact. • 27. Thecommunicationisclear, objective and noise-free. Prof. Dr. Luiz Cesar Barçante

  16. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet Processes – 110 points • 28. Bestaveragepricepaid in thepurchase of raw-material. (GAME). • 29. Bestaveragepricereceived in the sale of raw-material in theproduct. (GAME) • 30. Valueadded: Price of final productsold / cost of raw-material purchased. (GAME) • 31. Delivery lead-time (periodfromthemomentthebuyerconfirmedthepurchaseuntilproductisreceivedbysuchbuyer). (CM) • 32. Thecriteriausedtoselect and qualifysuppliers are clear and welldefined. (AC) Prof. Dr. Luiz Cesar Barçante

  17. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet Results – 450 points • 33. Thecompany has metallexpectations. (CM) • 34. Profitability – ROI (GAME) • 35. Market Share: amount of sales. (GAME) • 36. Financial Share: Value of sales. (GAME) • 37. OrganizationalClimate. (AC) • 38. Ranking of companiesthathavebestdealtwithSupplierMarket. (SM) • 39. Considering all items evaluated, what score would you give the company? (EO) Prof. Dr. Luiz Cesar Barçante

  18. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet • 4.3 The Game Modeling Figure 2. The game modeling Prof. Dr. Luiz Cesar Barçante

  19. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet 4.4 Excel Spreadsheet Figure 3 – Miners 1 Excel Spreadsheet – Bill Prof. Dr. Luiz Cesar Barçante

  20. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet 4.4 Excel Spreadsheet Figure 4 – Miners 1 Excel Spreadsheet – Evaluation (there ins’t Goldsmith W) Prof. Dr. Luiz Cesar Barçante

  21. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet 4.4 Excel Spreadsheet Figure 5 – Miners 1 Excel Spreadsheet – Investments Prof. Dr. Luiz Cesar Barçante

  22. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet 4.4 Excel Spreadsheet Figure 6 – Goldsmiths’ Excel Spreadsheet – Financial Report Prof. Dr. Luiz Cesar Barçante

  23. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet 4.4 Excel Spreadsheet Figure 7 – Companies’ Results Excel Spreadsheet Prof. Dr. Luiz Cesar Barçante

  24. DevelopmentandApplyingof a Brazilian Business Game Using Excel Spreadsheet CONCLUSIONS The use of Excel Spreadsheet as a business game support in Brazil has been efficient due to some aspects, as follows: • It enables a quick release of data; • The costs are relatively low; • The use of printed forms are unnecessary; • It is easy to access and manipulate it; One thing is for sure, it is very rewarding to see students who usually just “attend class”, and who are not sure of what they will do for a living, dive headfirst into the simulated market trying, by means of failed attempt vs. successful attempt, to get an opportunity to make a difference in their daily real lives. Prof. Dr. Luiz Cesar Barçante

More Related