Application Assignment I

Application Assignment I - Application Assignment I (due...

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

View Full Document Right Arrow Icon
Application Assignment I (due October 31, 2007) IMPORTANT NOTES: 1. Use the Excel files when given. Do not change any existing columns or formats. 2. All group members must contribute equally to the assignment. 3. Insert the group members’ names in each file (the spreadsheets have rows indicated in them). 4. Your complete submission should include 5 files : a. Excel file – exercise1.xls b. Excel file – you will create for exercise 2 c. Excel file – exercise 3 d. Excel file – exercise 4 e. Powerpoint file – you will create for exercise 4. 5. Email the assignments to me at asha_george@uml.edu on or before October 31, 2007 10 p.m. The person sending the email should remember to cc the other group members so they too know that the assignment has been submitted.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exercise 1: Just-in-Time Inventory Systems for Pinnacle Manufacturing Pinnacle Manufacturing is evaluating a proposal for the development of a new inventory management system that will allow it to use just-in-time techniques to manage the inventories of key raw materials. It is estimated that the new system will allow Pinnacle to operate with inventory levels for gadgets, widgets, and sprockets equaling 10 days of production and with inventories equaling only 5 days of production for cams and gizmos. To estimate the inventory cost savings from this system, you have been asked to gather information about current inventory levels at all of Pinnacle’s production facilities. You have received estimates of the current inventory level of each raw material used in a typical production day and the average dollar value of a unit of each raw material. These estimates are given in the Excel spreadsheet ( exercise1.xls ). a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Application Assignment I - Application Assignment I (due...

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

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