Answered step by step
Verified Expert Solution
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 Freel FHle:
CHICKK JICURD: Naterial: Sner DU
Conversion: S ner U
Total cost fransferred out to nert dent: $
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 is units; complete as to material costs and complete as to conversion costs. This is August ending inventory from the previous report which becomes September beginning inventory in this report.
Ending WIP inventory, September is units; complete as to material costs and complete as to conversion costs.
Units started into production for September are
Carryover the material and conversion costs assigned to the ending WIP from the August report as the beginning WIP inventory prior period costs. Material Costs $ and Conversion Costs: $
Costs added during September are: $ for materials and $ for conversion.
Change the date in the heading to be "For the Month Ended September
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 dothen you have done the cell referencing incorrectly. You are only changing the Data Block page.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started