CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 287 Weeks Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Accounting Posted 10 Dec 2017 My Price 10.00

Analyze and classify product and period costs

Please do asap  

Assignment attached.  thanks!!   

 

Project 2 The project relates to material covered in Chapter 2. Please post gen Due July 24th 11:59 pm Central Time e-mail me if you have a specific question and are unsure if it should b Submit your completed project by uploading your solution using this E Make sure you type in your name in cell A3 and save your file wi You will be graded on the accuracy of your answer and the usage of e Requirements 2-4 requires the usage of excel cell referencing an The project solution is worth a total of 10 pts. I will take off 5 pts I have a demonstration exercise that demonstrates the development o to the Chapter 2 folder. The requirements below are a little bit differe but there are a lot of similarities. We have to realize that real life is no You should use this worksheet as your as your data reference sheet. but feel free to ask questions in the office forum on Excel. I do not pre-grade, so if you email me make sure it is a specific q Objectives of Project 2 1. Analyze and classify product and period costs. 2. Develop the Cost of Goods Manufacturing statement for a manufacturing company. 3. Develop comparison charts. 4. Evaluate the costs of the production and operations. Grading Rubric for Project 2 Possible points 3 Requirement #2 COGM--.10 each 1.2 Each Calculation 1-6(.5 each) 3 Requirement #3 Charts - 1 pt. each 2 Comment on each chart (.15 each) 0.3 0.5 Total points possible 10 A deduction of 5 pts. if cell references are not used on requirements 2-4 Data and requirements for Project 2: This company makes a single product. The following information has been taken from the company's production, sales, and cost records for the month. Name: TYPE in your name here If you are using Excel 2013 , please make sure your file is compat Requirement #1 -.1 each classification and .25 for calculated amounts Requirement #4 (#1 worth .1 pt. and #2 and #3 each worth .2 pts.) The ?? Areas will need to be calculated as you move through the requirements for this project.
Background image of page 01

 

 

Production in units 29,000 Sales in units ?? Beginning Finished Goods in Units 0 Ending Finished goods in units ?? Total Sales in dollars $700,000 Unit selling price $25 Beginning of the month End of the month Inventories: Raw Materials $13,000 $12,000 Work in process $30,000 $28,000 Finished goods $0 ?? Costs: Direct labor $80,000 Advertising Expense $70,000 Indirect production labor $9,720 Raw materials purchased $130,000 $35,000 Utilities, Factory $32,000 ?? Maintenance, factory $20,000 ?? Selling and administrative Salaries $140,000 Utilities, selling and administrative $20,000 Part time janitor in the factory $12,000 There are 4 requirements to this project. A cost item can affect multiple areas. You are making your calculations based on this month's production and sales. I have entered the Direct labor to help get you started. Also, the selling and admin. Costs have been combined into one column. Building rent(production uses 82% of the space, administrative and sales offices uses the rest of the space) Royalty paid for use of production patent , $2.30 per unit produced Rent for special production equipment, $3,000 per month plus $.20 per unit produced Requirement #1 : Use the scenario above to fill in the chart below with the applicable information. Total each of the columns after you have assigned all the costs to the applicable column(s)
Background image of page 02

 

Attachments:

Answers

(12)
Status NEW Posted 10 Dec 2017 08:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)