Formula to determine any discount

Assignment Help Operation Management

Reference no: EM131434425

In cell H6, enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B42(20%). If no discount should be applied, the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula. Copy the formula to the range H7:H32.

Reference no: EM131434425

Questions Cloud

Describe any concerns related to the quantity : Explore water supply and management in your area using the internet. What is the source of your municipality's drinking water? Describe any concerns related to the quantity and quality of this water source. Explain one thing you can do in your e..

Considering opening drive-through window for customer pickup : A pizza place is considering opening a drive-through window for customer pickups. It is estimated that at peak times (6-9pm and 1-3am), customers will arrive at a rate of 11 per hour. The clerk who will staff the window can serve customers at the rat..

Calculate the break-even quantities for each alternative : An operations manager is deciding on the level of automation for a new process. The fixed cost for automation includes the equipment purchase price, installation, and initial spare parts. Calculate the break-even quantities for each alternative. If t..

Firm save annually in ordering and carrying costs : A produce distributor uses 800 packing crates a month, which it purchases at a cost of $10 each. The manager has assigned an annual carrying cost of 35% of the purchase price per crate. Ordering costs are $28. Currently the manager orders once per mo..

Formula to determine any discount : In cell H6, enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B42(20%). If no discount should be applied, the formula should return ..

What are competencies : What are competencies? Explain and provide two or three examples. (The Chapter is about Position Descriptions and Performance Standards) Is Legend of Sleepy Hollow a didactic story, a comedy or both? Explain the essential difference between a policy ..

Dumping will run out all foreign rivals : What is a major counterpoint to the argument that dumping will run out all foreign rivals?

For output equal to forecasted demand : Consider a production line that is to be used for 10 hours per day in order to meet forecasted demand of 900 units per day. The following precedence diagram with times in seconds describes the tasks necessary to produce this product: For output equal..

Geographical organizational structure : What would be real-world examples(companies that have these structures) of Functional organizational structure,Product organizational structure and Geographical Organizational Structure ?

User Account

All Pages