8. Now the managers would like to know how several output values change when sales...

80.2K

Verified Solution

Question

Accounting

image
image
8. Now the managers would like to know how several output values change when sales of Competition units increase. Create a data table that shows how Sales, COGS, Distribution Expense, and Marginal Net Income change when Competition Units Sold are increased from 3,500 to 3,900 in 100-unit increments. Do the analysis in the same Swim Accessories worksheet. Appropriately label the data table to make it easy to understand. Projections: $ 367,550.00 $ 120,000.00 247,550 umptions: Swim Accessories Categories Team Competition Casual arding revenues Units sold 2,500 3,500 3,000 Unit sales price $ 34.95 $ 44.95 $ 40.95 arding variable expenses (on a per unit basis) COGS 12.50 $ 12.50 $ 15.00 Distribution S 2.00 $ 3.50 $ 3.00 arding marginal fixed expenses Marketing 5 17,500 $ 30,000 $ 22,000 Payroll (not grouped by category) 70,000 Estimated overhead (not grouped by category) $ 25,000 er items Marginal tax rate 35% 11,507 236,044 SA SA SA Sales COGS Gross profit Other variable expenses Distribution expense Contribution margin Fixed expenses Marketing $ Payroll Overhead Total fixed expenses Marginal income before taxes Estimated income tax expense Marginal net income 69,500 70,000 25,000 164,500 71,544 25,040 46,503 $

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