Question: Formulate the following problem as a linear programming problem and then solve the problem by Excel only. Only the Excel file which shows the problem has been solved by Solver in Excel must be submitted. No grade if Excel file is not submitted.

Farmer Jones bakes two types of cake (chocolate and vanilla) to supplement his income. Each chocolate cake can be sold for $1, and each vanilla cake can be sold for $0.50. Each chocolate cake requires 20 minutes of baking tiMeand uses 4 eggs. Each vanilla cake requires 40 minutes of baking tiMeand uses 1 egg. Eight hours of baking tiMeand 30 eggs are available. Formulate an LP to maximize the farmer Jones's revenue.