schedule thesis

40
Assets Equipment PCS UNIt Cost per unit Stand 10 1,000.00 Mobile 2 110,000.00 Air Compressor 1 8,720.00 Chocolate Fountain 2 3,000.00 Videoke 2 21,000.00 Balloon Printing Machine 1 50,000.00 TOTAL Booth Tent Delivery Equipment Truck/Closed Van 1 200,000.00 Furniture & Fixtures Long Table 6 2,500.00 Tables for Adults 34 750.00 Chairs for Adults 204 300.00 Tables & Chairs for Ki 7 3,800.00 TOTAL Prepaid Rent 3000 per month 2 2 months advance 2 2 months deposit Organization Costs Business Licenses & Permit Sec Filing & Registration Community Tax BIR Registration Barangay Clearance Others

Upload: mykel

Post on 18-Nov-2015

9 views

Category:

Documents


0 download

DESCRIPTION

thesis sced

TRANSCRIPT

investmentAssetsEquipmentPCSUNItCost per unitTotal CostSUPPLIESMONTHLY EXPENSEStand101,000.0010,000.00Table Clothtwice a year- 0Mobile2110,000.00220,000.00Cloth4030.001,200.00to be replenished per use- 0100.00Air Compressor18,720.008,720.00Labor1,500.00to be replenished per use- 0Chocolate Fountain23,000.006,000.00Chair Cloth100.00100.00every year39,360.00Videoke221,000.0042,000.00Cloth20430.006,120.00to be replenished per use1,200.00Balloon Printing Machine150,000.0050,000.00Labor1,500.006,300.00TOTAL336,720.00Balloons2,750.00Sticks1605.00800.001,050.00BoothGlobos 10200.002,000.00800.00Tent1,500.00Long Balloons5100.00500.001,000.00Party Decors123,280.0039,360.00Delivery EquipmentRibbons6020.001,200.00Truck/Closed Van1200,000.00200,000.00Dcor paper1085.00540200,000.00POP for standee9700.006,300.00Furniture & FixturesHats5505.002,750.00Long Table62,500.0015,000.00Chocolate Syrup7150.001,050.00Tables for Adults34750.0025,500.00Poppers2040.00800.00Chairs for Adults204300.0061,200.00Banner5020.001,000.00Tables & Chairs for Kids73,800.0026,600.00TOTAL66,720.00TOTAL128,300.00

Prepaid Rent3000per monthWORKING CAPITAL22 months advance6,000.00Salaries Expense12,000.0022 months deposit6,000.0012,000.00Electricity Expense500.00Rent Expense3,000.0012,000.00Organization CostsTOTAL15,500.00500.00Business Licenses & Permit5,200.00Multiply by 3 months3.003,000.0015,500.00Sec Filing & Registration2,800.003 months46,500.00Community Tax500.00Working Capital (3 months)BIR Registration500.00Barangay Clearance500.0082,220.00Others3,000.0012,500.00

Sales & COSPackage 130 paxUNITPRICEABPackage 270 paxUNITPRICEABPackage 3100 paxUNITPRICEABPackagesSETPriceCostGross ProfitTables 5 pcs (round)520.00100.00Tables 12 pcs (round)1220.00240.00Tables 17 pcs (round)1720.00340.001A10,0007,1752,825w/cover525.00125.00w/cover1225.00300.00w/cover1725.00425.00B10,0006,8753,125Chairs 30 pcs3010.00300.00Chairs 72 pcs7210.00720.00Chairs 102 pcs10210.001,020.002A15,0008,1956,805w/ cover3015.00450.00w/ cover7215.001,080.00w/ cover10215.001,530.00B15,0008,2456,755Mobile w/ Lights3,000.003,000.00Mobile w/ Lights3,000.003,000.00Mobile w/ Lights3,000.003,000.003A20,0009,41510,585Balloons Balloons Balloons B20,0009,86510,135w/stick205.00100.00100.00w/stick605.00300.00300.00w/stick805.00400.00400.00Centerpiece515.0075.00Centerpiece1215.00180.00Centerpiece1715.00255.00ClassPopulationTargetNumberParty DecorationsParty DecorationsParty DecorationsAFP3,8771%39Ribbons1220.00240.00240.00Ribbons2420.00480.00480.00Ribbons6020.001,200.001,200.00Bus. Owners1,5501%16Dcor paper365.00180.00180.00Dcor paper365.00180.00180.00Dcor paper365.00180.00180.00Laborers5,4271%54Giveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsOthers4,6521%46Standee315.0045.0045.00Standee315.0045.0045.00Standee315.0045.0045.00Banner50.0050.00Banner70.0070.00Banner70.0070.00Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Long Table30.0030.00Long Table30.0030.00Long Table30.0030.00Target CustomersAFPBus. OwnersLaborersOthersTOTALVideoke700.00700.00Videoke700.00700.00Videoke700.00700.001A74182049A. Kids PartyA. Kids PartyA. Kids PartyB317525Clown700.00Clown700.00Clown700.002A19781044Face Painting500.00Face Painting500.00Face Painting500.00B57517hats305.00150.00hats305.00150.00hats305.00150.003A554620B. DebutB. DebutB. DebutBChocolate Fountain500.00Chocolate Fountain500.00Chocolate Fountain500.0039165446155Syrup2150.00300.00Syrup2150.00300.00Syrup3150.00450.00EmployeesEmployeesEmployeesDriver250.00250.00Driver250.00250.00Driver250.00250.00PackagesSETCustomersSalesCostGross ProfitParty Crew 3250.00750.00750.00Party Crew 3250.00750.00750.00Party Crew 3250.00750.00750.001A49490,000351,575138,4257,175.006,875.008,195.008,245.009,415.009,865.00B25250,000171,87578,1252A44660,000360,580299,420B17255,000140,165114,8353A20400,000188,300211,700B0000TOTAL2,055,0001,212,495842,505

171250

12.9166666667

ExpensesSalaries1200012144000Payroll registerContinuing Franchise FeeRent30001236000Utilities500126000DepreciationERROR:#REF!12ERROR:#REF!depreciation scheduleAmortizationEmployer's Payroll Expense343.00124116employers payroll expensw13th Month PayProfessional FeeTaxes and LicensesRepairs and Maintenance12001214400Miscellaneous Expense500126000ERROR:#REF!EMPLOYER'S PAYROLL EXPRENSE SEMI MONTHLYNAMEMONTHLY SALARYSSSPHILHEALTHPAGIBIGTOTALELIROSE MAYO12,000.00218.0075.0050.00343.00PAYROLL REGISTERNAMESTATUSGROSS PAYSSSPHILHEALTHPAGIBIGW/ TAXTOTALNET PAYELIROSE MAYOS6,000.00447.0075.0050.00418.42990.425,009.58ASalaries ExpensePAYROLL REGISTERNAMESTATUSGROSS PAYSSSPHILHEALTHPAGIBIGW/ TAXTOTALNET PAYELIROSE MAYOS12,000.00436.00150.00100.001,786.752,472.759,527.25Multiply by 12 months12121212121212Annual Total144,000.005,232.001,800.001,200.0021,441.0029,673.00114,327.00

BRent ExpenseMonthly Rent3,000.00Multiply by 12 months12Annual Rent36,000.00

CUtilitiesExpenseELECTRICITY500.00Multiply by 12 months12Annual Total6,000.00

DDEPRATION EXPENSEEQUIPMENTCostUseful LifeDepreciationMobile220,000.00544,000.00Air Compressor8,720.0024,360.00Chocolate Fountain6,000.0023,000.00Videoke42,000.0058,400.00Balloon Printing Machine50,000.00510,000.00326,720.0069,760.00EEMPLOYER'S PAYROLL EXPENSENAMEMONTHLY SALARYSSSPHILHEALTHPAGIBIGTOTALELIROSE MAYO12,000.00894.00150.00100.001,144.00Multiply by 12 months1212121212Annual Total144,000.0010,728.001,800.001,200.0013,728.00

FORGANIZATION COSTCOSTBusiness Licenses & Permit5,200.00Sec Filing & Registration2,800.00Community Tax500.00BIR Registration500.00Barangay Clearance500.00Others3,000.0012,500.00

GREPAIRS AND MAINTENANCE2,500.00

FMISCELLANEOUS500.00

Inventory & suppliesPackage 130 paxUNITPRICEABPackage 270 paxUNITPRICEABPackage 3100 paxUNITPRICEABSUPPLIESEQUIPMENT/FURNITUREEQUIPMENT/FURNITUREEQUIPMENT/FURNITURETables 5 pcs (round)520.00100.00Tables 12 pcs (round)1220.00240.00Tables 17 pcs (round)1720.00340.00w/cover525.00125.00w/cover1225.00300.00w/cover1725.00425.00Chairs 30 pcs3010.00300.00Chairs 72 pcs7210.00720.00Chairs 102 pcs10210.001,020.00w/ cover3015.00450.00w/ cover7215.001,080.00w/ cover10215.001,530.00Mobile w/ Lights3,000.003,000.00Mobile w/ Lights3,000.003,000.00Mobile w/ Lights3,000.003,000.00InventoryLong Table30.0030.00Long Table30.0030.00Long Table30.0030.00BalloonsVideoke700.00700.00Videoke700.00700.00Videoke700.00700.00Sticks1605.00800.00B. DebutB. DebutB. DebutGlobos 10200.002,000.00Chocolate Fountain500.00Chocolate Fountain500.00Chocolate Fountain500.00Long Balloons5100.00500.004,130.004,805.004,690.005,610.005,090.006,185.00Party Decors123,280.0039,360.00Ribbons6020.001,200.00SUPPLIESDcor paper1085.00540.00Balloons Balloons Balloons POP for standee9700.006,300.00w/stick205.00100.00100.00w/stick605.00300.00300.00w/stick805.00400.00400.00Hats5505.002,750.00Centerpiece515.0075.00Centerpiece1215.00180.00Centerpiece1715.00255.00Chocolate Syrup7150.001,050.00Party DecorationsParty DecorationsParty DecorationsPoppers2040.00800.00Ribbons1220.00240.00240.00Ribbons2420.00480.00480.00Ribbons6020.001,200.001,200.00Banner5020.001,000.00Dcor paper365.00180.00180.00Dcor paper365.00180.00180.00Dcor paper365.00180.00180.0056,300.00Beginning Supplies112,600.00Giveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsAdd:Purchases195,870.00Standee315.0045.0045.00Standee315.0045.0045.00Standee315.0045.0045.00Supplies Available308,470.00Banner50.0050.00Banner70.0070.00Banner70.0070.00Less:Ending Supplies112,600.00Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Cost of Sales (Supplies)195,870.00A. Kids PartyA. Kids PartyA. Kids Partyhats305.00150.00hats305.00150.00hats305.00150.00B. DebutB. DebutB. Debut

Syrup2150.00300.00Syrup2150.00300.00Syrup3150.00450.00CustomersCost of Sales (Supplies)Cost of Sales (Labor)Cost of Sales (Depreciation)845.001,070.001,305.001,635.002,125.002,680.00A49845.0041,405.002,200.00107,800.004,130.00202,370.00B251,070.0026,750.001,000.0025,000.004,805.00120,125.00LABORA441,305.0057,420.002,200.0096,800.004,690.00206,360.00A. Kids PartyA. Kids PartyA. Kids PartyB171,635.0027,795.001,000.0017,000.005,610.0095,370.00Clown700.00Clown700.00Clown700.00A202,125.0042,500.002,200.0044,000.005,090.00101,800.00Face Painting500.00Face Painting500.00Face Painting500.00B02,680.00- 01,000.00- 06,185.00- 0EmployeesEmployeesEmployees195,870.00290,600.00726,025.00Driver250250Driver250250Driver250250Party Crew 3250.00750.00750Party Crew 3250.00750.00750Party Crew 3250.00750.00750486,470.001,212,495.002,200.001,000.002,200.001,000.002,200.001,000.007,175.006,875.008,195.008,245.009,415.009,865.00

Profitability Ratios

Return on InvestmentPayback PeriodPeriodNet Operating IncomeAve. Total AssetsROIPeriodEstimated Project CostNet IncomeTimeYear 11,034,3932,072,21649.92%Year 11,228,100724,0751Year 21,308,4322,346,37155.76%Year 2504,025915,9030.55Year 31,631,1152,901,74556.21%Payback Period 1.55Year 41,985,5293,449,49957.56%1 year & 198 daysYear 52,399,2313,951,42560.72%

Financial ratios

