Formulate problem as linear programming problem

Assignment Help Basic Computer Science

Reference no: EM1361580

Formulate the following problem as a linear programming problem and then solve the problem by Excel only. Only the Excel file which shows the problem has been solved by Solver in Excel must be submitted. No grade if Excel file is not submitted."Farmer Jones bakes two types of cake (chocolate and vanilla) to supplement his income. Each chocolate cake can be sold for $1, and each vanilla cake can be sold for $0.50. Each chocolate cake requires 20 minutes of baking time and uses 4 eggs. Each vanilla cake requires 40 minutes of baking time and uses 1 egg. Eight hours of baking time and 30 eggs are available. Formulate an LP to maximize the farmer Jones's revenue. "

Reference no: EM1361580

Questions Cloud

Explain how can each of the principles be applied : Explain how can each of the 10 principles be applied in an example or expeerience with which you are familiar.

Determine net working capital : Determine Net Working Capital and explain how is this related to the cash conversion cycle describe what each component of the cash conversion cycle means

Determining expected activity times : PERT networks use a simple statistical method to evaluate the most likely task completion times. Describe how expected activity times and variances can be computed in a PERT network.

What is the potential energy for the child : What resistive force (assumed to be constant) does the wood exert on bullet? How long does it take the bullet to come to rest.

Formulate problem as linear programming problem : Formulate the following problem as a linear programming problem and then solve the problem by Excel only. Only the Excel file which shows the problem has been solved by Solver.

Public health counteract complacency : How does public health counteract complacency regarding infectious disease?

Evaluating corporations : One standard corporations use to determine their performance against their competitors is the set of rankings developed by Fortune magazine.

Solving bep problems : Calloway Cab Corporation determines its break even strictly on the basis of cash expenditures related to fixed expenses. Its total fixed costs are $400,000, but 20% of this value is represented by depreciation.

Illustrate what means do they use to hedge against exchange : Consider any two of those operations and the contribution they are making to the parent firm's profits. Illustrate what means do they use to hedge against exchange rate risk.

User Account

All Pages