SALES BUDGET

Territory 1 Enero February March Quarter

1 1000 1125 1210 3335
In 2 600 650 675 1925
Units 3 925 900 960 2785
4 430 450 475 1355
TOTAL 2955 3125 3320 9400
33,000.00 37,125.00 39,930.00 110,055.00
19,800.00 21,450.00 22,275.00 63,525.00
In
Currency 30,525.00 29,700.00 31,680.00 91,905.00
14,190.00 14,850.00 15,675.00 44,715.00
TOTAL L. 97,515.00 L. 103,125.00 L. 109,560.00 L. 310,200.00
 PRODUCTION BUDGET IN PRODUCT UNITS
Enero Febrero Marzo Trimestre
Budgeted units to sell 2,955 3,125 3,320 9,400
Final Inventory of Finished Products 2,050 2,175 2,215 2,215
Available items for sale 5,005 5,300 5,535 11,615
(-) Initial Inventory of Finished Products 2,140 2,050 2,175 2,140
(=) Unidades a Producir 2,865 3,250 3,360 9,475

January
IIPT 2,175
CAM 3,360 is my unknown
Sales Cost Scheme of the Income Statement UMEDPV 5,535
IFPT2,215
CV= 3,320

if adding from top to bottom, subtract from bottom to top

if going from top to bottom subtracts, from bottom to top adds
 BUDGET FOR MATERIALS USE
January February March Trimester
Unidades a ProducirPIZARRAS 2,865.00 3,250.00 3,360.00 9,475.00
Units of material per unit of
(x) finished product 1 1 1 1
Total units of material
(=) required FORMICA DOCUMENTS 2,865.00 3,250.00 3,360.00 9,475.00 3,500
Unit cost of direct material 8.50 8.50 9.00 8.67
Total cost of materials to be used 24,352.50 27,625.00 30,240.00 82,217.50 April

PURCHASE BUDGET FOR MATERIALS

January February March
Units of material to be used 2,865 3,250 3,360 9,475
Final inventory of materials 1,950 2,016 2,100 2,100
Available material units 4,815 5,266 5,460 11,575
(-) Initial inventory of materials 1,719 1,950 2,016 1,719
Material units to purchase 3,096 3,316 3,444 9,856
Unit cost of direct material 8.50 8.50 9.00 8.67
Cost of materials to be purchased 26,316.00 28,186.00 30,996.00 85,418.67
 LABOR BUDGET
January February
Units to Produce 2,865 3,250
Hours per Finished Product Unit 2 2
Total hours to be used 5,730 6,500
Cost per hour 3.00 3.50
Direct Labor Cost 17,190.00 22,750.00
March Quarter
3,360 9,475
2 2
6,720 18,950
3.50 3.35
23,520.00 63,460.00
 Indirect Manufacturing Cost Sheet (5730 hours of MOD) for the month of January
2014
TYPE OF EXPENSE FIXED VARIABLE TOTAL
Indirect Materials L. 1,200.00 L. 1,200.00
Indirect Labor (variable L.0.50x5730 hours MOD) 1,500.00 2,865.00 4,365.00 MIXED
Supervision 1,250.00 1,250.00
Payroll Tax (var. L.0.30x5730 hours MOD) 1,719.00 1,719.00
Maintenance (variable L.0.20x5730 hours) 500.00 1,146.00 1,646.00
Heating and light (variable L.0.10x 5730) 600.00 573.00 1,173.00
Energy (variable L.0.12x5730) 450.00 687.60 1,137.60
Insurance 650.00 650.00
Taxes 1,000.00 1,000.00
Depreciation 3,000.00 3,000.00
Various (variablesL.0.15x5730) 859.50 859.50
TOTAL INDIRECT MANUFACTURING COSTS L. 10,150.00 L. 7,850.10 L. 18,000.10
MOD HOURS

2014
TYPE OF EXPENSE FIXED VARIABLE TOTAL
Indirect Materials L. 1,200.00 L. 1,200.00
Indirect Labor (variable L.0.50x6500 hours) 1,500.00 3,250.00 4,750.00
Supervision 1,250.00 1,250.00
Payroll Tax (var. L.0.30x6500 hours) 1,950.00 1,950.00
Maintenance (variable L.0.20x6500 hours) 500.00 1,300.00 1,800.00
Heating and light (variable L.0.10x 6500) 600.00 650.00 1,250.00
Energy (variable L.0.12x6500) 450.00 780.00 1,230.00
Insurance 650.00 650.00
Taxes 1,000.00 1,000.00
Depreciation 3,000.00 3,000.00
Various (variablesL.0.15x6500) 975.00 975.00
TOTAL INDIRECT MANUFACTURING COSTS L. 10,150.00 L. 8,905.00 L. 19,055.00

2014
TYPE OF EXPENSE FIXED VARIABLE TOTAL
Indirect Materials L. 1,200.00 L. 1,200.00
Indirect Labor (variable L.0.50x6720 hours) 1,500.00 3,360.00 4,860.00
Supervision 1,250.00 1,250.00
Payroll Tax (var. L.0.30x6720 hours) 2,016.00 2,016.00
Maintenance (variable L.0.20x6720 hours) 500.00 1,344.00 1,844.00
Heating and light (variable L.0.10x 6720) 600.00 672.00 1,272.00
Energy (variable L.0.12x6720) 450.00 806.40 1,256.40
Insurance 650.00 650.00
Taxes 1,000.00 1,000.00
Depreciation 3,000.00 3,000.00
Various (variablesL.0.15x6720) 1,008.00 1,008.00
TOTAL INDIRECT MANUFACTURING COSTS L. 10,150.00 L. 9,206.40 L. 19,356.40
 FINAL INVENTORY BUDGET
Units Unit Cost Total
Inventory of direct materials, end of month:
January 1,950 8.50 16,575.00
February 2,016 8.50 17,136.00
March 2,100 9.00 18,900.00
1 de enero de 2019 (inventario inicial) 1,719 8.50 14,611.50
Finished goods inventory, end of month:
January 2,050 20.7828 42,604.65
February 2,175 21.3631 46,464.69
March 2,215 21.7608 48,200.25
January 1, 2019 (initial inventory) 2,140 20.1100 43,035.40
 COST OF SALES
January February
Direct Material 24,352.50 27,625.00
Direct Labor 17,190.00 22,750.00
(+) CIF 18,000.10 19,055.00
Cost of Production 59,542.60 69,430.00
(/) Unidades Producidas 2,865 3,250
(=)Costo de Producción Unitario 20.7828 21.3631

COST OF SALES
January February
Direct Material 24,352.50 27,625.00
Direct Labor 17,190.00 22,750.00
(+) CIF 18,000.10 19,055.00
Production Cost 59,542.60 69,430.00
Initial Inventory of Finished Goods 43,035.40 42,604.65
(=) Mercaderia disponible para la venta 102,578.00 112,034.65
Final Inventory of Finished Goods 42,604.65 46,464.69
Cost of Sales 59,973.35 65,569.96
 March Quarter
30,240.00 82,217.50
23,520.00 63,460.00
19,356.40 56,411.50
73,116.40 202,089.00
3,360 9,475
21.7608 21.3287

March Quarter
30,240.00 82,217.50 Ppto Uso Mat
23,520.00 63,460.00 Labor cost
19,356.40 56,411.50 CIF Budget
73,116.40 202,089.00 Sum of the 3 cost elements
Final Inventory Value
119,581.09 245,124.40
Final Inventory Value 48,200.25
71,380.85 196,924.15
Sales expense budget; L.97,515 in sales in lempiras for e
Fijos Variables Total
Salaries 3,000.00 3,000.00
Commissions (3% of L.97,515.00) 2,925.45 2,925.45
Trips (2% x 97,515.00) 1,950.30 1,950.30
Advertising (1% x L.97,515.00) 975.15 975.15
Depreciation 1,000.00 1,000.00
Bad Debts (1% x L.92,115.00) 921.15 921.15
Various 800.00 800.00
Total Gastos de ventas 4,800.00 6,772.05 11,572.05

Sales expense budget; L.103,125 in sales in lempiras for

Fijos Variables Total

Salaries 3,000.00 3,000.00
Commissions (3% x L.103,125.00) 3,093.75 3,093.75
Trips (2% x 103,125.00) 2,062.50 2,062.50
Advertising (1% x L.103,125.00) 1,031.25 1,031.25
Depreciation 1,000.00 1,000.00
Uncollectible Accounts (1% x L.96,925.00) 969.25 969.25
Various 800.00 800.00
Total Gastos de ventas 4,800.00 7,156.75 11,956.75

Sales expense budget; L.109,560 in sales in lempiras for m

Fijos Variables Total

Salaries 3,000.00 3,000.00
Commissions (3% x L.109,560.00) 3,286.80 3,286.80
Travel (2% x 109,560.00) 2,191.20 2,191.20
Advertising (1% x L.109,560.00) 1,095.60 1,095.60
Depreciation 1,000.00 1,000.00
Bad Debts (2% x L.102,060.00) 1,020.60 1,020.60
Various 800.00 800.00
Total Sales Expenses 4,800.00 7,594.20 12,394.20
 Administrative Expenses Budget
January 2019 TYPE OF EXPENSE

Salaries of the executives $2,800.00

Office Salaries 500.00
Insurance 400.00
January
Taxes 200.00 February
Depreciation 800.00 and March
Various 500.00
Total 5,200.00

February 2019

March 2019
 BUDGETED INCOME STATEMENT
January February
Sales 97,515.00 103,125.00
(-) Cost of Sales 59,973.35 65,569.96
Gross Margin in Sales 37,541.65 37,555.04
(-) Operating Expenses 6,372.05 6,756.75
Operating Utility 31,169.60 30,798.29
(+/- Financial Income and Expenses 0.00 0.00
(+/- Other Income and Other Expenses 0.00 0.00
(=) Utlidad antes de Impuesto sobre la Renta 31,169.60 30,798.29
(-) Income Tax 25% 7,792.40 7,699.57
Utility after Tax 23,377.20 23,098.72
(-) Legal Reserve 5% of the UDI 1,168.86 1,154.94
Utility after Legal Reserve 22,208.34 21,943.78
(-) Dividends 0.00 0.00
(=) Utlidad Neta 22,208.34 21,943.78
 March Quarter
109,560.00 310,200.00
71,380.85 196,924.15
38,179.15 113,275.85
7,194.20-20,323.00
30,984.95 92,952.85
0.00 0.00
0.00 0.00
30,984.95 92,952.85
7,746.24 23,238.21
23,238.72 69,714.63
1,161.94 3,485.73
22,076.78 66,228.90
0.00 0.00
22,076.78 66,228.90