Attachment # 00004356 - 59600021.xlsx
59600021.xlsx (223.45 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Bellwether Garden SupplyBalance SheetDecember 31, 2013ASSETSCurrent AssetsPetty CashCash on HandRegular Checking AccountPayroll Checking AccountSavings AccountMoney Market FundAccounts ReceivableOther ReceivablesAllowance for Doubtful AccountInventoryPrepaid ExpensesEmployee AdvancesNotes Receivable-CurrentOther Current AssetsTotal Current AssetsProperty and EquipmentFurniture and FixturesEquipmentVehiclesOther Depreciable PropertyBuildingsBuilding ImprovementsAccum. Depreciation-FurnitureAccum. Depreciation-EquipmentAccum. Depreciation-VehiclesAccum. Depreciation-OtherAccum. Depreciation-BuildingsAccum. Depreciation-Bldg ImpTotal Property and EquipmentOther AssetsDepositsOrganization CostsAccum Amortiz - Organiz CostsNotes Receivable- NoncurrentOther Noncurrent AssetsTotal Other AssetsTotal AssetsLIABILITIES AND CAPITALCurrent LiabilitiesAccounts PayableAccrued ExpensesSales Tax PayableWages Payable401 K Deductions PayableHealth Insurance PayableFederal Payroll Taxes PayableFUTA Tax PayableState Payroll Taxes PayableSUTA Tax PayableLocal Payroll Taxes PayableIncome Taxes PayableOther Taxes PayableCurrent Portion Long-Term DebtContracts Payable- CurrentOther Current LiabilitiesTotal Current LiabilitiesLong-Term LiabilitiesNotes Payable-NoncurrentTotal Long-Term LiabilitiesTotal LiabilitiesCapitalCommon StockPaid-in CapitalRetained EarningsNet IncomeTotal CapitalTotal Liabilities & CapitalIncome StatementFor the Twelve Months Ending December 31, 2013Current MonthYear to DateRevenuesSalesSales - AviarySales - BooksSales - EquipmentSales - Food/FertSales - Hand ToolsSales - Landscape ServicesSales - MiscellaneousSales - NurserySales - PotsSales - SeedsSales - SoilOther IncomeSales DiscountsTotal RevenuesCost of SalesProduct CostProduct Cost - AviaryProduct Cost - BooksProduct Cost - EquipmentProduct Cost - Food/FertProduct Cost - Hand ToolsProduct Cost - PotsProduct Cost - SeedsProduct Cost - SoilDirect Labor - NurseryMaterials CostMaterials Cost - NurserySubcontractors - LandscapingTotal Cost of SalesGross ProfitExpensesFreightAdvertising ExpenseAuto ExpensesBad Debt ExpenseBank ChargesDepreciation ExpenseLegal and Professional ExpenseLicenses ExpenseMaintenance ExpenseOffice ExpensePayroll Tax ExpRent or Lease ExpenseRepairs ExpenseSupplies ExpenseUtilities ExpenseWages ExpenseOther ExpensePurchase Disc- Expense ItemsTotal ExpensesStatement of Cash FlowFor the twelve Months Ended December 31, 2013Cash Flows from operating activitiesAdjustments to reconcile netincome to net cash providedby operating activitiesTotal AdjustmentsNet Cash provided by OperationsCash Flows from investing activitiesUsed ForNet cash used in investingCash Flows from financing activitiesProceeds FromNet cash used in financingNet increase <decrease> in cashSummaryCash Balance at End of PeriodCash Balance at Beg of PeriodNet Increase <Decrease> in CashStatement of Retained EarningsBeginning Retained EarningsAdjustments To DateSubtotalEnding Retained EarningsChart of AccountsAs of Dec 31, 2013Filter Criteria includes: Report order is by ID. Report is printed with Accounts having Zero Amounts and in Detail Format. Account IDAccount DescriptionActive?Account Type10000YesCash10100102001030010400105001100011100Contracts Receivable1140011500120001400014100142001470015000Fixed Assets15100152001530015400Leasehold Improvements155001560016900Land17000Accumulated Depreciation17100172001730017400Accum. Depreciation-Leasehold175001760019000191001915019200199002000023000231002320023300233502340023500236002370023800239002400024100243002470024800Suspense - Clearing Account27000Long Term Liabilities27100Contracts Payable- Noncurrent27400Other Long-Term Liabilities39002Beginning Balance EquityEquity-doesn't close390033900439005Equity-Retained Earnings39007Dividends PaidEquity-gets closed40000Income40000-AV40000-BK40000-CESales - Ceramics40000-EQ40000-FF40000-FUSales - Furniture40000-HT40000-LS40000-MI40000-NU40000-PO40000-SE40000-SO40000-STSales - Statuary40000-TOSales - Topiary40800Interest Income4100045400Finance Charge Income48000Sales Returns and Allowances490005000050000-AV50000-BK50000-CEProduct Cost - Ceramics50000-EQ50000-FF50000-FUProduct Cost - Furniture50000-HT50000-LSProduct Cost - Landscaping50000-MSProduct Cost - Miscellaneous50000-PO50000-SE50000-SO50000-STProduct Cost - Statuary50000-TOProduct Cost - Topiary57000Direct Labor57000-LSDirect Labor - Landscaping57000-MIDirect Labor - Miscellaneous57000-NU57000-TODirect Labor - Topiary5720057200-LSMaterials Cost - Landscaping57200-MIMaterials Cost - Miscellaneous57200-NU57200-TOMaterials Cost - Topiary57300Subcontractors57300-LS57300-MISubcontractors - Miscellaneous57300-NUSubcontractors - Nursery57300-TOSubcontractors - Topiary5750058000Other58500Inventory Adjustments59000Purchase Returns and Allowance59500Purchase Discounts6000060500Amortization Expense61000615006200062500Cash Over and Short63000Charitable Contributions Exp63500Commissions and Fees Exp6400064500Dues and Subscriptions Exp65000Employee Benefit Programs Exp65500Freight Expense66000Gifts Expense66500Income Tax Expense67000Insurance Expense67500Interest Expense68000Laundry and Cleaning Exp685006900069500Loss on NSF Checks7000070500Meals and Entertainment Exp7100071500Other Taxes7200072500Penalties and Fines Exp73000Pension/Profit-Sharing Plan Ex73100Printing Offsite Expense73500Postage Expense740007450075000Salaries Expense75100Salaries Bonus Expense75200Salaries Commission Expense7550076500Travel Expense7700077500890008950090000Gain/Loss on Sale of AssetsGeneral LedgerFor the Period From Dec 1, 2013 to Dec 31, 2013Filter Criteria includes: Report order is by ID. Report is printed with shortened descriptions and in Detail Format. DateReferenceJrnlTrans DescriptionDebit AmtCredit AmtBalanceBeginning BalanceEnding BalanceGeneral Ledger Trial BalanceFilter Criteria includes: Report order is by ID. Report is printed in Detail Format. Total:Account VarianceFor the Period From Jan 1, 2013 to Dec 31, 2013Filter Criteria includes: The Variance Calculation is Actual - Budget. Period EndActual AmountBudget AmountOver AmountOver Percent1/31/132/28/133/31/134/30/135/31/136/30/137/31/138/31/139/30/1310/31/1311/30/1312/31/13Sub TotalBudgetFilter Criteria includes: 1) Types: Income Statement Accounts. YTD TotalRevenue- Cost of Sales- ExpensesCash RequirementsFilter Criteria includes: 1) Invoices Due (no discount available). Report order is by ID. Report is printed in Detail Format. Vendor IDVendorInvoice/CM #Date DueAmount DueDisc AmtAgeABNEYAbney and Son ContractorsB1000AKERSONAkerson DistributionA-6411A-7811A-92034ARMENTAArmenta's LandscapingARM501ARM967CALDWELLCaldwell Tools CompanyC1280C1450C1563B1004CLINECline Construction, Inc.B1023B1006CLOONEYClooney Chemical SupplyB1021116655DANIELDaniel Lawn Pro, Inc.45541DEJULIADeJulia Wholesale Suppliers93238-01AR-021703B1020SS-0000122113AR130322245552294977GARYGary, Wilson, Jones, & Smith121501-BGS10045GWINWATERGwinnett County WaterB1005HAWKINSDPH Web DesignB1003HUBBARDHubbard WholesaleB-2001HU1025JACKSONJackson Advertising Company2456-D2210046JUANJuan Motor Tools & TiresAB-12985JM6414KIDDKidd Computers54452MILESMiles Maintenance & RepairVCM30006B1007MILLSMills Leasing Corp.VCM30007NATLBANKNational Trust BankB1008NEIGHBORSNeighbors Telephone CompanyB1010VCM30008SOGARDENSouthern Garden WholesaleLL-15029684SG-11010SG-12230SG-12300SG-12401SG-11657SG-11658SOPOWERSouthern Power Co.B1011STANLEYStanley Shipping ExpressVCM30009B1012SULLEYSulley Printing14223B1024WATKINSWatkins Financial PlanningB1013VCM30010Report TotalVendor LedgersFilter Criteria includes: Report order is by ID. Trans NoTypePaidBalance FwdCLOUDETCloudet Property ManagementGAREVENUEGeorgia Department of RevenueGWINLICENSEGwinnett County License BoardOFCSUPPLOffice Supplies & MorePARISParis Brothers Tree SurgeonsPAYNEPayne EnterprisesSAFESTATESafe State Insurance CompanyAged PayablesFilter Criteria includes: 1) Includes Drop Shipments. Report order is by ID. Report is printed in Detail Format. ContactTelephone 10 - 3031 - 6061 - 90Over 90 daysWesley Abney770-555-0000Cameron Akerson678-555-1279Albert ArmentaCarl Caldwell770-555-7130Suzanne Cline770-555-8546Shaye Clooney404-555-0899Valerie Daniel770-555-1126Jerry DeJulia404-555-1500Robert Gary404-555-8000John Marco770-555-0177Dennis Hawkins770-555-4221Karl Hubbard770-555-7155Yvette Jackson404-555-5855Kenneth Juan770-555-0188Joe Kidd770-555-5827Paul Miles770-555-7117Angela Mills404-555-1901Nita Ackerman404-555-0799Mandy Neighbors404-555-1022Thomas Mayors404-555-9668Clare SimellCindy Stanley404-559-6278Trent Sulley404-555-6932Mark Watkins770-555-3994Customer LedgersCustomer IDCustomerALDREDAldred Builders, Inc.ARCHERArcher Scapes and PondsARMSTRONGArmstrong LandscapingCANNONCannon Healthcare CenterCHAPPLEChapple Law OfficesCUMMINGSCummings ConstructionDASHDash Business SystemsEVERLYEverly Property ManagementFRANKLINFranklin Botanical GardensFREEMONDFreemond Country ClubFROSTFrost Technology ParkNo ActivityGOLDENGolden GardensGORDONGordon Park & Recreation CenterHENTONHenton Park ApartmentsHOLLANDHolland Properties, Inc.KENTONKenton Golf and Tennis CenterKNIGHTKnight Brothers NurseriesMASONMason Office ParkMCKAYMcKay ConstructionMOSLEYMosley Country ClubPIERCEPierce Properties, Inc.RETAILRetail (Cash) SalesROBERTSRoberts Learning CentersROSERose UniversitySAIASaia's Neighborhood NurserySEAWRIGHTSeawright Sod and Lawn CareSMITHSmith Family Garden CenterSNOWDENSnowden Interior DesignSNYDERSnyder SecuritiesSTEVENSONStevenson Leasing, Inc.TACOMATacoma Park Golf CourseTEESDALETeesdale Real EstateTHURMANThurman Golf Course DesignTRENTTrent Bank and TrustWILLIAMSWilliams IndustriesAged ReceivablesBill To ContactTony Aldred770-555-06541012910332Nancy Archer770-555-4660102091032910317Emma Armstrong770-555-88241012410119101201021210336CCM40071031410339Dr. Natasha Cannon, MD770-555-412810321Francis Chapple770-555-8858102561034110313Betty Cummings770-555-1147CCM400510307McKenzie Dash770-555-998810327Lee Everly770-555-66601020510208George Franklin770 555-9598103261032810340Delores Freemond770-555-896710206CCM400610325Kathryn Gordon770-555-001410123Jacob Henton404-555-20251020710310Jamie Holland770-555-99271021110304e2CCM4010Kevin Kenton770-555-44691033810324Troy Mason770-555-331110315Nicole McKay404-555-422510116Sam Mosley770-555-69481020410342Walk-in Customers10114Sabrina Roberts770-555-61781021010331Kelly Rose404-555-720210320Regina Saia770-555-1684101171012110215Mason Seawright404-555-224610316Mindy Smith404-555-779110203Catherine Snowden770-555-100510306Troy Snyder770-555-35241012710334Marsha Stevenson770-555-88481031810118Laney Aaron770-555-73881012610322Wade Teesdale770-555-64881012210311Briana Thurman770-555-40291013010343

Assignment 2

Question # 00060714 Posted By: solutionshere Updated on: 04/11/2015 03:16 AM Due on: 04/11/2015
Subject General Questions Topic General General Questions Tutorials:
Question
Dot Image

Assignment 2: Accounting Analysis Project

The Accounting Analysis Project is based on the completion of the Bellwether Garden Supply (BGS) project and consists of two (2) separate parts – textbook questions, and an analysis in response to the BGS project.

Part I: BGS Textbook Questions

1. Answer the fifteen (15) questions regarding the Bellwether Garden Supply scenario.

1. Examine Bellwether Garden Supply's chart of accounts. Are all of the account types in accordance with usual accounting procedures? If not, list the accounts that could be classified differently.

2. What is the balance in Account No. 89500, Purchase Disc-Expense Item? Is it a debit or credit balance? Why? (Hint: Display the General Ledger report; select Options. In the Time Frame period, select all. Select the filter GL Account ID from 89500 to 89500.) Explain.

3. How do you compute the sales discount? How does Sage 50 compute the sales discount?

4. How do you change a sales discount?

5. What types of entries are recorded in Bellwether's general journal?

6. How does Sage 50 identify these windows? Identify the software module and journal.

Module

Window

Journal

Purchases/Receive

Inventory

Sales/Invoicing

