Question: Using EOQ MODEL WITH QUANTITY DISCOUNTS (CONSTANT CARRYING COST) please solve the situation( explain it in Excel Form with formula) IVA is a distributor of

Using EOQ MODEL WITH QUANTITY DISCOUNTS (CONSTANT CARRYING COST) please solve the situation( explain it in Excel Form with formula) IVA is a distributor of PROGIBB 40 SG, a Plant Growth Regulator sourced from Sumitomo Chemicals which is a Multinational agrochemical company based in Japan. Sumitomo Chemicals has offerred IVA a quantity discount pricing schedule if the company will buy PROGIBB 40 SG in volume as follows:

Order Quantity (sachet)	Price (Php) per sachet
10 - 20	3500
21 - 40	3250
41 - 80	3100
80 and above	2850

One sachet contains 250 g. With an annual demand of 2000 sachets of the product, an annual carrying cost per sachet of Php 100 and an ordering cost of Php 12,000, the management of IVA wants to determine the optimal order quantity and total annual inventory cost.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Using EOQ MODEL WITH SHORTAGES please solve the situation( explain it in Excel Form with formula) IVA is a local distributor of AWESOME 25 WG (Thiamethoxam) supplied by Shandong Weifang Rainbow...

Using Basic EOQ Model please solve the situation( explain it in Excel Form with formula) IVA will launch it's newly registered proprietary product Double Nickel 250 WDG as a control of black sigatoka...

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

Spend analysis Stock-keeping unit (SKU) 10 Three-way match Utilization ty Images; @ monsity/ Getty Images Vendor master health care? iency? CHAPTER 17 applied, and what are the steps to fol-...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

The University of Southern Mississippi College of Science & Technology IET 670 Section: G001 Supply Chain Design & Management Midterm Exam Full Points: 100 Student ID: Name: Closed book closed notes...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Hello Guys, I need your help on that new two modules. I attached them file with this email. The module # 3 is related to the module two, which I submitted in my first questions. So I attached the...

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

MGT411 Innovative and Creative Business Thinking University of Phoenix Material Organizational Ecosystem Case Study Wal-Mart Stores, Inc. is a leading company in its industry and a widely recognized...

Find the equilibria of the following autonomous differential equations that include parameters. dw

According to condominium law, property taxes are assessed A. by number of unit owners. B. at a flat rate per unit. C. on average square footage per unit. D. on each unit separately.

what is the purpose of a section 7 5 4 election in a partnership? a ) to allocate partnership liabilities to each partner

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...