USE EXCEL SOLVER TO ANSWER QUESTION.

188Q1 - Exce S B Draw Page Layout [ Recent Sources [ Existing Connections Formulas Data Review View Help AutoSave of H File Home Insert A La From Text/CSV Lo Lo From Web From Table/Range Data - Acrobat Queries & Connections I Stocks Search 2 | Sort m Geography T Filte Get Properties Refresh All Edit Links Get & Transform Data Queries & Connections Data Types Sort & N15 - X fx A B C D E F G H I J K L 4 You run a popular coffee shop and have bags of coffee beans in stock. 5 You exercise a continuous review inventory replenishment policy and every time when you run out of coffee beans, 6 you go to a local wholesale vender to purchase the coffee beans. 7 8 The purchasing cost of coffee beans is 220 per bag. 9 10 11 12 Every time you purchase the coffee beans, 13 there is a fixed $100 transportation cost, plus a $10 per bag processing fee the vender charges you. 14 15 You face a very stable daily demand and your estimated annual demand is 6709 bags of coffee beans. 16 17 18 19 You keep your money in an interest generating account and the annual interest rate is 4.5% 20 21 Use Excel solver to solve this EOQ problem. 22 23 Each time you should order bags. (Round to an integer.) 24 25 Your can add a new sheet in this file to work on Solver. 26 Keep your solver inputs in this file. Save the file and submit as an attachment. 27 28 29