Question: please answer on excel Q1:ABC Publishing (20 points) 9) Build a spreadsheet model to calculate profit/loss for any given demand. 10 (1) Use Goal Seek

please answer on excel

Q1:ABC Publishing (20 points) 9) Build a spreadsheet model to calculate profit/loss for any given demand. 10 (1) Use Goal Seek to determine the price per copy that the publisher must charge to breakeven with demand of 3500 copies (show result on different sheet) 11 (1) Use a two way data table to vary demand from 1000 to 5000 in increments of 500 and the price to vary from $16 to $6 in increments of $2 to assess the sensitivity of profit to do 12 13 Price/book $16.00 14 15 Fixed Cost $160,000.00 16 Variable Cost/book $6.00 17 No. of copies 8 9 Total Cost Total Revenue 1 Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

PLEASE SHOW HOW TO SOLVE USING EXCEL, PLEASE INCLUDE ALL FORMULAS USING FOR EXAMPLE: =PV(C42,C41.C40,0,0) H22 X M 1 0 A B D F G H J Meyerson's Bakery DO NOT MODIFY 1) Complete the Income Statement....

Answer all questions. Note that these questions should be completed by using Excel (except for Case Studies 1 and 4), then copy and paste or screenshot the charts/tables/part of the excel to a word...

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...

1. (-/1 Points] DETAILS MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER This question has several parts that must be completed sequentially. If you skip a part of the question, you will not receive any...

please answer question 4 thanks 3. E-book Profit/Loss. Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of...

JUST DO ONE EXCELL THE FIRST ONE Williamson Manufacturing Transportation Model Data Shipping Cost Per Unit Units Shipped Instructions: 1. Deliverables: 3 Excel files submitted to Blackboard only. No...

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applicationis for business. The fixed cost of manuscript preparation, textbook design, and web site...

I need to put this information on EXCEL using formulas I need help with the input on Excel AutoSave OFF @ @ 2... Homework 1 Template Home Insert Draw Page Layout Formulas Data Review View Tell me...

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...

EL eBOOK Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and...

Kara took clients to dinner Her cost Cab from their hotel to the restaurant 20 cover charge 50 dinner 200 drinks 50 tips70 cab back to their hotel 20 What is her deduction

Steve and Cher put $2,400 into a college fund every year for their son, Don, on his birthday, with the first deposit one year from his birth (at his very first birthday). The college fund has a...

Kennedy Company manufactures variety of scooters. The company is in need of 3 0 , 0 0 0 batteries for the scooters. They can buy the batteries from an outside supplier for \ ( \ $ 4 2 \ mathrm { a }...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...