Absorption, Variable, and Activity Based Costing

profilekeafemaral76
Markl_S_M2A2b.xlsx

Sheet1

CALCULATING REVENUE
BEDROOMS APARTMENT UNITS AMOUNT OF UNITS PRICE/MONTHLY PRICE/ YEARLY
0 STUDIO APARTMENT UNITS 24 $2,225.00 $26,700.00
1 ONE BEDROOM APARTMENT UNITS 24 $2,655.00 $31,860.00
2 TWO BEDROOMS APARTMENT UNITS 24 $3,420.00 $41,040.00
3 THREE BEDROOMS APARTMENTS UNITS 24 $4,735.00 $56,820.00
4 FOUR BEDROOMS APARTMENT UNITS 24 $5,225.00 $62,700.00
120 $18,260.00 $219,120.00
COST DRIVERS
DIRECT MATERIAL AMOUNT FOR THE MATERIAL YEARLY
FLOWER $500.00
MULCH $500.00
GRASS SEED $250.00
SHOWER HEADS $1,500.00
TOILET SEATS $2,000.00
DOOR KNOBS $2,000.00
LOCKS $3,000.00
CARPET $5,000.00
FAUCET $2,000.00
STOVES $10,000.00
REFRIGERATOR $10,000.00
MICROWAVES $5,000.00
CABINETTE $1,000.00
DISHWASHERS $5,000.00
WASHER $5,000.00
DRYERS $5,000.00
TOTALING $57,750.00
DIRECT LABOR COST THE AMOUNT OF WORKERS BI WEEKLY PAY YEARLY PAY
MAINTENTANCE STAFF 2 $1,500.00 $9,000.00
ADMINISTRATION STAFF 1 $1,360.00 $16,320.00
MANAGEMENT 1 $1,600.00 $19,200.00
$4,460.00 $44,520.00
OVERHEAD COST MONTHLY YEARLY
RENTAL FEES $3,000.00 $36,000.00
INSURANCE $1,000.00 $1,200.00
UTILITIES $500.00 $6,000.00
REPAIRS FEE $250.00 $3,000.00
ADVERTISEMENT FEES $100.00 $1,200.00
$4,850.00 $47,400.00
YEARLY PROFITS YEARLY TOTALS
REVENUE $219,252.00
DIRECT MATERIALS $57,750.00
DIRECT LABOR $44,520.00
OVERHEAD $47,400.00
TOTAL PROFIT $69,582.00