Not use ai please Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixedcost of manuscript preparation, textbook design, and web-site construction is estimated to be $170,000. Variable processing costsare estimated to be $6 per book. The publisher plans to sell single-user access to the book for $52.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) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand?(b) Use Goal Seek to calculate the price that results in breakeven. If required, round your answer to two decimal places.(c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price that maximizes profit.If Eastman sells the single-user access to the electronic book at a price of $, it will earn a maximum profit of $

DescriptionValue Price52 Demand1600 Revenue640000 Total Cost179600 Profit/Loss-352 In Part (a), we…

Answered: Eastman Publishing Company is…

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter6: Linear Systems

Section6.8: Linear Programming

Problem 5SC: If during the following year it is predicted that each comedy skit will generate 30 thousand and...

See similar textbooks

Similar questions

If you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.
If during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.
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…
Eastman Publishıng Company is considering publishing an electronic textbook about spreadsheet applications for business. The fxed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $150,000. Vanable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $49. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be antiopated with a demand of 3,400 copies? For subtractive or negative numbers use a minus sign. 7200 (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue - total cost yielding a profit of zero. In which interval of demand does breakeven occur? (i) Breakeven appears in the interval of 3,000 to 3,200 copies. (i) Breakeven appears in the interval of…
Compare the primary types of forecasting methods used to determine demand.
Describe the results of your two graphs as they compare to the movement of demand. Be specific. Choosing between the three-period and the five-period forecasts, which length of averaging would you use as a purchasing manager of Greenfield’s Tannery? Be sure to factor in the cumulative forecast errors in your answer. Also, make sure you include some rationale about why you are picking the method you do for this particular business. So for example, does picking one method over the other have any impact on how much inventory they will have on hand to meet customer demand? What happens when the demand drops? Which method better supports that?
An enterprising New Product Development class has an idea to sell on campus custom-flavored, enriched bottles of water from dispensers which would add customers’ desired vitamins and natural flavors to each bottle. To assess profit potential, they need an estimate of demand for bottled water on campus. If demand exceeds the breakeven level of seven bottles per week per customer, the business would generate profit. The entrepreneurial class needs to know whether or not demand exceeds seven bottles per consumer per week, because below this level of demand, revenues wouldn’t cover expenses. Unless sample data indicates sufficient demand, the class will stop development. Since the class of entrepreneurs doesn’t know that the population mean is, they will estimate this mean using their sample data. They take a random sample of thirty students on campus and find that on average a student consumes 9.9 bottles per week. They also find that the sample standard deviation is 4.1 bottles per…
A university currently has a recycling program for paper waste. The fixed cost of running this program is $5,000 per year. The variable cost for picking up and disposing of each ton of recyclable paper is $40. If the work is outsourced to a recycling company, the cost would be $80 per ton. If the forecasted demand is 800 tons, what should the university do? Use the Break-Even Excel template in MindTap to find your answer. Round your answers to the nearest dollar. Total cost of doing the job in-house: $ ____Total cost of outsourcing the job: $ ____ So the best decision for the university is to ________ (do the job in house/ outsource the job) for a savings of $ _____ . Find the break-even point using the Excel Goal Seek tool. Round your answer to the nearest whole number. ____ tons
A mall has a theater that seats 646 people and charges between $6 and $14 per ticket. When tickets to a movie cost $14, the average attendance was 117 people. When ticket prices were lowered to $6, the average attendance was 548 people. Assuming the demand function is linear, how much should a ticket cost in order to maximize revenue? Round your answer to the nearst cent.
When a company offers a new product or service, they estimate how much of that product or service people will want at different prices. This is referred to as the product or service demand . As the price of a product or service increases, the demand usually decreases, and this drives the price down. Companies use the estimated demand to determine how much of a product or service they are willing to supply at different prices. As the price of a product or service increases, companies are willing to supply more of it because they will earn more money. If you graph the demand and the supply curves on the same xy-plane, they will sometimes intersect at the point where the price and the supply are in equilibrium. Consider the scenario below. Yaseen is a local artist who wants to increase the amount of money she earns every month by selling at-home painting kits. These kits will include a photograph of the finished painting, a link and password to Yaseen’s YouTube channel where she will…
Suppose that a company has determined that a 70% experience curve accurately describes the evolution of its production costs for a new line. If the first unit costs $100 to produce, what should the 1,000th unit cost based on the experience curve?
Approaching the month of Ramadan, PT Prima Sehat predicts that there will be an increase in demand for fresh meat. For this reason, the company seeks to optimize this moment for increasing company profits. One of the efforts made is to maximize income from the livestock sector by calculating the optimization of animal food. The raw material for animal feed used today is suspects and kala, at a price of Rp. 20 and Rp. 30 per kg.Each animal feed must contain alpha elements not less than 30 units and gamma 120 units, and beta elements at most 280 units. The composition of feed consisting of suspects and kala is at most 8 to 1. From the information received, it is known that the composition per kg of suspect consists of 6 alpha units, 20 units of Beta and 10 units of gamma. Whereas per kg of Kala contains 3 units of alpha composition, 40 units of Beta and 40 units of Gama. The company only provides Sangka as much as 8 kg per process Please use the linear graph method program to solve the…

SEE MORE QUESTIONS

Recommended textbooks for you

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

SEE MORE TEXTBOOKS