Pablo O. Profile

0,0

(0 değerlendirme)

Şu anda adlı kullanıcıyı takip ediyorsunuz

Kullanıcıyı takip etmede hata.

Bu kullanıcı kullanıcıların kendisini takip etmesine izin vermiyor.

Zaten bu kullanıcıyı takip ediyorsunuz.

Üyelik planınız sadece 0 takibe izin veriyor. Buradan yükseltme yapın.

başarılı bir şekilde takipten çıkarıldı

Kullanıcının takip edilmesinde hata.

adlı kullanıcıyı başarılı bir şekilde tavsiye ettiniz

Kullanıcıyı tavsiye etmede hata.

Bir şeyler yanlış gitti. Lütfen sayfayı yenileyin ve tekrar deneyin.

E-posta başarılı bir şekilde doğrulandı.

$20 USD / saat

buenos aires,

argentina

$20 USD / saat

Şu anda burada saat 5:12 ÖS

Şubat 20, 2022 tarihinde katıldı

0 Öneriler

Pablo O.

@PabloOrtegaT

0,0

(0 değerlendirme)

0,0

$20 USD / saat

buenos aires,

argentina

$20 USD / saat

Mevcut değil

Tamamlanmış İş

Mevcut değil

Bütçe Dahilinde

Mevcut değil

Zamanında

Mevcut değil

Tekrar İşe Alınma Oranı

Accountant, Fianance planner

I graduated from the University of Buenos Aires 25 years ago. Since then, I have worked for all kinds of companies, both small family business and multinational corporations, being responsible for general accounting and budgeting. I had also the opportunity to automate many processes and build different models for forecast and analyze the performance by product category or sales channel.

Accountants freelancerlarından Argentina içinden olanlarının tümünü görün.

Pablo O. ile işiniz hakkında iletişime geçin

Detayları sohbet üzerinden tartışmak için giriş yapın.

Portföy

This model uses Power Pivot to make sales projections. It has four input tabs: Product Master, Customers, Units and Selling Price. The output tabs can be set up according user's needs. There are a few examples in the attached image, but any output you need can be easily built by adding and removing the corresponding fields to the pivot table (fields inclide selling price, cost, commercial agreements and any calculation based on these; more can be added as per request)

It was designed to be as easy to use as possible: simply update the input tabs, refresh the pivot table and there you go.

Selling forecast model

Calculation of a weighted Average within a pivot table

Weigthed Average in Pivot Table

The classic Price - Volume analysis. It explains if the increase or decrease of sales is driven by a change in prices or by the difference in units sold.
It supports calculations between periods (YoY, QoQ, MoM) and between different scenarios (Actual vs Budget) and also in difrerent currencies
It can be set up to do the calculations by product (shown in the image), category, customer, sales channel, etc

Simple to use, it needs four inputs: Currency Rate, Products, Customers and Transaction Data in fourseparate sheets; all the calculations are preformed within the pivot table

Price Volume analysis with Power Pivot

Selling forecast model

Weigthed Average in Pivot Table

Price Volume analysis with Power Pivot

Değerlendirmeler

Değişiklikler kaydedildi

Burada görülecek hiç değerlendirme yok!

Deneyim

I prefer not to specify

Nis 2014 - Şu anda

Responsible for the annual budget and monthly forecasts, working with managers across the business unit. I am also responsible for the entire P&L, with special attention to net and gross margins analysis by line of business and distribution channels. Modeling and analysis of different business scenarios by request of the management team Financial analysis for new products launches. Preparation of Monthly Business Reviews presenting the financial insights to the regional management

Visteon Corporation

Ara 2010 - Nis 2014 (3 yıl, 4 ay)

Responsible for all accounting processes, monthly closings and reports to the corporate team under USGAAP and compliance with SOX standards. Support to external and internal audits. Preparation of the annual financial statements, as well as quarterly financial statements to be presented at the SEC