How to print: Complete the Select Offers for Merchandising Cost Report Screen.
CWDirect Rel 4.0 Merchandising Cost Report EKAPLAN INX1338 11/30/99 14:49:06 Page 1 EZK Mail Order Offer MIL THIRD MILLENIUM OFFER Item\SKU Item Description Vendor/Item Duty Royalties Prep Freight Other Total Item/Offer GM % Price Cost Charges Cost Price Class 222 HEALTH SUPPLMENTS Long SKU Department 1234 GA123 NATURAL GARLIC TABS 1.31 .00 .00 .00 .00 .00 1.31 3.89 66.32 GRE456 GREEN TEA W/PEACH 1.29 .00 .00 .00 .00 .00 1.29 3.50 63.14 VIT789 B25 VITAMIN E 400IU .79 .00 .00 .00 .00 .00 .79 10.00 92.10 VIT789 B50 VITAMIN E 400IU .00 .00 .00 .00 .00 .00 .00 6.23 100.00 Class 222 Totals: 4 Average 5.91 85.64 Offer MIL Totals: 4 Average 5.91 85.64 CWDirect Rel 4.0 Merchandising Cost Report EKAPLAN INX1338 11/30/99 14:49:06 Page 2 EZK Mail Order Offer QQQ NEW YEAR SPECIAL Item\SKU Item Description Vendor/Item Duty Royalties Prep Freight Other Total Item/Offer GM % Price Cost Charges Cost Price Class 012 OFFICE Long SKU Department 0123 GEL888 BLUE GEL WRITER PEN .50 .00 .00 .00 .00 .00 .50 1.50 66.67 GEL888 GREN GEL WRITER PEN .50 .00 .00 .00 .00 .00 .50 1.50 66.67 GEL888 NAVY GEL WRITER PEN .50 .00 .00 .00 .00 .00 .50 1.50 66.67 GEL888 ORAN GEL WRITER PEN .50 .00 .00 .00 .00 .00 .50 1.50 66.67 GEL888 PINK GEL WRITER PEN .50 .00 .00 .00 .00 .00 .50 1.50 66.67 GEL888 YELW GEL WRITER PEN .50 .00 .00 .00 .00 .00 .50 1.50 66.67 Class Totals: 6 Average 1.50 66.67 Class 123 SOFT TOYS Long SKU Department 1234 AUG678 AUGIE DOGGIE DOLL 2.00 .00 .00 .00 2.01 .00 4.01 12.00 66.58 Class 123 Totals: 1 Average 12.00 66.58 Offer QQQ Totals: 7 Average 3.00 66.61 |
Contents:
• Offer (Offer code)code and description
• Item Class code and description
• L/S dept (Long SKU department) code
• For each item within an offer, item class, and long SKU department:
• item and SKU code and description
• vendor/item Price for the item's default vendor. The price is converted, if necessary, based on unit of measure or vendor currency. (Note: If the item does not have a vendor/item record for its default vendor, the item does not appear on the report. However, if there is a vendor/item but no vendor/item price, the item will appear, but the vendor/item price will appear as .00)
• vendor/item additional charges, broken out into duty (type = D), royalties (type = R), prep (type = P), freight cost (type = F), and other charges (all other types of additional charges assigned to the vendor/item). These charges are also converted, if necessary, in the same way as the vendor/item price. You use Working With PO Additional Charges (WPAC) to create additional charges of specific types. You can then assign these additional charges to vendor/items, specifying a percentage or per-unit amount for each type of charge. See Chapter 22: Working with Vendor Items (WVNI).
• total cost, including the vendor/item price and all additional charges
• the most current Price for the item/SKU in this offer. The system determines the "most current price" by using the single-unit price with the latest effective date, including dates in the future.
• the gross margin percentage, calculated by:
((Item/offer price - Total cost) / Item/offer price) x 100
• total number of items/SKUs for the class
• average item/offer price for the class
• average gross margin percentage for the class
• total number of items/SKUs for the offer
• average item/offer price for the offer
• average gross margin percentage for the offer
| Chapter 86: Printing the Merchandising Cost Report (PMCR) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 87: Inventory Inquiry by SKU (DSQI) |
ME12_07r CWDirect 18.0 August 2015 OTN