Answered step by step
Verified Expert Solution
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?
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
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