Mathematical Modeling of Feed Rations Using Solver Software

Animal nutrition is a very large area of study where mathematical modeling is a success, as in many areas. In addition to shaping the main physiological processes underlying the farm animals yielding, the objective function optimization issue (i.e. total expenditure on fodder) arises both in terms o...

Full description

Saved in:
Bibliographic Details
Published in:Bulletin of University of Agricultural Sciences and Veterinary Medicine Cluj-Napoca Vol. 74; no. 1; pp. 21 - 25
Main Authors: ROTARU, Ancuta Simona, BENTEA, Mihai, POP, Ioana, VATCA, Anamaria, ANDRONIE, Luisa
Format: Journal Article
Language:English
Published: AcademicPres 18.05.2017
Subjects:
feed rations, mathematical models,objective function, optimization, Solver
ISSN:1843-5262, 1843-536X
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Abstract Animal nutrition is a very large area of study where mathematical modeling is a success, as in many areas. In addition to shaping the main physiological processes underlying the farm animals yielding, the objective function optimization issue (i.e. total expenditure on fodder) arises both in terms of protein and vitamin's intake of nutrients and in terms of their cost. Optimising feed rations through mathematical modeling monitors the amount of food an animal needs throughout the day, so that the objective function (also called goal function of efficiency function) be minimum or maximum depending on the problem requirements. In order to solve mathematical model one needs fodder varieties that are part of the fodder basis and this feed (in kg) must be purchased or produced, and the solving method we use is the Solver tool of Microsoft Office Excel software . In order to optimize the objective function one should observe the following restrictions concerning the provisioning of total feed expressed in nutrients: provisioning of the necessary fodder by groups of fodder, observing proportions in fodder structure by groups of fodder, complying with fodder plants culture technologies and taking into account the availability of land designated for the forage and fodder crops. The mathematical model consists of three parts: the system of restrictions, non-negativity conditions and objective function. This paper shows the effectiveness of the Solver IT tools solver in dealing with many linear programming issues, including the establishment of feed rations as ensuring a good and well balanced food in terms of nutrition ensures both a good maintenance of the animals and an increased production.
AbstractList Animal nutrition is a very large area of study where mathematical modeling is a success, as in many areas. In addition to shaping the main physiological processes underlying the farm animals yielding, the objective function optimization issue (i.e. total expenditure on fodder) arises both in terms of protein and vitamin's intake of nutrients and in terms of their cost. Optimising feed rations through mathematical modeling monitors the amount of food an animal needs throughout the day, so that the objective function (also called goal function of efficiency function) be minimum or maximum depending on the problem requirements. In order to solve mathematical model one needs fodder varieties that are part of the fodder basis and this feed (in kg) must be purchased or produced, and the solving method we use is the Solver tool of Microsoft Office Excel software . In order to optimize the objective function one should observe the following restrictions concerning the provisioning of total feed expressed in nutrients: provisioning of the necessary fodder by groups of fodder, observing proportions in fodder structure by groups of fodder, complying with fodder plants culture technologies and taking into account the availability of land designated for the forage and fodder crops. The mathematical model consists of three parts: the system of restrictions, non-negativity conditions and objective function. This paper shows the effectiveness of the Solver IT tools solver in dealing with many linear programming issues, including the establishment of feed rations as ensuring a good and well balanced food in terms of nutrition ensures both a good maintenance of the animals and an increased production.
Author BENTEA, Mihai
ROTARU, Ancuta Simona
VATCA, Anamaria
POP, Ioana
ANDRONIE, Luisa
Author_xml – sequence: 1
  givenname: Ancuta Simona
  surname: ROTARU
  fullname: ROTARU, Ancuta Simona
– sequence: 2
  givenname: Mihai
  surname: BENTEA
  fullname: BENTEA, Mihai
– sequence: 3
  givenname: Ioana
  surname: POP
  fullname: POP, Ioana
– sequence: 4
  givenname: Anamaria
  surname: VATCA
  fullname: VATCA, Anamaria
– sequence: 5
  givenname: Luisa
  surname: ANDRONIE
  fullname: ANDRONIE, Luisa
BookMark eNo9kNtKAzEQhoNUsNY-gTf7Aqs5bNKsXkmxWmgRtIJ3YXKqW7YbSWrFtzdurXPzD__Ax_Cdo0EXOofQJcFXhEvGr_UnpP3WdCUkfUMoJfgEDYmsWMmZeBscdyroGRqntMF5BBWyJkN0u4Tdu9vCrjHQFstgXdt06yL4YuacLZ7zIXSpeE2_7Uto9y7m8LsviO4CnXpokxv_5QitZver6WO5eHqYT-8WpSGc47IGiytmiAbDjZt45g21wmDhGXgirOHEgBBU6omdaEulBcq0tBILSWvGRmh-wNoAG_URmy3EbxWgUX0R4lpBzP-3ThktOSVgK4tlBZJK6XKlAWOotSUis9iBZWJIKTr_zyNY9TbV0abKNlVvk_0AiLdtfA
ContentType Journal Article
DBID AAYXX
CITATION
DOA
DOI 10.15835/buasvmcn-asb:12210
DatabaseName CrossRef
DOAJ Directory of Open Access Journals
DatabaseTitle CrossRef
DatabaseTitleList CrossRef
Database_xml – sequence: 1
  dbid: DOA
  name: DOAJ Directory of Open Access Journals
  url: https://www.doaj.org/
  sourceTypes: Open Website
