Carnival Confections, Inc. produces two popular southern food items, pork rinds and fried peanuts, which it sells
Question:
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.6p - 0.002p2 + 0.5f - 0.0009f 2 - 0.001pf
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 a spreadsheet.
c. What is the optimal solution?
Step by Step Answer:
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 1233
8th Edition
Authors: Cliff T. Ragsdale