Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable, how would you find out how many of each type of candy bar you have?

The cook corporation has two divisions--east and west. the divisions have the following revenues and expenses: east west sales $ 603,000 $ 506,000 variable costs 231,000 300,000 traceable fixed costs 151,500 192,000 allocated common corporate costs 128,600 156,000 net operating income (loss) $ 91,900 $ (142,000 ) the management of cook is considering the elimination of the west division. if the west division were eliminated, its traceable fixed costs could be avoided. total common corporate costs would be unaffected by this decision. given these data, the elimination of the west division would result in an overall company net operating income (loss)

Three pounds of material a are required for each unit produced. the company has a policy of maintaining a stock of material a on hand at the end of each quarter equal to 30% of the next quarter's production needs for material a. a total of 35,000 pounds of material a are on hand to start the year. budgeted purchases of material a for the second quarter would be:

The east asiatic company (eac), a danish company with subsidiaries throughout asia, has been funding its bangkok subsidiary primarily with u.s. dollar debt because of the cost and availability of dollar capital as opposed to thai baht-denominated (b) debt. the treasurer of eac-thailand is considering a 1-year bank loan for $247,000.the current spot rate is b32.03 /$, and the dollar-based interest is 6.78% for the 1-year period. 1-year loans are 12.04% in baht.a. assuming expected inflation rates of 4.3 % and 1.24% in thailand and the united states, respectively, for the coming year, according to purchase power parity, what would the effective cost of funds be in thai baht terms? b. if eac's foreign exchange advisers believe strongly that the thai government wants to push the value of the baht down against the dollar by5% over the coming year (to promote its export competitiveness in dollar markets), what might the effective cost of funds end up being in baht terms? c. if eac could borrow thai baht at 13% per annum, would this be cheaper than either part (a) or part (b) above?