please work with this project by using excel sheet, please attach the excel file to the answers thank you so much.

The Great American Mill satisfies all demand with either its own woven fabric or fabric urchased from another mill. That is, fabrics that cannot be woven at Great American Mill because of limited loom capacity will be purchased from another mill. The purchase price of each fabric is also shown in Table 1. MANAGERIAL REPORT Develop a model that can be used to schedule production for the Great American Mill, and, at the same time, determine how many yards of each fabric must be purchased from another mill. Include a discussion and analysis of the following in the report: 1. The final production schedule and loom assignments for each fabric. 2. The projected profit. 3. A discussion of the value of additional loom time. The mill is considdring purchasing a ninth dobbie loom. What is your estimate of the monthly profit contribution of this additional loom? 4. A discussion of whether the objective of minimizing total costs may provide a different model than the objective of maximizing profit. ONLINE Submission: Your Project which is worth 5% of your course grade is a Linear Programming problem with 13 Decision Variables and 7 Constraints. You will email your EXCEL file as attached file. The name of the EXCEL file is your name, that is, LAST NAME, FIRST NAME, Class Time. Here is an example of a filename: KUNG,MABEL,7AM or KUNG,MABEL,830 AM Your email to me, mkunga fullerton.edu, will indicate the time when your email is sent. Any email after the deadline will not be accepted. Your project will be counted as zero points. The format of your EXCEL file consists of: (1) The Data entry of your Linear Programming Model run inside Excel Solver (2) The sensitivity report (3) The Managerial Report with the 4 questions. You may type the answers on your EXCEL file under the Sensitivity Report. The maximum number of page for the analysis of all 4 questions is ONE PAGE. GTTP (Get To The Point) The Great American Mill satisfies all demand with either its own woven fabric or fabric urchased from another mill. That is, fabrics that cannot be woven at Great American Mill because of limited loom capacity will be purchased from another mill. The purchase price of each fabric is also shown in Table 1. MANAGERIAL REPORT Develop a model that can be used to schedule production for the Great American Mill, and, at the same time, determine how many yards of each fabric must be purchased from another mill. Include a discussion and analysis of the following in the report: 1. The final production schedule and loom assignments for each fabric. 2. The projected profit. 3. A discussion of the value of additional loom time. The mill is considdring purchasing a ninth dobbie loom. What is your estimate of the monthly profit contribution of this additional loom? 4. A discussion of whether the objective of minimizing total costs may provide a different model than the objective of maximizing profit. ONLINE Submission: Your Project which is worth 5% of your course grade is a Linear Programming problem with 13 Decision Variables and 7 Constraints. You will email your EXCEL file as attached file. The name of the EXCEL file is your name, that is, LAST NAME, FIRST NAME, Class Time. Here is an example of a filename: KUNG,MABEL,7AM or KUNG,MABEL,830 AM Your email to me, mkunga fullerton.edu, will indicate the time when your email is sent. Any email after the deadline will not be accepted. Your project will be counted as zero points. The format of your EXCEL file consists of: (1) The Data entry of your Linear Programming Model run inside Excel Solver (2) The sensitivity report (3) The Managerial Report with the 4 questions. You may type the answers on your EXCEL file under the Sensitivity Report. The maximum number of page for the analysis of all 4 questions is ONE PAGE. GTTP (Get To The Point)