In this question whats the answer for a,b,c,d,e ?

Excel File Edit View Insert Format Tools Data Window Help @@@ AutoSave OFF BA G. HW2 Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibrl (Body) 14 ap General Insert Pasto 18 Delete 27.0. 3 3 B T U GA- = = = $ % ) V 8.98 Conditional Format Celi Formatting as Table Styles Format O Sort & Filter Find & Select G39 x A 8 D E F G H L M N o P Q R s T U V w X 1 2 3 4 5 5 6 G 7 8 9 9 0 1 2 (Powered by Koffee) Powered by Koffee (PBK) is a new campus coffee store. PBK uses 50 bags of whole Page 108 bean coffee every month, and you may assume that demand is perfectly steady throughout the year. PBK has signed a year-long contract to purchase its coffee from a local supplier, Phish Roasters, for a price of $25 per bag and an $85 fixed cost for every delivery independent of the order size. The holding cost due to storage is $1 per bag per month. PBK managers figure their cost of capital is approximately 2 percent per month. a. What is the optimal order size, in bags? 5.6) b. Given your answer in (a), how many times a year does PBK place orders? [ 5.6] c. Given your answer in (a), how many months of supply of coffee does PBK have on average? 0 5.6) d. On average, how many dollars per month does PBK spend to hold coffee (including cost of capital)? 5.6] 3 Suppose that a South American import/export company has offered PBK a deal for the next year. PBK can buy a year's worth of coffee directly from South America for $20 per bag and a fixed cost for delivery of $500. Assume the estimated cost for inspection and storage is $1 per bag per month and the cost of capital is approximately 2 percent per month. a. Should PBK order from Phish Roasters or the South American import/export company? Quantitatively justify your answer. 5.6) Is should be fel, not (a) inn