Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Question
Submitted by ronyro on Fri, 2013-06-07 22:16
due on Tue, 2013-06-11 21:50
answered 7 time(s)
Hand shake with Abhishek Jain: In progress
Hand shake with helloworld: In progress
Hand shake with Economic Tutor: Complete ($10.00 paid)
Hand shake with Assignment Ex...: Complete
ronyro is willing to pay $25.00
ronyro bought 69 out of 78 answered question(s)

Assignment 3: Excel Problems

Assignment 3: Excel Problems

At the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.

Complete problems P16A-17B (p. 898), P16A-19B (p. 899),  P18-24A (p. 979), P18-26A (p. 980) in your textbook.

Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.

Answer
Submitted by accountguru on Sat, 2014-04-19 04:15
teacher rated 491 times
4.77393
purchased 7 times
price: $25.86

Answer rating (rated one time)

5

Cost Accounting_Four questions

body preview (4 words)

xxxx xxxxxxxxxxxxxxx questions

file1.xlsx preview (466 words)

P16A-18B

xxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxx Paper xxxx
xxxxxx Units xxxxxxxxxxx xxxxx
Material Direct xxxxxxxxxxxxxxxxxx xxxxxxxx
Units completed & xxxxxxxxxxxxxxxxxxxxx xxxxxxxxxx
xxxxxx Units650163 163163
Total 5,070 4,583xxxxx 4,583
xxxxx xxxxxxxx xxxxxx$575$6,240
xxxxxx xx Equivalent xxxxxxxxxx4,583 xxxxx
xxxx per xxxxxxxxxx unit $1.24$0.13 $1.36
Costs xxxxxxxxx xx
Units completed & xxxxxxxxxxx xxxxx xxxxxx xxxx$6,019
xxxxxx Units 163xxxx xxxxxxx
xxxxxx xxxxxx$575$6,240

xxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
1. Draw a xxxx xxxx for xxx xxxxxxxxxxx Department
Preparation Department
xxxx Cut into xxxxx Bitsxxxxxxxx xxxxxxxxxxxxxxxx xx Compression Department
xxxxxxxxxxx xx Compression xxxxxxxxxx
Actual UnitsEquivalents xxxxx
xxxx xxxxxxxxxxxxxx xxxxxManufacturing xxxxxxxx
Units completed & transferred 1,900xxxxx 1,9001,900xxxxx
xxxxxx xxxxx xxxxx 630 x630 xxx
Totalxxxxxxxxxx1,900 2,530 xxxxx
Costs incurred $2,600$1,365xxxx$2,445
Number xx Equivalent xxxxxxxxxx xxxxxxxxxx xxxxx
Cost xxx equivalent unit xxxxx$0.72 $0.25 $0.97
Costs allocated to
xxxxx completed & transferred xxxxx$1,953 $1,365 xxxx xxxxxx
Ending xxxxxxxxxxxx xxxx $609
Totals$2,600 xxxxxx$640 xxxxxx
xx xxxxxxx xxx xxxxxxx xxxxx xx xxxxxx the xxxx xx xxxxx completed and transferred xx the Comprehensive xxxxxxxxxx
xxxxxxx
Work in xxxxxxx x xxxxxxxxxxxxx $5,634
Work in xxxxxxx x Preparationxxxxxx
xxx xxxxxx xxxxxxxx of xxxxxx xxxxxxxxx xx xxxxxxxxxxx xxxxxxxxxxx
Work xx xxxxxxx - Preparation
Raw Material - Wood$2,600 xxxxxxxx to xxxxxxxxxxx department xxxxxx
Raw Material - Adhesivesxxxxxx Balance x xxxxxx WIP $1,416
Direct xxxxx$640
xxxxxxxxxxxxx Overhead $2,445
$7,050xxxxxx

xxxxxxx

xxxxxxxxx
British xxxxxxxxxxx
xx xxxxxxx xxxxxxx xxx xxxxxxxx xxxxx xxx each xxxx
Revenue
xxxxxx of xxxxxxxxxxxx
xxxxx per xxxxxx xxx
xxxxx Revenue$60,000
Variable xxxxx
Cast x xxxxxxxx
xxxxxxxx per xxxx $300

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by Google on Wed, 2016-05-18 11:46
teacher rated 642 times
4.57788
price: $11.99

