Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This project is based on a REAL-WORLD scenario. A customer gets an updated price sheet from their vendor, Gardner Denver (Links to an external site.).

This project is based on a REAL-WORLD scenario. A customer gets an updated price sheet from their vendor, Gardner Denver (Links to an external site.). This updated price sheet comes in the form of an Excel spreadsheet with three (3) columns Material (aka part number), Description, Price.

The current software they use for managing their inventory, pricing, quotes, invoices, and other such fun things in business requires that their price update is in the form of a CSV file. But, not just any old CSV file, and not in the current format the pricing sheet comes in. And there are going to be three (3) files. One for the Main warehouse, one for warehouse 00, and one for warehouse 01. The CSV files must meet the following criteria:

  1. The three columns that are needed are:
    1. Part number
    2. Cost
    3. Price
  2. The file must be comma-delimited
  3. The file must NOT contain any quotation marks
  4. The numeric fields (Cost and Price) must have two decimal places (with trailing zeros)
  5. The cost field is calculated
    • Cost = Price * 0.6
  6. Each warehouse file must be separate
    • For the main warehouse, the part number does not change
    • For warehouse 00, you must append -00 to the part number
    • For warehouse 01, you must append -01 to the part number

Here is a sample of the result from each warehouse file.

Main Warehouse

00001143 SP,136.41,227.35 00001223 SP,48.66,81.10 00001236 SP,149.72,249.53 0001-0003-00,100.95,168.25 00015172 W,85.32,142.20

Warehouse-00

00001143 SP-00,136.41,227.35 00001223 SP-00,48.66,81.10 00001236 SP-00,149.72,249.53 0001-0003-00-00,100.95,168.25 00015172 W-00,85.32,142.20

Warehouse-01

00001143 SP-01,136.41,227.35 00001223 SP-01,48.66,81.10 00001236 SP-01,149.72,249.53 0001-0003-00-01,100.95,168.25 00015172 W-01,85.32,142.20

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

Database Systems An Application Oriented Approach Complete Version

Authors: Michael Kifer, Arthur Bernstein, Richard Lewis

2nd Edition

0321268458, 978-0321268457

More Books

Students also viewed these Databases questions