Create an appropriate worksheets

Assignment Help Business Management
Reference no: EM132947714

1. Create an appropriate worksheets based on the work you have done above. Enter your own data. Save your worksheets as portlouis, curepipe and vacoas.

2. Save your work into a new workbook as yourlastname.xls. Please note that only one workbook must be created.

3. Insert a new worksheet in your workbook - name it 'consolidated worksheet'. Use appropriate formula to consolidate the 'quantity' and 'sales' figures from the different worksheets you created in step 2 above.

4. Salespeople who have sales greater than 30,000 will receive a 10% commission. Those who have achieved a sales between 10,000 and 30,000 will receive a 5% commission and those who have achieved a sales of less than 10,000 will not receive any commission. Calculate the commission in the 'Port Louis' worksheet for each sales person using absolute referencing and the 'if' formula.

Reference no: EM132947714

Questions Cloud

Discuss the importance of professional engineers : Discuss the importance of professional engineers maintaining continued vigilance of the prospect of ethical transgression, and up-to-date knowledge of the corpo
What is the current situation in latin countries : What is the current situation in Latin countries in terms of the political dynamics?
Describe csr and its significance : Describe CSR and its significance to internal and xternal business environments.
Why is tracking vital statistics so important in healthcare : Why is tracking vital statistics so important in healthcare? How does calculating something like Years of Potential Life Lost change the way we think about publ
Create an appropriate worksheets : 1. Create an appropriate worksheets based on the work you have done above. Enter your own data. Save your worksheets as portlouis, curepipe and vacoas.
Determine the number of hectare for plantation : A farmer wants to make use of a piece of land with an area 23 hectares to plant Beans and Cabbages.
Aboriginal power readings : Based on the Aboriginal Power readings please provide a short summary of three (3) examples of partnerships opportunities governments and energy companies can p
Question on moral decision-making : This week, you will write about a time in which you had to make a difficult moral decision.
Discuss various theories of motivations : What are the determinants of motivations for an individual at a workplace?

Reviews

Write a Review

Business Management Questions & Answers

  Determining the salvage value in six years

The firm's marginal tax rate is 40 percent, and its required rate of return is 12 percent. Should the new packing machine be purchased?

  Sequence jobs scheduling rules

a) Sequence these jobs based on the following scheduling rules: Slack and critical ratio (CR)

  Improve the employees performance

Improve an employee before terminating - Before discharging an employee, what are the proper steps in attempting to improve the employee's performance?

  Client capabilities and commitment

Credibility and influence are vital components for success as a performance consultant as well as successful completion of any consulting project. Use the "Client Capabilities and Commitment" Assessment on p. 97 - 98 in the Field Book.

  Architectures for integrating systems

A service-oriented architecture (SOA) is a type of architecture that designs and builds business processes into individual packages that can operate independent

  Explain the principal theories and the various approaches

Explain the principal theories and the various approaches to management that have evolved over time and their application

  What is a senior accountant

What is a Senior Accountant? Senior accountants take ownership of reporting costs, profitability, margins and expenditures for a given business.

  In what situations would you use lump sum gmp

1) In what situations would you use Lump Sum GMP? In what situations would you use Progressive GMP?

  Training and performance management

In your own words, Explain one similarity and one difference between training and performance management and between training and succession planning.

  How do organizations behave and why

The concept of rationality, especially in an organizational setting, is well established. Yet, it is possible that assumptions about rationality create blind spots concerning social forces that may affect IS innovation and change in an organization. ..

  Complicated working relationships

Complicated working relationships, intense power struggles, and excessive reliance on group processes are disadvantages of what type of organizational structure?

  Part of an informal organizational that operated

Try to recall a situation when you were part of an informal organizational that operated within a formal one and share your experience with the class.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd