7 8 Part 3: Economic Ordering Quantity 9 1. Calculate the company's EOQ for Engine Valve A1100 (make sure to link values to the other tabs): 10 11 Estimated Annual Sales this year: 12 Ordering cost for each order: 13 Carrying Cost per unit 14 15 EOQ: 16 units units 17 2. Complete the table below by linking to the appropriate cells in the other tabs: 18 19 Order Size Total Total Carrying Cost Ordering Cost 24 20 21 28 29 30 22222222223 25 26 5 10 20 50 100 27 3. Create a graph of both the Carrying and Ordering cost. Make sure your EOQ ties to where the two lines cross. Rename your Chart to: Cost of Ordering & Carrying Inventory L

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
7
8 Part 3: Economic Ordering Quantity
9 1. Calculate the company's EOQ for Engine Valve A1100 (make sure to link values to the other tabs):
10
11 Estimated Annual Sales this year:
12 Ordering cost for each order:
13 Carrying Cost per unit
14
15 EOQ:
16
units
units
17 2. Complete the table below by linking to the appropriate cells in the other tabs:
18
19
Order Size
Total
Total
Carrying
Cost
Ordering
Cost
24
20
21
28
29
30
22222222223
25
26
5
10
20
50
100
27 3. Create a graph of both the Carrying and Ordering cost. Make sure your EOQ ties to where the two lines cross. Rename your Chart to: Cost of Ordering & Carrying Inventory
L
Transcribed Image Text:7 8 Part 3: Economic Ordering Quantity 9 1. Calculate the company's EOQ for Engine Valve A1100 (make sure to link values to the other tabs): 10 11 Estimated Annual Sales this year: 12 Ordering cost for each order: 13 Carrying Cost per unit 14 15 EOQ: 16 units units 17 2. Complete the table below by linking to the appropriate cells in the other tabs: 18 19 Order Size Total Total Carrying Cost Ordering Cost 24 20 21 28 29 30 22222222223 25 26 5 10 20 50 100 27 3. Create a graph of both the Carrying and Ordering cost. Make sure your EOQ ties to where the two lines cross. Rename your Chart to: Cost of Ordering & Carrying Inventory L
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education