Question: 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.
 WHAT IF ANALYSIS DATA (2?ND Freel FHle): CHICKK JICURD: Naterial: S6.35ner

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!