excel
ATC 2-7 Spreadsheet Assignment Mastering Excel
Siwa Company makes and sells a decorative ceramic statue. Each statue costs $50 to manufacture and
sells for $75. Siwa spends $3 to ship the statue to customers and pays salespersons a $2 commission for
each statue sold. The remaining annual expenses of operation are administrative salaries, $70,000;
advertising, $20,000; and rent, $30,000. Siwa plans to sell 9,000 statues in the coming year.
Peste
1
2
4
5
17
7
8
14
15
16
10
11
12
13
File
Page Layout
Inint
Home
X 04
Copy
Format Painter
Copboard
C30
Arial
BIU-
M
Pont
f
Formulas
- 11
A B
C
Chapter 2 - Mastering Excel
18
19
20
MN Sheet1 Sheet2 Sheet3
Rrady
Fixed Expenses
Net Income
A A
Sales Revenue
Variable Expenses
Cost of Goods Sold
Sales Commissions
Shipping Expenses
Contribution Margin
Data Review
Administrative Salaries
Advertising
Rent
Source: Microsoft Excel 2010
Operating Leverage
View
Ayriment
ATC 2-7- Microsett Excel
Wrap Test
Merge & Center-
Contribution Margin Format Income Statement
(9,000 x $75 )
(9,000 x $50 )
(9,000 x $ 2)
(9,000 x $ 3 )
General
5.%.
Number
DE F G
Cass
Conditional Format
Formatting as Table - Styles-
Styret
H
1
Name:
$ 450,000
18,000
27,000
$ 70,000
20,000
30,000
Insert Delate Format
Calty
J
K
AutoSum
Fa-
2 Cear
$675,000
495,000
$180,000
120,000
$ 60,000
3.00
220%
YA
Sort & Find &
Fimar - Select-
Exting
Required
Construct a spreadsheet that shows a contribution margin format income statement and that calculates
operating leverage. Place formulas in the spreadsheet to allow changes to any of the preceding informa-
tion to be automatically reflected in the income statement and operating leverage.