I need more help with LP model then is provided i need the formulas in excel to complete this which this and other solutions di not have.

Rick Eldridge is the new vice president for operations at the The Golfer's Link (TGL), a company specializing in the production of quality, discount sets of golf clubs. Rick was hired primarily because of his expertise in supply chain management (SCM). SCM is the integrated planning and control of all resources in the logistics process from the acquisition of raw materials to the delivery of finished products to the end user. While SCM seeks to optimize all activities in the supply chain, including transactions between firms, Rick's first priority is ensuring that all aspects of production and distribution within TGL are operating optimally. Junior's chub sets, and Menthais dres not prodoce Men's dub sets. Jutiot's club sets, and Ment thas dres not proctooe Men's dub sets. ing manth. Can you create a quick excel spreadsheet and post screenshots of the formula view please. Please show all work and solver paramaters and constrsaints used. Thank you! Rick Eldridge is the new vice president for operations at the The Golfer's Link (TGL), a company specializing in the production of quality, discount sets of golf clubs. Rick was hired primarily because of his expertise in supply chain management (SCM). SCM is the integrated planning and control of all resources in the logistics process from the acquisition of raw materials to the delivery of finished products to the end user. While SCM seeks to optimize all activities in the supply chain, including transactions between firms, Rick's first priority is ensuring that all aspects of production and distribution within TGL are operating optimally. Junior's chub sets, and Menthais dres not prodoce Men's dub sets. Jutiot's club sets, and Ment thas dres not proctooe Men's dub sets. ing manth. Can you create a quick excel spreadsheet and post screenshots of the formula view please. Please show all work and solver paramaters and constrsaints used. Thank you