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 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 and also at the various levels of management. As the junior manager of MGMT Lawn & Garden Services in the production department (operational level): Discuss the type of information system that would be better suited in this new environment 1(a) For the production department show how that department can be computerised since Levi currently uses a manual system. 1(b) From the perspective of the production department as the junior manager, discuss the effect of the PESTLE Analysis.
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 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 and also at the various levels of management.
As the junior manager of MGMT Lawn & Garden Services in the production department (operational level):
Discuss the type of information system that would be better suited in this new environment
1(a) For the production department show how that department can be computerised since Levi currently uses a manual system.
1(b) From the perspective of the production department as the junior manager, discuss the effect of the PESTLE Analysis.
Step by step
Solved in 2 steps
