Q$4$: Chapter $8,$ Problem $21$

Please download the Excel file for your work and submit your Excel file. 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\mathrm{.}6p0\mathrm{.}002p2+0\mathrm{.}5f-0\mathrm{.}0009f2-0\mathrm{.}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 Excel and solve it$.$

c$.$ What is the optimal solution?