Carnival Confections, Inc., produces two popular southern food items, pork rinds and fried peanuts, which it sells at a local recreation area on weekends. The owners of the business have estimated their profit function on these items to be:
0.6𝑝 − 0.002𝑝2 + 0.5𝑓 − 0.0009𝑓2 − 0.001𝑝𝑓
Note that p is the number of packages of pork rinds produced, and f is the number of packages of fried peanuts produced. Both of these items require deep frying. The company’s fryer has the capacity to produce a total of 600 packages of pork rinds and/or fried peanuts. One minute of labor is required to dry and package the pork rinds, and 30 seconds are required to dry and package the peanuts. The company devotes a total of 16 hours of labor to producing these products each week.
a. Formulate an NLP model for this problem.
b. Implement your model in Excel and solve it.
c. What is the optimal solution?