Answered step by step
Verified Expert Solution
Link Copied!

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
unit_cost =350 # Cost per chip
holding_cost_fixed =35 # Fixed holding cost per unit per year
holding_cost_percentage =0.1 # 10% holding cost
ordering_cost =122 # Ordering cost per order
annual_demand =395*12 # Annual demand (395 per month)
# Price structure
prices ={
'1-99': 350,
'100-199': 325,
'200 or more': 300
}
# Calculate EOQ and total annual cost for each price tier
total_costs_fixed ={}
for tier, price in prices.items():
if tier =='1-99':
EOQ_fixed = math.sqrt((2* annual_demand * ordering_cost)/ holding_cost_fixed)
elif tier =='100-199':
EOQ_fixed = math.sqrt((2* annual_demand * ordering_cost)/(holding_cost_fixed *(price / prices['1-99'])))
else:
EOQ_fixed = math.sqrt((2* annual_demand * ordering_cost)/(holding_cost_fixed *(price / prices['1-99'])))
total_cost_fixed =(annual_demand / EOQ_fixed)* ordering_cost +(EOQ_fixed /2)* holding_cost_fixed + annual_demand * price
total_costs_fixed[tier]= total_cost_fixed
# Find the minimum total annual cost for fixed holding cost
min_cost_tier_fixed = min(total_costs_fixed, key=total_costs_fixed.get)
optimal_order_quantity_fixed = round(EOQ_fixed)
minimum_annual_cost_fixed = round(total_costs_fixed[min_cost_tier_fixed])
# Calculate holding cost as percentage of unit cost
holding_cost_percentage_per_unit = unit_cost * holding_cost_percentage
# Calculate EOQ and total annual cost with percentage holding cost
EOQ_percentage = math.sqrt((2* annual_demand * ordering_cost)/ holding_cost_percentage_per_unit)
total_cost_percentage =(annual_demand / EOQ_percentage)* ordering_cost +(EOQ_percentage /2)* holding_cost_percentage_per_unit + annual_demand * unit_cost
optimal_order_quantity_percentage = round(EOQ_percentage)
minimum_annual_cost_percentage = round(total_cost_percentage)
# Print results for Part 2a
print("Part 2a:")
print("The optimal order quantity after the change in pricing structure is:", optimal_order_quantity_fixed, "units")
print("The total annual cost for Bell Computers to order, purchase, and hold the integrated chips is: $", minimum_annual_cost_fixed)
# Print results for Part 2b
print("
Part 2b:")
print("The optimal order quantity after the change in the holding cost calculation is:", optimal_order_quantity_percentage, "units")
print("The total annual cost for Bell Computers to order, purchase, and hold the integrated chips is: $", minimum_annual_cost_percentage)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business and Administrative Communication

Authors: Kitty o. locker, Donna s. kienzler

10th edition

77830105, 978-0077830106, 978-0073403182

More Books

Students also viewed these General Management questions