book1

3
SEYMORE CORPS MONTH sale act. Production Beginning Inventory workforce january 1250 1500 1000 60 february 1250 1700 1450 68 march 1250 1900 2100 76 april 2500 2100 1700 84 may 2500 2250 1450 90 june 2500 2250 1200 90 july 2667 2250 783 90 august 2667 2275 391 91 september 2666 2275 0 91 october 666 2275 1609 91 november 667 2275 3217 91 december 667 2275 4825 91 hiring cost firing cost work cost OT cost $6,200.00 $0.00 $405,200.00 $0.00

Upload: priambodo-ariewibowo

Post on 17-Nov-2015

212 views

Category:

Documents


0 download

DESCRIPTION

aa

TRANSCRIPT

Sheet1SEYMORE CORPSMONTHsaleact. ProductionBeginning Inventoryworkforceending inventoriovertimehiredfiredmax reg prodmax ottotalinv cost per monthjanuary12501500100060145000015002501500870february125017001450682100080170025017001260march125019002100761700080190025019001020april25002100170084145008021002502100870may25002250145090120006022502502250720june2500225012009078300022502502250469.8july266722507839039100022502502250234.6august26672275391910010227525022750september26662275091160900022752502275965.4october66622751609913217000227525022751930.2november66722753217914825000227525022752895december66722754825916433000227525022753859.8hiring costfiring costwork costOT costInv. Costtotal$6,200.00$0.00$405,200.00$0.00$15,094.80$426,494.80

Sheet2

Sheet3