Answered step by step
Verified Expert Solution
Question
1 Approved Answer
REVENUE August September October November December Wedding Invitations $4,507 $4,687 $4,875 $5,070 $5,273 Birthday Party Invitations $3,841 $4,148 $4,480 $4,839 $5,226 Business Party Invitations $2,652
REVENUE | August | September | October | November | December |
Wedding Invitations | $4,507 | $4,687 | $4,875 | $5,070 | $5,273 |
Birthday Party Invitations | $3,841 | $4,148 | $4,480 | $4,839 | $5,226 |
Business Party Invitations | $2,652 | $2,758 | $2,868 | $2,983 | $3,102 |
Total Sales Revenue | $11,000 | $11,594 | $12,223 | $12,891 | $13,601 |
EXPENSES | |||||
Printing Costs | $4,400 | $4,637 | $4,889 | $5,157 | $5,440 |
Salaries | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Administration | $550 | $580 | $611 | $645 | $680 |
Advertising | $1,544 | $1,621 | $1,702 | $1,787 | $1,877 |
Legal Fees | $788 | $764 | $741 | $719 | $698 |
Shipping | $928 | $974 | $1,023 | $1,074 | $1,128 |
Total Expenses | $11,710 | $12,077 | $12,467 | $12,882 | $13,323 |
Net Income before Taxes | -$710 | -$483 | -$244 | $9 | $278 |
Taxes | $0 | $0 | $0 | $3 | $78 |
Net Profit (loss) | -$710 | -$483 | -$244 | $7 | $200 |
A line chart (August December) shows the trend over the entire period in total sales revenue, expenses and net profits. Be sure to select the right graph type and label the chart well in order to indicate that you are displaying the results in thousands of dollars. Save the chart on a separate worksheet, enter the name "Trend" in the index tab. The chart should not be "embedded" (which looks copied with gridlines in the background), but on a new sheet, clear and presentable with all proper labels.
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