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

  Calculate the revised material handling costs

Calculate the material handling rate that would have been used by Eloise Smiths predecessor at East Coast Marine and calculate the revised material handling costs to be allocated on a per purchase order basis.

  In this case a full set of budgets will be prepared and

in this case a full set of budgets will be prepared and presented in appropriate format.nbsp reports will be prepared

  Product mix and product line

Make a distinction between a product item, a product mix, and a product line. Give examples.

  Question on cvp computation

Determine the break even point in units. The company has a capacity of 150,000 units and is currently at two thirds of its capacity. The sales manager believes the company could increase sales by 8,000 units if advertising expenditures are increa..

  Brinkers bicycle shopnbsp a special order decisionthis

brinkers bicycle shopnbsp a special order decisionthis offer is the greatest thing thats happened to us since we

  Evaluate the total monthly fixed cost

What would you expect to happen to the costs of cakes - The owner of the company has provided the following data concerning the activity rates in its activity-based costing system

  Compute the break-even point in dollars for 2014

Compute the break-even point in dollars for 2014 and compute the contribution margin under each of the alternative courses of action.

  Developing unit costs using normal costing

The Coastal Landscaping and Snow Removal company employs normal costing to assign overhead costs to firm's various jobs. Labor is charged to jobs at $25 per hour and for upcoming winter session, overhead is estimated at $200,000 for $10,000 hours ..

  Discuss the stance and initiatives of the australian account

Discuss the way in which AGL has demonstrated its social and environmental accountability in the last two years.

  Question on segment reporting

Slatter Corp operates primarily in the United States. However, few years ago, it opened plan in Spain to produce merchandise to sell there. This foreign operation has been so successful that throughout the past 24 months the company started a manu..

  Measurement in the context of accounting

Measurement in the context of accounting The diverse measurement methods developed for different kinds of assets propose that standard setters are confused regarding the nature of the attribute which is to be measured

  Production budget of franklin glass

Franklin glass works production budget was based on 200,000 units. Each unit requires two standard hours of labor for completion,. Total overhead was budgeted at $900,000 per year, and fixed rate was estimated to be $3 for each unit.

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