Green create Lawn negociate Spreadsheet and Business Process visual percept Brief Introduction & Reason for the Report Green Grow Lawn mete out is a small growing lawn care seam operated by George Lobbo. Record memory for the business has reached a percentage point where a better system is needed for sweeping the customers, advantage dates, customer payments, and revenue. After considering several options for improving his record keeping system, Mr. Lobbo decided to have a system using Microsoft stand out created for him. The Lawn Care Workbook contains several worksheets, including node, Payment, Quote and Amortization worksheets, as salubrious as two revenue charts. Design Specifications In the Lawn Care workbook, a worksheet was created and named Customers and this worksheet stores all relevant customer information. The Customers worksheet has columns for customer beginning and exit names, standard fee, additional periodic charges, lend weekly charges, service day, lawn coat, start date, and about the customers service, much(prenominal) as why additional charges were applied. The Customers worksheet also includes a marrow count of Green Grow Lawn Cares customers, pass judgment total revenue by day, anticipated total weekly revenue, and anticipated total monthly revenue.
As the standard fee is based on lawn size, the standard pricing guide was recreated in the Customers worksheet, and then the VLOOKUP function was used to retrieve the standard lawn size price. The customer entries are sorted alphabetically by last name. trope 1: Green Grow Lawn Care Customer List Sorted Figure 2: Green Grow Lawn Care Anticipated Revenue & Total Customer Count Figure 3: Green Grow Lawn Care Standard set Guide A Payment worksheet was also created. This worksheet will enable Mr. Lobbo to track customer payments. The Payment worksheet includes columns for the payment date, customers outgrowth and last name, total weekly charges, one-time fees, this weeks total charges, amount paid, remaining... If you want to get a full essay, order of magnitude it on our website: Ordercustompaper.com
Ordercustompaper.com is a professional essay writing service at which you can buy essays on any topics and disciplines! All custom essays are written by professional writers!
No comments:
Post a Comment