Question

Purpose: Examine the use of spreadsheets in business applications.

Select a type of business that interests you. Be sure to describe the business purpose.

Some examples of businesses, industries, or technologies to investigate are accounting, retail sales, real estate sales, catering, engineering, and health-related services.

Find or develop 3 sample spreadsheet templates that could be used to perform specific functions in the selected business. Explain the purpose of each spreadsheet and why it would be helpful for the business.

Post a short summary of the business, the spreadsheets you would incorporate and why they are important in

Answer 1

Every business cannot use or afford business software or customize software for their operations. Spreadsheets are an important tool which is used by business small or big as an important tool.

There are number of spreadsheet templates which are available which can be readily used to perform selective functions in selected business.

Let us take some of the sample worksheet templates provided in Excel and find the purpose and usefulness for different business.

Healthcare: Excel has built in template Blood pressure tracker which can be opened using File>new>installed template

Blood pressure and heart beat monitoring of an individual patient can be done using this template in Healthcare business.

This helps in keeping track of health vital statistic systematically by date and time, which helps healthcare professional to decide line of treatment.

2. Billing Statement: Billing is major part of almost every business. Small grocery store, medical store, and business which handle less amount of product can easily use Billing Statement from Template.

This will help in generating Billing invoice to customers which can also be stored for future reference.

3. Sales Report: Sales record helps the business in keeping track of inventory, determining best selling and lowest selling item. This will help in deciding future items and growth of business.

Use File>New>Installed template to get Sales Report.

This helps in tracking record of sales to different customers for different quarter. This helps in identifying increase or slump in sales to different customers of different products in different quarter which helps in properly maintain inventory to meet demand-supply.