Lilly, John - Chapter 9 Homework

Lilly, John - Chapter 9 Homework - Business 402 Chapter 9...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Business 402 Chapter # 9 Homework Created By: John T. Lilly Last Modified: 11/4/2011 Description: Worksheets: ATC 1st Run 2nd Run Scenario Summary Honor Code: Acknowlegement of Honor Code: John Lilly Production Plan and Constraints for ATC Inc. Best Production Plan without Retraining Best Production Plan if allowed to Retrain Current Employees Comparison of Current Scenario, Non-Retraining Best Scenario, Retrained Best Scenario On my honor, I have neither given nor received any unauthorized aid in completion of this assignment. I recognize that I am encouraged to help my classmates with questions or problems that they may have, and I am also able to seek help from classmates. But ultimately, I have created and completed this assignment on my own. This file is my own. I have not referred to used, or copied a file that has been given to me by anyone else, nor have I given a copy of my file to another student.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
ATC Valve Production Markup Production Time per Unit (in Hours) 300% 2nd Run Item Set-Up Cost Casting Machining Unit Cost List Price Total Profit Valve 102-45 $950.00 1.20 1.70 0.30 448 $35.00 $105.00 140.00 49.82% $8,850.00 Valve 102-46 $1,000.00 3.20 1.50 0.30 145 $44.00 $132.00 29.00 10.32% $1,552.00 Valve 102-47 $1,000.00 3.00 1.20 0.30 504 $41.00 $123.00 112.00 39.86% $8,184.00 Total 281.00 100% $18,586.00 Total Time Used 596.8 415.9 84.3 1097 (based on # of each valve produced) CONSTRAINTS Casting Machining Min Total Time Used 0 0 0 0 Min for Each Valve 0 10% Max Total Time Used 1100 1100 1100 1100 Max for Each Valve 1,000,000 50% per-phase maximums Other constraints integer Casting Constraint Final Assembly Total Assembly Number Produced % of Total # Produced Final Assembly Total Assembly Number Produced % of Total # Produced A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Background image of page 2
Microsoft Excel 12.0 Answer Report
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 5

Lilly, John - Chapter 9 Homework - Business 402 Chapter 9...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online