ACC 202 Module 2 Assignment 3 Excel Problems,P16A-17B (p. 898), P16A-19B (p. 899), P18-24A (p. 979), P18-26A (p. 980) (NEW COURSE)A+++Answers Excel Attached

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
P16A-17B
1Draw a time line for assembly xxxxxxxxxx Time xxxx xxx Assembly xxxxxxxxxx
Units xxxxxxxTransferred xxxWIP at xxx xxxxxxxxxxxxxxx materialxxxxxx LaborMnufacturing xxxxxxxx
x xxxxxxx * 76,10040%x xxxxxxxx xxxxxxx x 98,505
2Computed the equivalent xxxxx
Sue xxxxxxxxxx
xxxx per Equivalent xxxx x Assembly Department
For xxx xxxxx ended April xx
Direct materialxxxxxxxxxx Cost Total
Units completed and transferred outx xxxxxxx xxxxxx
xxx ending* 23,900 * 9,560
x 100,000* xxxxxx
Cost added
Direct material* 375,720
Direct Labor & xxxx xx x 256,205
xxxx per unitx xxxx * xxxx * xxxx
x Assigned total costs xx the xxxxxxxxxx department
xxx xxxxxxxxxx
xxxxxxxxxx xx xxxxx cost x Assembly department
For xxx xxxxx ended April 30
Direct xxxxxxxxConversion xxxx xxxxx
Units xxxxxxxxx xxx transferred out x 285,923x xxxxxxx * xxxxxxx
WIP xxxxxx x 89,797 * xxxxxx* 118,391
Total xxxx xxxxxxxxx forx xxxxxxxx 256,205x 631,925
4 Prepared T-account for xxx xxxxxxxxx
xxxx xx Process xxxxxxxxx - xxxxxxxx
xxxxxxx BalancexxxTranferred Outx 513,534
Direct Materials * xxxxxxxWIP xxxxxx x xxxxxxx
xxxxxx Laborx xxxxxxx
xxxxxxxxxxxx xxxxxxxx x xxxxxx
x xxxxxxx* xxxxxxx
xxxxxxxx
1 xxxxxxxx xxx xxxxxxxxxxx Department
xxxxxxxx for Preparation Department
xxxxxxxxx WIPStarted Production(Sheets) Completed and transferred xx xxxxxxxxxxx xx MarchEnding xxxxxxx Adding xxxxxx xxxxx xxxxxxxxxxxDirect xxxxx xxxxxxxxxxxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by Google on Wed, 2016-05-18 11:44
teacher rated 642 times
4.57788
price: $11.99

ACC 202 Module 2 Assignment 3 Excel Problems,P16A-17B (p. 898), P16A-19B (p. 899), P18-24A (p. 979), P18-26A (p. 980) (NEW COURSE)A+++Answers Excel Attached

body preview (0 words)

