
Concept explainers
The general ledger of Jay Consulting shows the following balances at July 31:
Jay has asked you to develop a worksheet that will serve as a
Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, $17,731.
To test your model, use the following balances at August 31:
Print the worksheet when done. Check figure: Total debits, $18,810.
CHART (optional)
Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.

Prepare a trial balance in a worksheet for the month ended July 31, and August 31.
Explanation of Solution
Want to see more full solutions like this?
Chapter MB Solutions
Excel Applications for Accounting Principles
- One of Alyra Co.'s activity cost pools is packaging, with an estimated overhead (OH) of $120,000. It packages glassware (1,200 packagings) and ceramics (800 packagings). How much overhead should be assigned to glassware packaging? A) $48,000 B) $60,000 C) $72,000 D) $120,000arrow_forwardFinancial Accounting question.arrow_forwardCan someone please solve this?arrow_forward
- Fernando Traders has a balance date of 31 December. On 1 January 2XX3, it had an opening inventory balance of $15,000. During the year, Fernando Traders purchased $30,000 worth of goods for resale. On 31 December 2XX3, the closing inventory balance was $13,000. Sales for the year totaled $50,000. What is the Cost of Goods Sold for Fernando Traders for the period ending 31 December 2XX3?arrow_forwardMunoz medical clinic has budgetedarrow_forwardNeed Answerarrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning



