Accounting Excel Problems
If there is anyone out there that can help me with this, I would greatly appreciate it. I originally posted this back on 8/27 and the teacher disappeared on me so this assignment is now overdue & affecting my grade. I’ve been in & out of the hospital all week with my son so I am running very short on time & really need the help! Thank you in advance to anyone that is willing to offer me their assistance!
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowAssignment 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.
Assignment 3 Grading Criteria |
Maximum Points
|
P16A-17B |
|
Drew time line for assembly department |
2
|
Computed the equivalent units |
3
|
Assigned total costs in the assembling department |
3
|
Prepared T-account for WIP inventory |
3
|
P16A-19B |
|
Drew time line for preparation department |
3
|
Computed the equivalent units |
3
|
Compute total costs |
3
|
Prepared journal entry to record costs of sheets |
3
|
Posted journal entries to WIP inventory and calculated ending balance |
3
|
P18-24A |
|
Computed revenue and VC for each show |
2
|
Computed number of shows BP must perform to break even |
3
|
Computed number of shows needed to earn $3,825,000 profit |
3
|
Prepared BP’s contribution margin income statement |
3
|
P18-26A |
|
Computed Big Time’s break even revenue in dollars |
3
|
Computed dollar revenues needed to earn OI of $11,200 |
3
|
Graphed Big Time’s CVP relationships |
4
|
Computed new BEP if average revenues increased to $900 per trade |
3
|
Total: |
50
|