Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assignment 5.1, Problem 9A2, page 375. Each Column (B-K) must have an answer. Please make sure that waterloo division & cedar rapids is done and
Assignment 5.1, Problem 9A2, page 375.
Each Column (B-K) must have an answer. Please make sure that waterloo division & cedar rapids is done and then the following breakdown of the two.
1 | A | B | C | D | E | F | G | H | I | J | K | ||
2 | A | Company as a whole | Break down of 2 divisons | Break down of Waterloo Division | Break down of Cedar Rapids Division | ||||||||
3 | waterloo divisions | Cedar rapids division | Not allocated | Downtown | Summer | Not allocated | Downtown | Solon | Airport | ||||
4 | |||||||||||||
5 | net sales |
| 3,200 | 800 =B5*0.1 | 2,400 =B5*0.3 | ||||||||
6 |
| ||||||||||||
7 |
|
| 1, 400 =C5*0.4375 | 350 =G5*0.4375 | 1,050 =I5*0.4375 | ||||||||
8 |
| =SUM(C8:D8) | =SUM(I8:K8) | =F5*0.1 | 240 =I9*0.1 | =K5*0.05 | |||||||
9 |
| =SUM(B7:B8) | =SUM(F7:F8) |
| 1,290 =SUM(I7:I8) | 0 =SUM(J7:J8) | |||||||
10 |
| =B5-B9 | =C5-C9 | =F5-F9 | 1,110 =I5-I9 | =K5-K9 | |||||||
11 |
| 335 =SUM(C11:D11) | 335 =SUM(H11:K11) | 125 | 40 | 210 | 125 | ||||||
12 |
| =D10-D11 | =F10-F11 | =J10-J11 | |||||||||
13 |
| 490 =SUM(C13:D13) | 140 | 350 | 35 =C13*0.25 | 70 =E13*0.5 | 35 =C13*0.25 | 70 =D13*0.2 | 70 =D13*0.2 | 105 =D13*0.3 | 105 =D13*0.3 | ||
14 |
| =B12-B13 | =D12-D13 | =F12-F13 | =H12-H13 | =K12-K13 | |||||||
15 |
| 110 | |||||||||||
16 |
| =B14-B15 should = 2300 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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