Question: Prepare a contribution margin statement in excel. Assuming the cost of goods sold is 90% variable AND 10% fixed and general and administrative expenses are

Prepare a contribution margin statement in excel. Assuming the cost of goods sold is 90% variable AND 10% fixed and general and administrative expenses are 25% variable and 75% fixed, prepare a contribution margin statement. We have income statement Revenue $151800 Cost of good sold $126584 Gross margin $25216 General and admin.expenses $21005 Net income $4211 I have less than an hour.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

please answer the highlighted boxes Standard Job Order Costing - Variance Analysis 9 10 16 17 Special order lamps are manufactured in division S. Because of the precise nature of the process a 18...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $189 per unit during the current year. Its income statement is...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $186 per unit during the current year. Its income statement is...

Q:

Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $190 per unit during the current year. Its income statement is as follows: Sales Cost of goods sold Gross profit...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its income statement is...

Q:

Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $187 per unit during the current year. Its income statement is as follows: Sales Cost of goods sold Gross profit...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $190 per unit during the current year. Its income statement is...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $189 per unit during the current year. Its income statement is...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its income statement is...

Q:

Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its income statement is...

Q:

Calculate PV of retirement needs and annual payment needs for three scenarios: Retirement at 62 with 70% WRR Retirement at 65 with 75% WRR Retirement at 67 with 80% WRR Calculate PV of education...

Q:

The European Union has banned certain pesticides for two years after studies found links between the use of these insecticides and a decline in the bee population. In particular, research has shown...

Q:

Given d ^ ( 4 ) = . 0 5 1 2 . Find i ^ ( 2 ) . a ) . 0 5 2 2 b ) . 0 5 0 2 c ) . 0 5 3 2 d ) . 0 5 1 8 e ) . 0 5 1 5

Q:

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Q:

socialist egalitarianism which resulted in wage levelling;

Q:

soyuznye (all-Union, controlling enterprises directly from Moscow);

Q:

functional committees having no direct supervision of enterprises, but responsible for overall policy and planning (GosPlan) and certain subordinate aspects of economic life such as supply (GosSnab),...