Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a C++ program to calculate the sales statistics for each department this year. The store has standard sales amount (in thousand dollars) for each

Write a C++ program to calculate the sales statistics for each department this year. The store has standard sales amount (in thousand dollars) for each month based on data in previous years.

Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec

23.0 33.1 21.0 23.5 54.0 34.3 35.0 45.0 56.3 45.6 34.0 55.0

The monthly sales amounts for departments were stored in a file sales.dat. Every line in the file contains 12 sales amounts for a department.

Write a C++ program to calculate statistics for each department in the store. Your program should open the file sales.dat and do the following:

Store the standard sales amount in an array

Read the sales amount for a department into a parallel array

Compute the average monthly sale.

Compare each monthly sales amount with the standard and store the result in a third array of Boolean. The program will store true in the third array if the amount is larger than or equal to the standard and false otherwise.

Use the third array to find out how many months are below standard and how many are above.

Output the statistics for the department, including department number, average sales amount, numbers of months above and below standard, and performance. The program should output unsatisfactory as the performance of the department if more than four months are below standard and satisfactory otherwise.

Keep processing each department until the end of the file.

The program must include a single function for each of the following. You may use more functions or break these into multiple functions as needed or desired.

Given the array of sales amount, return the average sales amount.

Given the array of sales amount, compare with the standard array and enter comparison results in the third array.

Given the third array of Boolean, return the number of months in which the sales amounts are above standard.

Output a final statistics for each department.

"sales.dat"

23 33.5 21 23 25 56 54 43 34.2 35.4 34 69.5

24 35.2 24 26 43 56.7 54 32 43 34 34 57.9

24 42 43 35 52 56 67 54 56 45.3 32 32

20 32 45 72 45.4 63.2 45 56 52 65 53 65

34 35 37.5 32 23 45 31 43 52 43 76 65

35 56 63.4 45.2 45.6 56 67.3 45 56.3 67 78 76

34.2 45 62 19 45 39 38 37 82 74 45 58.4

Sample output using sales.dat as input file

> ./a.out

Store Statistics

Dept Average Above Below Performance

---------------------------------------------------------------------------------------------

1 37.6 7 5 unsatisfied

2 38.6 8 4 satisfied

3 44.9 7 5 unsatisfied

4 51.1 8 4 satisfied

5 43.0 7 5 unsatisfied

6 57.6 11 1 satisfied

7 48.2 9 3 satisfied

PLEASE NOTE

The program is well documented.

The program computes and outputs correct statistics

The program contains at least the four functions as specified in the handout

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago