Compute net income using absorption costing

Assignment Help Accounting Basics

Reference no: EM132883341

Absorption vs. Variable Costing Assignment

A Company

This is the first year so there is no beginning inventory.

BUDGETED:
Sales 6,000 units [at $30 per unit]
Production 7,000 units
Variable mfg. cost $10 per unit [DM-$5; DL-$3; Var. mfg. overhead-$2]
Fixed mfg. cost $ 4 per unit [based on planned production of 7,000 units]
Var. S&A cost $ 1 per unit [based on units sold]
Fixed S&A cost $ 2 per unit [based on planned sales of 6,000 units]

ACTUAL:

Sales 6,200 units @ $30
Production 6,400 units

There were no efficiency variances.
There were no material, labour or variable overhead spending variances.
There were no fixed S&A spending variances. We spent the same as budgeted.

There was a $2,000 unfavourable fixed overhead spending variance.
Fixed overhead denominator variance must be calculated.

REQUIRED: Make an excel spreadsheet, using cell references wherever possible, that will allow a user to enter the above numbers and...
1) Compute net income using Absorption costing.
2) Compute net income using Variable (direct) costing.
3) Reconcile the difference in net income.

Absorption vs. Variable Costing Assignment (PART TWO)

B Company

Beginning inventory is 4,000 units
All rates were the same in the previous year.

BUDGETED:

Sales 60,000 units [at $50 per unit]
Production 75,000 units
Variable mfg. cost $20 per unit [DM-$8; DL-$7; Var. mfg. overhead-$5]
Fixed mfg. cost $10 per unit [based on planned prod. of 75,000 units]
Var. S&A cost $ 3 per unit [based on units sold]
Fixed S&A cost $ 2 per unit [based on planned sales of 60,000 units]

ACTUAL:
Sales 58,000 units @ $50
Production 65,000 units

There were no efficiency variances.
There were no fixed S&A spending variances. We spent the same as budgeted.

There was $50,000 F in material, labour and variable overhead spending variances.

There was a $20,000 unfavourable fixed overhead spending variance.
Fixed overhead denominator variance must be calculated.

Reference no: EM132883341

Questions Cloud

How a less-than-ideally-matched employee might impact a smal : How a less-than-ideally-matched employee might impact a small firm?

Canadian space exploration organization : You should approach the following question/case as if you are an HR consultant brought in by the employer; you must answer all aspects of questions 1 and 2, pro

Define the types of charismatic and transformational leaders : The company you work for is at a key moment for its development. The general manager has retired, so a new leader has to be recruited. Employees are discouraged

Explain the four steps in the control process : Explain the four steps in the control process and how could such steps help this company in the future.

Compute net income using absorption costing : Compute net income using Absorption costing and Compute net income using Variable (direct) costing and Reconcile the difference in net income

Troubleshoot sensitive customer service issues : You are interviewing for a position as a customer service associate at a new fulfillment company, much like Amazon

Construct on the contribution of technical writing : A.) REFLECTION. Construct on the contribution of Technical Writing in your Tourism Management.

When should employees attempt to resolve conflict themselves : When should employees attempt to resolve conflict themselves. Explain

Development and implementation of the project : You are required to address the following key elements in the development and implementation of the project in approximately 500 words or more:

User Account

All Pages