please show in Excel how to do this problem. Do not attach any file, it cant be open. Post the excel sheet step by step. Thank you.

Problem 2 (name the Excel file as A4Problem 2 yourLastNameFirstName.xlsx 60 points total (Data file needed: A4Problem2.x/sx) A produce company supplies organically grown apples to four regional specialty stores. After the ipples are collected at the company's orchard, they are transported to any of three preparation centers where they are peepared for retail (by undergoing extensive cleaning and then packaging). After the apples are prepared, they are stippod to the spociality stores. Due to the fragility of the product, the cost of transporting this organic fruit is rather hiph The company has three preparation centers available for use. The A4Problem4 worksheet contans the following (i) the unit transportation costs (in S/pound) to get the apples from company's orchard to the preperation cenvers, (ii) the cost (\$/pound) to prepare the apples in the preparation eenters, (iii) the preparation centers' monthly capacities. (iv) the demand at the specialty stores, and (v) the unit costs of transporting the apples from the preparation centers to the specialty stores. each of the three preparation centers and how much of each specialty store's demanu wo omply from each preparation center, to minimize the total cost of the operation. Please SAVE your solver model explicitly. a. Construct and solve a lincar optimization model to You do not need to write the L.P model as you are required in Problem 1