**TI82** TxtView file generated by CalcText - Kouri] NBudgetNLÿoperating budget1. Sales budget Jan Feb Mar Q1 # unit sold 2100 2200 2300 6600 sales (excl. VAT) € 42,000 € 44,000 € 46,000 € 132,000 sales (incl. VAT) € 50,400 € 52,800 € 55,200 € 158,400 (A/R) collectible cash from sales € 0 € 0 € 0 € 0 Beg. A/R € 43,200 € 48,000 € 50,400 € 141,600 A/R Cash inflow € 43,200 € 48,000 € 50,400 € 141,600 € (A/R)158,400 2. COGS budget 2a. Production budget Jan Feb Mar Q1 # unit sold 2100 2200 2300 6600 Ending inventory 0 0 0 Beginning inventory 0 0 0 April # unit production 2100 2200 2300 6600 2400 2b. DM budget Jan Feb Mar Q1 Used material (DM) € 8,400 € 8,800 € 9,200 € 26,400 Ending inventory € 8,800 € 9,200 € 9,600 Beginning inventory € 8,400 € 8,800 € 9,200 purchased material € 8,800 € 9,200 € 9,600(inventories raw materials) € 27,600 purchased material (incl. VAT) € 10,560 € 11,040 € 11,520 € 33,120 A/P payable cash from expense € 10,560 € 22,560 (février mars purchased mat including vat) Beg. A/P € 10,000 € 10,000 Cash outflow (DM) € 10,000 € 10,000 € 10,560 € 30,560 2c. DL + OH budget Jan Feb Mar Q1 Net salary wages € 16,000 € 16,000 € 16,000 € 48,000 Social charges € 12,000 € 12,000 € 12,000 € 36,000 other production expense € 1,400 € 1,400 € 1,400 € 4,200 Total DL + OH € 29,400 € 29,400 € 29,400 € 88,200 Social charge payable payable cash from expense € 17,680 € 29,680 € 29,680 € 77,040 € 12,000 Beg. Social charges payable € 12,000 Cash outflow (DL+OH) € 29,680 € 29,680 € 29,680 € 89,040 2d. COGS Jan Feb Mar Q1 COGS (=DM+DL+OH) € 37,800 € 38,200 € 38,600 € 114,600 <- no inventories for finished goods 3. SGA budget depreciation € 2,400 € 2,400 € 2,400 € 7,200 additional equipment depreciation (new equipment) € 200 € 200 € 24,000 Interest on loan € 200 € 200 € 200 € 600 Total SGA € 2,600 € 2,600 € 2,800 € 8,000 Cash outflow € 200 € 200 € 200 € 600 4. Income statement Jan Feb Mar Q1 Sales € 42,000 € 44,000 € 46,000 € 132,000 COGS € 37,800 € 38,200 € 38,600 € 114,600 GM € 4,200 € 5,800 € 7,400 € 17,400 SGA € 2,600 € 2,600 € 2,800 € 8,000 Operating income € 1,600 € 3,200 € 4,600 € 9,400 5. VAT Budget Jan Feb Mar Beg. VAT payable € 6,400 € 6,360 € 6,680 VAT paid -€ 6,400 -€ 6,360 -€ 6,680 VAT (Sales) € 8,400 € 8,800 € 9,200 VAT (Material) -€ 1,760 -€ 1,840 -€ 1,920 VAT (other production expense) -€ 280 -€ 280 -€ 280 VAT (new equipment) -€ 4,800 End. VAT payable € 6,360 € 6,680 € 2,200 6. Cash budget Jan Feb Mar Beg. Cash € 3,000 -€ 1,880 -€ 1,920 Cash (+) (sales) € 43,200 € 48,000 € 50,400 Cash (-) (DM) -€ 10,000 -€ 10,000 -€ 10,560 Cash (-) (DL+OH) -€ 29,680 -€ 29,680 -€ 29,680 Cash (-) (SGA) -€ 200 -€ 200 -€ 200 Cash (-) (VAT) -€ 6,400 -€ 6,360 -€ 6,680 Equipment payable Cash (-) (new equipment) -€ 14,400 € 14,400 Cash (-) (loan repayment) -1800 -1800 -1800 bank loan End. Cash -€ 1,880 -€ 1,920 -€ 14,840 € 39,600 7. B/S (as of Mar 31) Assets Liabilities and equity Fixed assets € 188,000 Capital € 160,000 Accumulative depreciation-€ 64,400 Retained earning € 26,000 Inventories (Raw material) € 9,600 Bank loan € 39,600 Account receivable € 158,400 Equipment payable € 14,400 Cash (shortage) -€ 14,840 Social charge payable € 12,000 VAT payable € 2,200 Account payable € 22,560 Total assets € 276,760 Total liabilities and equity € 276,760ÿ7Â