Accounting Excel Problems
dondaxridIf 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 |
12 years ago
10
Purchase the answer to view it
p16a-17b_p16a-19b__p18-24a_and_p18-26a.xlsx
