Data to be collected on Customer Profile Form

The Pine Valley Furniture is concerned with the processing of high quality made from the wood furniture and it also supplies these materials around the United States. The firm started back in the early 1980s with aim of manufacturing custom furniture for clients (Tangjang, and Nair, 2016). That time the records were preserved in a cabinet of a file but over years it has evolved and came up with Information System for meeting the requirements of the users and administrators from different locations. Currently, the firm is split in various locations within the United States and in order to meet the requirements of the users satisfactorily came with this system of automating services across different locations (Valacich, George, and Valacich, 2017). Now the firm has an idea of developing an e-commerce website comprising of several forms of customers such as home office, family as well as a student among other in order to uphold competition with other companies offering similar services. The main purpose of the Pine Valley Furniture Information System is to advance the sales as well as the ultimate benefits of the firm. Through this system, the Pine Valley Furniture system expects a smooth flow of the company by minimizing the cost of labor and management overhead costs.

Tracking System for customers of Pine Valley Furniture needs to be implemented which involves the creation of the customer profile forms. In order to understand the needs of every customer’s several forms need to be developed but, in our case, will focus on family customers profiles which are created when new clients place their initial order (Van der Wagen, and White, 2018). The customers will be expected to fill the whole form and accurately to accomplish the process and so as to motivate the customers there will be a provision of 10% discount on the average customer order who accomplishes the creation of the profile successfully. The existing clients will also be given a chance to participate in the user profiling method. Customer profile data will be gathered through a client profile form. The information required mostly are the individual details such as name, phone number, address, id, email, location as well as income information, profession origin, booking information, requirements of the furniture, details of the budget, size of the family as well as the interest level again might be available in the sheet of the profile of the users such as comments among others (Butler et al., 2015).

The client profile form is utilized to gather data from clients in order the Pine Valley Furniture can develop and keep their user database. The diagram below indicates the profile form of a customer.

The explanation of the information gathered is provided below:

Firm Name, the system produces User Id and the data available on the form.

The radio buttons are utilized to guarantee the correct selection of the choices and the edit texts are for the provision of the required details in the appropriate formats.

The name field – the user is expected to supply full names and correctly and in case the order is not followed the system prompts for an error message.

Profile Form for Family Customers

Age field – the user is required to supply their ages based on the correct format of the dates.

Phone number field – the user should provide at least 10 numerical in order to be validated.

Email field – the user should supply correct email with the appropriate format.

Address field – the customer should provide the resident house number, the name of the street, city where he or she comes from, province, a country he or she originates and the zip code of the city.

The system automatically gives a new user Id in order to avoid duplication of details since it is unique.

The save button – this aid the user to in submitting the details into the system database.

Cancel button – the user can cancel the whole form if he opts to continue later.

Help button – in case the customer needs any assistance can click the help button and the possible solution is offered relevantly.

Next button – this aid the user once has completed the registration to move to the next window of the system.

The alert for a discount is colored red to draw the user’s attention and the asterisk is utilized to indicate the mandatory fields.

The form also consists of the buttons for saving data, canceling the process, requesting for help and the button to allow the user to navigate in the next window.

The demographic commerce analysis aids in achieving a various goal, to begin with, it helps in discovering and identifying which sectors, as well as subgroups, live in the given population and to produce a comprehensive reflection of the characteristics that an ordinary member of every one of the sectors executes. The demographic reports in place have depicted effective techniques for drawing the attention of the focused group of individuals for a given item in the globe (Mulcahy et al., 2016). The reports incorporate global information to assist the marketers to reach details involving each and every potential focused market. The demographic market study reports can also aid in characterizing unique demographic profile. Generating a profile might offer information concerning an ordinary participant for a given group to help in producing a visual of a theoretical focus market. Demographics are the characteristics of a chosen human population. Demographic emerging issues can be established through information comprising of age, race, income, gender, location just mentions a few (Barrett et al., 2017). By using this emerging information, one is capable of analyzing modifications in a certain population over a given span of time and can also this information can help in economic as well as marketing decision making. In reference of the requirement of the sales as well as a marketing category, the products by demographic summary report can offer details concerning sales by region, customer category, product categories and is provided as shown below.

