Answered step by step
Verified Expert Solution
Question
1 Approved Answer
import math # Given data unit _ cost = 3 5 0 # Cost per chip holding _ cost _ fixed = 3 5 #
import math
# Given data
unitcost # Cost per chip
holdingcostfixed # Fixed holding cost per unit per year
holdingcostpercentage # holding cost
orderingcost # Ordering cost per order
annualdemand # Annual demand per month
# Price structure
prices
:
:
or more':
# Calculate EOQ and total annual cost for each price tier
totalcostsfixed
for tier, price in prices.items:
if tier :
EOQfixed math.sqrt annualdemand orderingcost holdingcostfixed
elif tier :
EOQfixed math.sqrt annualdemand orderingcostholdingcostfixed price prices
else:
EOQfixed math.sqrt annualdemand orderingcostholdingcostfixed price prices
totalcostfixed annualdemand EOQfixed orderingcost EOQfixed holdingcostfixed annualdemand price
totalcostsfixedtier totalcostfixed
# Find the minimum total annual cost for fixed holding cost
mincosttierfixed mintotalcostsfixed, keytotalcostsfixed.get
optimalorderquantityfixed roundEOQfixed
minimumannualcostfixed roundtotalcostsfixedmincosttierfixed
# Calculate holding cost as percentage of unit cost
holdingcostpercentageperunit unitcost holdingcostpercentage
# Calculate EOQ and total annual cost with percentage holding cost
EOQpercentage math.sqrt annualdemand orderingcost holdingcostpercentageperunit
totalcostpercentage annualdemand EOQpercentage orderingcost EOQpercentage holdingcostpercentageperunit annualdemand unitcost
optimalorderquantitypercentage roundEOQpercentage
minimumannualcostpercentage roundtotalcostpercentage
# Print results for Part a
printPart a:
printThe optimal order quantity after the change in pricing structure is: optimalorderquantityfixed, "units"
printThe total annual cost for Bell Computers to order, purchase, and hold the integrated chips is: $ minimumannualcostfixed
# Print results for Part b
print
Part b:
printThe optimal order quantity after the change in the holding cost calculation is: optimalorderquantitypercentage, "units"
printThe total annual cost for Bell Computers to order, purchase, and hold the integrated chips is: $ minimumannualcostpercentage
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started