Flexible and documented base-case spreadsheet model

Assignment Help Operation Management

Reference no: EM132172142

Kaizer Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits. Last year, 20,000 units of container #145 were produced and sold. The selling price of the container was $25 per unit, with a variable cost of $16 per unit and a fixed cost of $70,000 per year.

(a) Construct a correct, flexible, and documented base-case spreadsheet model that allows the user to easily vary the inputs to the problem and see the resulting revenue, costs, and profit. What is the profit level for the base case?

(b) Using the model and Goal Seek, find the break-even quantity.

(c) Construct a Data Table and chart showing profit versus quantity. Vary the quantity from 0 to 70000 in increments of 5000.

Reference no: EM132172142

Questions Cloud

Caused people to have negative response to his message : What is it about his tone that caused people to have a negative response to his message?

Calculate the amount of life insurance : Assuming $15,000 in final expenses and $20,000 allocated to help make mortgage payments, calculate the amount of life insurance

Write a case report for each case study : After clicking a disorder, click the Diagnostic Overview tab in the left column. This will cover the major diagnostic features of the disorder.

Define the problem or issue that your government address : Research the ways that organizations or communities might change or adapt to upheavals in the societies in which they exist.

Flexible and documented base-case spreadsheet model : Construct a correct, flexible, and documented base-case spreadsheet model that allows the user to easily vary the inputs to the problem

Skill functions create effective business organization : How do interpersonal skill functions create an effective business organization?

Why would your research question be important to study : Reflect on the information you have learned in your readings for Module 1, thinking about information related to human sexuality that you would like.

Describe the importance of job advertisment : Describe the importance of Job advertisment, cover letter and resume when you apply for a job.

What resources might you want to engage : Questions to ask the group: What are your concerns? What would you like more information about? What would be your next steps in working with Adam?

User Account

All Pages