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 $145,000. Variable processing costs are estimated to be $4 per book. The publisher plans to sell single-user access to the book for $43. 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). $ 3706 x (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) $ 47.37 x (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

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 $145,000. Variable processing costs are estimated to be $4 per book. The publisher plans to sell single-user access to the book for $43. 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). $ 3706 x (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) $ 47.37 x (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

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

Nike Store at Lee Plaza in Dumaguete City wants to know the optimal price of one of their Clarkson shoe model, taking into account the purchases of socks and insoles. The current price of the Clarkson shoes is P4,499-50 per pair, the related annual sales of which is 24 pairs. The cost of the shoes is estimated at P3,450.00. The elasticity of demand for the shoes is estimated at -2.9 and assumed to be constant within a relevant price range. Every purchase of a pair of the Clarkson model leads to an average of 2 pairs of socks and 1 pair of insole being sold. The socks and insoles contribute P95, and P70, respectively. What is the expected profit from the complementary products? (Note: Ignore currency symbol and comma. Round your answer to the nearest ones.) Answer:
Bill O'Really of OX News observed that poultry (chicken and turkey) consumption in the US increased dramatically over the 2000 to 2006 period. This he believed was due to the fact that consumers, being more health conscious, switched from red meat to poultry, in an effort to eat healthier foods. Intrigued by these findings, Bill contacted the US Department of Agriculture for additional information. The department provided him with data that yielded two findings. First, there was a 75% decrease in the price of poultry over the period and second, there was widespread adoption of cost reducing innovations in poultry processing. Being a supposedly brilliant journalist, Bill concluded that the demand curve for poultry had shifted to the right. a. Is Bill's conclusion correct or incorrect? Explain your answer using supply and demand diagrams (best to use two diagrams in your answer). ANS:
Crispies Inc., a player in the breakfast cereals market, sold 20,000 boxes of cereal in the first quarter of the year at a price of $5 per box. Market analysis, however, indicated that Crispies could sell 25,000 boxes in the next quarter if it lowered the price by $1 per box. The firm thus reduced the price to $4 in the second quarter to increase sales to 25,000 boxes. However, after this price reduction, the sales revenue of the firm began to decline long before it hit the target of 25,000 boxes. Which of the following, if true, can best explain this outcome? A. There is a surplus of corn in the domestic economy. B. Crispies' cereals have a high content of Butylated Hydroxytoluene, which according to recent media reports causes extreme hyperactivity in children. C. The output in the fast-food industry shrunk by 2.5 percent this year. D. The rate of inflation in the country is low. E. Crispies' per-unit cost of production is lower than $4.
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 $156,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $41. 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). (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) (c) Use a data table that varies price…
A company produces and sells a consumer product and thus far has been able to control the volume of the product by varying the selling price. The company is seeking to maximize its net profit. It has been concluded that the relationship between price and demand, per month, is approximately D = 500 - 5p, where p is the price per unit in dollars. The fixed cost is $1,000 per month, and the variable cost is $20 per unit. Obtain the answer mathematically to the following questions: a.What is the optimal number of units that should be produced and sold per month? b.What is the maximum profit per month? c.What are the breakeven sales quantities and the range of profitable demand volume?
You have just been employed as the quantitative analyst by a budget event organizing firm.Your task is to maximize the firm's total revenue.The admission fee to their weekend program for business students,"Board Room Discussion" is $10 and the average attendance is 1000 students.Analysis from the recent survey conducted by the marketing department show that every $1 reduction in the admission fee will attract 200 more students to attend.The records also show that every student who attends the event spends $5 on one of their publications. Required: i. State the total revenue function of the firm. ii. Estimate the admission fee that maximizes total revenue and total revenue at that price.
The Atlas Movies Theater is planning to reprice their ticket rates to maximize revenues. They have three classes of tickets: Classic, Silver, and Gold. The accompanying table provides information on the average ticket sales, revenue and price elasticity on demand. They have a total seating capacity of 300. The table also provides the price range within which they plan to reduce their ticket rates. According to the nonlinear model, which of the following is the projected revenue figure for Silver tickets based on its new price? Click the icon to view the ticketing model. OA. $1,224.63 B. $1,132.08 C. $1,163.02 D. $1,316.92 Ticketing Model Atlas Movie Theater Ticketing Data Ticket Class Classic Silver Gold ... Current Average Elasticity Total Rate Daily Seating Sold Capacity $8.45 $13.25 80 $17.50 30 150 Print -1.5 -2 -1 Done 300 Price Range $6.50 $7.50 $11.50 $12.50 $15.50 $16.50 1 X
topic: managerial economics
It is known that beef increased its weekly demand from 70 to 85 tons/week (although its price remained unchanged) when the price of pork increased from $45 to $65/kg. Determine a) The linear model where the demand “Qx” s for beef depends on the price of pork, in its form Qx = mPy + b; any other way of representing the model will not be evaluated.b) The type of elasticity of beef with respect to pork c)The coefficient of elasticity d)How much is Exy worth when 90 tons/week of beef is demanded?How much will the variation in the price of pork affect the income of beef producers?
Need complete solution. A company produces and sells a consumer product and thus far has been able to control the volume of the product by varying the selling price. The company is seeking to maximize its net profit. It has been concluded that the relationship between price and demand, per month, is approximately D = 500 - 5p, where p is the price per unit in dollars. The fixed cost is $1,000 per month, and the variable cost is $20 per unit. Obtain the answer mathematically to the following questions: a.What is the optimal number of units that should be produced and sold per month? b. What is the maximum profit per month? c.What are the breakeven sales quantities and the range of profitable demand volume?
A tax on Cigarettes introduced in Mexico in 2012 increased the price of Cigarettes by about 10%. An evaluation of the first two years of this measure found that Cigarette consumption fell on average by 7.6%, with a larger decrease (11.7%) in low income households. The study also estimated an increase in consumption of alternatives to smoking, particularly Nicotine patches, of 2.1% (AYA, 2017) Explain factors that determine responsiveness to a price increase. Which of these factors might explain the difference in the economy and low income households?
The municipality is planning to build a huge monument, buying marble from the domestic market, which is efficient. An independent study has previously estimated the local demand and supply of marble as ??=25−0.2? and ??=−5+?, respectively. If the demand due to this project is expected to change to ??=49−0.2? (the quantity is measured in square meters and the price in dollars): What is the value of the change in the total surplus caused by this project?