please show the formulas for everything and excel coordinates thank you C...

90.2K

Verified Solution

Question

Finance

please show the formulas for everything and excel coordinates thank you image
C D F G H 3 K M N 0 P Q R CALCULATE AND 700 20 1,020 150 10 80 AO 2.000 400 5,000 140 10 20 5 2010 ADD Determine the percentage of items in each category and the annual dollar value for each ca. yory for part A bilery buys flour in 25 pound bags. The bakery uses 1.215 bags a year. Ordering cost is sto per ander, Annual carrying cost is $75 per bag Determine the economic order quantity What is the average number of bags on hand? c. How many orders per year will there he 1. Compute the total cost of ordering and carrying flour . I holding costs were to increase by S9 per year, how much would that affect the minimum total annual cost? A large law firm uses an average of 40 boxes of copier paper a day. The firm operates 260 days a 0 to order and receive a shipment of paper. C par Storage and handling costs for the paper are $30 a year per box, and it costs approximately D

Answer & Explanation Solved by verified expert
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