Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $150,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $41. Required:
Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,400 copies?

At a student café, there are equal numbers of two types of customers with the following values. the café owner cannot distinguish between the two types of students because many students without early classes arrive early anyway (i.e., she cannot price-discriminate). students with early classes students without early classes coffee 70 60 banana 51 101 the marginal cost of coffee is 10 and the marginal cost of a banana is 40. the café owner is considering three pricing strategies: 1. mixed bundling: price bundle of coffee and a banana for 161, or just a coffee for 70. 2. price separately: offer coffee at 60, price a banana at 101. 3. bundle only: coffee and a banana for 121. do not offer goods separately. assume that if the price of an item or bundle is no more than exactly equal to a student's willingness to pay, then the student will purchase the item or bundle. for simplicity, assume there is just one student with an early class, and one student without an early class. price strategy revenue from pricing strategy cost from pricing strategy profit from pricing strategy 1. mixed bundling $ $ $ 2. price separately $ $ $ 3. bundle only $ $ $ pricing strategy yields the highest profit for the café owner.

What are two benefits of consumer programs

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?