*PLEASE SHOW ALL STEPS & FORMULA THROUGH EXCEL***

Problem 2 BIG makes three types of Baseball bats- Novice, Standard, and Professional. There are three stages in manufacturing. Each one of these bats-Cutting, Polishing, and Finalizing. The time required for each bag in each stage is given below: Cutting/bat (in Polishing/bat Minutes) (in Minutes) Finalizin g/bat (in Minutes) 5 5 5 Novice Standard 10 20 10 20 25 30 Professional o- Problem 2(Contd) 2 For each Novice type bat BIG can make a profit of $5.50. . For each Standard type bat BIG can make a profit of $9. For each Professional type bat BIG can make a profit of $15. Market demand requires that BIG manufactures at least one bat of each type. Given that BIG has only 15 hours of Cutting, 15 hours of Polishing, and 15 hours of Finalizing time each day, using Linear Programming help BIG to decide how many of each type of bat they should manufacture each day to maximize the profit