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 DocumentRight 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 DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

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