Please solve on Excel using the Goal programming model on Excel Solver! I will upvote for all the steps shown. Thank you!

Let x1 be the number of hours used for producing material A per week and x2 be the number of hours used for producing material B per week, then the above problem can be formulated as: Minz={P1d1,P2d12+,5P3d2,3P3d3,P4d1+}x1+x2+d1d1+=80(ProductionCapacityConstraint)x1+d2=70(SalesConstraintforMaterialA)x2+d3=45(SalesConstraintforMaterialB)d1++d12d12+=10(OvertimeOperationConstraint)x1,x2,d1,d1+,d2,d3,d12,d12+0(Non-negativityrestriction)