Package 1Package 2Package 3Package 130 paxUNITPRICEABPackage 270 paxUNITPRICEABPackage 3100 paxUNITPRICEABAShort Term Solvency & LiquiditySUPPLIESABABABTables 5 pcs (round)520.00Tables 12 pcs (round)1220.00Tables 17 pcs (round)1720.00Table Clothw/cover525.00w/cover1225.00w/cover1725.00Year 1Year 2Year 3Year 4Year 5Cloth4030.001,200.00Chairs 30 pcs3010.00Chairs 72 pcs7210.00Chairs 102 pcs10210.00Current Assets1,488,5602,179,3132,885,1943,355,7073,983,433Labor1,500.00w/ cover3015.00w/ cover7215.00w/ cover10215.00Current Liabilities409,671500,030605,756721,864856,755Chair Cloth100.00100.00Mobile w/ LightsMobile w/ LightsMobile w/ Lights3.633554.358374.762974.648674.64944Cloth20430.006,120.00Balloons Balloons Balloons Current Ratio3.63 : 14.35 : 14.76 : 14.65 :14.65 : 1Labor1,500.00w/stick205.00100.00100.00w/stick605.00300.00300.00w/stick805.00400.00400.00BalloonsCenterpiece515.0075.00Centerpiece1215.00180.00Centerpiece1715.00255.00Year 1Year 2Year 3Year 4Year 5Sticks1605.00800.00202060608080Party DecorationsParty DecorationsParty DecorationsQuick Assets1,288,5601,979,3132,685,1943,155,7073,783,433Globos 10200.002,000.00121536365050Ribbons1220.00240.00240.00Ribbons2420.00480.00480.00Ribbons6020.001,200.001,200.00Current Liabilities409,671500,030605,756721,864856,755Long Balloons5100.00500.0081024363047Dcor paper365.00180.00180.00Dcor paper365.00180.00180.00Dcor paper365.00180.00180.003.145353.958394.432804.371614.41600Party Decors123,280.0039,360.00Giveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsQuick Ratio2.15 : 13.96 : 14.43 : 14.37 : 14.41 :1Ribbons6020.001,200.00121224246060Standee315.0045.0045.00Standee315.0045.0045.00Standee315.0045.0045.00Dcor paper1085.00540.00363636363636Banner50.0050.00Banner70.0070.00Banner70.0070.00Year 1Year 2Year 3Year 4Year 5POP for standee9700.006,300.00333333Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Current Assets1,488,5602,179,3132,885,1943,355,7073,983,433Hats5505.002,750.003030Long TableLong TableLong TableCurrent Liabilities409,671500,030605,756721,864856,755Chocolate Syrup7150.001,050.0022VideokeVideokeVideoke1,078,8881,679,2832,279,4392,633,8433,126,678Poppers2040.00800.002222A. Kids PartyA. Kids PartyWorking Capital1,078,8881,679,2832,279,4392,633,8433,126,678Banner5020.001,000.001111ClownClownBeginning Supplies66,720.00Face PaintingFace PaintingAdd:Purchases216,870.00CustomersCost of Sales (Supplies)Cost of Sales (Labor)hats305.00150.00hats305.00150.00hats305.00150.00Year 1Year 2Year 3Year 4Year 5Supplies Available283,590.00A49845.0041,405.002,200.00107,800.00B. DebutB. DebutB. DebutWorking Capital1,078,8881,679,2832,279,4392,633,8433,126,678Less:Ending Supplies66,720.00B251,570.0039,250.001,000.0025,000.00Chocolate Fountain500.00Chocolate Fountain500.00Chocolate Fountain500.00Total Assets2,072,2162,620,5263,182,9643,716,0334,186,817Cost of Sales (Supplies)216,870.00A441,305.0057,420.002,200.0096,800.00Syrup2150.00300.00Syrup2150.00300.00Syrup3150.00450.000.520640.640820.716140.708780.74679B172,135.0036,295.001,000.0017,000.00EmployeesEmployeesWorking Capital to Total Assets0.52 : 10.64 : 10.72 : 10.71 : 10.75 : 1A202,125.0042,500.002,200.0044,000.00DriverDriverB03,180.00- 01,000.00- 0Party Crew 3250.00Party Crew 3250.00Year 1Year 2Year 3Year 4Year 5216,870.00290,600.00845.001,570.001,305.002,135.002,125.003,180.00Cash & Cash Flow from Operating1,085,1901,158,7051,400,9501,671,9211,981,296Current Liabilities409,671500,030605,756721,864856,755507,470.00A. Kids PartyA. Kids PartyA. Kids Party2.648932.317272.312732.316122.31256Clown700.00Clown700.00Clown700.00Cash Flow Liquidity Ratio2.65 : 12.31 : 12.31 : 12.32 : 12.31 : 1Face Painting500.00Face Painting500.00Face Painting500.00EmployeesEmployeesEmployeesDriver250250Driver250250Driver250250Party Crew 3250.00750.00750Party Crew 3250.00750.00750Party Crew 3250.00750.00750

