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

  Cost-volume-profit analysis and strategy

Mr. Carter is manager of Simmons Farm and Seed Company, a wholesaler of fertilizer, seed, and other farm supplies. The company has been successful in current years primarily because of great customer service, flexible credit terms, customized orde..

  Percentage markups on cost

What percentage markups on selling price are equivalent to the following percentage markups on cost: 33 1/3, 20, 40, and 50? Discuss importance.

  Question on operating cycle and cash conversion cycle

Camp Manufacturing turns over its inventory 8 times each year, has an average payment period of 35 days, and has an average collection period of 60 days. The firm's annual sales are 3.5 million dollars. Assume there is no difference in the investm..

  Managerial accounting-planning and controlling

How is managerial accounting working for planning and controlling? Point out any specific roles of managerial accounting compared with other organizations.

  Determining the traditional costing-activity based costing

K's Cornerspot, a popular university eatery in a competitive market, has seating & staff capacity to serve about 600 lunch customers every day. For the past 2 months, demand has fallen from its previous near-capacity level. Concerned about his dec..

  Shellhammer company is considering the purchase of a new

shellhammer company is considering the purchase of a new machine. the invoice price of the machine is 170000 freight

  Advertising technologies inc ati specializes in providing

advertising technologies inc. ati specializes in providing both published and online advertising services for the

  Healthcare operations budget

Many areas should be considered when developing the healthcare operations budget. To accurately assess revenue and cost considerations, strategic forecasting should be performed. Each kind of healthcare business (i.e., hospital, health plan, facil..

  Determine the amount of cost in the raw materials

AC 505 Case Study I,  Determine the amount of cost in the Raw Materials, Work in Process, and Finished Goods Inventory as of the date of the storm. ( Hint: You may wish to reconstruct the various schedules and statements that would have been affecte..

  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.

  Question 1 the boudenza postal service bps was formed in

question 1 the boudenza postal service bps was formed in 1870 with a mandate to establish a postal delivery system in

  Consider an american automaker like gm with production

consider an american automaker like gm with production facilities in 50 countries and sales in almost 200 countries to

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