50.1K

Verified Solution

Link Copied!

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.

Answer & Explanation Solved by verified expert

See Answer