Calculating commission earned for beverages for order

Assignment Help Business Management
Reference no: EM133035235

Use an IF function in cell J10 to calculates the commission earned for beverages for order 1.

  1. The beverage commission is 10% of the total sale if the customer buys a beverage.
  2. If the beverage sale amount (cell D10) is greater than 0, the beverage commission equals the sales total (cell G10) multiplied by the beverage commission rate (cell G4).
  3. Otherwise, the beverage commission is 0.
  4. Use appropriate relative and absolute cell references.

Reference no: EM133035235

Questions Cloud

Determine the fixed and variable components : Determine the fixed and variable components of repair expense using the high-low method. Use copies made as the measure of activity
Explaining the cultural communication practices : Interview two people who belong to cultural groups that are different from your own. Have a conversation with your interview partners about communication in the
Explain the change and transformation of organization : Individual or self-change is important in understanding why people resist change. Some of the personalities have higher resistance to change while other persona
Explain the psychographic segmentation : Assignment: What are the psychographic segmentation, the, demographic segmentation, the Behavioral market segmentation, geographic segmentation, and market segm
Calculating commission earned for beverages for order : Use an IF function in cell J10 to calculates the commission earned for beverages for order 1.
Calculate the number and type of storage units : Calculate the number and type of storage units for the following scenario. Key your answers in the designated space.
Writing memo about perception and decision-making : Write a personal reflection memo about perception and decision-making. The memo describes a time had an erroneous perception of someone else that led to making
Explain the company governance structure : "Why should I care about the shareholders, who I see once a year at the general meeting. It is much more important that I care about the employees; I see them e
Examples of branding in financial services : Identify two examples of branding in financial services (e.g., specific types of retail bank accounts or insurance policies), and define their characteristics.

Reviews

Write a Review

Business Management Questions & Answers

  Differences among international markets

Now consider the differences among international markets. (dell Computers)dell Computers)

  Effective annual yield on the debentures

Polycorp debentures are selling for $104 (FV = 100) and mature in ten years. The coupon rate is 6% pa, with coupons paid quarterly. What is the effective annual yield on the debentures?

  Healthcare-particularly government-

Healthcare-particularly government-funded healthcare-is heavily regulated.

  What are the differences between the tcp and the ip

What are the differences between the TCP and the IP? Why are TCP/IP and DNS important components to the way the Internet works?

  Explain the role of purchasing and supply management

Explain the role of Purchasing and Supply Management in new product development as well as development of specifications.

  Describe the local economys stage in the business cycle

Describe the local economys stage in the business cycle and describe how current credit market conditions affect your planning or operating decision for your good or service.

  International franchising: challenges and opportunities

Is China Stealing U.S. Intellectual Property? International Franchising: Challenges and Opportunities.

  Classroom space of an online educational environment

List at least 10 commonly used terms that any student might see in the classroom space of an online educational environment. Write definitions in your own words for each of these terms that can be easily understood by any student in this online envir..

  Success of cross-border alliances

Explain the four (4) key factors for the "success of cross-border alliances". Provide examples in your response

  Achieve the maximization of shareholders wealth

Can a firm still achieve the maximization of shareholders' wealth even if the government has passed regulations that require pollution controls, development res

  Describe the five phases of a project

Determine which project might be implemented and why (e.g. feasibility study, breakeven analysis, etc). Describe the five phases of a project

  Performing a business impact analysis

What are the 5 things you must consider when performing a business impact analysis? With references please.

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