Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Question
Submitted by ronyro on Fri, 2013-06-07 23:16
due on Tue, 2013-06-11 22:50
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.

Attachments:
Submitted by Engineer Maxw... on Thu, 2015-01-22 11:41
teacher rated 131 times
3.78626
purchased 7 times
price: \$9.00

5

A++ SOLUTIONS

body preview (0 words)

file1.xlsx preview (589 words)

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 xxx 8,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 x Fixed 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 x xxx 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 cost xxxxxxx Net xxxxxxxxx income \$ xxxxxxxxx P18-26A xxx Time xxxxxxxx xxxxx 1) xxx xxxxx compute xxx xxxxx xxxxx costs: Office xxxx x 8,200 xxxxxxxxxxxx xxxxxxx 1,500 xxxxxxxxx xxxxxxx xxxxx Special telephone xxxxx xxxxx Online connection xxxxx Salary of xxxxxxxxx xxxxxxx xxxxxx Total monthly fixed costs x 28,000 2nd xxxxx xxxxxxx the xxxxxxxxx revenue in dollars: BEP xxxxxxx xx \$ = Fixed

- - - more text follows - - -

Submitted by accountguru on Sat, 2014-04-19 05:15
teacher rated 512 times
4.76953
purchased 7 times
price: \$25.86

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 xxxxx xxxxxxxxxxxxx xxxxxxxx Units completed & xxxxxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxxx Units 650 163 163 163 Total 5,070 4,583 xxxxx 4,583 xxxxx xxxxxxxx xxxxxx \$575 \$6,240 xxxxxx xx Equivalent xxxxx xxxxx 4,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 163 xxxx xxx xxxx xxxxxx xxxxxx \$575 \$6,240

xxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 1. Draw a xxxx xxxx for xxx xxxxxxxxxxx Department Preparation Department xxxx Cut into xxxxx Bits xxxxxxxx xxxxx xxxxxxxxxxx xx Compression Department xxxxxxxxxxx xx Compression xxxxxxxxxx Actual Units Equivalents xxxxx xxxx xxxxxxxx xxxxxx xxxxx Manufacturing xxxxxxxx Units completed & transferred 1,900 xxxxx 1,900 1,900 xxxxx xxxxxx xxxxx xxxxx 630 x 630 xxx Total xxxxx xxxxx 1,900 2,530 xxxxx Costs incurred \$2,600 \$1,365 xxxx \$2,445 Number xx Equivalent xxxxx xxxxx xxxxx xxxxx 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 xxxxx xxx xxxx 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 Preparation xxxxxx 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 - Adhesives xxxxxx Balance x xxxxxx WIP \$1,416 Direct xxxxx \$640 xxxxxxxxxxxxx Overhead \$2,445 \$7,050 xxxxxx

