ACC 202 ABI-WE 2 MSU Accounting homework

User Generated

Yrrrcw

ACC 202 ABIWE 2

Michigan State University

Description

All the description and questions are in the excel worksheet and before the order start you suppose to check all the part.

Thank you! I need to it back before Feb 27 23:59pm

Unformatted Attachment Preview

Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Hi, have done your assignment :). See attached :)

Step 1: Determine the variable and fixed portions of each expense.
You have been provided worksheets with an "Expense Report" template and "Accounting Policies" showing how the company classifies expenses.
In the "Expense Report" use VLOOKUP to fill in the Type, Classification, and Product/Period columns for each expense with information from the
"Accounting Policies" worksheet.
Complete the Cost per Unit column in the "Expense Report" worksheet. Use the production data (in yellow) at the top right corner of the worksheet.
When finding cost per unit use an IF statement so that Total Units Produced is used for product costs and Total Units Sold is used for period costs.
TIP: You only have to enter a formula once in the top row. REFERENCE (Absolutely) the appropriate cells and COPY (or drag) the formula down to include
all rows in that column.

Step 2: Turn the data into a Pivot Table.
Select the data from the "Expense Report" starting with the left column titled, "Acct. #", moving over to include all the columns and down to include every
expense on the trial balance. TIP: It is important to include the row that includes the column titles.
Insert a PIVOT TABLE on a new tab. RENAME the tab, "Pivot Table". TIP: You can right click on the name of the worksheet to change its color.

Step 3: Pivot the table appropriately to obtain relevant information.
In the FIELD LIST next to the Pivot Table, drag Classification and Type into the filter.
In the FIELD LIST next to the Pivot Table, drag Account Description to the rows and Total Cost to the sum of values. Be sure the VALUE FIELD SETTINGS are
set to SUM not COUNT. TIP: right click anywhere in the Pivot Table to open up the Field List choices on the right-hand side.
Filter the Pivot Table to list Fixed, MOH costs.
Highlight the expense titles and total cost in the Pivot Table and copy and paste them to the "Cost Structure" worksheet in the section for Fixed Overhead
(MOH).
Next, filter the Pivot Table to list Fixed, selling expenses and copy and paste the expense titles and amounts into the "Cost Structure" tab in the section
Fixed Selling. Follow the same steps above to fill in the Fixed Administrative section.
On the FIELD LIST next to the Pivot Table, drag Total Cost out of the Sum of Values and drag Cost Per Unit into the Sum of Values. THIS IS AN IMPORTANT
STEP! Variable costs should be shown as per unit amounts, NOT total amounts.
With the Type filter set to variable, use the Classification filter to find variable cost per unit for Selling, MOH, direct labor, and direct materials. Copy the
expense titles and costs per unit for these items from the "Pivot Table" to the "Cost Structure" worksheet and place within the appropriate section. Be
sure the VALUE FIELD SETTINGS are set to SUM not COUNT.

Step 4: Perform a CVP Analysis to determine how to reach a profit of \$3,645,710.
REFERENCING the information you just copied from the Pivot Table, complete the Cost Formula section in the top right portion of the "Cost Structure" ...

Review

Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4