Jeweltopia is a trendy online jewelry boutique that completed its first year of operations. Management would like to conduct some data analysis to take a detailed look at various business activities. Jill, the sales head, is concerned that their sales have not met their budgeted sales every month. Analysts collected the following data: Jill decided to analyze his data and create some visuals to assist during the presentation of her findings to management. With all this in mind, please answer the following questions.
a. Using Excel, determine sales variances for each month. Also, determine if the Jeweltopia had favorable or unfavorable sales variance for the year as a whole.
b. Jill would like to create visual aids to depict this data in a way. What kind of graph would you create for Jill and why? Using Excel, create this graph.
c. Based on your answers to parts a) and b), do you believe Jill's concerns are warranted? What would you recommend Jill do about their budgeting or current sales figures?

Question

Jeweltopia is a trendy online jewelry boutique that completed its first year of operations. Management would like to conduct some data analysis to take a detailed look at various business activities. Jill, the sales head, is concerned that their sales have not met their budgeted sales every month. Analysts collected the following data:  Jill decided to analyze his data and create some visuals to assist during the presentation of her findings to management. With all this in mind, please answer the following questions. 
a. Using Excel, determine sales variances for each month. Also, determine if the Jeweltopia had favorable or unfavorable sales variance for the year as a whole.
b. Jill would like to create visual aids to depict this data in a way. What kind of graph would you create for Jill and why? Using Excel, create this graph.
c. Based on your answers to parts a) and b), do you believe Jill's concerns are warranted? What would you recommend Jill do about their budgeting or current sales figures?

Quizplus · Accepted Answer

The Answer of Jeweltopia is a trendy online jewelry boutique that completed its first year of operations. Management would like to conduct some data analysis to take a detailed look at various business activities. Jill, the sales head, is concerned that their sales have not met their budgeted sales every month. Analysts collected the following data:  Jill decided to analyze his data and create some visuals to assist during the presentation of her findings to management. With all this in mind, please answer the following questions. 
a. Using Excel, determine sales variances for each month. Also, determine if the Jeweltopia had favorable or unfavorable sales variance for the year as a whole.
b. Jill would like to create visual aids to depict this data in a way. What kind of graph would you create for Jill and why? Using Excel, create this graph.
c. Based on your answers to parts a) and b), do you believe Jill's concerns are warranted? What would you recommend Jill do about their budgeting or current sales figures?

Jeweltopia Is a Trendy Online Jewelry Boutique That Completed Its