Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show formulas! 5. Enter a SUMIFS function into cell B8 on the Contribution worksheet that sums the variable product costs on the Sales and

please show formulas! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
5. Enter a SUMIFS function into cell B8 on the Contribution worksheet that sums the variable product costs on the Sales and Cost Data worksheet. The setup of this function is identical to the SUMIFS function in step 4 with the following changes: This function should find a match to the item in cell A8 (Product) in Column C on the Sales and Cost Data worksheet. This function should also find a match to the item in cell A6 (Variable Cost) in Column D on the Sales and Cost Data worksheet. Add cell capacity to include Row 100 on the Sales and Cost Data worksheet. 6. Enter a formula in cell C9 on the Contribution worksheet that sums the two variable costs in cells B7 and B8. 7. Enter a formula in cell C10 that calculates the Contribution Margin. The formula should subtract the total variable costs in cell C9 from the sales revenue in cell C5 (C5-C9). 8. Enter a SUMIFS function into cell B12 on the Contribution worksheet that sums the fixed SG\&A costs on the Sales and Cost Data worksheet. The setup of this function is identical to the SUMIFS function in step 4 except this function should find a match to the item in cell A12 (SG\&A) in Column C on the Sales and Cost Data worksheet. Add cell capacity to include Row 100 on the Sales and Cost Data worksheet. Contribution Sales and Cost Data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Deciding What To Teach And Test Developing Aligning And Auditing The Curriculum

Authors: Fenwick W. English

1st Edition

0803968329, 978-0803968325

More Books

Students also viewed these Accounting questions