b. Find the EOQ given this information: D = 4,500 units/year, S = $36, and H = $10 per unit per year. %3D c. Find the economic production quantity given this information. D = 18,000 units/year, S $100, H = $40 per unit per year, p = 120 units per day, and u= 90 units/day

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
Question

(Use an excel file to show formulas used)

1.
234 5 6
Item
Unit Cost
Annual Volume (00)
$100
25
80
30
15
60
50
10
11
70
60
85
10
60
b. Find the EOQ given this information: D = 4,500 units/year, S= $36, and H = $10 per unit per year.
c. Find the economic production quantity given this information.
D= 18,000 units/year, S = $100, H = $40 per unit per year, p = 120 units per day,
and u = 90 units/day
Transcribed Image Text:1. 234 5 6 Item Unit Cost Annual Volume (00) $100 25 80 30 15 60 50 10 11 70 60 85 10 60 b. Find the EOQ given this information: D = 4,500 units/year, S= $36, and H = $10 per unit per year. c. Find the economic production quantity given this information. D= 18,000 units/year, S = $100, H = $40 per unit per year, p = 120 units per day, and u = 90 units/day
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,