Parameters Component ID Inventory On-Hand (H) Order Up to Point (M) Cost per unit 570 5 100 $4.50 578 741 30 70 55 70 $12.50 $3.26 755 17 45 $4.15 Fixed Cost per Order $120 Minimum Order Size for Discount Discounted to 50 Any orders of this size or more will get a discount 90% Model Component ID Order Quantity (0) Cost of Goods 570 ? ? 578 ? ? 741 ? ? 755 ? ? Total Number of Orders ? Using countif Total Fixed Costs Total Cost of Goods Total Cost ? ? ? Parameters Component ID Inventory On-Hand (H) Order Up to Point (M) Cost per unit 570 5 100 $4.50 578 741 30 70 55 70 $12.50 $3.26 755 17 45 $4.15 Fixed Cost per Order $120 Minimum Order Size for Discount Discounted to 50 Any orders of this size or more will get a discount 90% Model Component ID Order Quantity (0) Cost of Goods 570 ? ? 578 ? ? 741 ? ? 755 ? ? Total Number of Orders ? Using countif Total Fixed Costs Total Cost of Goods Total Cost