file1.xlsx preview (492 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxx
1Draw x xxxx xxxx xxx assembly departmentTime xxxx xxx xxxxxxxx Department
Units Started xxxxxxxxxxx out WIP xx xxx xxxxxxxxxxxxxxx xxxxxxxx xxxxxx xxxxxMnufacturing xxxxxxxx
x xxxxxxxx 76,100xxx x xxxxxxx* 157,700 x xxxxxx
2 Computed xxx xxxxxxxxxx units
Sue xxxxxxxxxx
Cost xxx Equivalent xxxx x xxxxxxxx xxxxxxxxxx
For xxx month ended xxxxx 30
xxxxxx materialConversion xxxx xxxxx
Units completed and transferred xxx* xxxxxx* xxxxxx
xxx xxxxxx* xxxxxx x xxxxx
x xxxxxxxx xxxxxx
xxxx xxxxx
Direct material * xxxxxxx
Direct xxxxx & xxxx xxx xxxxxxx
Cost per unitx xxxx x 2.99 x 6.75
x xxxxxxxx xxxxx costs xx xxx xxxxxxxxxx department
xxx Elecronics
xxxxxxxxxx xx total cost x Assembly department
xxx the xxxxx ended xxxxx 30
xxxxxx xxxxxxxx Conversion xxxx Total
xxxxx completed and transferred xxx * 285,923* 227,611 * xxxxxxx
WIP endingx xxxxxxx 28,594 x xxxxxxx
Total xxxx xxxxxxxxx xxxx xxxxxxx x xxxxxxx* xxxxxxx
4 Prepared xxxxxxxxx xxx WIP inventory
xxxx in xxxxxxx xxxxxxxxx x xxxxxxxx
Opening xxxxxxx0.0 Tranferred xxx * xxxxxxx
Direct xxxxxxxxx * xxxxxxxWIP xxxxxx * xxxxxxx
xxxxxx xxxxx * xxxxxxx
Mnufacturing xxxxxxxx x xxxxxx
* 631,925 x 631,925
xxxxxxxx
x xxxxxxxx for xxxxxxxxxxx xxxxxxxxxx
xxxxxxxx xxx xxxxxxxxxxx xxxxxxxxxx
Beginning xxxStarted xxxxxxxxxxxxxxxxxx Completed xxx xxxxxxxxxxx xx xxxxxxxxxxx in xxxxxxxxxxx xxx xxxx Adding xxxxxx xxxxxxxxxxxxxxxx Direct xxxxxxxxxxxxxxxxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by Engineer Maxw... on Thu, 2015-01-22 10:41
teacher rated 113 times
3.76106
purchased 5 times
price: $9.00

A++ SOLUTIONS

body preview (0 words)

file1.xlsx preview (589 words)

Answers

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxx xxxxxxx xxxxxxxxxxx
1)Average tickets sold per xxxx xxxxx
x Price per xxxxxx $50
xxxxx revenue per xxxx x 60,000
xxxxx labor xxxx per xxxx xxx x xxxxx $ 21,000
xxxxx variable cost (1,200 x xxx8,400
xxxxx variable cost per xxxx $ 29,400
2) xxx X x xxxxxx xx shows to xxxxxxxxxx
NI = SP(X) x VC(X) x FC
$0 = xxxxxxxxxx - xxxxxxxxxx x $459,000
xx x $60,000(X) - $29,400(X) - xxxxxxxx
xxxxxxxxx = -$459,000
x x xxxxxxxxx x -$30,600
x = xx
3) xxxxxxxx no. xx shows xFixed xxxx x xxxxxxx xxxxxx
Contribution xxxxxx xxx show
xxxxxxxx no. xx xxxxx =xxxxxxxx + $3,825,000
$60,000 x xxxxxxx
xxxxxxxx xxx xx xxxxx x$4,284,000
$30,600
Required xxx xx xxxxx xxxx
This is not achievable because they xxx only xxxx xxx shows per year.
4) British xxxxxxxxxxx
Income xxxxxxxxx
For xxx year 2011
xxxxx revenue (120 x $60,000)x xxxxxxxxx
xxxxx Variable cost xxxx x $29,400)xxxxxxxxx
xxxxxxxxxxxx margin x 3,672,000
xxxxx xxxxx costxxxxxxx
Net xxxxxxxxx income$ xxxxxxxxx
P18-26A xxx Time xxxxxxxx xxxxx
1) xxx xxxxx compute xxx xxxxx xxxxx costs:
Office xxxxx 8,200
xxxxxxxxxxxx xxxxxxx1,500
xxxxxxxxx xxxxxxxxxxxx
Special telephone xxxxx xxxxx
Online connection xxxxx
Salary of xxxxxxxxx xxxxxxxxxxxxx
Total monthly fixed costsx 28,000
2nd xxxxx xxxxxxx the xxxxxxxxx revenue in dollars:
BEP xxxxxxx xx $ = Fixed

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by Good_Morning on Wed, 2016-05-18 07:56
teacher rated 150 times
3.646665
price: $11.00

Complete problems P16A-17B (p. 898), P16A-19B (p. 899), P18-24A (p. 979), P18-26A (p. 980)

body preview (18 words)

xxxxxxxx problems xxxxxxxx xxx xxxxx xxxxxxxx xxx xxxxx xxxxxxxxx (p. 979), xxxxxxx (p. 980)

