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

Define healthcare organization with its own mission

Should every community have its own healthcare organization with its own mission, or should hospitals be like Wal-Mart, where the mission is set once for the world? State yo

What type of instrument is this-is it negotiable

On a sheet of paper, Elle writes, without her signature, "I acknowledge that I owe Frank $600, payable out of the proceeds of the sale of my car, a 1995 Honda Civic, which I p

What potential causes of poor decision making existed

What potential causes of poor decision making existed at WorldCom during Bernard Ebbers' administration? What might have happened if Ebbers had been prone to a different confl

Protecting your business from counterfeiters

Protecting Your Business from Counterfeiters You are a manufacturer of high-end leather goods. How can process and/or product innovation protect you from counterfeiters that a

Designing the last station of serial production line

You are designing the last station of a serial production line. You want the last station to be able to maintain a throughput of 500 units/day. You also want the cycle time th

Active role to play in the performance management cycle

Managers share responsibility for employee performance and have an active role to play in the performance management cycle. Define each of these terms, the circumstances under

Describe the components of an executive compensation plan

You are the HR VP for the Carringten Auto Brake Lining Company. A recent economic downturn has seriously affected the auto industry and your company, as well. Describe the com

Prepare a formal statistical report

The French boutique owned by Ilsa Lund has experienced unusual levels of employee theft at other outlets that have been open for several months prior to the one located in the

Reviews

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