A sports manufacturer produces two products: footballs and baseballs.

Problem #2 (20 points)
A sports manufacturcr produces two products: footballs and baseballs. Thcsc products can be produced either during the morning shift or the evening shift. The cost of manufacturing the football and the baseball in the morning shift is S20 each, and the cost of manufacturing the football and the baseball in the evening shift is S25 each. The amounts of labor, leather, inner plastic lining.
and demand requircrnents arc given as follows:
Resource Football Baseball
Labor (hourslunit) 0.75 2
Lcather (pounds/unit) 7 15
Inner plastic lining (pounds unit) 0.5 2
Total demand (units) 1500 1200
llascd on the information about the company, we know that the maximum labor hours available in the morning shift and evening shift are 5.000 hours and 2.000 hours, respectively, per month. The maximum amount of leather available for the morning shift is 15.000 pounds per month and 14.000 pounds per month for the cvening shift. The maximum amount of inner plastic lining available for the morning shift is 2,000 pounds per month and 1,500 pounds per month for the evening shift.
Formulate the given problem scenario as a linear program so as to minimize the production cost and determine the number of footballs and baseballs made by this company. Sohe the problem using Microsoft Excel with ASPE. For the formulation, provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible. Also, the spreadsheet model setup should provide clearly labeled values used for the decision variables, constraints, and objective function.
Click Here For More Details on How to Work on this Paper......
Need a Professional Writer to Work on this Paper? Click Here and Get this Essay Done ………