* Note: Please show me step by step on how to do this. The Solver program is used to get the answers in this. I will also insert the answers

NUTRITIOUS AND DELICIOUS CO. Nutritious & Delicious Co. (N&D) is the distributor of a very popular blend of cat food that sells for $4.00 per can. N&D experiences demand of 60 cans per week. They order the cans of cat food from the CatFood Company. CatFood sells cans to N&D at $1.50 per can and charges a flat fee of $50 per order for shipping and handling. N&D uses the EOQ (economic order quantity) as their fixed order size in each replenishment. Assume that the opportunity cost of capital and all other inventory cost is 30 percent annually and that there are 50 weeks in a year. a. How many cans of cat food should N&D order at a time? b. What is N&D's total fixed order cost (i.e. set-up order cost) for one year? c. What is N&D's total inventory holding cost for one year? d. What is N&D's weekly inventory turns? e. What is N&D's weekly flow-time? f. Compute Annual Profit: Show the Annual Product Cost as well as the Annual Revenue in a year. Since N&D has to meet the Annual Demand without having customers wait or having any shortages, Annual Revenue is fixed and does not depend on Q. Therefore, Annual Revenue for N&D is r*D which is, ($4/can)*(3000 cans/year) assuming 50 weeks in a year. NutriciousDelicious_FullSolution - Excel studioadmin File Insert Draw Page Layout Formulas Data Review Help Tell me what you want to do Share h Select Draw with Eraser Lasso Touch Select Tools Pen Inkto Ink to Shape Math Convert Pens B13 f 816.496582064734 D E F M N O PO R S T Nutricious and Delicious (N&D) 2 Cat Food - Supplier 3 Inputs 4 FIXED Setup/ORDERING cost (S) 5 Annual interest rate() 6 Unit material/PRODUCT cost (c) 7 Selling price per unit() 8 Annual demand (D) V 9 Unit Inventory Holding cost (h) 10 11 Analysis using the Solver 12 Order information 13 Order quantity, Q 14 Time between orders (cycle time). T 15 Orders per year, 1/T - i.e. "n" $50 30% $1.50 $4.00 30001 $0.45 Decision Vanable 50 weeks tingtion "hi'zixc 50*015 0.27 816 a. CLI should order 816 cans at a tine. 13.61 About 14 weeks between each replenishment. 3.67 -4 orders About 4 orders in a year. d. CLI's weekly inventory turns (based on a 50 week year) 7.35 About 7 to 8 inventory turns in a year. e. Cli's weekly flow-time (based on a 50 week year) That is, a single catfood can stays on the shelf for about 7 weeks before being sold. b. CLI's total annual fixed ordering cost c. CLI's total annual inventory holding cost 16 Weekly Inventory Turnover 17 Weekly Flow Time 18 19 Costs affected by order quantity 0.15 6.80 20 Annual setup cost, S'n $183.71 $183.71 338742 21 Annual holding cost,h*(Q/2) 22 Total affected cost 23 24 Costs/revenues unaffected by order quantity 25 Annual product/material cost. C D 26 Annual revenue . r*D 27 28 Total annual profit 29 30 $4,500.00 $12.000.00 > BALANCED!] $7.132.58 f. N&D's total annual profit N&D Ready +110% e 9 6:08 PM 1/24/2021