The store gives a discount of 8 on the unit sale price if, Ask an Expert

Management Studies

The store gives a discount of 8% on the unit sale price if the item type is finished product, a discount of 6% on the unit sale price if the item type is semi-finished product, and a discount of 4% on the unit sale price if the item type is raw material. Determine the Discount % for each item depending on the respective Item Type. You should use IF statement and absolute reference to accomplish this task.

How do I make the IF Nested function for this in excel. Right now the formula I have is =IF(C6:C53=Raw Material, "4%", IF(C6:C53=Semi Finished Product, "6%", IF(C6:C53=Finished Product, "8%"))) AND this is not working correclt.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92030470

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 define 1 incremental 2 substantial and 3 transformational

1. Define 1) incremental, 2) substantial, and 3) transformational innovation. Provide two examples of each type of innovation and explain why you chose them. 2. Search the Internet and find an article on a recent global ...

A company is trying to determine the optimal mix of tv

A company is trying to determine the optimal mix of TV, Newspaper and Radio ads for their marketing campaign this week. Management requires that the number of TV ads would not exceed 25% of the total number of ads. If th ...

Several states have now legalized the use of recreational

Several states have now legalized the use of recreational marijuana, paving the way for the growth of legal marijuana dispensaries. Let's say that within a state, legal dispensaries look very similar to each other in ter ...

What are the three opportunities for the marketer when it

What are the THREE opportunities for the marketer when it comes to the location? How does Rony describe the increase use of location based data ? What is the first example of crowdsourcing in the web? What is the technol ...

Challenges face established firms in regards to innovative

Challenges face established firms in regards to innovative technology. Three challenges include 1) working on existing opportunities; 2) pursuing future opportunities; and 3) optimally balancing the firm’s resources to w ...

1 whenever possible it is advisable to use instruments that

1. Whenever possible, it is advisable to use instruments that have already been developed and repeatedly used in published studies, rather than developing our own instruments for our studies. Do you agree? Discuss the re ...

Answer each question in 75 words a piece use references if

Answer EACH question in 75 words A PIECE. Use references, if needed and cite. 1. Discuss whether or not you were aware of the differences between managers and leaders. Now that you are aware of the differences, does this ...

1 in 200 words or more recommend the best way to implement

1. In 200 words or more, Recommend the best way to implement a restructuring plan that will downsize a sales team? 2. Does structure follow strategy or strategy follow structure? 3. What type of information come from a s ...

1 imagine you overhear two of your colleagues talking and

1. Imagine you overhear two of your colleagues talking and one says to the other, “Companies should use investment entry modes whenever possible because they offer the greatest control over business operations.” Do you a ...

1 compare the rights of plaintiffs under common law with

1. Compare the rights of plaintiffs under common law with the rights of persons who purchase securities registered under the Securities Act of 1933 and sustain losses. In your answer, emphasize the issue of who must bear ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert