Find herewith a table of factory strategic plan of producing a final End-Product assembled by three types of products 1, 2 and 3. find below what are given and what are required. a) The quantities of each product 1, 2 and 3. b) The factory overall expenses excluding the costs of production of the End-Product. c) The expected (forecasted) sales invoices for each month. d) Given below the costs of each product that used to product the End-Product. Cost of Product 1/Ton= $1,200 Cost of Product 2/Ton= $2,100 Cost of Product 3/Ton= $5,200 * 100 point Solve the following requirement with supportive documents and figures in separate attached file for each question. OLD le.com/forms/d/e/1FAIpQLSf8N31mHjdf39QWkvTMBcilX151gsh1B2lir56Ah6pSg87eyw/form Response < + 5. Can you judge if this business operation is feasible? If this calculation will remain almost with a regular 10% increase in sales revenue and a 5% increase in overall operating expenses? What will you report to the board of directors to implement your plan or need further resources? (40 points) Fiscial Year 2023 Product 1 Product 2 Product 3 Factory overall expenses Overal Sales Months qnt. qnt. qnt. (Ton) (Ton) (Ton) (out of production costs (USD) Invoices (M$) Jan 5.5 8.1 1.2 10,000,000 3 Feb 4.9 8.3 1.8 10,700,000 5 Mar 3.4 8.9 1.4 11,449,000 7 Apr 2.4 8.2 1.6 12,250,430 10 May 3.6 8.1 1.7 13,107,960 10 Jun 1.9 8.3 1.8 14,025,517 11 Jul 2.3 8.5 1.3 15,007,304 14 Aug 2.5 8.7 1.2 16,057,815 17 Sep 2.6 8.8 1.7 17,181,862 21 Oct 6.2 8.8 1.5 18,384,592 23 Nov 6.7 8.9 1.9 19,671,514 30 Dec 7.1 9.3 1.8 21,048,520 30 1. Add file a H -10- F5 0+ F6 F7 F8 F9 A COO 80 F10 F11 F12 Insert PrtSc Delete ENG IN al App X + s.google.com/forms/d/e/1FAIpQLSf8N31m Hjdf39QWkvTMBcilX151gsh1B2lir56Ah6pSg87eyw/form Response Solve the following requirement with supportive documents and figures in separate attached file for each question. 1. Calculate the factory operating expenses for the factory in FY 2023? (15 points) 2. Find the COGS amount in USD. (15 points) 3. Find the NET profit in table form for this fiscal year, then by drawing the curves for each into scale using an excel sheet. (15 points) 4. Find if ROI is within the first five or after five years. (15 points) 5. Can you judge if this business operation is feasible? If this calculation will remain almost with a regular 10% increase in LO CEL ENG IN 03:22 PM 12-Oct-22