Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help, i am using office 360. Thank you! G H 1 J 3 4 LO 7 ar . B C D E F H
Please help, i am using office 360. Thank you!
G H 1 J 3 4 LO 7 ar . B C D E F H 1 SG&A Variance to Forecast 2 3 Deptid Department Actual Forecast Variance 4 100 Corporate $187,274 $175,000 -7.01% 5 101 Accounting $61,456 $60,000 -2.43% 6 102 HR $88,133 $90,000 2.07% 200 Operations $167,209 $150,000 -11.47% 8 202 Research $116,801 $125,000 6.56% 9 206 Manufacturing $175,202 $165,000 -6.18% 10 301 Sales $169,975 $125,000 -35.98% 11 305 Marketing $212,012 $185,000 -14.60% 12 400 Logistics $172,371 $200,000 13.81% 13 410 IT $92,749 $100,000 7.25% 14 420 Warehouse $57,845 $75,000 22.87% 15 16 Required: 1. Highlight all variances greater than +10% with Green Fill with Dark Green Text. 17 2. Highlight all variances less than -10% with Ligh Red Fill with Dark Red Text. 18 9 1 . B B C D E F G H 1 2 3 4 5 6 Summary Total Debits Total Credits Diff $25,853.00 $25,853.00 $0.00 7 8 Telephone Expense Allocation Credit 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Account Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Department Comments Operations To allocate telco by cell number Research To allocate telco by cell number Manufacturing To allocate telco by cell number Sales To allocate telco by cell number Marketing To allocate telco by cell number Logistics To allocate telco by cell number IT To allocate telco by cell number Warehouse To allocate telco by cell number Accounting To allocate telco by cell number Corporate To allocate telco by cell number Debit $3,750.82 $2,120.97 $1,297.83 $12,725.13 $1,982.20 $125.25 $2,207.85 $497.20 $1,145.75 $25,853.00 Required: 1. Format the Diff value with Green Fill with Dark Green Text if the value equals 0. 2. Format the Diff value with Light Red Fill with Dark Red Text if the value does not equal 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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