Should the company buy the new equipment

Assignment Help Management Information Sys

Reference no: EM131232419

Information Systems: Build Models on Excel

Build Excel Models

1) An electronics firm is currently manufacturing an item that has a variable cost of $0.60 per unit and selling price of $1.10 per unit. Fixed costs are $15,500. Current demand is 32,000 units. The firm can substantially improve the product quality by adding a new piece of equipment at an additional fixed cost of $8,000. Variable cost would increase to $0.70 but the demand is expected to jump to 50,000 units due to the higher quality of the product. Should the company buy the new equipment?

2) Your publishing company is launching a new book soon and it has decided to release a hard cover and a paperback version at the same time. The cost to produce each hard cover book is $12 and the cost to produce each paperback book is $8.

You company wants you to build a model to estimate the total profit associated with the two books based on the price for each book and the advertising budget. The company's marketing department has estimated the total number of books that will be sold according to the following equations:

Hardcover: QHardCover = (10,000*(12 - PHardCover*.03) * Advertising^0.2
Paperback: QPaperback = (15,000*(8 - PPaperback*.04) * Advertising^0.2

Notes:

· Q_HardCover - Quantity of hardcover books sold
· P_HardCover - Price of hardcover book
· Q_Paperback - Quantity of paperback books sold
· P_Paperback - Price of paperback book
· Advertising - Amount spent on advertising the book

Reference no: EM131232419

Questions Cloud

Identify what you found in your environmental scan : Identify what you found in your environmental scan. What did you learn about the industry? What did you learn about your organization

Impact on management transportation : List several environmental regulations and describe their impact on management transportation.

Understand the significance of organizational culture : "It is imperative that managers understand the significance of Organizational Culture in order to create the right environment within their organizations. Using Handy's Cultural Types and one theorist, critically discuss this statement.

Compare juvenile delinquency prevention and treatment : An explanation of the overall importance of prevention and treatment-why are both critically necessary components of the juvenile justice system, and to what extent are they interrelated?

Should the company buy the new equipment : Variable cost would increase to $0.70 but the demand is expected to jump to 50,000 units due to the higher quality of the product. Should the company buy the new equipment?

What legal issues were decided by the court in this case : The complete title and citation for the case. • Explain which court decided this case. • How did the case get to the court? Discuss the procedural history of the case. • Discuss the facts of the case. What legal issues were decided by the court in th..

Why is project schedule management important : Why is Project Schedule Management important? Why is Project Cost Management important

Do you feel that the narrative is important : Which of the 3 components do you feel is the most important? Why? What are the functions of the narrative section of a report? Do you feel that the narrative is important? Why or why not?

Discuss your experience working with labsim : Discuss your experience working with LabSim and completing Unit 1 Lab tasks in Part I. Of the three Sections chosen in LabSim Module 3, share your thoughts about one of the simulated labs that you completed.

User Account

All Pages