Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 3. Data Analytics & Excel Facts: ABC Manufacturing Company (ABC) is closing its books for the year ended 12/31 X4. You are aware the
Part 3. Data Analytics & Excel
Facts:
- ABC Manufacturing Company (ABC) is closing its books for the year ended 12/31 X4. You are aware the Management of ABC has an aggressive attitude toward achieving both their budgeted annual sales and budgeted net income. Historically, ABCs sales tend to be spread fairly uniformly throughout the year (i.e. ABC is not a seasonal business). Also, in recent years, ABCs sales have been increasing about 20% per year.
- You note the following calendar quarterly sales for the year-end 12/31/X4 and the two prior years 12/31/X2 & 12/31/X3.
Calendar Year Ending | $ Sales in Quarter Ending March 31st | $ Sales in Quarter Ending June 30th | $ Sales in Quarter Ending September 30th | $ Sales in Quarter Ending December 31st |
12/31/X2 | $1,040,000 | $970,000 | $1,020,000 | $1,030,000 |
12/31/X3 | $1,210,000 | $1,230,000 | $1,260,000 | $1,280,000 |
12/31/X4 | $2,100,000 | $2,300,000 | $2,700,000 | $3,400,000 |
Required:
- Prepare a line chart --using Excel -- of Sales by Quarter by year. The Quarters should be on the horizontal axis; dollar sales should be on the vertical axis. Your chart should have 3 lines one for each year. Your chart should have an appropriate title. Students must submit via D2L both this line chart as well as their comments required in 2 below.
- Please explain any concerns you have based upon your review of the completed line chart in view of the Facts described above.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started