80.2K

Verified Solution

Question

Finance

Vendor A

This Year

Plan

Last year

Net Sales $

$51,000

$50,000

$48,000

COGS $

Gross Margin $

$18,564

$19,100

$18,336

Gross Margin %

Vendor B

This Year

Plan

Last Year

Net Sales $

$51,500

$49,200

$51,500

COGS $

Gross Margin $

$19,570

$18,718

$18,849

Gross Margin %

  1. Calculate the sales percent for This Year versus Plan and This Year versus Last Year.

  2. Calculate the cost of goods in dollars for This Year, Plan, and Last Year.

  3. Calculate the gross margin percentage for This Year, Plan, and Last Year.

  4. Calculate the gross margin dollar percentage change for This Year versus Plan and This Year versus Last Year.

  5. After analyzing the above data, which vendors met their planned sales and gross margin in both dollars and percentage? For the vendors that did not achieve their sales and gross margin plan, what actions can a buyer take in order to achieve the plan?

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