Each item depending on the respective item type

Assignment Help Operation Management

Reference no: EM131275752

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.

Reference no: EM131275752

Questions Cloud

Supply chain management by its very nature depends : Supply chain management by its very nature depends on relationships and connections. Describe supply chain integration as it applies to relationships and connections. Explain the challenges for integrating business functions and inter-organizational ..

Analyse characteristics of your service causing this problem : You are the marketing manager of a service company. You notice that the number of customers using your service is decreasing. Research has indicated that it is because of customer dissatisfaction. Analyse the characteristics of your service causing t..

Discuss the pros and cons : With so much productive capacity and room for expansion in the United States, why would a company based in the United States choose to purchase items from foreign firm? Discuss the pros and cons.

What is the capacity of the orthopedists office in patients : Consider an orthopedist’s office. All arriving patients first check in at a reception area where they fill out the necessary paperwork. On average, it takes 10 minutes to complete check-in and there are four receptionists working at the office. What ..

Each item depending on the respective item type : 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 mater..

Focus of attention for revenue management : You have been assigned to manage booking levels for Delta Airlines. Flight from Seattle to Dallas has been the focus of attention for revenue management due to low utilization of the available seats. This flight is served by a Boeing 737 with a capac..

What is the optimal product mix : Hospital has capacity/week for 100 general surgeries or 25 neurosurgeries -average demand for general surgeries is 80 and is 15 for neurosurgeries WHAT IS THE OPTIMAL PRODUCT MIX?

Planning stages of implementing major downsizing initiative : Your company is in the planning stages of implementing a major downsizing initiative. Like most well-kept company secrets, word has started to spread throughout the company. You fear how this will impact both short-term and long-term productivity; Wh..

User Account

All Pages