Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calcule el costo del flete de envo, siga la zona, obtuve esta tabla de peso y zona de envo ahora, no s cmo combinarla con

Calcule el costo del flete de envo, siga la zona, obtuve esta tabla de peso y zona de envo ahora, no s cmo combinarla con la zona y determinar la tasa de peso en la segunda tabla, por favor ayuda, he intentado usar INDEX MATCH pero no trabajo.

Peso de envo en libras Zona
3.4 4
2.0 45
1.0 3

La tabla del grfico de zonas es esta:

Zonas 2 3 4 5 6 7 8 44 45 46
1 libra $8.76 $9.09 $9.91 $10.35 $10.71 $10.83 $11.01 $32.71 $33.63 $43.09
2 $9.42 $10.48 $11.33 $11.58 $12,08 $12.54 $12.75 $36.39 $37.66 $46.76
3 $9.90 $11.04 $11.94 $12.43 $12.94 $13.38 $14.03 $39.54 $42.90 $49.79
4 $10.19 $11.11 $12.32 $13.12 $13.48 $14.36 $15,03 $43.42 $45.73 $54.01

Ayuda con la frmula para buscar la zona y el peso coincidente para obtener la cotizacin de Excel!

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

Step: 3

blur-text-image

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

Process Audits And 6 Sigma Excellence To Mitigate Risk And Improve Business Performance

Authors: Mr Indulis Laimonis Svikis

1st Edition

B09M5FPYR4, 979-8769768996

More Books

Students also viewed these Accounting questions

Question

The Nature of Nonverbal Communication

Answered: 1 week ago

Question

Functions of Nonverbal Communication

Answered: 1 week ago

Question

Nonverbal Communication Codes

Answered: 1 week ago