please use excel and solver step by step

A moving company receives shipment requests on regular basis. Based on the available requests, the company wants to make a weekly shipment plan every Friday for the coming week. The customers need to specify the destination and the space they need in linear feet. Thus, the customers do not need to pay for an entire truck or pay based on weight. The company currently has only one truck with two trailers. Each trailer has a capacity of 35 feet. It is important to note that each order should be loaded on one trailer (Le partial shipment is not allowed). Table below shows the available orders and the associated quote prices. This company normally cannot serve all customers and they need to choose and accept certain orders that maximize revenue. Order Space 4 Price 95 1 2 Order 8 9 6 120 70 3 4 5 10 11 12 15 Space 3 5 7 20 8 13 14 10 11 12 13 14 Price 25 88 115 107 38 110 120 65 118 6 7 75 100 18 Deliverables: A Develop a mathematical formulation to help this moving company accept the orders that maximize its revenue. Clearly define all the variables and parameters. Also, list all your assumptions B. Find the optimal solution. Enough details and associated computer files should be provided io. order for us to repeat your solution