Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculation worksheets (i) Cal1_MonthlySales Order_date Order Id Order Status Type Market Order Region Order Country Order City Customer Segment Customer Id Product Family Product Category
-
Calculation worksheets
-
(i) Cal1_MonthlySales
| Order_date | Order Id | Order Status | Type | Market | Order Region | Order Country | Order City | Customer Segment | Customer Id | Product Family | Product Category | Product Name | Product Price ($) | Order Quantity | Order Discount Rate | Order Profit Per Order ($) | Shipping_date | Shipping Mode | Days for shipment (scheduled) | Delivery Status | Late_delivery_risk | Sales ($) | COGS ($) | Gross Profit Margin (%) | Days for shipment (real) | Shipment Status |
| 1/1/19 | 50080 | PENDING_PAYMENT | PAYMENT | Pacific Asia | West Asia | Turqua | Eskisehir | Home Office | 2982 | Apparel | Cleats | Perfect Fitness Perfect Rip Deck | $59.99 | 1 | 17% | -$84.65 | 1/7/19 | Standard Class | 4 | Late delivery | 1 | $49.79 | $134.44 | -170.01% | 5 | Late Shipment |
| 1/1/19 | 50080 | PENDING_PAYMENT | PAYMENT | Pacific Asia | West Asia | Turqua | Eskisehir | Home Office | 2982 | Golf | Women's Apparel | Nike Men's Dri-FIT Victory Golf Polo | $50.00 | 2 | 10% | -$10.17 | 1/7/19 | Standard Class | 4 | Late delivery | 1 | $90.00 | $100.17 | -11.30% | 5 | Late Shipment |
| 1/1/19 | 50097 | CLOSED | CASH | Europe | Eastern Europe | Rusia | Briansk | Corporate | 10362 | Fan Shop | Camping & Hiking | Diamondback Women's Serene Classic Comfort Bi | $299.98 | 1 | 18% | $83.14 | 1/4/19 | Standard Class | 4 | Advance shipping | 0 | $245.98 | $162.84 | 33.80% | 4 | In-time Shipment |
| 1/1/19 | 50118 | COMPLETE | DEBIT | Africa | North Africa | Argelia | Algiers | Corporate | 10008 | Footwear | Cardio Equipment | Nike Men's Free 5.0+ Running Shoe | $99.99 | 2 | 13% | $48.72 | 1/5/19 | Standard Class | 4 | Shipping on time | 0 | $173.98 | $125.26 | 28.00% | 4 | In-time Shipment |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advanced Cost Accounting
Authors: J.K. Mitra
1st Edition
8122425941, 978-8122425949
