Question: please use excel formulas to calculate where needed Eable Eosting Chapter 5 Excel Problem Data Using the following information, complete the production report: WIP, beginning


Eable Eosting Chapter 5 Excel Problem Data Using the following information, complete the production report: WIP, beginning 35,000 units, DM 60%, CC 30% complete WPP, ending 20,000 units, DM 75%, CC 25% complete. Units started this period 175,000 Units completed and transferred out 190,000 This excel problem will not have a separate input section. In other words, you will use the information given and input it in the appropriate cells, which will be the only cells in which you will type just a number. Every other cell that contains information will come from a calculation. The rest of the template will be completed by putting formulas in the appropriate cells so that the necessary calculations are performed to complete the production report. On the second tab, journalize the following and answer the questions shown there: 1. The requisition of raw materials into production. 2. The addition of conversion cost (credit conversion costs) 3. The transfer of completed units to Finished Goods
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
