Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the Sales, COGS and Gross Profit Margins ?? Gross Profit Margin (%) Product Order Price ($) Quantity $59.99 FF $50.00 $299.98 SH $99.99 al

Calculate the Sales, COGS and Gross Profit Margins ??

image text in transcribed

Gross Profit Margin (%) Product Order Price ($) Quantity $59.99 FF $50.00 $299.98 SH $99.99 al $129.99 al $129.99 FF $50.00 FF $50.00 $59.99 $59.99 EF $50.00 $129.99 al $129.99 Order Discount Order Profit Per Shipping_da Rate Order ($) te Shipping Mode 1 17% $84.65 1/7/19 Standard Class 2 10% $10.17 1/7/19 Standard Class 1 18% $83.14 1/4/19 Standard Class 2 13% $48.72 1/5/19 Standard Class 1 17% $52.87 1/6/19 Standard Class 1 3% $20.55 1/5/19 Standard Class 2 5% $39.90 1/3/19 Standard Class 4 20% $36.80 1/5/19 Standard Class 4 9% $61.14 1/4/19 Standard Class 5 6% $79.37 1/4/19 Standard Class 5 10% $74.25 1/4/19 Standard Class 1 15% $34.58 1/3/19 Standard Class 1 16% $24.57 1/3/19 Standard Class Days for shipment (scheduled) Delivery Status 4 Late delivery 4 Late delivery 4 Advance shipping 4 Shipping on time 4 Shipping canceled 4 Shipping on time 4 Advance shipping 4 Shipping on time 4 Advance shipping 4 Advance shipping 4 Advance shipping 4 Advance shipping 4 Advance shipping Late_delive ry_risk Sales ($) COGS ($) 1 $49.79 1 $90.00 0 $245.98 0 $173.98 0 $107.89 0 $126.09 0 $95.00 0 $160.00 0 $218.36 0 $281.95 0 $225.00 0 $110.49 0 $109.19

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

Business Intelligence A Managerial Perspective on Analytics

Authors: Ramesh Sharda, Dursun Delen, Efraim Turban

3rd edition

133051056, 978-0133051056

More Books

Students also viewed these Accounting questions

Question

13. What was your biggest failure?

Answered: 1 week ago