DeliveryMethod fulltext_linktorsrc
Discipline Agriculture
EISSN 1843-536X
EndPage 25
ExternalDocumentID oai_doaj_org_article_cb8521ad4d084a8288ecb8ba00a9bd16
10_15835_buasvmcn_asb_12210
GroupedDBID AAYXX
ADBBV
ALMA_UNASSIGNED_HOLDINGS
BCNDV
CITATION
EBD
ECGQY
EN8
EOJEC
EYRJQ
GROUPED_DOAJ
IPNFZ
KQ8
OBODZ
RIG
RNS
TR2
ID FETCH-LOGICAL-c1550-9ad043c1bac5ce7f3fc2d6c06f3af16dc51ca6628b7d7bd28da23b8d80682933
IEDL.DBID DOA
ISSN 1843-5262
IngestDate Fri Oct 03 12:47:44 EDT 2025
Sat Nov 29 05:54:48 EST 2025
IsDoiOpenAccess true
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Issue 1
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c1550-9ad043c1bac5ce7f3fc2d6c06f3af16dc51ca6628b7d7bd28da23b8d80682933
OpenAccessLink https://doaj.org/article/cb8521ad4d084a8288ecb8ba00a9bd16
PageCount 5
ParticipantIDs doaj_primary_oai_doaj_org_article_cb8521ad4d084a8288ecb8ba00a9bd16
crossref_primary_10_15835_buasvmcn_asb_12210
PublicationCentury 2000
PublicationDate 2017-05-18
PublicationDateYYYYMMDD 2017-05-18
PublicationDate_xml – month: 05
  year: 2017
  text: 2017-05-18
  day: 18
PublicationDecade 2010
PublicationTitle Bulletin of University of Agricultural Sciences and Veterinary Medicine Cluj-Napoca
PublicationYear 2017
Publisher AcademicPres
Publisher_xml – name: AcademicPres
SSID ssj0000626891
Score 1.9880178
Snippet Animal nutrition is a very large area of study where mathematical modeling is a success, as in many areas. In addition to shaping the main physiological...
SourceID doaj
crossref
SourceType Open Website
Index Database
StartPage 21
SubjectTerms feed rations, mathematical models,objective function, optimization, Solver
Title Mathematical Modeling of Feed Rations Using Solver Software
URI https://doaj.org/article/cb8521ad4d084a8288ecb8ba00a9bd16
Volume 74
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVAON
  databaseName: DOAJ Directory of Open Access Journals
  customDbUrl:
  eissn: 1843-536X
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000626891
  issn: 1843-5262
  databaseCode: DOA
  dateStart: 20060101
  isFulltext: true
  titleUrlDefault: https://www.doaj.org/
  providerName: Directory of Open Access Journals
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV09T8MwFLRQxQAD4lN8KwMjVh07cRyYCqJioULQoVv0nu0gBlqUfvD3eU7SKhsLUyTLsqJz5HsXPd8xdpM7OvVTA1wJ1DxRKDiSgOMSwfrSeipxRR02kY1GZjLJXztRX6EnrLEHboDrWzTEMOASJ0wCpA-MpyEEISBHF9dm21T1dMRUcwZL3cTlhTwTUltatpZDKZUcfVzCfPVlpxzmeBdLGe7Pdmip495f08xwn-219WE0aN7rgG356SHbHXxUrUeGP2L3LxurVZoZwszClfJoVkZDoqLorfkHF9XNANH7LLQ-06Nc_EDlj9l4-DR-fOZtBgK3QTzwHJxIlI0JutT6rFSllU5boUsFZaydTWMLWkuDmcvQSeNAKjTOCG2IydUJ601nU3_KogwQUFmZCyQgFaKE2DtMaTnjY-nO2O0ageK7cboogkIIgBVrwAoCrKgBO2MPAaXN1GBTXQ_Q5hXt5hV_bd75fyxywXZk4NpgqWouWW9RLf0V27arxee8uq6_i1_yR77h
linkProvider Directory of Open Access Journals
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Mathematical+Modeling+of+Feed+Rations+Using+Solver+Software&rft.jtitle=Bulletin+of+University+of+Agricultural+Sciences+and+Veterinary+Medicine+Cluj-Napoca&rft.au=ROTARU%2C+Ancuta+Simona&rft.au=BENTEA%2C+Mihai&rft.au=POP%2C+Ioana&rft.au=VATCA%2C+Anamaria&rft.date=2017-05-18&rft.issn=1843-5262&rft.eissn=1843-536X&rft.volume=74&rft.issue=1&rft.spage=21&rft_id=info:doi/10.15835%2Fbuasvmcn-asb%3A12210&rft.externalDBID=n%2Fa&rft.externalDocID=10_15835_buasvmcn_asb_12210
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1843-5262&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1843-5262&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1843-5262&client=summon