Levi Landon owns a small lawn care business with three employees. He owns the lawn mowers, rakes, and weed whackers that are housed in a storage area at the back of his home. He currently keeps his records in a spiral-bound book. He has a page for his list of customers, and their information including when he first started to do their garden, and the size of their lawns. He has another section to keep track of payments. Levi usually requires payment on completion of the service, but this rarely happens and he has lost track of who owes him and how much. Levi realizes that he is not as efficient as he could be in his record keeping and asks you to help him to track customer service dates, payments and lawn care revenue. He may want to get a loan to purchase some more equipment. He provides you with his book of customers, and payments and prices of the various lawn sizes. To help Levi with the reporting requirements, you need to work with Customer, Payment, and Prices tables that are available in a database. You should also prepare several queries, as well as some reports to share with him. To help him with his loan information, you may need to perform some calculations in a spreadsheet to better advise him. Levi is pleased with the progress his business is making, the reports you produced and the help you provided regarding his loan information. His bankers have great prospects for Levi. They are encouraging Levi to examine the Caribbean Landscape Ltd in the Bahamas (http://www.caribbeanlandscape.net/ ), with a view of expanding his business to provide similar services. Levi imagines that since he is seriously contemplating expanding his business, he will need representation at the basic functional areas of a business Operational manager in the Accounts and Finance departments of MGMT Lawn & Garden Services and you get to choose your department. Process flow diagram with bands, roles and/or cross functional interactions and showing where two or more decisions are made.
CASE BACKGROUND
Levi Landon owns a small lawn care business with three employees. He owns the lawn mowers, rakes, and weed whackers that are housed in a storage area at the back of his home. He currently keeps his records in a spiral-bound book. He has a page for his list of customers, and their information including when he first started to do their garden, and the size of their lawns. He has another section to keep track of payments. Levi usually requires payment on completion of the service, but this rarely happens and he has lost track of who owes him and how much.
Levi realizes that he is not as efficient as he could be in his record keeping and asks you to help him to track customer service dates, payments and lawn care revenue. He may want to get a loan to purchase some more equipment. He provides you with his book of customers, and payments and prices of the various lawn sizes.
To help Levi with the reporting requirements, you need to work with Customer, Payment, and Prices tables that are available in a
Levi is pleased with the progress his business is making, the reports you produced and the help you provided regarding his loan information. His bankers have great prospects for Levi. They are encouraging Levi to examine the Caribbean Landscape Ltd in the Bahamas (http://www.caribbeanlandscape.net/ ), with a view of expanding his business to provide similar services.
Levi imagines that since he is seriously contemplating expanding his business, he will need representation at the basic functional areas of a business Operational manager in the Accounts and Finance departments of MGMT Lawn & Garden Services and you get to choose your department.
Process flow diagram with bands, roles and/or cross functional interactions and showing where two or more decisions are made.
Step by step
Solved in 4 steps with 1 images
