Hello everyone and welcome to a new
Computer tutorial with Ebm
Lesson number 27 excel course
2016 well and took two lessons
By using the tool Solver today we will
make a third well let's do
an example and before doing this example
if you have not seen them lesson 25 and 26
I advise you to see just in case
In this example we own
pizzeria and we can only make
pizzas daily number three
classes we have then what
we want to make a solver that we
few can manufacture kick with
the greatest benefit and not spend the
limitations we have
I have three types of pizza
Pepperoni vegetarian and special
and both Pepperoni as
considered vegetarian pizzas
traditional well let's
make interim operations
First let's get the total of what
I would gain by selling Pepperoni
I put myself in B3 and
b4 b3 multiplied by
as yet I have
the pizzas I'll sell it
obviously I will leave zero but
That will help me then as
explained in previous tutorials
We do vegetarian, serious b5 by
b6 and finally we make pizza
special that would b9 by b10
Now I
here and in total sales
I do the sum of the three bone
B3 B7 and B11
Now I make
total of pizzas because it would be an equal and
b2 + b6 + b10
pizzas
traditional as we have said are of
Pepperoni and vegetarian
and B2 + B6 would
While
intermediate operations and I have now
let's go to the solver as I always go
for data and I open the solver
I have it resolved but I tell
reset everything to start
to establish the objective
total sales are I put
The maximum and cells to varying
we have seen other times
they will be b2 predicament Control
B6 and B10
now let the
I would add restrictions
maximum pizzas that I can
manufacture is 150 then the box h3
esmenor or equal to 150 or
either add or h6 and now tells me that
traditional as much
I can make 90
then I come here I tell pizzas
Traditional it would
Less than or equal H14 H7
prodded add the maximum amount
vegetarian that I can manufacture are
25 because then I would come to that
search for vegetarians that I have
Here vegetarian would
in this case sometimes
B6 less or equal to H8
Maximum supreme supreme is what I have
Special pizza place here would be 60
B10 less than or equal H9
and then I have all
standards set and I'll give you solve
there has left me the result
as you can see it has not skipped any
rule because I can sell 65
25 vegetarian pepperoni what
I can sell up to 60 of which
call special and that never in
I spent no time or 150
pizzas would be in total that
I can sell and traditional
He not happened to me because it would just
90 and with total sales
of 5525 very well as far
today's tutorial if they liked me
They can give like can subscribe to
Channel already know me down there where
puts subscribe and so they will be
informed of the video or videos that we got
every day I can follow the network
social and web pages Ebm
Garret computing and Ebm
any comments or suggestions or
request puts me under I
He answered all well many
and thanks to the video tomorrow


For more infomation >> RED BALL 4 RED BALL GAME AGAINST EVIL SQUARES AND the BOSS #14 - cartoon game video for kids - Duration: 10:22.
For more infomation >> cats meow says - children songs - Baby songs - Funny pussies - Duration: 2:17.
For more infomation >> Como Exitar A Una Mujer En Segundos Con Este Poderoso Conocimiento - Duration: 5:08. 
For more infomation >> 3 " Bộ Phận " Của Cá "Có Chết" Bạn Cũng Không Được Ăn - Duration: 12:09. 
For more infomation >> Ăn Trứng Vịt Lộn Kiểu Này Tốt Hơn Ngàn Lần Dùng Nhân Sâm - Duration: 10:25. 
For more infomation >> Bạn Sẽ "Hối Hận Cả Đời" Nếu Ăn Bơ Mà Bỏ Hạt Chẳng Khác Nào Vứt ĐI Thần Dược - Duration: 10:18.
For more infomation >> Em gái nghịch dại ăn quá nhiều xoài và 1 cái kết bất ngờ xẩy ra hối không kịp - Duration: 2:55. 

Không có nhận xét nào:
Đăng nhận xét