Paste 11 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 V X Font A Alignment Number Month January February March April May June July August September October November December Order Cost: $ B Coll Styles Demand 1,280 $ 1,294 $ 1,238 $ 761 $ 1,285 $ 1,282 $ 757 $ 670 $ 1,238 $ 1,286 $ 1,312 $ 762 $ 32.50 Cells C Editing Holding Costs 138.79 140.31 134.24 82.51 139.30 138.94 82.08 72.68 134.24 139.37 142.19 82.65 Analyze Data D Paste 45 BIUab x, B Styles Styles Pane Dictate 1. Alvin's Sportfishing Accessories is establishing an ordering policy for the organization's regional hub, which supplies the regional retail stores with various sportfishing accessories. Alvin's partner, Theodore, has collected the previous year's monthly demand and monthly holding costs from the organization's lead accountant, Simon. Using the previous year's data, which is on the EOQ worksheet, answer the proceeding questions. For full credit, all calculations must be executed via MS Excel formulas/functions. a. What is the economic order quantity, Qo, for the upcoming year assuming demand and holding costs will increase 3%? b. What is the total, ordering and holding, cost of the upcoming year's inventory? 2. Han's Hellcats Limited specializes in producing and installing high-performance engine components specifically for the Dodge Hellcat. The fabrication shop produces intake systems for the engines and is in need of developing an economic production plan. Using the previous year's data, which is on the EPQ worksheet, answer the proceeding questions. For full credit, all calculations must be executed via MS Excel formulas/functions. What is the economic production antity, Qp, for the upcoming year assuming the holding cost will increase by 7.5%? b. What is the total, carrying and setup, cost of production for the upcoming year? 3. ULL's Cajun Cadaver Lab is in need of developing an ordering policy for the acquisition of surgical gloves, which is sold in cases. Using the previous year's data, which is on the Discount worksheet, answer the proceeding questions. For full credit, all calculations must be executed via MS Excel formulas/functions. Notably, it is acceptable to purchase quantities greater than the upcoming year's demand, 55 cases, due to the fact that there is no concern regarding obsolescence, deterioration, storage, or funding. In essence, it is acceptable to purchase some gloves that will ultimately be used in the following year. Holding cost per unit per year is 15% of purchase price. The vendor is offering a 2% discount for orders between 60-89 units and a 5% discount for orders of 90 or more units. a. Is it advisable to take advantage of the quantity discount offered by Cajun Critical Care's supplier, Moody's Medical Supplies? How many cases will be purchased per order? b. What is the total, ordering and holding, cost of the inventory? Editor

wall incteair 3W? b. What is the sotal, orderine and holdine. cost of the upcoming vears hoventary? tocriformulationios. incirase by 7 ss