Hi! I need help with answer 8, 11-15, 17 and 18 , 20-23. Can you please explain how you got the answers. The last tutor gave me all wrong answers.

Thank you

ONLINE Exercise #1 Economic Order Quantity Exercise (25 Points) SCM 300 Buckshot Electronics is a chain of electronics superstores that is located throughout California. They have 15 locations concentrated primarily in heavily populated areas. They sell thousands of products made by hundreds of different manufacturers. Buckshot sells everything from phones, cameras, DVD players, and video game consoles to large items like televisions. Sony is one of their larger suppliers. They offer products in nearly every category Buckshot offers to its customers. In fact, Sony sells multiple cell phone models through Buckshot. One such model is the Q9900. One of Buckshot's San Francisco stores is forecasted to sell about 7800 units of the Q9900 in the coming year. This forecasted demand is about average in terms of Buckshot's 15 other California locations. Presently they order 900 units of the Q9900 every 6 weeks. Each store fills weekly orders through its Sony Distributor for items like TV's, DVD Players, cameras, and of course, cell phones, in addition to many other items. Orders for cell phones must be made in increments of 100 units. The distributor takes only one order per week, but Buckshot is not obligated to order every item every week. That order is then shipped 2 days later to that individual Buckshot Electronics location by truck. Buckshot's Central Procurement is looking to save money by investigating order sizes and subsequent order frequency. You are being asked to create a recommendation for order size and time between orders for the Q9900 based on the numbers for this San Francisco location. Answer the questions that follow in order to create a detailed report for your supervisor. Below are some the key figures important in your analysis: Q9900 Wholesale Price $ 325.00 Q9900 Retail Price $ 399.00 Annual Per Unit Holding Costs are estimated at 35% of the wholesale cost of the Q9900. Costs associated with each order include: Order Placement Fees (Documentation, Network Support) Delivery (Fuel, Driver, Truck, etc.) Packaging Receiving (Inspection, Documentation, etc.) Labor ( 5 hours @ $10.00/hr) Stocking, Misc. $ 250.00 $ 350.00 $ 150.00 $ 150.00 $ 50.00 ONLINE Exercise #1 Questions are worth either 0.5 points or 1 point. All questions will be answered in multiple choice format via BlackBoard THE GIVENS 1. What is the annual demand for one store? Find D: (Choose the closest answer) 2. What is the per unit annual holding for one store? Find h: (Choose the closest answer) 3. What is the per unit cost for each item? Find C: (Choose the closest answer) 4. What is the cost to place one order? Find S: (Choose the closest answer) 5. What is the weekly demand? Find D/52: (Choose the closest answer) Using Present Lot Size (Q = 900) 6. How many orders per year are being placed annually? (Q = 900) Do Not Round. (Choose the closest answer) According to the information supplied, what is the present annual inventory cost? (In other words, using their present lot size what is the annual inventory cost?) Also, separately identify, the annual cost of purchasing the inventory, the annual holding cost (AHC) and annual ordering cost (AOC). 7. What is the annual cost to purchase the items? (Q = 900) (Choose the closest answer) 8. What is the annual ordering cost, AOC? (Q = 900) (Choose the closest answer) 9. What is the annual holding cost, AHC? (Q = 900) (Choose the closest answer) 10. What is the total annual cost of inventory, TC? (Q = 900) (Choose the closest answer) Using the Economic Order Quantity (Q=EOQ) 11. What is the EOQ? (Choose the closest answer) 12. Using the calculated EOQ, how often will orders be placed? All answers are in weeks. (Choose the closest answer) According to the information supplied, what would be the annual inventory cost if they used the calculated EOQ? Also, separately identify the annual holding cost (AHC) and annual ordering cost (AOC). 13. Using the calculated EOQ, what is the annual holding cost (AHC)? (Choose the closest answer) 14. Using the calculated EOQ, what is the annual ordering cost (AOC)? (Choose the closest answer) 15. What is the total annual cost of inventory, TC? (Q = EOQ) (Choose the closest answer) 16. If they could order the EOQ instead of 900, how much would this one store stand to save annually? 17. Why is this not possible for this company to use the calculated EOQ as their order size? ONLINE Exercise #1 PROPER ORDER SIZE The store must decide how often they want to order. Remember, the weekly demand is 150 units. If they order weekly, the store will require at minimum 200 units per week. If they order every other week, the store will require at minimum 300 units to get to the next ordering period. 18. If they order every 3 weeks, what will be the minimum required order size to fulfill three weeks of demand? Remember, you must abide by the Sony Distributor's ordering rules. 19. Assume they sell exactly 150 units each week during the three-week period. Based on the appropriate answer to the previous question, how many extra units will they have left at the end of each three week period? 20. Based on the ordering scenario where orders are placed every 3 weeks, over a 52 week year, how much extra inventory will this store have accumulated? (Take your answer to #19, divide by 3, and then multiply by 52) 21. If they instead order every 2 weeks what will be the minimum required order size to fulfill two weeks of demand? Remember, you must abide by the Sony Distributor's ordering rules. 22. Assume they sell exactly 150 units per week. Based on the appropriate weekly order size, how many extra units will they have left at the end of the 2-week period? 23. Based on the weekly ordering scenario, over a 52 week year, how much extra inventory will this store have accumulated? (Take your answer to #22, divide by 2, and then multiply by 52) 24. Realistically, which of the following options is most attractive? An attractive option is one where the order size is close or equal to the EOQ, abides by the distributor's ordering rules, and minimizes the amount of unnecessary inventory. (We will call this Q*) According to the appropriate recommendation you provided in #24, what would be the Total Annual Inventory cost? Also, separately identify, the annual holding cost (AHC) and annual ordering cost (AOC). 25. Using the Q*, what is the annual holding cost (AHC)? (Choose the closest answer) 26. Using the Q*, what is the annual ordering cost (AOC)? (Choose the closest answer) 27. What is the total annual cost of inventory, TC? (Q = Q*) (Choose the closest answer) 28. The total annual savings for this one store using our recommendation (Q*) versus the present lot size of 900, would be: TOTAL SAVINGS ALL STORES 29. Without store-by-store information it is difficult to say how much this would save the corporation. Nonetheless, using only the numbers for this store it can be said that if the numbers for the other 14 stores are similar there is a potential to save a total of about...Remember, there are 15 stores, total! Questions are worth either 0.5 points or 1 point. All questions will be answered in multiple choice format via BlackBoard QUESTION 1 1. What is the annual demand for one store? Find D: (Choose the closest answer) 3900 4300 4800 5800 6500 7100 7800 8200 8600 9500 k.103 00 l. 10700 0.5 points QUESTION 2 1. What is the per unit annual holding for one store? Find h: (Choose the closest answer) 75.6 5 145. 35 150. 00 113. 75 221. 75 250. 00 325. 00 333. 50 375. 25 399. 00 415. 75 453. 55 0.5 points QUESTION 3 1. What is the per unit cost for each item? Find C: (Choose the closest answer) 75.6 5 113. 75 145. 35 150. 00 221. 75 250. 00 325. 00 333. 50 375. 25 399. 00 415. 75 453. 55 0.5 points QUESTION 4 1. What is the cost to place one order? Find S: (Choose the closest answer) 50 150 250 300 350 450 500 650 750 900 950 105 0 0.5 points QUESTION 5 1. What is the weekly demand? Find D/52: (Choose the closest answer) 25 45 50 75 10 0 12 5 13 5 15 0 20 0 22 5 27 5 32 5 0.5 points QUESTION 6 1. How many orders per year are being placed annually? (Q = 900) Do Not Round. (Choose the closest answer) 8.6 7 6.6 7 5.3 3 2.4 1 7.5 0 8.1 0 1.6 7 5.0 0 4.2 5 3.2 5 6.1 5 3.7 5 0.5 points QUESTION 7 1. What is the annual cost to purchase the items? (Q = 900) (Choose the closest answer) $1,565,0 00 $2,045,0 00 $2,100,0 00 $2,535,0 00 $3,005,0 00 $3,352,0 00 $3,675,0 00 $3,885,0 00 $4,200,0 00 $4,475,0 00 $4,585,0 00 $4,745,0 00 0.5 points QUESTION 8 1. What is the annual ordering cost, AOC? (Q = 900) (Choose the closest answer) $4,58 9 $6,98 7 $8,23 3 $10,2 58 $11,5 68 $14,5 64 $27,6 78 $32,2 51 $39,7 65 $43,1 27 $48,1 36 $51,1 87 1 points QUESTION 9 1. What is the annual holding cost, AHC? (Q = 900) (Choose the closest answer) $4,58 9 $6,98 7 $8,23 3 $10,2 58 $11,5 68 $14,5 64 $27,6 78 $32,2 51 $39,7 65 $43,1 27 $48,1 36 $51,1 87 1 points QUESTION 10 1. What is the total annual cost of inventory, TC? (Q = 900) (Choose the closest answer) $1,620,0 00 $2,085,0 00 $2,106,0 00 $2,594,0 00 $3,058,0 00 $3,402,0 00 $3,715,0 00 $3,946,0 00 $4,315,0 00 $4,527,0 00 $4,635,0 00 $4,786,0 00 1 points QUESTION 11 1. What is the EOQ? (Choose the closest answer) 24 0 27 4 31 3 33 9 35 2 36 1 37 5 39 6 40 5 41 7 43 0 44 4 1 points QUESTION 12 1. Using the calculated EOQ, how often will orders be placed? All answers are in weeks. (Choose the closest answer) 8.6 7 6.6 7 5.3 3 2.4 1 7.5 0 8.1 0 1.6 7 5.0 0 4.2 5 3.2 5 6.1 5 3.7 5 1 points QUESTION 13 1. Using the calculated EOQ, what is the annual holding cost (AHC)? (Choose the closest answer) $17,3 50 $18,5 51 $20,5 29 $26,2 58 $31,5 55 $34,1 24 $27,6 78 $19,2 15 $14,6 54 $12,7 89 $9,35 0 $23,1 76 1 points QUESTION 14 1. Using the calculated EOQ, what is the annual ordering cost (AOC)? (Choose the closest answer) $17,3 50 $18,5 51 $14,6 54 $12,7 89 $9,35 0 $23,1 76 $26,2 58 $31,5 55 $34,1 24 $27,6 78 $19,2 15 $20,5 29 1 points QUESTION 15 1. What is the total annual cost of inventory, TC? (Q = EOQ) (Choose the closest answer) $1,603,0 00 $3,388,0 00 $3,695,0 00 $3,915,0 00 $4,297,0 00 $4,503,0 00 $2,045,0 00 $2,115,0 00 $2,576,0 00 $3,027,0 00 $4,628,0 00 $4,781,0 00 1 points QUESTION 16 1. If they could order the EOQ instead of 900, how much would this one store stand to save annually? $16,3 51 $17,5 52 $15,6 55 $14,7 88 $11,3 51 $22,1 75 $24,2 57 $28,5 56 $31,1 25 $29,6 79 $27,2 16 $18,3 62 1 points QUESTION 17 1. Why is this not possible for this company to use the calculated EOQ as their order size? They do not have enough room in their store to use the EOQ as their order size. They do not have enough money to afford order sizes as large as the calculated EOQ. Orders can only be placed in increments of 100. Orders can only be placed in increments of 50. Orders can only be placed in increments of 150. The calculated EOQ is smaller than their weekly demand. Ordering the calculated EOQ would actually cost them more than using their present order size, 900 units. 1 points QUESTION 18 1. If they order every 3 weeks, what will be the minimum required order size to fulfill three weeks of demand? Remember, you must abide by the Sony Distributor's ordering rules. 12 5 15 0 20 0 25 0 30 0 35 0 40 0 42 5 45 0 47 5 50 0 55 0 1 points QUESTION 19 1. Assume they sell exactly 150 units every three week period. Based on the appropriate answer to the previous question, how many extra units will they have left at the end of each three week period? 0 25 50 75 10 0 12 5 15 0 17 5 20 0 22 5 25 0 27 5 1 points QUESTION 20 1. Based on the ordering scenario where orders are placed every 3 weeks, over a 52 week year, how much extra inventory will this store have accumulated? (Take your answer to #19, divide by 3, and then multiply by 52) 0 438 867 131 4 175 2 205 2 260 0 303 3 346 7 390 0 433 3 476 7 1 points QUESTION 21 1. If they instead order every 2 weeks what will be the minimum required order size to fulfill two weeks of demand? Remember, you must abide by the Sony Distributor's ordering rules. 12 5 15 0 20 0 25 0 30 0 35 0 40 0 42 5 45 0 47 5 50 0 55 0 1 points QUESTION 22 1. Assume they sell exactly 150 units per week. Based on the appropriate weekly order size, how many extra units will they have left at the end of the 2 week period? 0 25 50 75 10 0 12 5 15 0 17 5 20 0 22 5 25 0 27 5 1 points QUESTION 23 1. Based on the weekly ordering scenario, over a 52 week year, how much extra inventory will this store have accumulated? (Take your answer to #22, divide by 2, and then multiply by 52) 0 438 867 131 4 175 2 205 2 260 0 303 3 346 7 390 0 433 3 476 7 1 points QUESTION 24 1. Realistically, which of the following options is most attractive? An attractive option is one where the order size is close or equal to the EOQ, abides by the distributor's ordering rules, and minimizes the amount of unnecessary inventory. (We will call this Q*) Order 200 units every week Order 300 units every 2 weeks Order 300 units every 2.25 weeks Order 361 units every 2.41 weeks Order 400 units every 2.67 weeks Order 450 units every 3 weeks Order 500 units every 3 weeks Order 500 units every 3.33 weeks 1 points QUESTION 25 1. Using the Q*, what is the annual holding cost (AHC)? (Choose the closest answer) $15,3 00 $16,5 50 $22,5 20 $24,2 54 $17,0 62 $32,1 25 $21,2 05 $15,6 44 $24,7 00 $14,7 79 $12,3 60 $22,2 76 1 points QUESTION 26 1. Using the Q*, what is the annual ordering cost (AOC)? (Choose the closest answer) $15,3 00 $16,5 50 $22,5 20 $24,2 54 $17,0 62 $32,1 25 $21,2 05 $15,6 44 $24,7 00 $14,7 79 $12,3 60 $22,2 76 1 points QUESTION 27 1. What is the total annual cost of inventory, TC? (Q = Q*) (Choose the closest answer) $1,603,7 62 $3,388,7 62 $3,695,7 62 $3,915,3 51 $4,297,3 51 $4,503,3 51 $2,045,3 51 $2,115,3 51 $2,576,7 62 $3,027,7 62 $4,628,7 62 $4,781,7 62 1 points QUESTION 28 1. The total annual savings for this store using our recommendation (Q*) versus the present lot size of 900, would be: $18,3 51 $15,4 55 $15,9 08 $12,3 00 $17,6 58 $20,1 75 $22,1 50 $25,5 56 $31,1 25 $22,1 26 $18,1 22 $25,6 79 1 points QUESTION 29 1. Without store-by-store information it is difficult to say how much this would save the corporation. Nonetheless, using only the numbers for this store it can be said that if the numbers for the other 14 stores are similar there is a potential to save a total of about...Remember, there are 15 stores, total! $275,2 65 $231,8 25 $238,6 20 $184,5 00 $264,8 70 $302,6 25 $332,2 50 $383,3 40 $466,8 75 $331,8 90 $271,8 30 $385,1 85 0.5 points Click Save and Submit to save and submit. Click Save All Answers to save all answers