Create a Product Costs worksheet to determine the vendor

Assignment Help Management Information Sys

Reference no: EM132264127

Management Info Systems Assignment -

You will use Microsoft Excel 2016 spreadsheet software to sort the Lab 3 data by criteria such as item description, item cost, vendor number, vendor name, or A/P terms. A/P Terms is expressed as the number of days that the customer has to pay the vendor for a purchase. In other words, 30 designates net 30 days. The vendor that allows customers the longest time to pay for an order would offer the most favorable payment terms.

You need to complete the following tasks:

Create a Product Costs worksheet to determine the vendor with the lowest price for the same item when it is supplied by multiple vendors. You can filter the data using the Item Description column. This filters list can be sorted by Item Cost and Vendor Number.

Include the following columns in the solution: Order Number Item Number Item Description Item Cost Quantity Cost Per Order A/P Terms Order Date Arrival Date Delivery Days (Delivery Days is Arrival Date - Order Date)

Research Question (Word document): Write an analysis of the data in this spreadsheet. What can you learn about this business by looking at the data? What questions do you have after looking at the data? What departments would need to review these Worksheets? What additional Worksheets would be useful?

Attachment:- Lab3 .rar

Reference no: EM132264127

Questions Cloud

How do you feel the investigative community can overcome : How do you feel the investigative community can overcome these negative outcomes?

What additional information would you need : Should you continue to fly the plane? Why might your answer depend on the decision time frame, and what additional information would you need?

Part of the acquisition process : During what part of the acquisition process should the contracting officer have reacted to the engineer's demand for custom trash cans?

A description of the supplies and techniques you used : Process two of the following Porous items: piece of paper and a wooden furniture item or wooden door.

Create a Product Costs worksheet to determine the vendor : Management Info Systems - Create a Product Costs worksheet to determine the vendor with the lowest price for same item when it is supplied by multiple vendors

How to get the equilibrium price and quantity : Please explain in detail from here how to get the equilibrium price and quantity?

Identify the parties who are before the court : Articulate the context and relevance of law in a business environment: Identify the parties who are before the court. Provide a brief background and context.

Synopsizing in the government wide point of entry : Given the expected dollar value of the acquisition ($20,000), what method of publication, if any, is required?

What is the next generation identification system : The use of fingerprint evidence in criminal investigations and acceptance by the courts are based on three fundamental principles of fingerprints.

User Account

All Pages