Answered step by step
Verified Expert Solution
Link Copied!

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,200Cost of Product 2/Ton =$2,100Cost of Product 3/Ton =$5,200Solve 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 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).
image text in transcribed
\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Fiscial Year 2023 } \\ \hline Months & Product 1 qnt. (Ton) & Product 2 qnt. (Ton) & Product 3 qnt. (Ton) & Factory overall expenses (out of production costs (USD) & Overal Sales Invoices (M\$) \\ \hline Jan & 5.5 & 8.1 & 1.2 & 10,000,000 & 3 \\ \hline Feb & 4.9 & 8.3 & 1.8 & 10,700,000 & 5 \\ \hline Mar & 3.4 & 8.9 & 1.4 & 11,449,000 & 7 \\ \hline Apr & 2.4 & 8.2 & 1.6 & 12,250,430 & 10 \\ \hline May & 3.6 & 8.1 & 1.7 & 13,107,960 & 10 \\ \hline Jun & 1.9 & 8.3 & 1.8 & 14,025,517 & 11 \\ \hline Jul & 2.3 & 8.5 & 1.3 & 15,007,304 & 14 \\ \hline Aug & 2.5 & 8.7 & 1.2 & 16,057,815 & 17 \\ \hline Sep & 2.6 & 8.8 & 1.7 & 17,181,862 & 21 \\ \hline Oct & 6.2 & 8.8 & 1.5 & 18,384,592 & 23 \\ \hline Nov & 6.7 & 8.9 & 1.9 & 19,671,514 & 30 \\ \hline Dec & 7.1 & 9.3 & 1.8 & 21,048,520 & 30 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Fiscial Year 2023 } \\ \hline Months & Product 1 qnt. (Ton) & Product 2 qnt. (Ton) & Product 3 qnt. (Ton) & Factory overall expenses (out of production costs (USD) & Overal Sales Invoices (M\$) \\ \hline Jan & 5.5 & 8.1 & 1.2 & 10,000,000 & 3 \\ \hline Feb & 4.9 & 8.3 & 1.8 & 10,700,000 & 5 \\ \hline Mar & 3.4 & 8.9 & 1.4 & 11,449,000 & 7 \\ \hline Apr & 2.4 & 8.2 & 1.6 & 12,250,430 & 10 \\ \hline May & 3.6 & 8.1 & 1.7 & 13,107,960 & 10 \\ \hline Jun & 1.9 & 8.3 & 1.8 & 14,025,517 & 11 \\ \hline Jul & 2.3 & 8.5 & 1.3 & 15,007,304 & 14 \\ \hline Aug & 2.5 & 8.7 & 1.2 & 16,057,815 & 17 \\ \hline Sep & 2.6 & 8.8 & 1.7 & 17,181,862 & 21 \\ \hline Oct & 6.2 & 8.8 & 1.5 & 18,384,592 & 23 \\ \hline Nov & 6.7 & 8.9 & 1.9 & 19,671,514 & 30 \\ \hline Dec & 7.1 & 9.3 & 1.8 & 21,048,520 & 30 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Efficiency Through Automation

Authors: David Coderre

1st Edition

0470392428, 978-0470392423

More Books

Students also viewed these Accounting questions