Question

Clap Off Manufacturing uses 2,400 switch assemblies per week and then reorders another 2,400. Assume the relevant carrying cost per switch assembly is $6.10 and the fixed order cost is $565. a. Calculate the carrying costs. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) b. Calculate the restocking costs. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) c. Calculate the economic order quantity. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d. Calculate the EOQ number of orders per year. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Carrying costs Restocking costs Economic order quantity d. Number of orders

Answer 1

FCDDF000 (Autosaved) (Autosaved) (Autosaved) - Microsoft Excel - 0 X View D General - *- Wrap Text 1 Merge & Center - } Autosum Fill A7 D ZI Cell Styles Insert Delete Format Conditional Format Formatting as Table Styles Con = Home Insert Page Layout Formulas Data Review * Cut Comic Sans MS - 11 - A A = = = La Copy Paste Format Painter BI U 2 A Clipboard Font A14 A B C 1 (a) Carrying Costs $ 2 2400 / 2 * $6.10 Clear Sort & Find & Filter Select Editing Alignment Number Cells D E F I J K D 7,320.00 3 $ 29,380.00 4. (b) Restocking Costs : 5 $565*52 6 7 (c) Economic order Quantity 8 [(2T*F)/CC]^1/2 9 [C2(52)(2400)(565))/6.10]*1/2 | 10 11 (d) Number of orders 12 (52*2400)/480.82 13 14 480.82 Units 259.56 Orders K Sheet164 Sheet165 Sheet166 Sheet167 Sheet170 Sheet171 Sheet172 Sheet173 Sheet259 Sheeti ™ Ready Average: 12319.8522 Count: 14 + Sum: 36959.55659 B OU 150% A ^ ¢ a dy INC ¢* ENG - o Be - 0 10:06 01-03-2020 Type here to search 9