2,200.001,000.002,200.001,000.002,200.001,000.00

BAsset Liquidity & Management Efficiency (Activity)

20092008200920082009Net Sales9,046,188,12110,202,244,5499,046,188,12110,202,244,549Ave. Trade Receivable1,125,230,983900,289,4491,125,230,983900,289,4491,125,230,9830.0000010.048099.0668010.048099.06680Receivable Turnover9.07 times10.05 times9.07 times10.05 times9.07 times

Days in 1 year365365365365365Receivable Turnover0.0010.059.0710.059.07ERROR:#DIV/0!36.3253240.2567636.3253240.25676Average Collection Period40 days36 days40 days36 days40 days

Year 1Year 2Year 3Year 4Year 5Cost of Sales3,623,9623,919,3144,238,7394,584,1964,957,808Ave. Inventory100,000100,000100,000100,000100,00036.2396239.1931442.3873945.8419649.57808Inventory Turnover36.23 times39.19 times42.39 times45.84 times49.58 times

Year 1Year 2Year 3Year 4Year 5Days in 1 year360360360360360Inventory Turnover36.2439.1942.3945.8449.589.933889.185288.493097.853077.26127Average Conversion Period10 days9 days8 days8 days7 days

Year 1Year 2Year 3Year 4Year 5Net Sales6,471,3607,134,6747,865,9798,672,2419,561,146Average Working Capital1,078,8881,379,0861,979,3612,456,6412,880,2615.998175.173483.974003.530123.31954Working Capital Turnover6.00 times5.17 times3.97 times3.53 times3.32 times

Year 1Year 2Year 3Year 4Year 5Net Sales6,471,3607,134,6747,865,9798,672,2419,561,146Average Total Assets2,072,2162,346,3712,901,7453,449,4993,951,4253.122923.040732.710782.514062.41967Asset Turnover3.12 times3.04 times2.71 times2.51 times2.42 times

Year 1Year 2Year 3Year 4Year 5Total Assets2,072,2162,620,5263,182,9643,716,0334,186,817Net Sales6,471,3607,134,6747,865,9798,672,2419,561,1460.320210.367290.404650.428500.43790Capital Intensity Ratio0.32 : 10.37 : 10.40 : 10.43 : 10.44 : 1

CLong Term Financial Position or Stability / Leverage

Year 1Year 2Year 3Year 4Year 5Total Liabilities409,671500,030605,756721,864856,755Total Assets2,072,2162,620,5263,182,9643,716,0334,186,8170.197700.190810.190310.194260.20463Debt Ratio19.77%19.08%19.03%19.43%20.46%

Year 1Year 2Year 3Year 4Year 5Total Equity1,662,5452,120,4962,577,2092,994,1703,330,062Total Assets2,072,2162,620,5263,182,9643,716,0334,186,8170.802300.809190.809690.805740.79537Equity Ratio80.23%80.92%80.97%80.57%79.54%

Year 1Year 2Year 3Year 4Year 5Total Liabilities409,671500,030605,756721,864856,755Total Equity1,662,5452,120,4962,577,2092,994,1703,330,0620.246410.235810.235040.241090.25728Debt to Equity Ratio24.64%23.58%23.50%24.11%25.73%

DProfitability and Return to Investors

Year 1Year 2Year 3Year 4Year 5Gross Profit2,847,3983,215,3603,627,2404,088,0464,603,338Net Sales6,471,3607,134,6747,865,9798,672,2419,561,1460.440000.450670.461130.471390.48146Gross Profit Margin44.00%45.07%46.11%47.14%48.15%

Year 1Year 2Year 3Year 4Year 5Net Income724,075915,9031,141,7801,389,8701,679,461Net Sales6,471,3607,134,6747,865,9798,672,2419,561,1460.111890.128370.145150.160270.17565Net Profit Margin11.19%12.84%14.52%16.03%17.57%

Year 1Year 2Year 3Year 4Year 5Net Income (Loss)573,203,840332,638,253573,203,840332,638,253573,203,840Net Sales6,471,3607,134,6747,865,9798,672,2419,561,14688.5754846.6227772.8712738.3566659.95137Net Profit Margin8857.55%4662.28%7287.13%3835.67%5995.14%

