Objective/s: Apply logical functions given certain conditions 1. Open a new workbook and type the following to the corresponding cells: Percent Invoice Sales Cost Margin Paid? Commission 00001 50000 45000 YES 00002 150000 60000 NO 00003 60000 45800 YES 00004 45000 20000 YES 00005 85000 64000 YES 00006 36000 9000 NO 00007 591000 350000 NO 00008 25000 14000 YES 00009 78000 60000 YES 00010 36000 28000 YES 00011 65000 60000 YES Note: Commission can only be availed if margin is at least 20% and paid. Commission is 5% of sales. 2. Compute the percent margin and the commission following the stated rule. Percent margin is sales less cost all over cost (expressed in percent).

Objective/s: Apply logical functions given certain conditions 1. Open a new workbook and type the following to the corresponding cells: Percent Invoice Sales Cost Margin Paid? Commission 00001 50000 45000 YES 00002 150000 60000 NO 00003 60000 45800 YES 00004 45000 20000 YES 00005 85000 64000 YES 00006 36000 9000 NO 00007 591000 350000 NO 00008 25000 14000 YES 00009 78000 60000 YES 00010 36000 28000 YES 00011 65000 60000 YES Note: Commission can only be availed if margin is at least 20% and paid. Commission is 5% of sales. 2. Compute the percent margin and the commission following the stated rule. Percent margin is sales less cost all over cost (expressed in percent).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A new implementation project has started. Which integration document should the Technical Architect complete to understand the volumes of data that will go through each integration (initial and delta volumes)? 1. Integrations Requirements Document2. Test Scripts3. Test Results4. Operational Sizing Document.
Why did you decide to go with Microsoft Excel rather than any of the other alternatives that were open to you?
Why is the Waterfall methodology superior to Agile when developing a system for university course registration?
To what end may I put the subtotal function in Excel?
Why is the Waterfall approach preferable to the Agile one when developing a university course registration system?
I need the answer as soon as possible
Can you explain how to do multiple regression in Excel, along with the necessary steps?
between structured, O-O, and agile development methods? Whichmethod do you think is best, and why?
Write an essential detailed description of the main use case: PROCESS CHECKOUT.