Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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,2005. 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 Months qnt. ant ant. (out of production costs Sales (Ton) (Ton) (Ton) (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 fileSolve 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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started