Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how to calcuate:Inventory,Accts. Receivables,Current Assets,Fixed Assets???(offer some info in the pics below) I already get the formula(offered in the pics) but don't know how to
how to calcuate:Inventory,Accts. Receivables,Current Assets,Fixed Assets???(offer some info in the pics below)
I already get the formula(offered in the pics) but don't know how to use, so please listing the answer and teach me how to do the calculation.
3) Inventory & Asset values: - Inventory: ['Inventory $' = ('Total Inventory * SKU#') * 'Sales Price SKU$'] - Accounts Receivables: credit time is 21 days; applies to 45% of the customers; fresh produce. ['ARS' = ((('# Deliver. per week' * SKU per box) *(% of '# Customers '))* # weeks))) * 'SKU Sales Price'] - Current assets (e.g. cash) is here calculated as the value of: ['Other Current Assets $' = 'Monthly average of EBIT in one fiscal year']i Information u x. Page 2. Production & Market Entry Calculations: Exporting FGI Units u L Information I Current Production: 150 metric tons Capital requirement (for this entry mode): 5 8,750,000 S 3 Production Utilization: 40% percentage Cost of capital (for this entry mode): 4.50% % 3 Production Capacity: 375 metric tons Interest costs (for this entry mode): 3 393,750 S per FY I Available Production capacity (surplus): 225 metric tons I Capacity expanded plant (Salvador): x3 1125 metric tons/year Tax rate (for this entry mode): 22.50% on EBIT I Sorbet Sales volume: 1,800,000 SKU Capacity needed in Host market x1 375 Total tons/year Weight/ SKU 125 grams Capacity needed in Host markets x2 750 Total tons/year SKU's / box 4 pcs/box Capacity needed in Host markets x3 1,125 Total tons/year Weight/ box 0.50 kg Capacity needed in Host markets x4 1,500 Total tons/year 1,875 Total tons/year 2,250 Total tons/year Total Production (boxes) Total Production (weight) 450,000 #boxes 225 metric tons Capacity needed in Host markets x5 Capacity needed in Host markets x6 Load / pallet 125 boxes/pallet Capacity needed in Host markets x7 2,625 Total tons/year Weight/pallet (total) 62.5 kg Capacity needed in Host markets x8 3,000 Total tons/year Needed (I boxes 450,000 ii boxes Capacity needed in Host markets x9 3,375 Total tons/year Needed if pallets 3,600 if pallets/year Capacity needed in Host markets x10 3,750 Total tons/year Average customer freq. Prod.1 (Arrayan) Total Boxes / Customer and Year 30.00 boxes per week 2,600 boxes per annum Customers needed for total sales Admin. 0p. expenses 173.1 $ 0.75 # of Retailers Average customer freq. Prod.2 (locote) 15.00 boxes per week Total Boxes / Customer 50.00 delivery per week Average customer freq. Prod.3 (Tamarind) 5.00 boxes per week Inventory needs / week 8,654 boxes Average customer order Prod.1 1,560 boxes per annum Minimum (safety) Inventory 34,615 4 weeks supply Average customer order Prod.2 780 boxes per annum Inventory Replenishment Point (IRP) I 17,308 12 weeks supply Average customer order Prod.3 260 boxes per annum Total Inventory @ 6 weeks supply 51,923 boxes cost per box KDMNU'U'ILLHNI'OKDOOKIO'U'IbWNl'O Page 3a. Operational Costs & Product Cost Components: Exporting FGI TABLE 1 TABLE 2 Cost of goods sold Cost of goods sold (Host (Home Market) Market) Raw material costs / SKU (fruit) 0.96 Raw material costs / SKU (all other) 0.48 0.23 Other direct costs / SKU (Home Market) 0.37 Other direct costs / SKU (Host Market) N/A 3.27 Total COGS / SKU and origin: 1.81 3.50 Total COGS / SKU: 5.31 TABLE 3 TABLE 4 Operating Expenses per SKU Operating Expenses per SKU (Home Market) (Host Market) Production cost / SKU 0.42 Overhead costs / SKU 0.55 0.50 Marketing costs / SKU 0.44 0.76 Storage & Logistic costs / SKU 0.29 1.05 a Transport 1 costs/SKU (Raw Material) 0.51 0.04 b Transport 2 costs/SKU (FGI) by road 0.33 0.68 c Transport 3 costs/SKU (FGI) by sea 1.65 d Transport 4 costs/SKU (FGI/Raw) by air 2.65 N/A e Allocated Operating Expenses: 3.86 2.35 f Total Base Cost/SKU when sold in Host Market: S 11.52SALVADORBET SALES Host Market Operational outcome Total Costs / SKU (from p. 3) 11.52 MU1 in % / SKU 45.0% MU1 in $ / SKU 5.184 Sales price $ /SKU 16.70 Sales price f /SKU 219.32 Sales Volume # SKU: 1,800,000 Sales Revenue $ total 30,067,200 Sales Revenue f total f 394,782,336 SALVADORBET Gross Profit Export FGI by Sea Gross Profit / SKU (AUD) 5.18 Total Gross Profit (AUD) 9,331,200 Total Gross Profit (EGP) 122,518,656 Retailers Sales Export FGI by Sea MU2 in % / SKU 100% MU2 in $ / SKU 11.52 RRP (retail) $ / SKU 28.22 RRP (retail) f /SKU 371 Retailers Gross Profit Gross Profit / SKU (AUD) 16.70 Total Gross Profit (AUD) 30,067,200 Total Gross Profit (AUD) / Retailer 394,782,336 FOREX: AUD-EGP 13.130 FOREX: EGP-AUD II 0.076Page 5: Investment Outcomes: Exporting FGI Income Statement Revenue 30,067,200 COGS 9,558,000.00 Gross Profit 20,509,200 Transportation cost 3,960,000 Warehousing cost 2,412,000 Inventory Carrying cost 1,595,076.9 Other Op. Expenses 6,552,000 Total Operating Costs 14,519,077 EBIT 5,990,123 Interest 393,750 Taxes 1,347,778 Net Profit 4,248,595 GP margin 68.2% EBIT margin 19.9% Net Profit margin 14.1% FOREX conversion Revenue 2,285,107 Gross Profit 1,558,699 EBIT 455,249 Net Profit 322,893 FOREX: AUD-EGP 13.130 FOREX: EGP-AUD 0.076Step 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