Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On the last page (page 5: investment outcome), how to calculate for the transportation cost, warehousing cost, Inventory carrying cost, and other op. expenses? Page

On the last page (page 5: investment outcome), how to calculate for the transportation cost, warehousing cost, Inventory carrying cost, and other op. expenses?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed Page 3b. Human Resources Costs: JV \begin{tabular}{|l|rr|} \hline SALVADORBET HR Needs & \multicolumn{2}{|c|}{ Human Resources } \\ \cline { 2 - 3 } \# of needed FTE's: & f & 51 \\ Monthly Salary / FTE f: & 15,800.00 \\ Monthly Salary / FTE \$: & & 1,200.80 \\ Social Costs \%: & $ & 25% \\ Total Monthly Labour Costs (AUD) & 61,241 \\ Total Annual Labour Costs (AUD) & f & 734,893 \\ \hline Total Annual Labour Costs (EGP) & f & 9,649,140 \\ \hline Total Monthly Labour Costs (EGP) & & 115,789,678 \\ \hline \end{tabular} \begin{tabular}{|ll|ll|} \hline FOREX: AUD-EGP & = & f & 13.13 \\ FOREX: EGP-AUD & = & f & 0.076 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline SALVADORBET SALES & \multicolumn{2}{|c|}{ Operational outcome } \\ \hline Total Costs / SKU (from p. 3) & \multirow[t]{2}{*}{$} & 7.52 \\ \hline MU1 in \% / SKU & & 60.0% \\ \hline MU1 in \$ / SKU & $ & 4.51 \\ \hline Sales price \$ /SKU & $ & 12.03 \\ \hline Sales price f/SKU & \multirow[t]{2}{*}{f} & 157.98 \\ \hline Sales Volume \# SKU: & & 1,800,000 \\ \hline Sales Revenue \$ total & $ & 13,536,000 \\ \hline Sales Revenue f total & f & 177,727,680 \\ \hline SALVADORBET Gross Profit & \multicolumn{2}{|c|}{ Export FGI by Sea } \\ \hline Gross Profit / SKU (AUD) & $ & 4.51 \\ \hline Total Gross Profit (AUD) & $ & 8,121,600 \\ \hline Total Gross Profit (EGP) & f & 106,636,608 \\ \hline Retailers Sales & \multicolumn{2}{|c|}{ Export FGI by Sea } \\ \hline MU2 in \% / SKU & & 110% \\ \hline MU2 in \$ / SKU & $ & 13.24 \\ \hline RRP (retail) \$ / SKU & $ & 27.79 \\ \hline RRP (retail) f /SKU & f & 365 \\ \hline \multicolumn{3}{|l|}{RetailersGrossProfit} \\ \hline Gross Profit / SKU (AUD) & $ & 13.24 \\ \hline Total Gross Profit (AUD) & $ & 23,823,360 \\ \hline Total Gross Profit (EGP) / Retailer & $ & 312,800,717 \\ \hline FOREX: AUD-EGP & f & 13.13 \\ \hline FOREX: EGP-AUD & f & 0.076 \\ \hline \end{tabular} Page 5: Investment Outcomes: JV \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{\begin{tabular}{|c|} Income Statement \\ \end{tabular}} \\ \hline Revenue & $ & 21,657,600 \\ \hline COGS & $ & 5,346,000 \\ \hline Gross Profit & $ & 16,311,600 \\ \hline Transportation cost & & \\ \hline Warehousing cost & $ & - \\ \hline Inventory Carrying cost & $ & - \\ \hline Other Op. Expenses & $ & - \\ \hline Total Operating Costs & $ & - \\ \hline EBIT & $ & - \\ \hline Interest & $ & - \\ \hline Taxes & $ & - \\ \hline Net Profit & $ & - \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline GP margin & 0.0% \\ EBIT margin & 0.0% \\ Net Profit margin & 0.0% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ FOREX conversion } \\ \hline Revenue & & - \\ \hline Gross Profit & & - \\ \hline EBIT & f & - \\ \hline Net Profit & f & - \\ \hline \end{tabular} \begin{tabular}{|lll|} \hline FOREX: AUD-EGP & $ & 13.13 \\ FOREX: EGP-AUD & $ & 0.076 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions