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 $170,000. variable processing costs are estimated to be $6 per book. the publisher plans to sell single-user access to the book for $52.a. 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,600 copies? 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,200 to 3,400 copies.(ii) breakeven appears in the interval of 3,600 to 3,800 copies.(iii) breakeven appears in the interval of 3,800 to 4,000 copies.(iv) breakeven appears in the interval of 4,000 to 4,200 copies. c. use goal seek to answer the following question. with a demand of 3,600 copies, what is the access price per copy that the publisher must charge to break even?
Answers: 2
Other questions on the subject: Business
Business, 21.06.2019 22:20, arijade1391
Why should you not sign the tenant landlord agreement quickly and immediately
Answers: 1
Business, 22.06.2019 12:40, hardwick744
Acompany has $80,000 in outstanding accounts receivable and it uses the allowance method to account for uncollectible accounts. experience suggests that 6% of outstanding receivables are uncollectible. the current credit balance (before adjustments) in the allowance for doubtful accounts is $1,200. the journal entry to record the adjustment to the allowance account includes a debit to bad debts expense for $4,800. true or false
Answers: 3
Business, 22.06.2019 17:00, PlzNoToxicBan
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?
Answers: 2
Business, 22.06.2019 22:00, brad7330
Brody corp. uses a process costing system in which direct materials are added at the beginning of the process and conversion costs are incurred uniformly throughout the process. beginning inventory for january consisted of 1,050 units that were 65% completed. 10,900 units were started into the process during january. on january 31, the inventory consisted of 500 units that were 50% completed. what would be the equivalent units for direct materials cost using the weighted average method?
Answers: 2
Do you know the correct answer?
Eastman publishing company is considering publishing an electronic textbook about spreadsheet applic...
Questions in other subjects:
Mathematics, 13.10.2019 05:50
History, 13.10.2019 05:50
History, 13.10.2019 05:50
Health, 13.10.2019 05:50
