Can you help walk me through the excel process

Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes. The fishes are cleaned and stored at the local processing facilities. Then the fishes are shipped to two plants, where they are cut, processed, and packaged as sushi and sashimi. The sushi and sashimi are then transported to three restaurants. The transportation costs per fish from the fishers to the plants and from the plants to the restaurants are summarized in the following tables: Name: a. Determine the optimal shipments from fishers to plants and from plants to restaurants to minimize total transportation costs. Include the formulation and solver outputs. b. What would be the effect on the solutions if the capacity at each plant were 70 fishes? (Hint: add one constraint for each plant that either the sum of incoming shipments or outgoing shipments is less than or equal to 70 ) The production manager of Hilo Videotechnics Company is attempting to determine the upcoming 5 month production schedule for video recorders. Past production records indicate that 2,000 recorders can be produced per month. An additional 600 recorders can be produced monthly on an overtime basis. Unit cost is $10 for recorders produced during regular working hours and $15 for those produced on an overtime basis. Contracted sales per month are as follows: Name: Inventory carrying costs are $2 per recorder per month. The manager does not want any inventory carried over past the fifth month. The manager wants to know the monthly production that will minimize total production and inventory costs. a. Formulate a linear programming model for this problem. b. Solve the model by using the computer