Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2, assume actual sales are 250,000 units and target ending inventory is 10,000 units. PART 2 - Build an income statement Jery wants to

Part 2, assume actual sales are 250,000 units and target ending inventory is 10,000 units. image text in transcribed
PART 2 - Build an income statement Jery wants to project year-end results to see if the company will meet the budget. He runs the following data: Sales estimate: Average for all products Quantity Price Variable Selling costs Fixed selling costs 200,000.00 Production costs Direct materials Direct labor Variable overhead Fixed overhead Gieneral and admin 13,250,000,00 Reginning inventory (Sep 30) Projected ending inveotory (Dee 31) The Company projected to produce 250,000.00 units for the quarter. This is the denominator used to allocate fixed overhead. 1. Create two year-end projected income statements for Jerry: a) Absorption costing. b) Variable costing c) reconciliation between the two i) The reconciliation should include the difference between the two income amounts. Reconcile this difference to the inventory difference as described in the chapter and lecture. In other words, prove that your difference is correct. ii) Create a conditional "If" statement to check that your difference, reconciled in i) above is correct. If your difference is correct, the conditional statement should say "CORRLCT". If your differenee is incorrect, the cell should say "ERROR". This workshcet should be LINKED (cell referenced) to this instructions workshect. Label your worksheet "Projected income statements" PART 2 - Build an income statement Jery wants to project year-end results to see if the company will meet the budget. He runs the following data: Sales estimate: Average for all products Quantity Price Variable Selling costs Fixed selling costs 200,000.00 Production costs Direct materials Direct labor Variable overhead Fixed overhead Gieneral and admin 13,250,000,00 Reginning inventory (Sep 30) Projected ending inveotory (Dee 31) The Company projected to produce 250,000.00 units for the quarter. This is the denominator used to allocate fixed overhead. 1. Create two year-end projected income statements for Jerry: a) Absorption costing. b) Variable costing c) reconciliation between the two i) The reconciliation should include the difference between the two income amounts. Reconcile this difference to the inventory difference as described in the chapter and lecture. In other words, prove that your difference is correct. ii) Create a conditional "If" statement to check that your difference, reconciled in i) above is correct. If your difference is correct, the conditional statement should say "CORRLCT". If your differenee is incorrect, the cell should say "ERROR". This workshcet should be LINKED (cell referenced) to this instructions workshect. Label your worksheet "Projected income statements

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

Step: 3

blur-text-image

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

Introduction To Accounting

Authors: Peter Scott

2nd Edition

0198849966, 978-0198849964

More Books

Students also viewed these Accounting questions

Question

Learning is a good thing for everyone. Discuss.

Answered: 1 week ago

Question

What should be the role of managers in HRD?

Answered: 1 week ago

Question

What should be the role of government in HRD?

Answered: 1 week ago