Microwave Products is a manufacturer of microwave-related products has been talking with you about replacing some aging NCC copying equipment. Angela would like a mix of machines. PIC for the corporate headquarters and Taejon Business Machines for a satellite office. The machines must be able to link to each other as Angela has plans for content management software.

Angela has just informed you that Microwave Products would like to order the following equipment from TDC:

• Two PIC MV400s each with 20 Bin Sorter and 20 Bin Sorter with Stapler, Auto document Feeder, 2000 Sheet Paper Deck, Key Counter Socket, and Copycount System.
• Two PIC LMV300s each with: 20 Bin Sorter with Stapler, and Autodocument Feeder, a 2000 Sheet Paper Deck, Cabinet, Key Counter Socket, and Copycount System

• Three Taejon Business Machines C450s BASE MODEL ONLY.
• Three Taejon Business Machines Shredders
• Three PIC / Taejon Business Machines Links
• Seven Scan to email links (1 for each copier ordered).
• Angela has opted to donate her older machines to a local charity.
• (For Class Discussion) What advice/additional costs would you give to Angela regarding a future upgrade to content management?

You will be computing the price from the Distribution Company (TDC) for this customer. To do so you will need to convert PIC and Taejon Business Machines Direct Pricing to TDC pricing. This will also help you prepare for the pricing differences you will encounter between your distributorship and direct sellers. You will not be providing the customer with a price comparison.

Find the list prices in the background materials. Discount machines only for quantity discounts. Discount to the TDC negotiated price. Come up with your total. At the end, add pay on delivery discount: The customer will pay on delivery so they have earned a 3% discount on the total sale. (Note this is not the normal 2/10 net 30 due to the mix of machines and immediate payment on delivery)

Open up the Excel outline

1. You should see an outline with the following columns:

Column A: Proposed Equipment

Column B: Base Price (PIC/Taejon Business Machines Direct Pricing found in your Background materials/STM)

Column C: Quantity

Column D: Extended Price (Quantity X Base Price)

Column E: Quantity Discounts Applied (if Any)

Column F: TDC Discounts Applied

2. Fill in Columns A, B and C
3. Write a formula that automatically converts the data in column B and C to Column D Quantity X Base Price. Formula will reside in column D Make Sure the entire column D is converted.
4. Write a formula that applies the quantity discounts from PIC and Taejon Business Machines in Column E. Make sure the appropriate cells reflect the discount. (Hint not all products ordered receive a discount)
5. Write a formula in Column F that reflects the TDC discount. Make sure the entire column is converted.
6. The Sum in Column F will need to be reduced by the customer delivery discount, designate a cell as total price and write a formula that reduce the total by 3%
7. Submit documents into the drop boxes in Black Board.