Answered step by step
Verified Expert Solution
Link Copied!

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

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

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, Maureen Sterling

7th Canadian Edition

1260065952, 978-1260065954

More Books

Students also viewed these Accounting questions

Question

=+How can you personalize the language?

Answered: 1 week ago

Question

=+Can your message work in another locale?

Answered: 1 week ago

Question

=+Can you create an idea that spins out?

Answered: 1 week ago