Filetype Excel XLSX | Posted on 08 Aug 2022 | 4 years ago
Authentication
digital resources
358x Filetype XLSX File size 0.03 MB Source: www.dor.ms.gov
Sheet 1: Retail 20 Pk w Purchase Disc
| Mississippi Department of Revenue | INSTRUCTIONS: Enter the wholesaler's invoice price per carton | ||||||||||
| Minimum Cigarette Prices | of cigarettes in Column B beginning on Row 14. Next enter any | ||||||||||
| Price Reductions Based on PURCHASES | manufacturer's buydowns, contract price reductions or other | ||||||||||
| discounts BASED ON PURCHASES received in Columns C, D, | |||||||||||
| and E. The minimum retail selling prices per carton and per pack | |||||||||||
| will be automatically calculated Columns I, J K & L. | |||||||||||
| Size | Wholesale | Purchase Price Reductions per Carton | Net Cost | MINIMUM | Retail | Minimum | Minimum | Minimum | Minimum | ||
| 20 PACK | Invoice | MFG | CONTRACT | Other | to | Retail | Markup | Retail Price | Retail Price | Retail Price | Retail Price |
| Price | "Buydown" | Price Reduction | Discounts | Retailer | Markup( 6%) | rounded | per carton | per carton | per pack | per pack | |
| per carton | per carton | per carton | per carton | Carried out | (before sales tax | (Sales Tax Included) | before sales | (Sales Tax Included) | |||
| 10 Packs | 4 places | is added) | Tax is added | ||||||||
| per carton | |||||||||||
| 1 | 0.00 | 0.00 | |||||||||
| 2 | 0.00 | 0.00 | |||||||||
| 3 | 0.00 | 0.00 | |||||||||
| 4 | 0.00 | 0.00 | |||||||||
| 5 | 0.00 | 0.00 | |||||||||
| 6 | 0.00 | 0.00 | |||||||||
| 7 | 0.00 | 0.00 | |||||||||
| 8 | 0.00 | 0.00 | |||||||||
| 9 | 0.00 | 0.00 | |||||||||
| 10 | 0.00 | 0.00 | |||||||||
| 11 | 0.00 | 0.00 | |||||||||
| 12 | 0.00 | 0.00 | |||||||||
| 13 | 0.00 | 0.00 | |||||||||
| 14 | 0.00 | 0.00 | |||||||||
| 15 | 0.00 | 0.00 | |||||||||
| 16 | 0.00 | 0.00 | |||||||||
| 17 | 0.00 | 0.00 | |||||||||
| 18 | 0.00 | 0.00 | |||||||||
| 19 | 0.00 | 0.00 | |||||||||
| 20 | 0.00 | 0.00 |
| Mississippi Department of Revenue | INSTRUCTIONS: Enter the wholesaler's invoice price per carton of cigarettes in Column B | |||||||||
| Minimum Cigarette Prices | beginning on Row 14. Next enter any manufacturer's buydowns, contract price reductions | |||||||||
| Price Reductions Based on SALES | or other discount you received based on the Quantity of SALES you made in Columns | |||||||||
| G, H, and I respectively. (Buydowns and other Price Reductions based on Sales are deducted | ||||||||||
| after the minimum markup and sales tax have been added to the price of the cigarettes.) | ||||||||||
| The minimum selling prices per carton and pack are automatically calculated Columns J and K. | ||||||||||
| Size | Wholesale | MINIMUM | Retail | Minimum | TOTAL | Price Reductions per Carton Based on Contract SALES | Minimum Retail Price | Minimum | ||
| 20 PACK | Invoice | Retail | Markup | Retail Price | Minimum | MFG | CONTRACT | Other | per carton | Retail Price |
| Price | Markup( 6%) | rounded | per carton | Retail Price | "Buydown" | Price Reduction | Discounts | After Price Reductions | per pack | |
| per carton | Carried out | (before sales tax | per CARTON | per carton | per carton | per carton | (Total Minimum Sales Tax | |||
| 10 Packs | 4 places | is added) | (Sales Tax Included) | Included less Price Reductions) | ||||||
| per carton | ||||||||||
| 1 | 0.00 | |||||||||
| 2 | 0.00 | |||||||||
| 3 | 0.00 | |||||||||
| 4 | 0.00 | |||||||||
| 5 | 0.00 | |||||||||
| 6 | 0.00 | |||||||||
| 7 | 0.00 | |||||||||
| 8 | 0.00 | |||||||||
| 9 | 0.00 | |||||||||
| 10 | 0.00 | |||||||||
| 11 | 0.00 | |||||||||
| 12 | 0.00 | |||||||||
| 13 | 0.00 | |||||||||
| 14 | 0.00 | |||||||||
| 15 | 0.00 | |||||||||
| 16 | 0.00 | |||||||||
| 17 | 0.00 | |||||||||
| 18 | 0.00 | |||||||||
| 19 | 0.00 | |||||||||
| 20 | 0.00 |
no reviews yet
Please Login to review.
