Question: My answers are not adding up and do question D that is on the excel .. I do not comprehend what it's asking me I

My answers are not adding up and do question D that is on the excel .. I do not comprehend what it's asking me I think it's my dyslexia
I'm not really good at exceland how to punch in things either My answers are not adding up and do question D
My answers are not adding up and do question D
Problems .6 .6-20 Lila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila, who works in her brother's hardware store, is in charge of purchasing. She estimates that it costs $10 ev. ery time an order is placed. This cost includes her wages, the cost of the forms used in placing the or- der, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is one-half of 1 cent. Assume that the demand is con- stant throughout the year. (a) How many number 6 screws should Lila order at a time if she wishes to minimize total inventory cost? (b) How many orders per year would be placed? What would the annual ordering cost be? (c) What would the average inventory be? What would the annual holding cost be? 6-21 It takes am 6- Arld Paste BI UB a. Av E Merge & C A30 fx D C E F G H 1 Use this worksheet in order to solve problem 6-20 from your book. After you calculate al numbers, provide clear answers to al questions. In addition to questions from the book answer the following question: d) What is the total cost when Lila Battle orders optimal quantity? 8 9 10 11 Data 12 Demand rate. D 13 Ordering/Setup cost. Co 14 Holding cost. Ch 15 16 Results 17 Optimal Order Quantity, Q' 18 Average Inventory 19 Number of Orders 20 21 Holding costs 22 Ordering costs 23 Total cost T 24 25 26 27 28 29 30 31 33 34 35 36 37 38 0 1 2 13 34 15 36 17 18 PART 1 PART 2 PART 3 PART 4 +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!