Use the data given below to answer the following question(s). Below is the spreadsheet for demand prediction of a company that sells chocolates. A B C 1 Demand Prediction Models 23 Linear Model 4 A 10,000 5 B 10 67 Price Demand 8 $50 9,500 9 $55 9,450 10 $45 9,550 11If a dollar sign is used after the column in B5 (B$5), how will the formula at B8 be represented in C9 using absolute addressing?

Agovernment receives a gift of cash and investments with a fair value of $200,000. the donor specified that the earnings from the gift must be used to beautify city-owned parks and the principal must be re-invested. the $200,000 gift should be accounted for in which of the following funds? a) general fund b) private-purpose trust fund c) agency fund d) permanent fund

Kumar consulting operates several stock investment portfolios that are used by firms for investment of pension plan assets. last year, one portfolio had a realized return of 12.6 percent and a beta coefficient of 1.15. the average t-bond rate was 7 percent and the realized rate of return on the s& p 500 was 12 percent. what was the portfolio's alpha?

Cadbury has a chocolate factory in dunedin, new zealand. for easter, it makes two kinds of “easter eggs”: milk chocolate and dark chocolate. it cycles between producing milk and dark chocolate eggs. the table below provides data on these two products. demand (lbs per hour) milk: 500 dark: 200 switchover time (minutes) milk: 60 dark: 30 production rate per hour milk: 800 dark: 800 for example, it takes 30 minutes to switch production from milk to dark chocolate. demand for milk chocolate is higher (500lbs per hour versus 200 lbs per hour), but the line produces them at the same rate (when operating): 800 lbs per hour. a : suppose cadbury produces 2,334lbs milk chocolate and 1,652 lbs of dark chocolate in each cycle. what would be the maximum inventory (lbs) of milk chocolate? b : how many lbs of milk and dark chocolate should be produced with each cycle so as to satisfy demand while minimizing inventory?