Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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.076

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_2

Step: 3

blur-text-image_3

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

Strategic management concepts

Authors: Fred david

13th Edition

9780136120988, 136120997, 136120989, 978-0136120995

More Books

Students also viewed these General Management questions