An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local Annual demand is
An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. The following spreadsheet has been set up to solve the problem. What formula goes in cell B11 in this problem? 1 3 Annual Demand: 20,000 4 $25 Cost per Unit Ordering Cost Carrying Cost $30 25% 8. Order Quantity 483.73 10 11 Total Cost $502,738.61 =B3'B7+B9/B3'B6+B9'2+B5'B7 -B3'B5+B3/B9 B6+B9/2'B5*B7 O -SQRT(B3'B5+B3/B9 B6+B9/2 B5'B7) -B3'B3+B3/B9+B6*B9/2'B5*B7
Step by Step Solution
3.45 Rating (171 Votes )
There are 3 Steps involved in it
Step: 1
The ideal requesting amount when theres no ...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