Question: please show excel work. Problem 2.5 Mail Order House A mail order house uses 18,000 boxes per year. Carrying costs are $0.60 per box per

please show excel work. please show excel work. Problem 2.5 Mail Order

Problem 2.5 Mail Order House A mail order house uses 18,000 boxes per year. Carrying costs are $0.60 per box per year. Ordering costs are $96. The following price schedule applies. Number of boxes 1,000 to 1,999 2,000 to 4,999 5,000 to 9,999 10,000 or more Price per box $1.25 $1.20 $1.15 $1.10 a. Find the optimal order quanity. EOQ - SQRT(2DS/H) Common minimum Q = SQRT{(2*18000*96/.6) 2400 boxes Total Cost at 2400 - Carrying Cost+Order Cost+Purchase Cost (0/2) + (D/Q)S+PD (2400/2)*.6+(18000/2400)*96+1.20*18000 $23,040 Total Cost at 5000 = Total Cost at 10,000 = b. Number of orders per year

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!

Can you show me how insert each bullet in part a.) into excel. I am unfamiliar with excel functions and need to compute problem into an excel doc. thank you! Basic EOQ Analysis Consider a restaurant...

A mail-order house uses 16,050 boxes a year. Carrying costs are 75 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes 1,000 to 1,999 2,000 to...

help with homework questions. A mail-order house uses 15,890 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of...

Problem 2 (20 points) A mail-order house uses 15,000 boxes a year. Carrying costs are 70 cents per box a year, and ordering costs are $96. The following price schedule applies. Determine a. Determine...

Recording n Information p Flag question 3 4. 00 9 A mail-order house uses 18,000 boxes a year. Carrying costs are $0.60 per box per year, and ordering costs are $96. The following price schedule...

Please answer parts A and B for this question. Part A asks to round to the nearest whole number. Part B asks to round to two decimal places. A mail-order house uses 15,725 boxes a year. Carrying...

please answer the following A mail-order house uses 15,850 boxes a year. Carrying costs are 56 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes...

solve step by step. A mail-order house uses 16,125 boxes a year. Carrying costs are 56 cents per box a year, and ordering costs are $93. The following price schedule applies. Click here for the Excel...

Write a paper in which you identify at least 3 problems in a relationship you have been in or witnessed. Then, analyze and evaluate your position. You will need to do research and have four credible...

Ms. Carmen is a Malaysian citizen and was a resident in Malaysia prior to the year 2015. On 3 August 2015, she left Malaysia to join a U.K. company which is based in Perth. The following information...

On the Payroll worksheet, use a function in column K to make an employee ID using the last four digits of the employee's phone number

What is an example of constructive feedback? provide reference