Question: Inventory/Quantity Discount Model Data Enter the data in the shaded area. The minimum quantity is the minimum amount that needs to be ordered in

Inventory/Quantity Discount Model Data Enter the data in the shaded area. The minimum quantity is the minimum amount that needs to be ordered in

Inventory/Quantity Discount Model Data Enter the data in the shaded area. The minimum quantity is the minimum amount that needs to be ordered in order to get the price that is in the same column. Demand rate, D Order cost, S Holding cost, H (fixed amount) Range 1 Range 2 Minimum quantity Unit Price, P Results Range 1 Range 2 Q* (Square root formula) #DIV/0! #DIV/O! Order Quantity #DIV/O! #DIV/O! Holding cost #DIV/O! #DIV/O! Order cost #DIV/O! #DIV/0! Unit costs #DIV/O! #DIV/0! Total cost, T #DIV/0! #DIV/0! 3 Inventory 4 5 Order Quantity Data 6 Annual Demand Rate, D 7 Setup/Ordering Cost, S 8 Holding/Carrying Cost per Unit per Year, H 9 Unit price, P 10 11 Reorder Point Data (optional) 12 Days per year or ... 13...Daily demand rate, d 14 Lead time in days, L 15 Safety stock, ss 16 Reorder Point, dL+ss 17 18 Results 19 Optimum Order Quantity, Q* (EOQ) 20 Maximum Inventory, Q* Economic Order Quantity Model $ #DIV/O! #DIV/0! 21 Average Inventory, Q*/2 #DIV/O! 22 Number of Orders, D/Q* #DIV/O! 23 24 Annual Holding Cost, HQ*/2 #DIV/O! 25 Annual Order Cost, DS/Q* #DIV/O! 26 27 Annual Unit Costs, PD $0.00 28 Total Annual Cost, T 29 #DIV/O! (fixed amount)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

I see youve uploaded two images The first image appears to relate to an InventoryQuanti... View full answer

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 Finance Questions!

Consider the following random experiment: A fair coin is tossed once. Here, the sample space has only two elements S = {H,T}. We define a sequence of random variables X 1 , X 2 , X 3 , on this...

Q1. What are the responsibilities of inventory management? Q2.What are decision rules?Why are they necessary? Q3. Why is less inventory needed in a line-flow manufacturer system than in lot or batch...

7) The second financial statement to prepare is the statement of retained eamings. To determine the ending balance of retained earnings you need to start with the opening balance as reported in the...

What quantity should be ordered, and which supplier should be used? I choose vendor 1 range 1 because the TC was the lowest is this correct? My work is below. Question 1. Emery Pharmaceutical uses an...

See Project 03-01 Assignment Spring 2015.docx Please Help me on this homework i am having some trouble answering it. Product SAP ERP GBI Release 6.04 Level Undergraduate Graduate Focus...

4 Files 12:47 PM Mon May 16 Insert Draw Layout Review View Unit 3Microec0nomics Name: ELASTICITY Use the space below to take notes during class. Elastic: Unit Elastic: Inelastic: Perfect...

Is there any SAP expert? Does someone has completed solution to the attached assignment? CASE STUDY Purchase-to-Pay Example Using SAP ERP The objective of this assignment is for you to become...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Turn in with an Excel file with your calculations and a report Chard Appliance (B) Exhibit 2: Chard Appliance Sales by State: 2003 Chard Appliance, located in Wichita, Kansas was founded in 1938 as...

If f is continuous on [0, ] and lim x f(x) = 0, show that f(x) dx = f(0)

Based on the following information, Salaries and Wages: $18,944 Utilities: $4,726 Net Rental Income: $262,968 Real Estate Taxes: $28,273 General & Administrative: $18,921 Other Income: $15,435...

3. Create a Visual Basic Windows application. Use the following names for the solution and project, respectively: Characters Solution and Characters Project. Save the application in the VB2015\Chap01...

A 0.1-m3 rigid tank initially contains refrigerant-134a at 1.2 MPa and 100 percent quality. The tank is connected by a valve to a supply line that carries refrigerant-134a at 1.6 MPa and 30C. The...

Juggling Act a juggler performs in a room whose ceiling is 3.0 m above the level of his hands. He throws a ball upward so that it just reaches the ceiling. (a) What is the initial velocity of the...

Calculate the moments of inertia I1, I2, and I3, for a homogeneous ellipsoid of mass M with axes lengths 2a > 2b > 2c.

(a) Find the height at which a billiard ball should be struck so that it will roll with no initial slipping. (b) Calculate the optimum height of the rail of a billiard table. On what basis is the...

Discuss the motion of a string when the initial conditions are q(x, 0) = 4x (L x)/L2, q(x, 0) = 0. Find the characteristic frequencies and calculated the amplitude of the nth mode.

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

71. Let X denote the number of white balls selected when k balls are chosen at random from an urn containing n white and m black balls. (a) Compute P{X = i}. (b) Let, for i = 1, 2, . . . , k; j = 1,...

75. Let a1

73. For the multinomial distribution (Exercise 17), let Ni denote the number of times outcome i occurs. Find (a) E[Ni]; (b) Var(Ni); (c) Cov(Ni , Nj); (d) Compute the expected number of outcomes that...