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 $158,000. Variable processing costs are estimated to be $8 per book. The publisher plans to sell single-user access to the book for $42. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 - 6p, where p is the price of the e-book. (a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). $30568 (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) $ 50.75 (c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in dollars) that maximizes profit. $ 325

Yaster Breakfast Supplies is planning to manufacture and market a new toaster. After conducting extensive market surveys, the research department provides the following estimates: • a weekly demand of 318 at a price of $13 per toaster • a weekly demand of 201 at a price of $16 per toaster The financial department estimates that weekly fixed costs will be $1,399 and variable costs (cost per unit) will be $3. Assume: • the relationship between price and demand is linear • the cost function in linear Use your models to predict the marginal profit when Yaster is producing and selling 271 toasters per week. Round to the nearest cent. $ per toaster

An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…

Refer to the production possibilities curves for Chairland and Tableland. Chairland can produce 36 chairs per day and no tables, or 18 tables table per day and no chairs. Tableland can produce 40 chairs per day and no tables, or 40 tables per day and no chairs. If the two countries split the difference between the​ buyer's willingness to pay for tables and the​ seller's willingness to​ accept, in terms of the number of chairs for 1​ table, the terms of trade will be . (Enter your response rounded to one decimal​ place.) Country  Quantity per day Opportunity cost of chairs  Opportuity cost of tables Tableland 40 chairs, 40 tables 1 table 1 chair Chairland 36 chairs, 18 tables 1/2 table  2 chairs

A retailer anticipates selling 1,300 units of its product at a uniform rate over the next year. Each time the retailer places an order for a units, it is charged a flat fee of $25. Carrying costs are $26 per unit per year. How many times should the retailer reorder each year and what should be the lot size to minimize inventory costs? What is the minimum inventory cost? They should order units The minimum inventory cost is $ times a year.