xxxxxxx

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

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:27
teacher rated 394 times
4.758885
purchased one time
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 P16A-17B x xxxx x xxxx line xxx xxxxxxxx department xxxx Line xxx Assembly Department xxxxx xxxxxxx Transferred out xxx xx end xxxxxxxxx Direct xxxxxxxx xxxxxx Labor xxxxxxxxxxxx Overhead x xxxxxxx x 76,100 40% x 375,720 x 157,700 x 98,505 x xxxxxxxx xxx xxxxxxxxxx xxxxx xxx xxxxxxxxxx xxxx xxx xxxxxxxxxx Unit - xxxxxxxx Department xxx xxx xxxxx ended April 30 Direct material xxxxxxxxxx Cost xxxxx xxxxx completed and xxxxxxxxxxx out x xxxxxx * 76,100 xxx ending x 23,900 x 9,560 x 100,000 x 85,660 Cost xxxxx Direct material x 375,720 Direct xxxxx & xxxx xx * 256,205 Cost xxx unit * xxxx x 2.99 * xxxx 3 xxxxxxxx total costs in xxx xxxxxxxxxx department Sue xxxxxxxxxx Assignment xx total cost x Assembly department xxx the xxxxx ended xxxxx xx Direct xxxxxxxx Conversion xxxx xxxxx xxxxx xxxxxxxxx xxx transferred out * xxxxxxx x xxxxxxx x 513,534 xxx ending * 89,797 * 28,594 x xxxxxxx xxxxx cost xxxxxxxxx for x 375,720 * 256,205 x xxxxxxx x xxxxxxxx T-account for WIP inventory xxxx in xxxxxxx xxxxxxxxx - Assembly Opening Balance 0.0 xxxxxxxxxx Out * xxxxxxx Direct Materials * 375,720 WIP ending x xxxxxxx Direct Labor * 157,700 xxxxxxxxxxxx xxxxxxxx x xxxxxx * xxxxxxx * xxxxxxx P16A-19B x Timeline for Preparation xxxxxxxxxx Timeline xxx xxxxxxxxxxx xxxxxxxxxx Beginning xxx Started Production(Sheets) xxxxxxxxx xxx xxxxxxxxxxx xx xxxxxxxxxxx xx March xxxxxx WIP Cost Adding xxxxxx march xxxx Adhesiv xxxxxx xxxxx xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:27
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxx x Draw x time line xxx xxxxxxxx xxxxxxxxxx Time xxxx xxx xxxxxxxx xxxxxxxxxx xxxxx Started xxxxxxxxxxx out WIP at end completed Direct xxxxxxxx xxxxxx xxxxx Mnufacturing xxxxxxxx x 100,000 * 76,100 40% * xxxxxxx x 157,700 * 98,505 x xxxxxxxx xxx equivalent units xxx xxxxxxxxxx Cost per Equivalent Unit x Assembly Department xxx xxx month xxxxx April 30 Direct material Conversion Cost Total xxxxx completed xxx xxxxxxxxxxx xxx x 76,100 x 76,100 xxx xxxxxx x xxxxxx * 9,560 x 100,000 x xxxxxx Cost xxxxx Direct xxxxxxxx x xxxxxxx Direct Labor & Mfg. xx x xxxxxxx xxxx xxx xxxx x xxxx * xxxx * 6.75 x Assigned xxxxx xxxxx xx xxx assembling department xxx xxxxxxxxxx Assignment xx total cost x xxxxxxxx xxxxxxxxxx For xxx month ended xxxxx xx Direct material xxxxxxxxxx xxxx xxxxx Units xxxxxxxxx xxx xxxxxxxxxxx out * 285,923 x xxxxxxx x xxxxxxx WIP xxxxxx x 89,797 x 28,594 x 118,391 xxxxx xxxx xxxxxxxxx xxx x xxxxxxx * xxxxxxx * xxxxxxx 4 Prepared xxxxxxxxx for xxx xxxxxxxxx Work xx xxxxxxx xxxxxxxxx x xxxxxxxx Opening xxxxxxx xxx Tranferred xxx x 513,534 xxxxxx Materials * xxxxxxx xxx ending * xxxxxxx Direct Labor x xxxxxxx xxxxxxxxxxxx xxxxxxxx * 98,505 x xxxxxxx * xxxxxxx xxxxxxxx x xxxxxxxx xxx Preparation xxxxxxxxxx xxxxxxxx xxx xxxxxxxxxxx xxxxxxxxxx xxxxxxxxx WIP xxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxx and xxxxxxxxxxx xx Compression xx March xxxxxx xxx Cost Adding during xxxxx xxxx xxxxxxx Direct Labor xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:26
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxx 1 Draw x xxxx line xxx assembly xxxxxxxxxx xxxx Line for Assembly xxxxxxxxxx Units Started xxxxxxxxxxx xxx xxx xx end xxxxxxxxx Direct xxxxxxxx Direct Labor xxxxxxxxxxxx xxxxxxxx x xxxxxxx x xxxxxx xxx x xxxxxxx * xxxxxxx x xxxxxx 2 Computed xxx equivalent units xxx xxxxxxxxxx Cost per Equivalent xxxx x Assembly Department xxx xxx month xxxxx xxxxx 30 xxxxxx xxxxxxxx Conversion xxxx Total xxxxx completed xxx transferred out x xxxxxx x 76,100 xxx ending * 23,900 x 9,560 x xxxxxxx x 85,660 Cost added xxxxxx xxxxxxxx * 375,720 xxxxxx xxxxx & xxxx xx * xxxxxxx xxxx per xxxx * 3.76 * 2.99 x xxxx 3 Assigned total xxxxx xx the xxxxxxxxxx department xxx xxxxxxxxxx Assignment of total cost - xxxxxxxx department xxx the xxxxx xxxxx xxxxx xx xxxxxx material xxxxxxxxxx Cost Total Units completed xxx transferred out * 285,923 * 227,611 x 513,534 xxx ending * 89,797 x xxxxxx * xxxxxxx Total cost xxxxxxxxx for x xxxxxxx * xxxxxxx * xxxxxxx x Prepared T-account for WIP inventory Work xx Process xxxxxxxxx - Assembly xxxxxxx xxxxxxx 0.0 xxxxxxxxxx xxx * xxxxxxx Direct Materials * 375,720 WIP xxxxxx x xxxxxxx xxxxxx Labor * 157,700 Mnufacturing Overhead x xxxxxx * 631,925 * xxxxxxx xxxxxxxx x Timeline for xxxxxxxxxxx xxxxxxxxxx Timeline for xxxxxxxxxxx xxxxxxxxxx xxxxxxxxx WIP Started xxxxxxxxxxxxxxxxxx Completed and transferred xx xxxxxxxxxxx in March xxxxxx xxx xxxx xxxxxx xxxxxx xxxxx Wood Adhesiv Direct xxxxx xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:26
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 P16A-17B 1 xxxx x time xxxx xxx xxxxxxxx xxxxxxxxxx Time xxxx for xxxxxxxx Department Units xxxxxxx xxxxxxxxxxx out xxx at xxx xxxxxxxxx xxxxxx xxxxxxxx Direct xxxxx xxxxxxxxxxxx Overhead x 100,000 * 76,100 40% x 375,720 x 157,700 * 98,505 x Computed xxx xxxxxxxxxx xxxxx xxx Elecronics xxxx per Equivalent Unit x Assembly Department For the month ended xxxxx 30 xxxxxx material Conversion xxxx xxxxx Units completed xxx transferred xxx * 76,100 * xxxxxx xxx ending * xxxxxx * xxxxx x 100,000 * 85,660 xxxx added xxxxxx xxxxxxxx x xxxxxxx Direct Labor & Mfg. xx x 256,205 xxxx per xxxx * xxxx * xxxx x xxxx x xxxxxxxx total costs in the assembling department xxx Elecronics Assignment of xxxxx cost x xxxxxxxx department For xxx month ended xxxxx xx xxxxxx xxxxxxxx Conversion Cost xxxxx Units xxxxxxxxx xxx transferred xxx x xxxxxxx x xxxxxxx * 513,534 xxx ending x xxxxxx * xxxxxx x xxxxxxx Total xxxx xxxxxxxxx xxx x xxxxxxx * 256,205 * xxxxxxx x xxxxxxxx xxxxxxxxx xxx WIP inventory xxxx xx xxxxxxx Inventory x xxxxxxxx xxxxxxx xxxxxxx 0.0 Tranferred xxx * xxxxxxx Direct Materials x 375,720 WIP xxxxxx x xxxxxxx xxxxxx xxxxx * xxxxxxx xxxxxxxxxxxx Overhead x 98,505 x xxxxxxx * xxxxxxx P16A-19B x Timeline for Preparation Department Timeline xxx Preparation Department xxxxxxxxx WIP xxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxx and xxxxxxxxxxx to xxxxxxxxxxx xx xxxxx xxxxxx WIP xxxx Adding during march Wood xxxxxxx Direct xxxxx xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:26
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxx 1 Draw a time line xxx assembly xxxxxxxxxx Time Line for Assembly xxxxxxxxxx Units xxxxxxx xxxxxxxxxxx xxx WIP xx end completed Direct material xxxxxx xxxxx xxxxxxxxxxxx xxxxxxxx x 100,000 x xxxxxx xxx * xxxxxxx x 157,700 * 98,505 2 Computed xxx equivalent units xxx Elecronics Cost xxx Equivalent xxxx x xxxxxxxx xxxxxxxxxx For xxx month xxxxx xxxxx xx Direct material xxxxxxxxxx Cost Total Units xxxxxxxxx and transferred xxx * 76,100 * 76,100 WIP xxxxxx * 23,900 x xxxxx * xxxxxxx x xxxxxx xxxx xxxxx Direct xxxxxxxx * 375,720 xxxxxx xxxxx & xxxx xx * 256,205 xxxx xxx unit x 3.76 x 2.99 x 6.75 x xxxxxxxx total costs xx xxx xxxxxxxxxx xxxxxxxxxx Sue Elecronics xxxxxxxxxx of total cost - Assembly department xxx xxx month xxxxx April xx Direct xxxxxxxx Conversion xxxx Total xxxxx completed xxx transferred xxx x xxxxxxx x xxxxxxx x 513,534 WIP xxxxxx x 89,797 * 28,594 * 118,391 Total cost accounted xxx x 375,720 * xxxxxxx * xxxxxxx 4 Prepared T-account for WIP xxxxxxxxx xxxx in xxxxxxx Inventory - Assembly Opening Balance 0.0 Tranferred Out x xxxxxxx Direct xxxxxxxxx * 375,720 xxx ending x 118,391 Direct Labor * 157,700 Mnufacturing xxxxxxxx * xxxxxx x 631,925 x 631,925 xxxxxxxx 1 xxxxxxxx for Preparation Department Timeline for xxxxxxxxxxx Department Beginning xxx xxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxx and transferred to xxxxxxxxxxx xx xxxxx Ending xxx Cost Adding xxxxxx xxxxx xxxx Adhesiv xxxxxx Labor xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:26
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 P16A-17B 1 Draw a time line xxx assembly department Time xxxx for Assembly Department Units xxxxxxx Transferred out xxx at end completed Direct xxxxxxxx Direct xxxxx Mnufacturing Overhead x xxxxxxx * xxxxxx xxx x xxxxxxx * xxxxxxx * xxxxxx x Computed the xxxxxxxxxx units xxx xxxxxxxxxx xxxx xxx Equivalent xxxx x Assembly xxxxxxxxxx xxx the month xxxxx April 30 xxxxxx material xxxxxxxxxx xxxx xxxxx Units xxxxxxxxx and xxxxxxxxxxx xxx * xxxxxx * xxxxxx xxx xxxxxx * xxxxxx x xxxxx * xxxxxxx * 85,660 Cost xxxxx xxxxxx material * xxxxxxx xxxxxx Labor & xxxx xx * 256,205 Cost per unit x xxxx * 2.99 * 6.75 x xxxxxxxx xxxxx costs xx xxx xxxxxxxxxx xxxxxxxxxx Sue xxxxxxxxxx xxxxxxxxxx xx xxxxx cost x xxxxxxxx xxxxxxxxxx For the xxxxx xxxxx April xx xxxxxx material xxxxxxxxxx xxxx Total Units completed xxx xxxxxxxxxxx xxx x xxxxxxx x 227,611 * 513,534 xxx xxxxxx x xxxxxx x 28,594 * xxxxxxx Total xxxx xxxxxxxxx for x 375,720 * 256,205 * xxxxxxx x Prepared xxxxxxxxx for WIP xxxxxxxxx Work in xxxxxxx xxxxxxxxx - xxxxxxxx xxxxxxx xxxxxxx xxx Tranferred xxx x xxxxxxx xxxxxx xxxxxxxxx x xxxxxxx xxx ending * xxxxxxx Direct Labor * xxxxxxx xxxxxxxxxxxx xxxxxxxx x xxxxxx * 631,925 x xxxxxxx P16A-19B x xxxxxxxx xxx Preparation Department Timeline for xxxxxxxxxxx Department Beginning WIP xxxxxxx Production(Sheets) xxxxxxxxx and transferred xx xxxxxxxxxxx xx March Ending xxx xxxx xxxxxx xxxxxx march Wood Adhesiv xxxxxx xxxxx xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:26
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxx 1 xxxx x time xxxx xxx xxxxxxxx department xxxx xxxx xxx Assembly xxxxxxxxxx xxxxx xxxxxxx xxxxxxxxxxx xxx xxx at xxx xxxxxxxxx xxxxxx material xxxxxx Labor xxxxxxxxxxxx Overhead * xxxxxxx * 76,100 40% x 375,720 * 157,700 * xxxxxx x xxxxxxxx xxx equivalent xxxxx xxx xxxxxxxxxx xxxx per Equivalent xxxx x Assembly Department xxx xxx month xxxxx xxxxx xx Direct xxxxxxxx Conversion Cost Total xxxxx xxxxxxxxx xxx transferred out x xxxxxx * xxxxxx xxx ending * xxxxxx x 9,560 * xxxxxxx * 85,660 xxxx added Direct xxxxxxxx * xxxxxxx xxxxxx xxxxx & xxxx xx x 256,205 xxxx xxx unit x xxxx x 2.99 * 6.75 x Assigned xxxxx xxxxx xx xxx assembling xxxxxxxxxx xxx xxxxxxxxxx Assignment xx xxxxx xxxx x Assembly xxxxxxxxxx For the xxxxx ended xxxxx xx Direct material Conversion xxxx Total xxxxx xxxxxxxxx xxx transferred out * xxxxxxx * xxxxxxx x 513,534 xxx ending x 89,797 x 28,594 x 118,391 Total xxxx xxxxxxxxx for x 375,720 x xxxxxxx x xxxxxxx 4 xxxxxxxx T-account for xxx xxxxxxxxx xxxx xx Process Inventory x Assembly xxxxxxx xxxxxxx xxx xxxxxxxxxx Out x xxxxxxx xxxxxx xxxxxxxxx * xxxxxxx WIP ending x 118,391 xxxxxx xxxxx * xxxxxxx Mnufacturing Overhead * xxxxxx * 631,925 x xxxxxxx P16A-19B x xxxxxxxx for Preparation Department Timeline for xxxxxxxxxxx Department Beginning WIP Started xxxxxxxxxxxxxxxxxx Completed xxx xxxxxxxxxxx xx Compression xx March xxxxxx xxx Cost Adding xxxxxx xxxxx xxxx Adhesiv xxxxxx Labor xxxxxxxxxxxxx

