Provide a formula in the solution. Thank you! ABC Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be P100,000. Variable production and material costs are estimated to be P150 per book. Demand over the life of the book is estimated to be 4,000 copies. The publisher plans to sell the text to college and university bookstores for P1,000 each. 1. What profit or loss can be anticipated with a demand of 4000 copies? 2. With a demand of 4000 copies, what is the minimum price per copy that the publisher must charge to break even? 3. If the publisher believes that the price per copy could be increased to P1,297.50 and would not affect the anticipated demand of 4000 copies, what action would you recommend?

Provide a formula in the solution. Thank you! ABC Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be P100,000. Variable production and material costs are estimated to be P150 per book. Demand over the life of the book is estimated to be 4,000 copies. The publisher plans to sell the text to college and university bookstores for P1,000 each. 1. What profit or loss can be anticipated with a demand of 4000 copies? 2. With a demand of 4000 copies, what is the minimum price per copy that the publisher must charge to break even? 3. If the publisher believes that the price per copy could be increased to P1,297.50 and would not affect the anticipated demand of 4000 copies, what action would you recommend?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

Garrison Boutique, a small novelty store, just spent $4,000 on a new software program that will help in organizing its inventory. Due to the steep learning curve required to use the new software, Garrison must decide between hiring two part-time college students or one full-time employee. Each college student would work 20 hours per week, and would earn $1 S per hour. The full-time employee would work 40 hours per week and would earn $15 per hour plus the equivalent of $2 per hour in benefits. Employees are given two polo shirts to wear as their uniform. The polo-shirts cost Garrison $10 each. What are the relevant costs, relevant revenues, sunk costs, and opportunity costs for Garrison?
Eastman Publishing Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be $80,000. Variable production and material costs are estimated to be $3 per book. Demand over the life of the book is estimated to be 4000 copies. The publisher plans to sell the text to college and university bookstores for $20 each. Q) If the publisher believes that the price per copy could be increased to $25.95 and not affect the anticipated demand of 4000 copies, what action would you recommend? What profit or loss can be anticipated?
Eastman Publishing Company is considering publishing a paperbadk textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be $160,000. Variable production and material costs are estimated to be $6 per book. Demand over the life of the book is estimated to be 4000 copies. The publisher plans on selling the text to college and university bookstores for $46 each. a. What is the breakeven point?
Eastman Publishing Company is considering publishing a paperback textbook on spreadsheet application for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be $80,000. Variable production and material cost are estimated to be $3 per book. Demand over the life of the book is estimated to be 4000 copies. The publisher plans to sell the text to college and university bookstore for $20 each. Required: a). What is the breakeven point? b). What profit or loss can be anticipated with a demand of 4000 copies? c). With a demand of 4000 copies, what is the minimum price per copy that the publisher must charge to breakeven? d) If the publisher believes that the price per copy could be increased to $25.95and not affect the anticipated demand of 4000 copies, what action would you recommend? What profit or loss can be anticipated?
D's is considering publishing a paperback textbook onspreadsheet applications for business. The fixed cost of manuscriptpreparation, textbook design, and production setup is estimated to beP100,000. Variable production and material costs are estimated to be P150 perbook. Demand over the life of the book is estimated to be 4000 copies. Thepublisher plans to sell the text to college and university bookstores for P1000each. e. What profit or loss can be anticipated with a demand of 4000 copies? f. With a demand of 4000 copies, what is the minimum price per copy that the publisher must charge to break even? g. If the publisher believes that the price per copy could be increased to P1, 297. 50 and would not affect the anticipated demand of 4000 copies, what action would you recommend? h. What profit or loss can be anticipated?
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and website construction is estimated to be $160,000. Variable processing costs are estimated to be $6.00 per book. The publisher plans to sell single-user access to the book for $46. a. Build a spreadsheet model to calculate the profit/loss for a given demand. For example, what profit can be anticipated with a demand of 3500 copies? b. Use a data table to very demand from 1000 to 6000 in increments of 200 to assess the sensitivity of profit to demand. c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with the demand of 3500 copies. Before you move on to Problem 2, make sure you save your workbook with this value displayed or else you will not receive credit.
1.Eastman Publishing Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be $60,000. Variable production and material costs are estimated to be $3 per book. Demand over the life of the book is estimated to be 3800 copies. The publisher plans to sell the text to college and university bookstores for $18 each. What is the breakeven point? What profit or loss can be anticipated with a demand of 3800 copies? With a demand of 3800 copies, what is the minimum price per copy that the publisher must charge to break even?
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 $171,000. Variable processing costs are estimated to be $8 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
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 $162,000. Variable processing costs are estimated to be $6.89 per book. Use Goal Seek to determine the access price per copy (in dollars) that the publisher must charge to earn a profit of $100,000 with a demand of 31,000 copies.
Binders-For-School Ltd is in the process of determining whether to purchase a high-capacity machine to make textbooks for the upcoming school year. The high-capacity machine will generate fixed costs of $10,000 per year versus the $2,000 fixed costs of using a low-capacity machine. The variable costs per unit when using the high-capacity machine will be $30. The company will charge $60 for each textbook and has determined that the high-capacity machine will be more economically beneficial if sales are greater than 800 books. What is the variable cost per unit under the low-capacity machine scenario? $20 $40 $60 $80
The Hub Store at a university in eastern Canada is considering purchasing a self-serve checkout machine similar to those used in many grocery stores and other retail outlets. Currently the university pays part-time wages to students totalling $58,000 per year. A self-serve checkout machine would reduce part-time student wages by $38,000 per year. The machine would cost $300,000 and has a 10-year useful life. Total costs of operating the checkout machine would be $5,600 per year, including maintenance. Major maintenance would be needed on the machine in five years at a total cost of $10,600. The salvage value of the checkout machine in 10 years would be $43,000. The CCA rate is 25%. Management requires a 10% after-tax return on all equipment purchases. The company’s tax rate is 30%. Required:1. Determine the before-tax net annual cost savings that the new checkout machine will provide. 2-a. Using the data from (1) above and other data from the exercise, compute the checkout…
A recently retired professor, Melinda Marketing, plans to establish the Hot-Air FanCompany and manufacture circulating fans. She estimates the fixed cost of operations tobe $357,500 annually. The variable cost of producing the fans is forecasted to be $85 perunit.a. How many fans must be sold to break even if the fans are priced at $150?b. If Hot-Air sells 6,000 fans, what will be the EBIT?c. If Hot-Air sells 6,000 fans and has interest expense of $8,125, what is Hot-Air’stimes-interest-earned? Hot-Air does not have any nonoperating expenses.d. If the fans are priced at $150, what is Hot-Air’s breakeven sales?