Variety of plastic items for packaging and distribution

Assignment Help Operation Management
Reference no: EM132280544

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

(d) The company is considering ways to improve profitability by either stimulating sales volume or reducing variable costs. Management believes sales can be increased by 35 percent of their current levels (alternative 1) or that variable costs can be reduced to 90 percent of their current level (alternative 2). Assuming all other costs stay at the base-case levels (values established in part (a)), use the model to determine which alternative would lead to a higher profit contribution.

Additional instructions: Your submission must be an EXCEL file; put your solution to each part on a separate tab of the EXCEL workbook.

For part (a), make sure that you include a textbox containing at least a one-sentence response to the question asked.

For part (b), provide a screenshot (or Snipping Tool capture) of the Goal Seek Dialog Box. Run Goal Seek before taking the screenshot.

For part (c), place the Chart of the relevant data to the right of the Data Table results.

For part (d), provide a side by side set of computations for the two alternatives. Also, provide a written interpretation of the result for each alternative, and a written recommendation of your recommendation between the two alternatives.

Reference no: EM132280544

Management opening in the procurement department

Bill Carter is an excellent hardware designer, but he wants to move into management, in order to broaden his experience. His manager is supportive and encourages Bill to go to

Calculate profit in the short run by using the price

Calculate profit in the short run by using the price and output levels you generated in part 5. Optional: You may want to compare this to what profit would have been in Assi

Corporation natural and societal environments

Discuss how a development in a corporation’s natural and societal environments can affect the corporation through its task environment. How can value chain analysis help ident

What is the difference between management approaches

How was walmart managed in the past? What is the difference between management approaches in the past to those of the present organization? What are the management styles and

Asking for a refund-repair-replacement or other adjustment

Choose such an incident from your own experience, and write a claim letter asking for a refund, repair, replacement, or other adjustment. You will need to include all the deta

Qualitative and quantitative forecasting method

What are the key differences between qualitative and quantitative forecasting method? Which method is better in your opinion and why? Briefly describe the different assumption

Reliability and safety of computer systems

Discuss 3 roles we play in connection to computers. Identify 3 problems created by computer failures for individuals and/or systems: What were the factors in causing these fai

Disability with regard to job control-uncertainty-conflict

Millions of U.S. workers grapple with difficult issues and even discrimination in the work force related to their disabilities. Many of these workers suffer with serious or ch


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd