Enter the formulas in the template. The numeric answers are to the right. Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand Carrying cost= Ordering cost= EOQ= Average Inventory Order per year Total Cost = Quantity Ordered $200.00 $190.00 2,500 Total Cost Order Cost Order Cost (D/Q'Ordering Cost) Carry Cost Carry Cost (Q/2"Carrying Cost) Purchase Cost (D*Price) Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 ***** 90 125 150 200 Price 1.400 ▬▬▬▬▬▬ 1,100 900 895 890 885 Demand = Carrying cost= Ordering cost= EOQ= Average Inventory Order per year Total Cost = Quantity Ordered 72.5 72.5 90.0 125.0 150.0 200.0 $200.00 $190.00 2,500 72.5 36.3 2.8 $13,784.05 Order Cost $6,892 Carry Cost $6,892 Order Cost (D/Q'Ordering Carry Cost Total Cost Cost) (Q/2"Carrying Cost) $ 293,784.05 $6,892.02 $ 233.784.05 $6,892.02 $ 194,105.56 $5.555.56 $ 194.875.00 $4,000.00 $ 195,583.33 $3.333.33 $ 198,500.00 $2,500.00 $6,892.02 $6,892.02 $8,550.00 $11,875.00 $14,250.00 $19.000.00 Purchase Cost (D*Price) $280,000.00 $220,000.00 $180,000.00 $179,000.00 $178,000.00 $177,000.00
Enter the formulas in the template. The numeric answers are to the right. Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand Carrying cost= Ordering cost= EOQ= Average Inventory Order per year Total Cost = Quantity Ordered $200.00 $190.00 2,500 Total Cost Order Cost Order Cost (D/Q'Ordering Cost) Carry Cost Carry Cost (Q/2"Carrying Cost) Purchase Cost (D*Price) Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 ***** 90 125 150 200 Price 1.400 ▬▬▬▬▬▬ 1,100 900 895 890 885 Demand = Carrying cost= Ordering cost= EOQ= Average Inventory Order per year Total Cost = Quantity Ordered 72.5 72.5 90.0 125.0 150.0 200.0 $200.00 $190.00 2,500 72.5 36.3 2.8 $13,784.05 Order Cost $6,892 Carry Cost $6,892 Order Cost (D/Q'Ordering Carry Cost Total Cost Cost) (Q/2"Carrying Cost) $ 293,784.05 $6,892.02 $ 233.784.05 $6,892.02 $ 194,105.56 $5.555.56 $ 194.875.00 $4,000.00 $ 195,583.33 $3.333.33 $ 198,500.00 $2,500.00 $6,892.02 $6,892.02 $8,550.00 $11,875.00 $14,250.00 $19.000.00 Purchase Cost (D*Price) $280,000.00 $220,000.00 $180,000.00 $179,000.00 $178,000.00 $177,000.00
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Transcribed Image Text:Enter the formulas in the template. The numeric answers are to the right.
Quantity Discount Template (Detailed Documentation)
Discount
Quantity
Min.
1
50
90
125
150
200
Price
1,400
1,100
900
895
890
885
Demand =
Carrying cost =
Ordering cost =
EOQ =
Average Inventory
Order per year =
Total Cost =
Quantity Ordered
$200.00
$190.00
2,500
Total Cost
Order Cost
Order Cost
(D/Q* Ordering
Cost)
Carry Cost
Carry Cost
(Q/2* Carrying Cost)
Purchase Cost
(D* Price)
Quantity Discount Template (Detailed Documentation)
Discount
Quantity
Min.
1
50
90
125
150
200
Price
1,400
1,100
900
895
890
885
Demand =
Carrying cost =
Ordering cost =
EOQ =
Average Inventory
Order per year =
Total Cost =
Quantity Ordered
72.5
72.5
90.0
125.0
150.0
200.0
$200.00
$190.00
2,500
72.5
36.3
2.8
$13,784.05
Order Cost
$6,892
Total Cost
$ 293,784.05
$ 233,784.05
$ 194, 105.56
$ 194,875.00
$
$ 198,500.00 $2,500.00
Order Cost
(D/Q* Ordering
Cost)
$6,892.02
$6,892.02
$5,555.56
$4,000.00
195,583.33 $3,333.33
Carry Cost
$6,892
Carry Cost
(Q/2* Carrying Cost)
$6,892.02
$6,892.02
$8,550.00
$11,875.00
$14,250.00
$19,000.00
Purchase Cost
(D* Price)
$280,000.00
$220,000.00
$180,000.00
$179,000.00
$178,000.00
$177,000.00
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.