# Mexico Maquiladora Monthly Cost Worksheet > Source: https://netray.co/tools/mexico-maquiladora-monthly-cost-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Budget the monthly and annual operating cost of a Mexican plant line by line: headcount, shelter fees, rent, utilities, customs brokerage and freight. ## Category cost-finance ## Region Mexico ## Industry Maquiladora ## Audience - Plant manager - Finance lead - Nearshoring project lead ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Cost line **Key:** line **Type:** text #### Category **Key:** category **Type:** select **Options:** - Direct labor - Indirect labor - Shelter or admin fee - Facility - Utilities - Customs and trade - Logistics - Other #### Basis **Key:** basis **Type:** text #### Rate per month **Key:** rate **Type:** number **Format:** currency #### Quantity **Key:** qty **Type:** number #### Monthly cost **Key:** monthly **Type:** number **Expr:** rate * qty **Format:** currency #### Annual cost **Key:** annual **Type:** number **Expr:** rate * qty * 12 **Format:** currency **Rows:** **Line:** Production operators (fully loaded) **Category:** Direct labor **Basis:** per employee **Rate:** 1350 **Qty:** 60 **Line:** Line supervisors **Category:** Indirect labor **Basis:** per employee **Rate:** 2600 **Qty:** 4 **Line:** Process and quality engineers **Category:** Indirect labor **Basis:** per employee **Rate:** 3800 **Qty:** 3 **Line:** Shelter administration fee **Category:** Shelter or admin fee **Basis:** per employee **Rate:** 250 **Qty:** 67 **Line:** Industrial building lease **Category:** Facility **Basis:** per sq ft **Rate:** 0.6 **Qty:** 60000 **Line:** Electricity, water, gas **Category:** Utilities **Basis:** flat **Rate:** 9500 **Qty:** 1 **Line:** Customs broker fees **Category:** Customs and trade **Basis:** per pedimento **Rate:** 120 **Qty:** 180 **Line:** Cross-border truckload freight **Category:** Logistics **Basis:** per load **Rate:** 1450 **Qty:** 24 **Line:** Transport, canteen, security **Category:** Other **Basis:** per employee **Rate:** 120 **Qty:** 67 **Totals:** #### Total monthly cost **Key:** monthly **Agg:** sum **Format:** currency #### Total annual cost **Key:** annual **Agg:** sum **Format:** currency **Summary:** #### Average cost per line item **Key:** avg_line **Expr:** sum_monthly / count **Format:** currency #### Largest single monthly line **Key:** largest **Expr:** max_monthly **Format:** currency **Primary:** true **Notes:** Example figures are illustrative ranges, not quotes. Replace them with your own wage surveys, lease and shelter proposals. Divide the monthly total by planned monthly output to get cost per unit. Wage levels and statutory costs (social security, profit sharing, Christmas bonus, vacation premium) vary by city and change often; the labor rate should be fully loaded. ## Content **Intro:** A maquiladora or shelter budget is mostly headcount, but the lines that surprise people are the fees, customs and freight around the plant. This worksheet lets you build the monthly and annual cost line by line and export it for approval. **Sections:** #### How to use the worksheet **Body:** Edit the example rows: for each cost line enter the monthly rate per unit of the basis and the quantity. Monthly and annual cost compute automatically, and the totals update as you add or delete rows. Create one version per scenario, such as a 60 operator ramp, a 150 operator steady state, or a shelter versus own-entity structure, and compare the totals. Export to Excel for the finance review. #### What belongs in a fully loaded labor rate **Body:** The labor rate must be the full cost to the employer, not the wage. Besides salary, include social security and housing fund contributions, the state payroll tax, the mandatory year-end bonus (aguinaldo), vacation premium, profit sharing where applicable, attendance and productivity bonuses, uniforms and training. Many models also add turnover cost, because border cities can see high attrition. Use your own surveys and a local payroll provider for the real figure. **Bullets:** - Statutory contributions and payroll taxes - Annual bonus, vacation premium and profit sharing - Transport, meals and attendance incentives - Recruiting and training for turnover #### Shelter versus own entity **Body:** Under a shelter arrangement the provider employs the staff, holds the program authorization and charges a fee, often per employee plus a share of costs. An own entity gives control but requires incorporation, tax and customs capabilities. Capture the shelter fee as its own line so you can compare. Remember that fees, minimum commitments and exit terms are in the contract, not the budget. #### Common mistakes **Body:** Budgets often leave out cross-border logistics, customs brokerage, scrap, tooling transfers and the finance cost of inventory held across the border. Treat the worksheet as the operating baseline, then add the one-time setup cost and working capital separately. Review it with the plant controller each quarter against actuals. **Cta:** If you are comparing a Mexican plant with an existing site, we can help pull actual cost data from your ERP so the worksheet starts from your numbers. **Faq:** #### What is a maquiladora? **Answer:** A maquiladora is a Mexican operation that assembles or manufactures goods for export, typically under the IMMEX program, importing inputs temporarily without up-front duties. Many are run by foreign companies, directly or through a shelter provider. #### Are the example rates accurate for my city? **Answer:** No. They are illustrative. Wages, rents and fees vary by city, industry and year. Replace every rate with quotes and surveys before using the output in a decision. #### How do I get cost per unit? **Answer:** Divide the total monthly cost by planned monthly output. Add materials, scrap, tooling and logistics beyond the plant to compare against another site on a landed cost basis. #### Does the worksheet include taxes? **Answer:** Only what you enter. Payroll taxes belong in the labor rate. Corporate income tax, VAT recovery and transfer pricing need separate analysis with a tax professional. ## Search terms maquiladora cost worksheet, maquiladora budget template, mexico manufacturing cost excel, shelter company cost model, mexico plant operating cost, nearshoring cost template, maquila cost per employee, tijuana juarez monterrey plant cost --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json