Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

image text in transcribed

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 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Concepts For A Changing Environment With IDEA Software

Authors: Larry E. Rittenberg, Bradley J. Schwieger

4th Edition

0387321500, 978-0324180237

More Books

Students also viewed these Accounting questions

Question

Global happiness polls.

Answered: 1 week ago

Question

Explain key approaches to implementing LMD

Answered: 1 week ago