Explore BrainMass
Share

Mathematics - Solve the Linear Programming Model

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Using Excel, Solve for the following:

The manager of a Burger Doodle franchise wants to determine how many sausage biscuits and ham biscuits to prepare each morning for breakfast customers. Each type of biscuit requires the following resources...

(See attachments).

© BrainMass Inc. brainmass.com October 25, 2018, 2:02 am ad1c9bdddf
https://brainmass.com/math/linear-programming/284100

Attachments

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

$2.19
See Also This Related BrainMass Solution

Linear Programming Model: 1) Formulate and solve an LP to maximize the company's revenues. 2) Reformulate and solve the problem if, after the first 50 units, the company can only sell B's at the reduced price of $46.

A Company produces three products, A, B and C and can sell these products in unlimited quantities at the following unit prices: A, $10, B$56 and C, $100. Producing a unit of A requires 1 hour of labor; a unit of B, 2 hours of labor plus 2 units of A; and a unit of C requires 3 hours of labor and 1 unit of B. A total of 400 labor hours are available. 1) Formulate and solve an LP to maximize the company's revenues. 2) Reformulate and solve the problem if, after the first 50 units, the company can only sell B's at the reduced price of $46.

View Full Posting Details