solve in excel solver then show all formula used

Please make sure that your answers in LP Model Formulation are composed of Decision Variables, Objective Function and Constraints. Compile your answers in 1-excel file (either computerized or print screens) and kindly upload it using this filename: Surname-IE189P(2Q2021)Ex#1. LP Problem: Blackberry Inc. needs to produce 1000 of their new Smart Phones. There are three ways this phones can be produced: manually, semi-automatically, and robotically. Manual assembly requires 1 minute of skilled labor, 40 minutes of unskilled labor, and 3 minutes of assembly room time. The corresponding values for semiautomatic assembly are 4, 30, and 2; while those for robotic assembly are 8, 20, and 4. There are 4500 minutes of skilled labor, 36,000 minutes of unskilled labor, and 2700 minutes of assembly room time available for this product. The total cost for producing the phone manually is $7; semi-automatically is $8; and robotically is $8.50. Any unused assembly floor time can be rented out per minute at a profit of $0.50. (a) Formulate the problem of producing 1000 blackberry smart phones at minimum cost meeting the resource requirements. (b) Their union contract states that the amount of skilled labor time used is at least 10% of the total labor (unskilled plus skilled) time used. Update your formulation in (a) to handle this requirement