Payments

Receipts

General Journal Entry

7. There are two ways to access backup and restore. Explain both.

8. On the Payroll Entry window, what are the differences between the amounts in the Taxes-Benefits-Liability area that have minus signs in front of them and amounts that do not show a minus sign?

9. Does Bellwether track Overtime pay in a separate account? Briefly explain.

10. What type of Accounting Method does Bellwether use? How do you find that out and what does it mean?

11. What is the Business Status Navigation Center? Can it be customized? Does the Business Status Center show your security settings? Can access be limited to the Sage 50's Navigation Centers?

12. Is the net income shown on the Business Status Navigation Center for the month or year to date? How do you check that?

13. What report verifies the balance in Account No. 11000 Accounts Receivable? What is the Accounts Receivable balance in the General Ledger and in the Customer Ledgers? Why is there a difference? (Hint:Look in the journals for Customers & Sales module.)

14. What report verifies the balance in Account No. 20000 Accounts Payable? What is the Accounts Payable balance in the General Ledger and in the Vendor Ledgers? Why is there a difference? (Hint:Look in the journals for the Vendors & Payables module.)

15. If you want to view a report that shows the changes made to maintenance items and transactions, what report would you look at?

Part II: BGS Analysis

2. Write a four to five (4-5) page paper in which you:

a. Analyze the financial condition of Bellwether Garden Supply, and interpret the result for company leaders.

b. Submit a copy of the firm’s key financial statements and reports (balance sheet, income statement, statement of retained earnings, statement of changes in financial position, and customer ledger) in one (1) Excel document. Attached.

c. Make recommendations for how management should address major business decisions or directions for the company over the next two (2) years.

d. Use at least two (2) quality academic resources in this assignment. Note:Wikipedia and other Websites do not qualify as academic resources.

Dot Image
Tutorials for this Question
  1. Tutorial # 00056633 Posted By: solutionshere Posted on: 04/11/2015 03:18 AM
    Puchased By: 4
    Tutorial Preview
    being restored from the support files. Once the procedure is ...
    Attachments
    2210011.docx (210.41 KB)
    2210012.docx (217.15 KB)
    2210013.docx (210.41 KB)
Whatsapp Lisa