Project briefs · Operations, Consulting & HR
Northrop Grumman · Summer 2027
Supply Chain Intern: a project built for this posting
A summer 2027 role in Northrop Grumman's global supply chain group, tracking supplier delivery and quality and helping compare bids before purchase orders are placed. Interns also pull and analyze data for business forecasting.
- Company
- Northrop Grumman
- Posting title
- 2027 Supply Chain Intern - HYBRID/Baltimore MD/Redondo Beach CA
- Location
- Baltimore, MD or Redondo Beach, CA (hybrid)
- Season
- Summer 2027
- Pay (as posted)
- $17.50 - $31.50/hour (bachelor's)
- Majors named
- Supply Chain Management, Business Management, Finance, Operations Management
Checked open on the employer's careers site on 2026-10-21. Read the full posting ↗
What this role is really testing
The project
Supplier Performance & Sourcing Decision Tracker
A structured Excel workbook that ingests mock supplier bid data, scores vendors across price, lead time, and quality metrics using formulas and pivot tables, and outputs a visual dashboard that flags the recommended supplier and highlights performance trends. This maps directly to the role's core tasks of comparing proposals, monitoring supplier performance, and pulling analyzed data for operations stakeholders.
- Build the data layer: Create three spreadsheet tabs, one with 6–8 fictional suppliers and columns for unit price, lead time (days), defect rate (%), and on-time delivery (%) across two mock bid rounds; one as a raw 'PO Log' with 20 rows of order history including supplier name, order date, quantity, and delivery status; and one as a 'Scorecard' tab that uses weighted Excel formulas (e.g., a 100-point composite score weighting price 40%, delivery 35%, quality 25%) to rank each supplier and auto-flag the top pick with a conditional formatting highlight.
- Add analysis with pivot tables and forecasting: Insert a pivot table on a fourth tab summarizing average lead time and defect rate by supplier, then use Excel's FORECAST.LINEAR function on the PO Log to project the next quarter's order volume for the top two suppliers, label this section 'Demand Forecast Support' to mirror the business forecasting language in the job description.
- Build the one-page dashboard: On a final 'Dashboard' tab, embed a clustered bar chart comparing all suppliers on the composite score, a line chart showing on-time delivery trend across both bid rounds, and a summary box using cell references (not typed text) that dynamically displays the recommended supplier name, its score, and a one-line sourcing rationale, format the tab so a recruiter opening the file lands here first and can read the story in under 60 seconds.
Free account. Provieo walks you through it and turns it into a page with a link you can put on your application. This posting comes with you.
Questions
Do I need to know how to code?
No. For roles like this one, Provieo builds the project as a live case-study page: slides, tables and findings you fill in. You bring the thinking.
Where did this project come from?
Provieo read the Northrop Grumman posting and generated it on 2026-10-21. If you paste the same posting yourself you may get a different project, so two applicants don't show up with the same one.
Is Provieo connected to Northrop Grumman?
No. This is an independent project idea based on a public posting. It does not guarantee an interview.