Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. you are trying to calculate forecast gross profits

You are trying to calculate forecast gross profits for the next 12 months based on...

70.2K

Verified Solution

Question

Accounting

You are trying to calculate forecast gross profits for the next 12 months based on forecast sales figures and a fixed profit margin. The forecast sales figures are in cells B6 to M6 and the profit margin percentage is in cell B2. If you wish to enter a formula in cell B8 that can be copied across to M8 to give the gross profit for each month, which of the following formulae would be unsuitable?

A) "=$B$2*B6"

B) "=B$2*B6"

C)"=$B2*B$6"

D)"=$B$2*B$6"

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

The Kf for the formation of Co(NH3)62+ is 7.70 × 104. The Kf for the formation of Co(en)32+ is...

Chemistry
Q

A rigid tank of volume 0.75 m3 is initially evacuated. A hole develops in the wall,...

Mechanical Engineering
Q

Discuss how a parent, using authoritative, authoritarian, and permissive parenting styles would manage the behavior and...

Psychology
Q

Suppose now that you open the lollipops to find out that you have 9 red, 6...

Basic Math
Q

cos 40 miles Question 7 8 33 points Law of Sines Determine the approximate measure...

Basic Math
Q

Solve y 2 y 1 17 y Enter your answers separated by commas

Algebra
Q

Required information The Foundational 15(Algo)[L010-1, L010-2, LO10-3] [The following information applies...

Accounting
Q

Yarisbin facterp prwchied csntrolabie variance: interim comaguations to the nearest cent. a regulred

Accounting
Q

A Corp was owned 100% by B Corp. A Corp paid a $3 million distribution...

Accounting
Q

A company suffered loss from embezzlement and misappropriation. In relation to which entity can a...

Accounting
Q

The December utilities bills have been expensed in January, the following month, when paid. Utilities...

Accounting
Q

OC signed a contract to provide office cleaning services for an entity for a period...

Accounting