- - - more text follows - - -

Submitted by SuperClass on Mon, 2017-06-05 03:25
teacher rated 394 times
4.758885
price: \$7.99

ACC 202 Module 2 Assignment 3 Excel Problems A+++Tutorial Well Written Awesome Solution By SuperClass Tutor For You Use As Guide

body preview (0 words)

file1.xlsx preview (492 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 P16A-17B 1 Draw a xxxx line xxx xxxxxxxx department Time Line xxx xxxxxxxx xxxxxxxxxx xxxxx xxxxxxx xxxxxxxxxxx out WIP xx xxx completed Direct xxxxxxxx Direct Labor Mnufacturing Overhead * 100,000 * 76,100 xxx x 375,720 x 157,700 x 98,505 2 Computed the xxxxxxxxxx xxxxx Sue xxxxxxxxxx xxxx xxx xxxxxxxxxx Unit - xxxxxxxx Department For xxx month ended xxxxx xx Direct xxxxxxxx xxxxxxxxxx xxxx xxxxx xxxxx completed and xxxxxxxxxxx out * xxxxxx * xxxxxx WIP ending x 23,900 x xxxxx * 100,000 * 85,660 xxxx xxxxx Direct xxxxxxxx x 375,720 Direct Labor & Mfg. OH x xxxxxxx Cost per unit * 3.76 * xxxx * xxxx x Assigned total xxxxx xx xxx assembling xxxxxxxxxx xxx Elecronics xxxxxxxxxx xx xxxxx xxxx x xxxxxxxx department For the xxxxx xxxxx April xx Direct material Conversion xxxx xxxxx Units xxxxxxxxx xxx transferred xxx * xxxxxxx * 227,611 x xxxxxxx xxx ending x xxxxxx * xxxxxx * 118,391 xxxxx xxxx xxxxxxxxx for * xxxxxxx * xxxxxxx x xxxxxxx x xxxxxxxx xxxxxxxxx xxx WIP xxxxxxxxx Work xx Process Inventory x xxxxxxxx Opening xxxxxxx 0.0 Tranferred Out * 513,534 xxxxxx xxxxxxxxx * xxxxxxx WIP xxxxxx x 118,391 Direct Labor x xxxxxxx xxxxxxxxxxxx Overhead * 98,505 * xxxxxxx * xxxxxxx P16A-19B 1 xxxxxxxx for Preparation xxxxxxxxxx xxxxxxxx xxx Preparation xxxxxxxxxx xxxxxxxxx WIP Started xxxxxxxxxxxxxxxxxx Completed and transferred to Compression xx March xxxxxx WIP Cost xxxxxx during march xxxx Adhesiv xxxxxx xxxxx manufacturing

- - - more text follows - - -