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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Chemistry
1.2K views

GRIGNARD REACTION: Precise mass (in grams) of the bromobenzene used: .21g Precise mass (in grams) of the magnesium...

Physics
1.2K views

1-What is the expression for the thin lens equation? Define all the terms in the expression. 2-Describe...

Operations Management
1.2K views

Required references 1- Identify ways to make performance evaluations more effective. Do you believe one of your...

Finance
1.2K views

Bond Valuation with Annual Payments Jackson Corporation's bonds have 5 years remaining to maturity. Interest is paid...

Finance
1.2K views

?(Percent of sales forecasting?) Which of the following accounts would most likely vary directly with the level of a?...

Biology
1.2K views

Document A: Eugene V. Debs Speech (Modified) Eugene V. Debs was a founding member of...

Biology
1.2K views

The segmented worms are true coelmate organisms called A annelida B platyhelminthes C poriferan D...

Biology
1.2K views

oughout the simulation you be asked questions about simulation If you answer correctly most questions...

Physics
1.2K views

A 0 270 m long bar with mass 0 100 kg is released with an...

Algebra
1.2K views

For f x x17 and g x 17 x find fog x and gof x...

Accounting
1.2K views

Your aunt and uncle are each 62 years old and hope to retire in four...

Accounting
1.2K views

please help i have 30 mins left Playoff Corporation holds 90 percent ownership of...