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!
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.
| 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
|
.awasam-promo {
background-color: #9ED5EA;
color: white;
text-align: center;
padding: 10px;
}
.button {
background-color: #4CAF50;
border: none;
color: white;
padding: 10px 20px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 2px;
cursor: pointer;
border-radius: 10px;
}
.awasam-alert {
color: red;
}
“Get 15% discount on your first 3 orders with us”
Use the following coupon
FIRST15
Order Now
The post Accounting Excel Problems appeared first on Savvy Essay Writers.
