2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the
number of orders from 4 to 20. (Prior to completing this requirement, change all worksheet figures back to their original amounts.)
A
B
C
D
E
1
Chapter 7: Applying Excel
2
3
Data
4
Manufacturing overhead
$
500,000
5
Selling and administrative overhead
$
300,000
6
7
8
Manufacturing overhead
9
Selling and administrative overhead
10
Total activity
11
12
13
OfficeMart orders:
14
Customers
15
Orders
16
Number of filing cabinets ordered in total
17
Selling price
18
Direct materials
19
Direct labor
Assembling
Units
Processing
Orders
Supporting
Customers
Other
50%
35%
5%
10%
10%
45%
25%
20%
1,000
250
100
units
orders
customers
1 customer
20 orders
80 units
$
595
$
180
$
50