Given the following information, answer the questions below Provide your answers briefly and show your calculations in an MS Excel file by step by step calculations with formula Annual Demand 30000 units Annual Production 40000 units Setup Cost 120 dollars Holding Cost (H) 25 dollars per item per year working days in yr 225 days What is the EPQ What is the total cost at EPQ What is the maximum inventory level What is the total number of production run in a year What is the length of production run What is the time between production What is the length of time with no production

The Answer is in the image, click to view ...

Question: Given the following information, answer the questions below. Provide your answers briefly and show your calculations in an MS Excel file by step by step

Given the following information, answer the questions below. Provide your answers briefly and show your calculations in an MS Excel file by step by step calculations with formula

Annual Demand	30000	units
Annual Production	40000	units
Setup Cost	120	dollars
Holding Cost (H)	25	dollars per item per year
# working days in yr	225	days

What is the EPQ?
What is the total cost at EPQ?
What is the maximum inventory level?
What is the total number of production run in a year?
What is the length of production run?
What is the time between production?
What is the length of time with no production?

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!

1. Prepare a horizontal analysis of the comparative income statement of Harlan ?Designs, Inc. Round percentage changes to one decimal place. 2. Why did 2016 net income increase by a higher percentage...

Procurement manager Ikbal is working on preparing a 10-day inventory management and order schedule for Dragon Ball Inc. The company has the following cost structure and demand structure: Setup(order)...

CON/CNE 271 Construction Safety HW #3: Calculations In this homework assignment, there are two scenarios where you must calculate the amount each contractor will be paying for workers' compensation...

Poindexter LeMans sat at his Louis XIV desk and looked at the garage monitor. Sure enough, there was his Lamborghini Veneno parked snuggly in the middle of his other 50 cars. He thought to himself,...

Problem 1. The end-of-month closing prices for Eastman Kodak and Archer Daniels Midland are given below. Kodak paid a $0.50 cash dividend per share on August 28 and November 27. ADM paid cash...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Operation Research ( Need proper solution) Instructions: 1. This is a GROUP work: Each member should contribute to it. However, collaboration between groups of the same section or other sections is...

Sheet1 Sheet2 Historical sales data 9 3 2231 976 4 2861 677 12 1986 1067 UAE Oman Kuwait KSA Bahrain 1 1864 1411 649 4620 361 2 2489 1014 500 5518 490 Week 6 1347 926 $21 1370 632 5 2144 686 566 S017...

Hello, I'm a bit at lost with this individual assignment, if you can please assist with the excel sheet calculations as to answer some of this questions I may be able to visualize with the formulas...

case study 1 Please be informed that This is strictly an individual assignment. In the multiple-choice questions, please highlight your answer. Once you are done with inserting all your answers in...

The histogram shows the sizes (in acres) of 36 vineyards in the Finger Lakes region of New York. a) Approximately what percentage of these vineyards are under 60 acres? b) Write a brief description...

Water is boiled in a pan on a stove at sea level. During 10 min of boiling, it is observed that 200 g of water has evaporated. Then the rate of heat transfer to the water is (a) 0.84 kJ/min (b) 45.1...

The optimal total value of assets in an active investment strategy is not dependent on:Select oneO A . alphaIncrease in asset value vs . decrease inIncrease in asset value vs . decrease in ....

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...