Receivables using excel for aging accounts receivable the lake lucerne company uses the allowance method of estimating bad debts expense. an aging schedule is prepared in order to calculate the balance in the allowance account. the percentage uncollectible is calculated as follows: 1-30 days 1% 31-60 days 2% 61-90 days 5% 91-365 days 50% after 365 days, the account is written off. use the blue shaded areas on the enter-answers tab for inputs. always use cell references and formulas where appropriate to receive full credit. copy/pasting values will not earn full points. requirements possible points 1 calculate the number of days each receivable is outstanding. 12 2 complete the schedule of accounts receivable. 45 3 journalize the adjusting entry for bad debts expense. 4 *for all requirements, enter all amounts as positive values. do not use a minus sign or parentheses for any values.

This problem has been solved! see the answerchapter 19 problem #8. quality and financial control (connect, perform)part one: geometrica designs and builds domes and space frames for large buildings. while the company had developed quality standards over time to respond to different client problems and training needs, it lacked a unified quality system, and its global client base wanted assurance that geometrica met an established international standard for quality. which of the following was an appropriate step for this company to take? a) reform its accounting and financial reporting systems to comply with sarbanes-oxleyb) establish and document a quality management system to comply with iso 9000management at workyou are the new fleet manager at xpressship, a package delivery company. as your first project, your boss has asked that you to look into implementing an electronic monitoring system for the fleet of 2,000 trucks your company owns. a recent internal audit on maintenance and repair costs on the company’s vehicles revealed while maintenance was performed regularly on the trucks, mileage or use had not been taken into account. this resulted in approximately $20,000 of unneeded repairs. you know that telematics have been used by other companies with fleets of cars or trucks and it will allow your company to not only track mileage and use, but also part replacement needs, vehicle oil pressure, and drivers’ speed and real time location. tracking these items can reduce maintenance costs while improving efficiency. you find that a simple computer can be installed in each vehicle. when the drivers return at the end of the day, the telematics information from each vehicle will be uploaded to a master computer where a software program will generate a report with results on the variables you have selected.early one morning as you are getting a cup of coffee, a few drivers that have been with the company for many years approach you with some concerns. eldon, the most senior driver says, “i heard you’re installing some type of computer to track our driving. my buddy works over at parcel and post package delivery and he said they’ve got these computers, too. he said managers are writing people up and firing drivers for speeding or not wearing seat belts. are you going to do that to us, too? ”part two: as a manager, which of the following statements would be effective in maintaining a positive relationship with company drivers? check all that apply.a) at this time, xpressship will be using telematics to monitor maintenance and repair needs, not drivers’ motoring habitsb) although the company isn’t doing so now, when xpressship begins to monitor driver motoring habits, the company will encourage them to keep a separate daily log where they can document any unusual circumstancesc) while xpressship could monitor things like speed, location, and idle time, the company trusts their drivers and will not be using that data in disciplinary decisionsd) xpressship executives are happy with their technology and believe that implementation is ideal for your organization

Afood worker has just rinsed a dish after cleaning it.what should he do next?

The following transactions occurred during july: received $1,000 cash for services provided to a customer during july. received $4,000 cash investment from bob johnson, the owner of the business received $850 from a customer in partial payment of his account receivable which arose from sales in june. provided services to a customer on credit, $475. borrowed $7,000 from the bank by signing a promissory note. received $1,350 cash from a customer for services to be rendered next year. what was the amount of revenue for july?