Pine Valley Furniture free essay sample

What data will the Customer Profile Form need to collect? Using the guidelines presented in the chapter, design the Customer Profile Form. The students should use a simple GUI development tool to develop the Customer Profile Form for PVF. The challenging part of this question is how the students will interpret terms like demographic or customer category. For demographic information to prepare the Products by Demographics Summary, the Customer Profile Form should gather such information as birth year (people may be less hesitant to provide this than their full birth date), ethnicity, household income range (in 5 to 7 broad categories), marital status, family size, education level, and perhaps vocation. Your students may omit some of these or add others that they have experienced on similar forms. Information such as zip code or region could be determined by the system based upon the billing or shipping address provided for the sale. The categorization of customers for Mr. We will write a custom essay sample on Pine Valley Furniture or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page Hwang could be accomplished by these demographic items or by categorization of repeat purchases. When designing the form, it would also be important for students to consider the navigational option of skipping this form and continuing to the completion of their sale. * b. Using the guidelines presented in the chapter, design the Products by Demographics Summary Report. When designing the Products by Demographics Summary Report, students should use tables 8-3 through 8-6 as checklists to assure they have developed a usable product for Gracie Breshers. Students will find the greatest challenge in formatting the columns and rows of this report with all of the logic breaks specified by Miss Breshers. They should probably use the categories of information specified in the case for sort sequencing: first by furniture category; within each category sort by sales region, within each region sort by age group, an for each age group within each region for each category of furniture report sales figures. If the students develop the report with an interactive software tool, they could allow for re-sorting of the report on different fields. With the volume of data likely generated by this report, highlighting will play an important role in avoiding information overload for the management users. Then actual report will vary based on students’ responses to the first question in this case. Even so, you may want to provide a sample data set that students could use to test their reports. Provide sufficient volume in the data set to allow for page breaks to see how they break the multiple lines of output for usability. Not the judicious use of highlighting. These reports could be prototyped using the same tools used for the Customer Profile Form, or simply with a word processing package like Word. * C. Using the guidelines presented in the chapter, design the Customer Purchasing Frequency Report. The same guidelines used in part (b) of this case apply to the development of the Customer Purchasing Frequency Report. This report will require more logic to develop depending upon the data set available since the required percentages will have to be calculated from total sales and demographic information. Further definition of customer type will help students determine the information that the form should contain. Additional information may help Mr. Hwang interpret the data requested for this form. Adding too many new fields will obscure the information that he seeks. Again encourage the students to use Table 8-6 to calibrate their work and determine the usability of their report. d. Modify the dialogue diagram presented in Figure 8-20 to reflect the addition of the Customer Profile Form, Products by Demographics Summary Report, and the Customer Purchasing Frequency Report. The Customer Profile Form would not fit into the dialogue as defined in Figure 8-20 because the options presented deal with providing customer information. This form is for the customer to fill out, not for management. It belongs more precisely in a dialogue that included the ability of the customer to logon and make a purchase. If the dialogue of Figure 8-20 expands to include customer options from the main menu then this form would be subordinate to that option with reference number for return displays back to screen 6 or on to subordinate screens to continue the purchase process. The Products by Demographic Summary report and the Customer Purchasing Frequency Report would both be placed subordinate to screen 5 on Figure 8-20 with sequence numbers 5. 1 and 5. 2, respectively. Each would have reference number for return displays back to screen 5 or 1. These reports would not be part of the individual Customer section of the dialogue because they summarize activity for all customers of PVF.