Read the Cox and Cable Wire Company Case Page #469

Complete question on page #69 question #7

7.) Design a spreadsheet to find a machine schedule and corresponding inventory and shipment schedule that meets demand. What is the profit contribution for the schedule?

Complete questions on page #86 question #7

7.) Design a spreadsheet that will evaluate the profitability production of any particular production and deliver schedule.

A.) Find a machine schedule and a corresponding inventory and shipment schedule that meets demand. What is the profitability of this schedule?

B.) Suppose that materials costs for products were to rise by a specific percentage. At what percentage increase would profitability drop to zero?

C.) Construct a table showing how profitability varies with changes in the selling price of Plastic reels. Repeat for Teflon reels. Which price has a greater effect on profitability?