1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
pickupchik [31]
4 years ago
5

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fix

ed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46. (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,500 copies
Business
1 answer:
Ilia_Sergeevich [38]4 years ago
3 0

Answer:

See the excel spreadsheet attached.

Anticipated profit/(loss) is ($20,000).

Explanation:

The net profit/(loss) is the difference between the total sales and total cost. The total sales is computed as the product of the sale of each book and the number of books sold. The total cost is the sum of the variable and fixed costs.

The total variable cost is the product of the variable cost per book and the total number of books sold.

Alternatively, sales less variable cost gives contribution margin. Contribution margin less fixed cost gives the net profit. As shown in the spreadsheet attached.

Download xlsx
You might be interested in
What term represents the worldwide movement toward economic, financial, trade, and communications integration?
igomit [66]
I believe that the answer is globalization.
6 0
4 years ago
Read 2 more answers
All of the current year's entries for Zimmerman Company have been made, except the following adjusting entries. The company's an
bearhunter [10]

Answer:

1) adjusting entries

a. On September 1 of the current year, Zimmerman collected six months' rent of $8,520 on storage space. At that date, Zimmerman debited Cash and credited Unearned Rent Revenue for $8,520.

Dr Unearned rental revenue 5,500

    Cr Rental revenue 5,500

b. On October 1 of the current year, the company borrowed $13,200 from a local bank and signed a one-year, 12 percent note for that amount. The principal and interest are payable on the maturity date.

Dr Interest expense 396

    Cr Interest payable 396

c. Depreciation of $3,000 must be recognized on a service truck purchased in July of the current year at a cost of $24,000.

Dr Depreciation expense 3,000

    Cr Accumulated depreciation 3,000

d. Cash of $3,600 was collected on November of the current year, for services to be rendered evenly over the next year beginning on November 1 of the current year. Unearned Service Revenue was credited when the cash was received.

Dr Unearned service revenue 600

    Cr Service revenue 600

e. On November 1 of the current year, Zimmerman paid a one-year premium for property insurance, $9,960, for coverage starting on that date. Cash was credited and Prepaid Insurance was debited for this amount.

Dr Insurance expense 1,660

    Cr Prepaid insurance 1,660

f. The company earned service revenue of $4,200 on a special job that was completed December 29 of the current year. Collection will be made during January of the next year. No entry has been recorded.

Dr Accounts receivable 4,200

    Cr Service revenue 4,200

g. At December 31 of the current year, wages earned by employees totaled $13,700. The employees will be paid on the next payroll date in January of the next year.

Dr Wages expense 13,700

    Cr Wages payable 13,700

h. On December 31 of the current year, the company estimated it owed $490 for this year's property taxes on land. The tax will be paid when the bill is received in January of next year.

Dr Property taxes expense 490

    Cr Property taxes payable 490

2) Assets     = Liabilities + Stockholders’     Revenues - Expenses = Net

                                          Equity                                                          Income

a.    na               -                    +                           +               na                +

b.    na               -                    -                           na              -                   -

c.     -               na                   -                           na              -                   -

d.    na               -                    +                           +               na                +

e.     -               na                   -                           na              -                   -

f.      +              na                   +                           +               na                +

g.    na              +                    -                            na             -                   -

h.    na              +                    -                            na             -                   -

5 0
4 years ago
Which statement describes border and shading?!
victus00 [196]

Border is something that goes right around an object.

Shading is the color of an object.

Hope this helps! :)

5 0
3 years ago
Read 2 more answers
If a customer purchases $500.00 in merchandise on account, and the terms are 2/10, n/30, what would the customer owe if he were
nika2105 [10]
In accounting, the invoice 2/10, n/30 means that the customers has to pay $500 within 30 days. If he can pay earlier, say within 10 days from the date of purchase, a cash discount of 2% is given. If the customer pays on the 9th day, he would only have to pay 

500(100% - 2%) = $490
3 0
4 years ago
In 2017, almost ________ of americans only used a mobile device to access the internet.
melisa1 [442]
Woo chick chin dry scary chick shy rii su do do tbh Gm tan Gn yum
4 0
2 years ago
Other questions:
  • A check involves three parties. the person who orders the bank to pay a certain amount of money is called the drawer. drawee. pa
    15·2 answers
  • The opportunity cost of going to college is a. the total money spent on food, clothing, books, transportation, tuition, lodging,
    12·2 answers
  • GoodFurn Furniture Company has recently moved to a new, larger location. At the new location, it has been unable to attract suff
    7·1 answer
  • Questions<br>1. How you rename a worksheet?<br>​
    15·1 answer
  • More magazine is a publication designed to appeal to women over the age of 40. Demand for such magazines is an example of how __
    6·1 answer
  • Which of these types of products usually involves the customer doing comparison shopping?
    14·1 answer
  • In the course of the communication process, which of the given steps logically follows after the listener receives the message s
    8·1 answer
  • Under a flexible-price monetary approach to the exchange rate Group of answer choices when the domestic money supply falls, the
    5·1 answer
  • Describe and evaluate the elements of the carrying cost of inventory and how it relates to inventory levels and capital investme
    14·1 answer
  • The following economic functions have been derived by the Finance Manager
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!