SA2 Frances Drew ib_e03_departmentstoreplanningmeeting.xlsx

# SA2 Frances Drew ib_e03_departmentstoreplanningmeeting.xlsx...

This preview shows pages 1–3. Sign up to view the full content.

# Questions 1 2 3 4 5 6 Look at the totals in cells B8, C8, F8. Do the numbers add up? Test drive the sheet by changing the amount in cell D4 to .10 do you see a new sales plan number in C4 that makes sense. Change the value in B4 to 8000000. Do you see a new sales plan number in cell C4 when the value in cell B4 was changed? The profit in dollars in column F are calculated by multiplying the profit percent values in column E by the sales values in column C. Change the value in cell E4 to .20. Does this change produce a new profit dollar value in cell F4? Look at the totals in cells B8, C8, F8. Do the numbers still add up? What could you use to see and check all the formulas in this sheet? What clues would tell you that

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: something might be wrong with a formula? Answers yes yes no no no Formula auditing would help to see all of the formulas on the sheet. One way to know that there is an isues with the formulas is if the totals do not change when the data is adjusted. Sales Projections by Department Projections for This Year Sales Sales Growth Profit Dollars Kitchen \$8,000,000 \$11,000,000 10.00% 20.00% \$3,300,000 Bathroom \$8,000,000 \$8,800,000 10.00% 35.00% \$3,080,000 Outdoor \$7,000,000 \$7,070,000 1.00% 20.00% \$1,414,000 Seasonal \$5,000,000 \$5,250,000 5.00% 45.00% \$2,362,500 Totals \$30,000,000 \$31,120,000 3.73% 31.67% \$9,856,500 Sales Last Year Profit Percent...
View Full Document

## SA2 Frances Drew ib_e03_departmentstoreplanningmeeting.xlsx...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online