Examlex
Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver.
A bakery produces both pies and cakes. Both products use the same materials (flour, sugar and eggs) and both have a setup cost ($100 for cakes, $200 for pies) . The baker earns a profit of $10 per cake and $12 per pie and can sell as many of each as it can produce. The daily supply of flour, sugar and eggs is limited. To manage the decision-making process, an analyst has formulated the following linear programming model (assume that it is possible to produce fractional pies and cakes for this example) :
Max 10x1 + 12x2 - 100y1 - 200y2
s.t. 5x1 + 10x2 ? 1000 {Constraint 1}
2x1 + 5x2 ? 2500 {Constraint 2}
2x1 + 1x2 ? 300 {Constraint 3}
My1 ? x1 {Constraint 4}
My2 ? x2 {Constraint 5}
Set up the problem in Excel and find the optimal solution. What is the maximum profit possible?
Commonly Used
Describes software, protocols, or standards that are widely adopted and integrated in various technological processes or systems.
Virtual Private Network (VPN)
A network that uses the public Internet communications infrastructure to build a secure, private network among various locations.
Internet Communications Infrastructure
The physical and digital technologies, systems, and standards that provide and manage the pathways over which internet data is transported.
Secure and Private Network
A Secure and Private Network refers to a network designed to protect and encrypt data being sent over it, ensuring that the information remains confidential and inaccessible to unauthorized users.
Q14: The exponential distribution has a most likely
Q20: A firm has prepared the following
Q28: A manager has observed sales for
Q39: The line forming the boundary of what
Q44: Decreasing marginal returns violates which assumption of
Q62: You are reviewing a simulation model and
Q65: The auditing tools can be used to
Q69: A freelance writer must choose how to
Q77: Maximum flow problems are concerned with maximizing
Q83: A manufacturing firm has four plants