Inventory Revenue S Tot. Curr. Assets + Asset Turnover Accts. Receivables + Total Assets + Fixed Assets S Current Assets S13) 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))) * 'Sales Price SKU$'] - Current assets (e.g. cash) is here calculated as the value of: ['Other Current Assets $' = 'Monthly average of EBIT in one fiscal year'] 14) All blue boxes = a field where you need to create the formula / insert the correct value.Current Production: 150 metric tons Capital requirement (for this entry mode): 5 122,000 5 Production Utilization: percentage Cost of capital (for this entry mode): 10.25% % Production Capacity: metric tons Interest costs (for this entry mode): 5 12,505 5 per FY Available Production capacity (surplus): metric tons Capacity expanded plant (Salvador): x4 1500 metric tons/year Tax rate (for this entry mode): 22.50% on EBIT Sorbet Sales volume: 1,800,000 SKU Capacity needed in Host market x1 375 Total tons/year Weight/ SKU grams Capacity needed in Host markets x2 750 Total tons/year SKU's / box . pcs/box Capacity needed in Host markets x3 1,125 Total tons/year Weight/ box kg Capacity needed in Host markets x4 1,500 Total tons/year Total Production (boxes) Total Production (weight) 450,000 # boxes Capacity needed in Host markets x5 1,875 Total tons/year 225 metric tons Capacity needed in Host markets x6 2,250 Total tons/year 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 # boxes 450,000 If boxes Capacity needed in Host markets x9 3,375 Total tons/year Needed # pallets 3,600 if pallets/year Capacity needed in Host markets x10 3,750 Total tons/year Average customer freq. Prod.1(Arrayan) 30.00 boxes per week Customers needed for total sales 173.1 it of Retailers Average customer freq. Prod.2 (Jocote) boxes per week Total Boxes/ Customer 50.0 delivery per week boxes per week Inventory needs / week 8,654 boxes 1,560 boxes per annum Minimum (safety) Inventory 34,615 4 weeks supply boxes per annum Inventory Replenishment Point (IRP) 17,308 2 weeks supply boxes per annum Total Inventory @ 6 weeks supply 51,923 boxes Average customer freq. Prod.3 (Tamarind) Average customer order Prod.1 Average customer order Prod.2 Average customer order Prod.3 Total Boxes / Customer and Year 2,600 boxes per annum Admin. Op. expenses 5 0.75 cost per box B C D Page 4. Operational Income: WoS SALVADORBET SALES Host Market Operational outcome Total Costs / SKU (from p. 3) un 13.69 MU1 in % / SKU 55.0% MU1 in $ / SKU 7.53 Sales price $ /SKU 21.22 Sales price f /SKU 278.61 Sales Volume # SKU: 1,800,000 Sales Revenue $ total 38,195,100 Sales Revenue f total 501,501,663 SALVADORBET Gross Profit Export FGI by Sea Gross Profit / SKU (AUD) 7.53 Total Gross Profit (AUD) 13,553,100 Total Gross Profit (EGP) 177,952,203 Retailers Sales Export FGI by Sea MU2 in % / SKU 170.50% MU2 in $ / SKU 23.34 RRP (retail) $ / SKU 44.56 RRP (retail) f /SKU 585 Retailers Gross Profit Gross Profit / SKU (AUD) 30.87 Total Gross Profit (AUD) 55,567,710 Total Gross Profit (AUD) / Retailer 729,604,032A B C D E Page 5: Investment Outcomes: WoS Income Statement Revenue 38,195,100 COGS 9,792,000 Gross Profit 28,403,100 Transportation cost 5,796,000 Warehousing cost 2,682,000 Inventory Carrying cost 3,231,893 Other Op. Expenses 6,372,000 Total Operating Costs 18,081,893 EBIT 10,321,207 Interest 12,505 Taxes 2,322,272 Net Profit 7,986,430 GP margin 74.4% EBIT margin 27.0% Net Profit margin 20.9% FOREX conversion Revenue 2,902,828 Gross Profit 2,158,636 EBIT 784,412 Net Profit 606,969