Calculate the cost in ending finished goods inventory

Assignment Help Managerial Accounting
Reference no: EM13491902

Requirement #1:

Calculate the following on the COGM worksheet:

1. Computation of Cost per unit: COGM/units produced

2. Calculate the number of units that were sold

3. Calculate the number of units in the finished goods inventory at the end of the year

4. Calculate the cost in ending finished goods inventory at the end of the year.

You should not type any number into a cell on the Schedule of COGM.

If I would change a number in your data field it would automatically change on the statements.

Requirement #2: Prepare 2 doughnut charts. I have a tutorial in the chapter 2 folder in course documents to assist you and developing a chart.

One chart should compare the total product costs to the total period costs, and another chart should compare the three types of product costs.

Insert these charts on separate sheets and comment on your chart results on the comment worksheet.

Requirement #3: Based on the current economic pressures, the company has decided to eliminate the part time janitor and the cost of that position  and have the production workers clean up the area. What will be the new COGM?

1. What will be the new COGM?

2. Computation of Cost per unit: COGM/units produced

3. Calculate the cost in ending finished goods inventory at the end of the year.


Attachment:- Project.xls

Reference no: EM13491902

Questions Cloud

Estimate the amount of inventory destroyed by the fire : Use the gross profit method to estimate the amount of inventory destroyed by the fire, and thus, the amount to be claimed from the insurance company.
Record the journal entries for the select transactions : Eraesi Company, which uses the perpetual inventory system, began operations on January 1, 2010. At January 1, 2011, the Company reports the following balances.
What is the coefficient of performance for the heat pump : A heat pump uses 100J of work output heat at some temperature. what is the coefficient of performance for the heat pump
Find the velocity of the driver as it hits the pile : A pile driver falls through a distance of 1.75m before hitting a pile. Find the velocity of the driver as it hits the pile
Calculate the cost in ending finished goods inventory : What will be the new COGM, computation of Cost per unit: COGM/units produced and calculate the cost in ending finished goods inventory at the end of the year.
What is the electric flux through one of six faces of cube : A point charge 5.00 nC is at the center of a cube with sides of length 0.140 m. What is the electric flux through one of the six faces of the cube
Prepare the closing entries for the company : Emaasxye has been operating as a sole proprietorship under the name XYZ Company for the last five years. The following is the company's unadjusted trial balance for the year ended Dec 31, 2011.
Determine the power loss of the wire : A wire made of aluminum is 882 m long and has a cross-sectional area of 36.6 10-7 m2. It is observed that 6.6 C pass through the wire in 79.2 s. Determine the power loss of the wire
State a solution is made by mixing equal masses of methanol : A solution is made by mixing equal masses of methanol, CH4O, and ethanol, C2H6O. Determine the mole fraction of each component to at least three significant figures.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd