LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER
Autor(a) principal: | |
---|---|
Data de Publicação: | 2007 |
Outros Autores: | , , |
Tipo de documento: | Artigo |
Idioma: | por |
Título da fonte: | Revista Universo Contábil |
Texto Completo: | https://ojsrevista.furb.br/ojs/index.php/universocontabil/article/view/121 |
Resumo: | Consumer market has induced companies in a constant process of changes, because it demands more and more quality products at a lower cost. The companies react by launching new products, promoting changes in their organizations, in all the aspects of their management, in order to improve processes and to qualify people. In such circumstances, it becomes vital to exploit efficiently all resources available in the organization, optimizing their utilization, controlling and reducing costs, increasing the effectiveness and maximizing the results. To find managerial or controllership tools that can facilitate that task is the challenge proposed here. A methodology which can make it possible to help optimize the company resources has been presented. Using the Solver function of Linear Programming (LP), associated with concepts of the Theory of Constraints, a case study has been carried out in a furniture factory, Colliseu Indústria de Móveis Ltda., that has office desks production as its main activity. Results obtained after the LP application have presented a series of strategic information that enable the manager, for instance, to choose the best product to be produced in the same process, to decide on launching a new product, to prompt the sale of already existing products, to accept or not a special order, among others. Keywords: Costs. Restrictions. Linear programming. |
id |
FURB-5_4d2e94304008fca11623aeacdf8b6bf7 |
---|---|
oai_identifier_str |
oai:ojs.bu.furb.br:article/121 |
network_acronym_str |
FURB-5 |
network_name_str |
Revista Universo Contábil |
repository_id_str |
|
spelling |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVERPROGRAMAÇÃO LINEAR: ESTUDO DE CASO COM UTILIZAÇÃO DO SOLVER DA MICROSOFT EXCELCustosRestriçõesProgramação Linear.Consumer market has induced companies in a constant process of changes, because it demands more and more quality products at a lower cost. The companies react by launching new products, promoting changes in their organizations, in all the aspects of their management, in order to improve processes and to qualify people. In such circumstances, it becomes vital to exploit efficiently all resources available in the organization, optimizing their utilization, controlling and reducing costs, increasing the effectiveness and maximizing the results. To find managerial or controllership tools that can facilitate that task is the challenge proposed here. A methodology which can make it possible to help optimize the company resources has been presented. Using the Solver function of Linear Programming (LP), associated with concepts of the Theory of Constraints, a case study has been carried out in a furniture factory, Colliseu Indústria de Móveis Ltda., that has office desks production as its main activity. Results obtained after the LP application have presented a series of strategic information that enable the manager, for instance, to choose the best product to be produced in the same process, to decide on launching a new product, to prompt the sale of already existing products, to accept or not a special order, among others. Keywords: Costs. Restrictions. Linear programming.O mercado consumidor tem levado as empresas a um processo constante de mudanças, pois exige cada vez mais produtos de qualidade e com menor custo. As empresas reagem lançando novos produtos, promovendo mudanças nas suas organizações, em todos os aspectos de sua gestão, no sentido de melhorar processos e capacitar pessoas. Diante disso, torna-se vital tirar maior proveito de todos os recursos disponíveis na organização, otimizando a utilização, controlando e reduzindo custos, aumentando a eficácia e maximizando os resultados. Encontrar ferramentas gerenciais ou de controladoria que facilitem essa tarefa é o desafio proposto aqui. Procura-se apresentar uma metodologia que possibilite auxiliar na tarefa de otimizar os recursos da empresa. Por meio da Programação Linear, função Solver, associada aos conceitos da Teoria das Restrições, efetuou-se um estudo de caso na Colliseu Indústria de Móveis Ltda, cuja principal atividade é a produção de mesas para escritório. Os resultados expostos, após a utilização da Programação Linear, apresentaram uma série de informações estratégicas que possibilitam ao gestor, por exemplo, escolher o melhor produto a ser produzido no mesmo processo, decidir lançar um novo produto, incentivar a venda dos produtos existentes, aceitar ou não uma encomenda especial, dentre outras. Palavras-chave: Custos. Restrições. Programação Linear.Universidade Regional de Blumenau2007-07-03info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdfhttps://ojsrevista.furb.br/ojs/index.php/universocontabil/article/view/12110.4270/ruc.20062Revista Universo Contábil; v. 2 n. 2 (2006); 54-661809-33371809-3337reponame:Revista Universo Contábilinstname:Universidade Regional de Blumenau (FURB)instacron:FURBporhttps://ojsrevista.furb.br/ojs/index.php/universocontabil/article/view/121/80Copyright (c) 2014 Revista Universo Contábilinfo:eu-repo/semantics/openAccessScalabrin, IdionirMores, Claudionor JoséEnderli Bodanese, Ronaldode Oliveira, José Adrelino2008-11-17T13:17:55Zoai:ojs.bu.furb.br:article/121Revistahttps://proxy.furb.br/ojs/index.php/universocontabil/PUBhttps://proxy.furb.br/ojs/index.php/universocontabil/oai||universocontabil@furb.br1809-33371809-3337opendoar:2008-11-17T13:17:55Revista Universo Contábil - Universidade Regional de Blumenau (FURB)false |
dc.title.none.fl_str_mv |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER PROGRAMAÇÃO LINEAR: ESTUDO DE CASO COM UTILIZAÇÃO DO SOLVER DA MICROSOFT EXCEL |
title |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER |
spellingShingle |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER Scalabrin, Idionir Custos Restrições Programação Linear. |
title_short |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER |
title_full |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER |
title_fullStr |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER |
title_full_unstemmed |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER |
title_sort |
LINEAR PROGRAMMING: A CASE STUDY WITH THE USE OF MICROSOFT EXCEL SOLVER |
author |
Scalabrin, Idionir |
author_facet |
Scalabrin, Idionir Mores, Claudionor José Enderli Bodanese, Ronaldo de Oliveira, José Adrelino |
author_role |
author |
author2 |
Mores, Claudionor José Enderli Bodanese, Ronaldo de Oliveira, José Adrelino |
author2_role |
author author author |
dc.contributor.author.fl_str_mv |
Scalabrin, Idionir Mores, Claudionor José Enderli Bodanese, Ronaldo de Oliveira, José Adrelino |
dc.subject.por.fl_str_mv |
Custos Restrições Programação Linear. |
topic |
Custos Restrições Programação Linear. |
description |
Consumer market has induced companies in a constant process of changes, because it demands more and more quality products at a lower cost. The companies react by launching new products, promoting changes in their organizations, in all the aspects of their management, in order to improve processes and to qualify people. In such circumstances, it becomes vital to exploit efficiently all resources available in the organization, optimizing their utilization, controlling and reducing costs, increasing the effectiveness and maximizing the results. To find managerial or controllership tools that can facilitate that task is the challenge proposed here. A methodology which can make it possible to help optimize the company resources has been presented. Using the Solver function of Linear Programming (LP), associated with concepts of the Theory of Constraints, a case study has been carried out in a furniture factory, Colliseu Indústria de Móveis Ltda., that has office desks production as its main activity. Results obtained after the LP application have presented a series of strategic information that enable the manager, for instance, to choose the best product to be produced in the same process, to decide on launching a new product, to prompt the sale of already existing products, to accept or not a special order, among others. Keywords: Costs. Restrictions. Linear programming. |
publishDate |
2007 |
dc.date.none.fl_str_mv |
2007-07-03 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
https://ojsrevista.furb.br/ojs/index.php/universocontabil/article/view/121 10.4270/ruc.20062 |
url |
https://ojsrevista.furb.br/ojs/index.php/universocontabil/article/view/121 |
identifier_str_mv |
10.4270/ruc.20062 |
dc.language.iso.fl_str_mv |
por |
language |
por |
dc.relation.none.fl_str_mv |
https://ojsrevista.furb.br/ojs/index.php/universocontabil/article/view/121/80 |
dc.rights.driver.fl_str_mv |
Copyright (c) 2014 Revista Universo Contábil info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Copyright (c) 2014 Revista Universo Contábil |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
Universidade Regional de Blumenau |
publisher.none.fl_str_mv |
Universidade Regional de Blumenau |
dc.source.none.fl_str_mv |
Revista Universo Contábil; v. 2 n. 2 (2006); 54-66 1809-3337 1809-3337 reponame:Revista Universo Contábil instname:Universidade Regional de Blumenau (FURB) instacron:FURB |
instname_str |
Universidade Regional de Blumenau (FURB) |
instacron_str |
FURB |
institution |
FURB |
reponame_str |
Revista Universo Contábil |
collection |
Revista Universo Contábil |
repository.name.fl_str_mv |
Revista Universo Contábil - Universidade Regional de Blumenau (FURB) |
repository.mail.fl_str_mv |
||universocontabil@furb.br |
_version_ |
1798945114462093312 |