The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products...

90.2K

Verified Solution

Question

Accounting

The office manager for the Gotham Life Insurance Company ordersletterhead stationery from an office products firm in boxes of 500sheets. The company uses 6,500 boxes per year. Annual carryingcosts are $3 per box, and ordering costs are $28. The followingdiscount price schedule is provided by the office supply company:Order Quantity (in boxes) Price per Box 200-999 $16 1000-2999 143000-5999 13 6000+ 12 a. Determine the optimal order quantity andthe total annual inventory cost. b. Determine the optimal orderquantity and total annual inventory cost for boxes of stationery ifthe carrying cost is 20% of the price of a box of stationery.

Please put answers in the excel format.

ORDERINGORDERINGORDERINGORDERING
EOQ        1,000        3,000     6,000
                 =
Average inventory =  
Annual carrying cost =
Number of orders =  
Annual order cost =  
Total inventory purchase cost
Total inventory cost =

Answer & Explanation Solved by verified expert
4.5 Ratings (728 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students