Please help me create the model for this in excel.

Paul Schooley is in charge of loading cargo ships for

Longcut Cargo Company $($LCC$)$ at the port of Newport

News, VA$.$ Paul is preparing aloading plan for an LCC

freighter destined for Ghana. An agricultural

commodities dealer would liketo tran sport the

following products aboard the LCC ship.

Paul can elect to load any and$/$or all of the available

commodities. However, the ship has three cargo holds

with the following capacity restrictions:

Only onetype of commodity can beplaced inyo any

cargo hold. However, because of balance

considerations, theweight in the forward cargo hold

must be within $10\%$ of the weight in the rear cargo

hold, and the center car go hold must be between $40\%$

and $60\%$ of the total weight on board.

a$.$ Create an LP modemto solethis problem.

b$.$ What is theoptimal solution using Solver.