Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need major help entering the answers in excel formula on excel Jx A B D E F G H 1 K L M Data

I need major help entering the answers in excel formula on excel
image text in transcribed
image text in transcribed
Jx A B D E F G H 1 K L M Data Section: Percent Conversion 40% Units 60,000 210,000 30,000 Work in process, beginning Units completed during the months Work in process, anding 70% HINT: Formulas in RED will be in units Forumlas in BLUE will percentages Formulas in GREEN will be in dollars Costs to account for: To find started and completed: Completed units - beginning inventory Started during the month - ending Inventory Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for Total $ 94,800 $ 151,200 $ 600,300 FORMULA 1 Direct Mat. % Added During Whole Units the Month Beg. Work in process FORMULA2 FORMULA 5 Started & Completed FORMULA 3 FORMULA 6 Ending Work in process FORMULA 3 FORMULA 7 Total Cost assignment % Added Direct Mat During the Conversion Beginning Direct Equiv. Units Month Equiv. Units Inventory Materials Conversion FORMULAS FORMULA 12 FORMULA 15 FORMULA 19 FORMULA 22 FORMULA 2! FORMULA 9 FORMULA 13 FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 2 FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 21 $0 $0 $0 Total $0 so $0 $0 Direct Mat Cost per FORMULA 11 equivalent unit Conversion FORMULA 18 Amount reported on the balance sheet as: Finished goods Inventory FORMULA 28 Work In Process Inventory FORMULA 29 Sheet1 Sheet2 Sheet3 + Ready improvements, choose Check for Updates. Module 3 Excel Spreadsheet Instructions In the Module 1 MFG spreadsheet, you used formulas to complete the Excel. By using these formulas instead of directly inputting the answers, you are creating a spreadsheet where the inputs can be changed and your outputs will be automatically updated. In this module, we are going to explore this concept further. Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #1 Inputs: Percent Conversion 40% Work in process, beginning Units completed during the months Work in process, ending Units 60,000 210,000 30,000 70% Costs to account for: Total Beginning work in process Materials added Conversion costs incurred $ $ $ 94,800 151,200 600,300 Check figure: Amount reported on the balance sheet as Finished goods inventory $ 760,200 FOC

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

Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

5th edition

9780470418239, 470239808, 9780470239803, 470418230, 978-1118128169

More Books

Students also viewed these Accounting questions

Question

Sell the quality of your brand or products.

Answered: 1 week ago