Hi I want help with the template excel sheet I don’t know who to do it. ! please help me


Question Description:

33

Hi I want help with the template excel sheet I don’t know who to do it. ! please help me Document Preview: 8 4 3 7/1/2014 1800 7/1/2014 7/3/2014 400 7/5/2014 106 159 7/7/2014 7/7/2014 128 56 68 7/10/2014 7/10/2014 7/10/2014 7/15/2014 61.21 7/15/2014 7/15/2014 71 32 38 7/15/2014 61 91.5 7/20/2014 120 7/30/2014 1200 7/30/2014 7/30/2014 86 38 46 274 61 250 PET CARE SIMULATION MONTH 2 TRANSACTIONS Group name: Month one closing entries Before starting the July operating entries, you must close out all June activity from the temporary accounts. Be sure to date the two closing entries as of June 30th and close the accounts directly to Retained Earnings. Post them to the June general ledger t-accounts. Then transfer the ending balances of all permanent accounts to the beginning balances (BB) in July’s general ledger T-accounts. Please round all amounts to the nearest dollar. Month Two operating entries Reminder: Your business choose to charge for dog walking and for pet-sitting. The pet food sales price per package is You must pay the rental deposit and rent expense for the month of July. #2-1 The 10 kennels and other materials that you ordered are delivered to your #2-2 new shop location. The total cost is $4,000. You pay 25% down and finance the remainer of the cost with a six month loan. Record this entry. You pay for all of the advertising for the second month of . #2-3 You receive the first shipment of pet food for the month. Total #2-4 units cost Food This purchase is made on account. The credit terms are 2/10, n30. You intend to take the discount therefore you record the invoice using the net method. You pay all of the payroll taxes that were recorded in the June 28th #2-5 payroll entry. Record revenues for services rendered and pet food sold for the first week of July. #2-6 Total number of 30 minute intervals of dog walking Total number of visits to animals for pet-sitting Total number of packages of pet food sold (Use the perpetual method of recording revenues and COGS.) As stockholders of… Attachments: JUNE–Pet-Car….xlsx untitled–Jul….xlsx JULY-Pet-Care….xlsx

Answer

33