Name of the Product: …………………….

Product Type:  Dining       Sofa Kitchen Wardrobe Computer Desk

Range: 15k – 20k 20k – 50k 50k – 1I 1I and above

Demographics Summary Report for Pine Valley Furniture

Specification: Length Width

Usage: Short Term Long Term

Category: Dining Room  Kitchen Study Drawing

Color: Light Dark

Name of the product – the user is expected to indicate the name of the item in need.

Product type – the customer is required to choose the items he or she wants by checking the checkboxes.

Range – the user is expected to indicate the range of amount he or she has in reference to the demand of the product selected.

Specification – the customer needs to input the length as well as the width of the item needed.

Usage – the customer should indicate the duration of the item requested by either selecting the short-term or long-term usage.

Category – the customer indicates the classification of the item in need and where to be used.

Color – the user should be in a position to choose between the two colors.

The following are samples of products by the demographic summary report.

Sales by product.

Sales by region

The information or ratio of sales incorporated in the study on the basis of several classifications is as provided below.

The name of the company and date are provided on the report.

Sale by item pie chart shows the quantity of the product sold in every region.

Users are classified in reference to their age. The final pie chart provides details on which classification of users has purchase how much items.

The user purchasing frequency report provides data on the frequency of the buying of the users, from which different conclusions on their purchases can be met. The diagram below shows the design of the customer purchasing frequency report:

The information illustrated above is a personalized report that implies that on requesting a report about the specific user by his or her user Id, the system produces a report. The following is the explanation of the report above:

The report comprises of the name of the company as well as the date.

It depicts the details of the user such as the name of the customer, the id of the customer, for the whom the above report is produced for.

The purchasing frequency is depicted by the graph and the amount of the purchases carried out throughout the year is depicted here, again can generate monthly report too.

Buttons are provided to aid the functionality of discarding the report, printing the report as well as saving the report for future use.

The system is designed in a such a way it provides the report of the necessary items such as the id of the customer, name of the customer, the date customer joined, the amount of the purchase the user has made, the date of the last purchase. The date of the generation of the report is system generated in respect to the region of the customer. The above report can be printed and filed then filed in a cabinet for back up in future in case of system failure. The graph indicates the performance of the purchases by users over the years.

References

Barrett, K. J., Brown, P. M., Clement, J., Cannon, J. B., Wolk, B., & Cheng, A. S. (2017). 2017 Ecological, Social and Economic Monitoring Plan.

Butler, P. R., Iverson, L., Thompson, F. R., Brandt, L., Handler, S., Janowiak, M., … & Connolly, S. (2015). Central Appalachians forest ecosystem vulnerability assessment and synthesis: a report from the Central Appalachians Climate Change Response Framework project. Gen. Tech. Rep. NRS-146. Newtown Square, PA: US Department of Agriculture, Forest Service, Northern Research Station. 310 p., 146, 1-310.

Mulcahy, A. W., Kapinos, K. A., Briscombe, B., Uscher-Pines, L., Chaturvedi, R., Case, S. R., … & Miller, B. M. (2016). Toward a sustainable blood supply in the United States. Rand Corporation, Santa Monica, CA.

Tangjang, S., & Nair, P. R. (2016). Integrated bamboo+ pine homegardens: a unique agroforestry system in Ziro Valley of Arunachal Pradesh, India. Int J Environ Agric Res, 2, 25-34.

Valacich, J. S., George, J. F., & Valacich, J. S. (2017). Modern systems analysis and design. Pearson Education Limited.

Van der Wagen, L., & White, L. (2018). Event management: For tourism, cultural, business and sporting events. Cengage AU.