Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WHAT IF ANALYSIS DATA ( 2 ? N D Freel FHle ) : CHICKK JICURD: Naterial: S 6 . 3 5 ner DU Conversion: S

WHAT IF ANALYSIS DATA (2?ND Freel FHle):
CHICKK JICURD: Naterial: S6.35ner DU
Conversion: S2.4.42 ner 0 U
09/30/2023 Total cost fransferred out to nert dent: $373,365
The "What If" part of the assignment will help you determine whether you have correctly used cell referencing in your spreadsheets. In your data block page make the following changes:
Beginning inventory for WIP, September 1 is 800 units; 90% complete as to material costs and 20% complete as to conversion costs. (This is August 31,2023, ending inventory from the previous report which becomes September 1,2023, beginning inventory in this report.)
Ending WIP inventory, September 30,2023, is 675 units; 80% complete as to material costs and 35% complete as to conversion costs.
Units started into production for September are 12,000.
Carryover the material and conversion costs assigned to the ending WIP 8/31/2023(from the August report) as the beginning WIP inventory prior period costs. (Material Costs $4,536 and Conversion Costs: $4,304.)
Costs added during September are: $75,800 for materials and $297,920 for conversion.
Change the date in the heading to be "For the Month Ended September 30,2023".
Your spreadsheets should automatically recalculate using the new data. You should not have to change any of the cell references or formulas for either of your statements. (If you do-then you have done the cell referencing incorrectly.) You are only changing the Data Block page.
image text in transcribed

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

Fundamental Accounting Principles Volume 2

Authors: John Wild, Ken Shaw, Barbara Chiappetta

21st Edition

0077716663, 978-0077716660

More Books

Students also viewed these Accounting questions