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

Charge is distributed inside a long cylindrical volume of radius R such that charge density...

Physics
Q

3 3 4 4 40 The equation y 4 2 sin 6t 3x represents wave...

Physics
Q

The Football Boosters bought pizza for $900 to sell at the game. They kept 10...

Basic Math
Q

Sarah wants to study the time it takes to complete a lab in a regular...

Basic Math
Q

Before every flight, the pilot must verify that the total weight of the load is...

Basic Math
Q

F 10 8 6 lim f x 00 X 3 lim f x x 3...

Calculus
Q

Prepare journal entries for the following 4 questions. Include an explanation for each. 1) Purchased...

Accounting
Q

Which of the following group of accounts is not closed at the end of the...

Accounting
Q

W\&W Tax Service offers tax and consulting services to individuals and small businesses. Data for...

Accounting
Q

Henrie's Drapery Service is investigating the purchase of a new machine for cleaning and blocking...

Accounting
Q

Arboles Company manufactures pencils and has the following information available for the month of July:...

Accounting
Q

Compute the MIRR statistic for Project J if the appropriate cost of capital is 10...

Finance