Budgeted income statement

$1$st Month $2$nd Month $3$rd Month $4$th Month Sum of months $1-3$

First quarter

Sales $$81,250$ $$121,875$ $$162,500$ $$138,125$ $$365,625$

Project quantity $10,00015,00020,00017,000$ $$45,000$

Beginning FG inventory $100010500650015200$ $$18,000$

Desired FG inventory $100010500650015200$ $$18,000$

Produced items $105006500152001800$ $$32,200$

Material cost $6300390091201080$ $$19,320$

Direct labour cost $122507583\mathrm{.}33333317733\mathrm{.}333332100$ $$37,567$

Gross margin $($costs of less sales$)$ $$62,700$ $$110,392$ $$135,647$ $$134,945$ $$308,738$

Manufacturing overhead

Supplies $21013030436644$

Inspection $105065015201803220$

Maintenance and repair $31519545654966$

Utilities $1056515218322$

Fixed overhead $$1,000$ $$1,000$ $$1,000$ $$1,0003000$

S & A

Commission $21013030436644$

Delivery $1056515218322$

Office supplies $21013030436644$

Fixed S & A $15001500150015004500$

Total overhead and S & A $470538655692287814262$

Net income $$57,995$ $$106,527$ $$129,955$ $$132,067$ $$294,476$

Base $205,708$

Change $$88,768$