file1._898_p16a-19b_p._899__p18-24a_p._979_p18-26a_p._980.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
P16A-17B
1 Draw a xxxx xxxx xxx assembly xxxxxxxxxx Time Line for xxxxxxxx Department
xxxxx Startedxxxxxxxxxxx outxxx at end xxxxxxxxxDirect xxxxxxxx Direct xxxxx xxxxxxxxxxxx Overhead
* xxxxxxx* 76,10040% x xxxxxxx * xxxxxxxx 98,505
2 xxxxxxxx the equivalent units
Sue Elecronics
Cost xxx Equivalent xxxx - Assembly Department
For xxx xxxxx ended April 30
xxxxxx material Conversion Costxxxxx
xxxxx completed xxx transferred xxx* xxxxxx* 76,100
xxx xxxxxx* xxxxxx * 9,560
* xxxxxxx * 85,660
Cost added
Direct materialx 375,720
Direct xxxxx & Mfg. OH x xxxxxxx
Cost per unit x 3.76* 2.99 x xxxx
3 Assigned xxxxx costs in xxx xxxxxxxxxx department
xxx xxxxxxxxxx
Assignment xx xxxxx xxxx x Assembly department
For xxx xxxxx ended April 30
xxxxxx material Conversion Cost Total
Units xxxxxxxxx and xxxxxxxxxxx xxx x 285,923 x xxxxxxxx 513,534
WIP xxxxxx * xxxxxx x 28,594 x 118,391
xxxxx xxxx xxxxxxxxx for x 375,720x xxxxxxxx xxxxxxx
xPrepared xxxxxxxxx xxx xxx xxxxxxxxx
xxxx in Process xxxxxxxxx - xxxxxxxx
xxxxxxx Balance xxx xxxxxxxxxx xxx * xxxxxxx
xxxxxx xxxxxxxxx * 375,720 WIP ending x xxxxxxx
xxxxxx xxxxx* xxxxxxx
xxxxxxxxxxxx Overhead * xxxxxx
x 631,925x xxxxxxx
xxxxxxxx
1 xxxxxxxx xxx Preparation Department
Timeline xxx xxxxxxxxxxx xxxxxxxxxx
xxxxxxxxx xxx Started xxxxxxxxxxxxxxxxxx Completed xxx transferred to xxxxxxxxxxx in MarchEnding WIP xxxx xxxxxx during marchxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by xstria on Mon, 2015-11-09 15:21
teacher rated 40 times
3.025
purchased 2 times
price: $15.00

ACC201 Module 4 Assignment 3 Problems

body preview (4 words)

xxxxxx xxxxxx x xxxxxxxxxx x Problems

file1.docx preview (235 words)

Name

xxxxxxxxxx xx Accounting x xxxxxx xxx

Instructor:

xxxx xxx 2014

xxxxxxxxxx xx xxxxx xxxxxxxx

Straight-Line xxxxxxxxxxxxx xxxxxxxxx

xxxxxxxxxxxx

xxxxx

Date xxxx

Deprecation xxx the year’xxxxxx xxxx xxxxxxx

Accumulated Book Deprecation xxxxx

$67,000

xxx 9, 2010 $67,000

xxxxx * $52,300 $13,075

xxxxxxx $53,925

xxx xx 2011

0.25 * $52,300 $13,075

xxxxxxx $40,850

Jan xx xxxx

0.25 x $52,300 $13,075

xxxxxxx $14,700

Jan xx xxxx

xxxx x $52,300 $13,075

xxxxxxxx xxxxxxx

Think the problem xxxx xx xxx ¼ percent xx a year is 0.25 xxxxxxx xx 0.20 this took me three xxxxx xx get it correct and yet I xxxxx xxxx xx xxxxxx

xxxxxxxxxxxx x xxxxxxxx − xxxxxxxx =$52,300 / 4 x xxxxxxx

Unit of xxxxxxxxxx xxxxx xxxxxx

xxxxxxxxx

xxxxxxxxxx Cost

Deprecation for the Year Deprecation Number of Deprecation xxx xxxx Units xxxxxxx

xxxxxxxxxxx xxxxxxxxxxxxxxxx Value xxxxxxx

Jan xx xxxx $67,000

$0.40 * xxxxxx xxxxxx

$12,000 xxxxxx

xxx xx xxxx

xxxx * 10,000 4,000

xxxxx xxxxxx

xxx 9, xxxx

xxxx x 40,000 xxxxxx

xxxxxx xxxxxx

xxx 9, 2013

0.40 * xxxxxx xxxxxx

32,00

xxx xx xxxx

xxxx * x

Depreciation = Number of Units Produce × xxxxx − xxxxxxx xxxxxxx Life xx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00