I have included the master page and the previous questions as information. I've been stuck on Questions 15&16 for two days. I will keep messing with formulas. TC= DC+(Q/2)H+(D/Q)S. Kindly show all steps, as I want to learn and see where I was making mistakes.

Thank you!

Economic Order Quantity Exercise (30 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, video cameras, 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, 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 $175.00 Q9900 Retail Price $ 299.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) $ 250.00 Delivery (Fuel, Driver, Truck, etc.) $ 125.00 Packaging $ 25.00 Receiving (Inspection, Documentation, etc.) $ 25.00 Labor ( 5 hours @ $10.00/hr) Stocking, Misc. $ 50.00 What is the annual demand for one store? Find D: (Choose the closest answer) 4800 8200 6500 O 9500 k. 10300 L 10700 O 3900 8600 7800 4300 7100 5800 Question 2 1 pts What is the per unit annual holding for one store? Find h: (Choose the closest answer) O 333.50 O 113.75 61.25 145.35 O 150.00 24.5 O 399.00 What is the per unit cost for each item? Cost is the amount the company pays their supplier per unit. Find C (Choose the closest answer) O 221.75 375.25 O 145.35 113.75 O 275 V O 333.50 175 O 399.00 O 245 O 325.00 O 75.65 O 150.00 1 pts Question 4 What is the cost to place one order? In other words, every time the company places an order, which costs are incurred? Find S (Choose the dosest answer) 750 475 500 What is the weekly demand? Find D/52: (Choose the closest answer) 075 O 50- O 200 150 O 125 O 275 O 135 O 45 O 225 O 100 cho O 25 O 325 Question 6 How many orders per year are being placed annually? (Q = 900) Do Not Round. (Choose the closest answer) 3.25 O 6.67 0 4.25 O 3.75 O 8.10 8.67 O 5.33 0 7.50 O 1.67 0 2.41 to O 6.15 O 5.00 What is the annual cost to purchase the items? (Q = 900) (Choose the closest answer) O $2,100,000 $4,745,000 $1,365,000 O $4,475,000 O $3,675,000 O $3,352,000 O $2,045,000 ho O $4,200,000 O $2,535,000 O $1,565,000 O $3,005,000 O $3,885,000 What is the annual ordering cost, AOC? (Q = 900) (Choose the closest answer) $6,987 $32,251 $43,127 $11,568 O $10,258 $4,111 O $39.765 O $3,293 mo O $14,564 O $8,233 O $4,589 O $27,678 What is the annual holding cost, AHC? (Q = 900) (Choose the closest answer) O $10,258 O $33.075 O $11,568 O $6.987 O $43,127 O $8,233 O $4,589 $39.765 O $14,564 O $48,136 $27,562 O $51,187 What is the total annual cost of inventory, TC? (Q = 900) (Choose the closest answer) $2.715,000 O $2,106,000 $1,058,000 O $1,620,050 $2,527 200 $1,946,000 $1,635,800 O $1,594,000 O $1,402,050 O $2,085,400 $1,396,700 What is the EOQ? (Choose the closest answer) 274 0417 0 375 O 240 O 332 O 324 348 405 O 313 O 396 361 O 430 Using the calculated EOQ, how often will orders be placed? All answers are in weeks. (Choose the closest answer) O 3.75 O 6.67 0 7.50 0 4.25 O 3.25 O 1.67 O 5.33 ho O 8.10 2.32 O 5.00 O 2.41 O 8.67 Using the calculated'EOQ, what is the annual holding cost (AHC)? (Choose the closest answer) O $17.678 O $31,555 $19,215 O $26,258 O $20,529 $10,657 O $18,551 O $9,350 m O $17,350 O $13,176 O $14,654 O $12,350 Using the calculated EOQ, what is the annual ordering cost (AOC)? (Choose the closest answer) O $16,258 O $15,526 O $9,350 O $14,654 O $11,124 O $12,789 O $27,678 $19,215 O $12,340 O $17,350 O $18,551 $10.646 1 pts Question 15 What is the total annual cost of inventory, TC? (Q = EOQ) (Choose the closest answer) O $2,695,900 O $1.297,050 O $1,915,000 O $1,429,0500 O $1,503,000 O $1.688,200 O $1,386,300 O $2,045,800 V $1,603,000 O $2,115,200 O $2.576.400 1 pts Question 16 If they could order the EOQ instead of 900, how much would this one store stand to save annually? O $27.216 $18.362 O $11,351 O $10 375 $ Question 16 1 pts If they could order the EOQ instead of 900, how much would this one store stand to save annually? O $27 216 O $18,362 O $11,351 O $10,375 O $14.788 O $24.257 O $21,400 O $15,655 O $11,125 O $22,175 O $7,552 O $6,351 TC = DC + (Q/2) H+ (D/Q) S DC = Annual cost to purchase inventory - Buy It (Q/2) H = Annual holding cost (AHC) - Hold It (Average inventory) * Annual per unit holding cost (D/Q) S = Annual ordering cost (AOC) Order It (Orders placed per year) * Cost to place each order