Year 1Year 2Year 3Year 4Year 5Cash Flow from Operating1,085,1901,158,7051,400,9501,671,9211,981,296Net Sales6,471,3607,134,6747,865,9798,672,2419,561,1460.167690.162400.178100.192790.20722Cash Flow Margin16.77%16.24%17.81%19.28%20.72%

Year 1Year 2Year 3Year 4Year 5Net Income (Loss)724,075915,9031,141,7801,389,8701,679,461Average Total Assets2,072,2162,346,3712,901,7453,449,4993,951,4250.349420.390350.393480.402920.42503Return on Assets (ROA)34.94%39.03%39.35%40.29%42.50%

Year 1Year 2Year 3Year 4Year 5Net Income (Loss)724,075915,9031,141,7801,389,8701,679,461Average Equity1,662,5451,891,5212,348,8522,785,6893,162,1160.435520.484210.486100.498930.53112Return on Equity (ROE)43.55%48.42%48.61%49.89%53.11%

Other Computations

NEW COSPackage 1Package 2Package 3Package 130 paxUNITPRICEABPackage 270 paxUNITPRICEABPackage 3100 paxUNITPRICEABSUPPLIESABABABTables 5 pcs (round)520.00Tables 12 pcs (round)1220.00Tables 17 pcs (round)1720.00Table Clothw/cover525.00w/cover1225.00w/cover1725.00Cloth4030.001,200.00Chairs 30 pcs3010.00Chairs 72 pcs7210.00Chairs 102 pcs10210.00Labor1,500.00w/ cover3015.00w/ cover7215.00w/ cover10215.00Chair Cloth100.00100.00Mobile w/ LightsMobile w/ LightsMobile w/ LightsCloth20430.006,120.00Balloons Balloons Balloons Labor1,500.00w/stick205.00100.00100.00w/stick605.00300.00300.00w/stick805.00400.00400.00BalloonsCenterpiece515.0075.00Centerpiece1215.00180.00Centerpiece1715.00255.00Sticks1605.00800.00202060608080Party DecorationsParty DecorationsParty DecorationsGlobos 10200.002,000.00121536365050Ribbons1220.00240.00240.00Ribbons2420.00480.00480.00Ribbons6020.001,200.001,200.00Long Balloons5100.00500.0081024363047Dcor paper365.00180.00180.00Dcor paper365.00180.00180.00Dcor paper365.00180.00180.00Party Decors123,280.0039,360.00Giveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsGiveaways/Souvenirs 15 pcsRibbons6020.001,200.00121224246060Standee315.0045.0045.00Standee315.0045.0045.00Standee315.0045.0045.00Dcor paper1085.00540.00363636363636Banner50.0050.00Banner70.0070.00Banner70.0070.00POP for standee9700.006,300.00333333Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Poppers 2 pc240.0080.0080.00Hats5505.002,750.003030Long TableLong TableLong TableChocolate Syrup7150.001,050.0022VideokeVideokeVideokePoppers2040.00800.002222A. Kids PartyA. Kids PartyBanner5020.001,000.001111ClownClownBeginning Supplies66,720.00Face PaintingFace PaintingAdd:Purchases216,870.00CustomersCost of Sales (Supplies)Cost of Sales (Labor)hats305.00150.00hats305.00150.00hats305.00150.00Supplies Available283,590.00A49845.0041,405.002,200.00107,800.00B. DebutB. DebutB. DebutLess:Ending Supplies66,720.00B251,570.0039,250.001,000.0025,000.00Chocolate Fountain500.00Chocolate Fountain500.00Chocolate Fountain500.00Cost of Sales (Supplies)216,870.00A441,305.0057,420.002,200.0096,800.00Syrup2150.00300.00Syrup2150.00300.00Syrup3150.00450.00B172,135.0036,295.001,000.0017,000.00EmployeesEmployeesA202,125.0042,500.002,200.0044,000.00DriverDriverB03,180.00- 01,000.00- 0Party Crew 3250.00Party Crew 3250.00216,870.00290,600.00845.001,570.001,305.002,135.002,125.003,180.00

507,470.00A. Kids PartyA. Kids PartyA. Kids PartyClown700.00Clown700.00Clown700.00Face Painting500.00Face Painting500.00Face Painting500.00EmployeesEmployeesEmployeesDriver250250Driver250250Driver250250Party Crew 3250.00750.00750Party Crew 3250.00750.00750Party Crew 3250.00750.007502,200.001,000.002,200.001,000.002,200.001,000.00