finance

Projected Sales (Peso) = ((sales for current year - sales for previouse year) / previous year) + current year

Projected Sales (Units) = (((sales for current year - sales for previouse year) / previous year) + current year) / per unit

Forecast

# of units needed

(Total units)

Cost per unit

(Total cost)

Forecast

# of hours needed

(Total hours)

Direct Labor per hour

(Total DL)

TPC = Total cost of all products + Total DL

Total Assets = Non-Current Assets+ Curremt Assets

Total Liabilities = Non-Current Liabilities + Current Liabilities

Working Capital = Current Assets - Current Liabilities

Cash Conversion Cycle = Inventory Conversion Period + Receivable Collection Period - Payable Defferal Period

Days in Inventory Outstanding (DIO) = (Ave. Inventory / COGS) x 365

Days in Receivables Outstanding (DRO) = (Ave. Receivables / Net Credit Sales) x 365

Days in Payables Outstanding (DPO) = (Ave. Payables / COGS) x 365

Contribution Margin = Cash Sales - Variable Cash Outlays

Contribution Margin Ratio = Contribution Margin / Cash Sales

Cash Break-Even = Fixed Cash Outlays / Contribution Margin Ratio

Break-Even Point = Cash Break-Even / Selling Price per unit

Economic Order Quantity = √((2(Annual Demand) x Cost Per Order) / Carrying Cost per unit

Total Inventory Cost = Total Ordering Cost + Total Carrying Cost

Total Ordering Cost = (Annual Demand (units) / EOQ or Order size) x Ordering Cost per Order

Total Carrying Cost = Ave. Inventory (EOQ/2) x Carrying Cost per unit