Fossoglor producesa pushchair, whose final assembly must include fourwheels and two seats. The factory producing the partsoperates three shifts a day. The following table providesthe amounts produced of each part in the three shifts.Ideally, the number of wheels produced is exactly twicethat of the number of seats. However, because produc$-$tion rates vary from shift to shift, exact balance in pro$-$duction may not be possible. Fossoglor is interested indetermining the number of production runs in each shift that minimizes the imbalance in the production of theparts. The capacity limitations restrict the number ofruns to between $4$ and $5$ for shift $1,10$ and $20$ for shift$2,$ and $3$ and $5$ for shift $3.$ Formulate the problem asa goal programming model, and construct the model inthe empty Excel spreadsheet.