please show the formulas for everything and excel coordinates thank you

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