Excel - Linear Programming Model Formulas -

I am studying for an exam and I have trouble with a question on the sample exam but have not responded. I went. Can anyone help me please? This is not a programming question strictly speaking, but I was sure that I could get help on the stack. This question is:

This question is:

In the Melbourne Central Complex sells GamesShop, two new computer games, French flops and Argentine Agonies. Client purchase patterns require that at least 20 copies of French flops and at least 25 copies of Argentine pain should be held in stock. The lack of performance requires that at least 50 games and more than 60 games will be stocked. The average cost for the French flop game is $ 130 and how much stock should each game play in order to reduce $ 110 for Argentine agony games?

I need to set up linear functions and then graph it, but I'm stuck in linear formulas. I'm usually setting it in the first table but I'm confused with the barriers of the 50-60 game part.

I am not looking for direct answers. I just want some guidance on how to set up the formula functions. I think this is a lack of data, although I do not experience it.

All help will be appreciated.

Let's start by giving a number of Argentines Agony and F of a French flop.

Pattern of customer purchase requires that at least 20 copies of French flop and at least 25 copies of Argentine pain should be held in stock :

20 & lt; = F

25 & lt; = A

A minimum of 50 games and more than 60 games will be stocked in the total for the lack of performance :

50 ; = A + F & lt; = 60.

The average cost of $ 130 for a French flop game and $ 110 for an Argentine agonity game. Copy this to WolframAlpha by removing these bottlenecks:

C = 130 * F + 110 * A