I want the solution using Simplex method not Exel solver.

please write the TP model with all constraints and the objective function.

5-21. The National Parks Service is receiving four bids for logging at three pine forests in Arkansas. The three locations include 20,000,30,000, and 10,000 acres. A single bidder can bid for at most 50% of the total acreage available. The bids per acre at the three loca- tions are given in Table 5.32. Bidder 2 does not wish to bid on location 1, and bidder 3 cannot bid on location 2. (a) In the present situation, we need to maximize the total bidding revenue for the Parks Service. Show how the problem can be formulated as a transportation model. (b) Determine the acreage that should be assigned to each of the four bidders. TABLE 5.32 Bids per Acre for Problem 5-21 Location 2 3 1 $520 $210 $570 Bidder $510 $495 3 $650 4 $180 $430 $710 $240