Company Name: Osram Sylvania
Company Web Site: http://www.sylvania.com
Company Address: 835 Washington Street, St. Marys, PA
Description of Responisibilities: Duties currently include but are not limited to the following:
Normal Job Duties:
Assist with preparation of monthly standard costs and analyze absorption rates.
Determine and analyze monthly standard costs by preparing SAP and Microsoft EXCEL reports in total, by production family, by shipment location, and by strategic business unit for St Marys (STM) and Wellsboro (WB).
Occurs every month end.
Develop and report standard cost allowables for forecasting measures:
Coordinate and conduct review of forecasted demand with Planning Department.
Prepare upload of forecasted production for both STM and WB.
Determine standard allowable for forecast periods by generating SAP reports from forecasted production for both STM and WB.
Prepare WB sales file analyzing change versus budget and prior month forecast by customer type.
Occurs every forecast cycle – typically monthly.
Assist with development and loading of budget standards and actuals:
Prepare various uploads of standard costs as established for budgeted volumes.
Determine standard allowable for budgeted volumes by generating SAP reports and corresponding EXCEL files.
Assist in generation of actual forecasts and account detail analyses.
Occurs in the March – May timeframe; several versions of uploads will be generated.
Assist with generation of repack projects / proposals:
Prepare repack proposals with various scenarios for evaluation.
Determine standard allowable change, labor repack costs, packaging requirements and freight and shrinkage allowances for proposed quantities.
Occurs as required however significant emphasis has been placed on reviewing inventory and repacking where possible so the number of repacks has increased.
Support Planning and Facilities:
Prepare natural gas usage report and calculate daily and cumulative banked gas for Facilities.
Modify shop orders per Planning requirements and updates.
Occurs daily for natural gas updates and weekly for shop order maintenance.
Assist in maintaining accurate and updated insurance and indemnity agreements for Purchasing.
Miscellaneous:
Assist with presentation material development for plant and strategic business unit management.
Provide invoice payment support as needed.
Update reports, charts and graphs used for plant measurement / management.
Assist in preparing documents required for both internal and external audits.
Delete forecast, month-end and miscellaneous PMs from SAP
Prepare key account analysis for management review – weekly, monthly and as needed
Participate in Physical Inventory and / or Audit counts
Setup files for the new fiscal year in September / October
Setup monthly closing files and forecasting files for each cycle
Assist with calculations for various projects, support as needed
Timeframe: On going basis - we typically prefer interns be available for 2 consecutive semesters (summer / fall / spring) and we usually have at least 1 at all times.
Pay: Between $10 - 15 / hour. Hours are flexible depending on students availability / class schedule
Description of Business: Based in Danvers, Mass., the General Lighting unit of OSRAM SYLVANIA manufactures incandescent, fluorescent and high-intensity discharge lamps at seven plants in the United States, Canada and Mexico. It provides general and specialty lighting sales, marketing and distribution services throughout the U.S. to industrial, commercial and retail customers and to original equipment and other lamp manufacturers. This business unit also has a centralized customer support organization located in Westfield, Ind.
The OSRAM SYLVANIA plant located in St. Marys manufactures the majority of the Consumer Lighting incandescent products for the company.