Margaret's Massages is a day spa providing relaxing treatment to its clients. Margaret's Massages balance sheet for June 30, 2021 is as follows: Margaret's MassagesBalance SheetJune 30, 2021 Assets Current Assets: Cash $13,860 Accounts Receivable $2,470 Prepaid Insurance $770 Total Current Assets $17,100 Property, Plant & Equipment Equipment & Fixtures $19,780 Less: Accumulated Depreciation ($3,470) $16,310 Total Assets $33,410 Liabilities Current Liabilities: Accounts Payable $2,530 Total Liabilities $2,530 Stockholders' Equity Common Stock, no par $9,010 Retained Earnings $21,870 Total Stockholders' Equity $30,880 Total Liabilities and Stockholders' Equity $33,410 The following information is also included: Sales fees 70% cash and 30% on account. The balance in the Accounts Receivable account is the sales on account from last quarter. Budgeted fees earned for this quarter are: $35,400 in July, $40,800 in August and $43,300 in September. Monthly costs include: $1,270 per month for rent, $5,800 a month for salaries plus 5% bonus for fees earned over $36,800 in a month, $420 for depreciation, $250 for Insurance Expense, and 7% of sales fees earned for Miscellaneous Expense, and utilities run $230 per month. Complete the following budgets for the third quarter.
Margaret's Massages is a day spa providing relaxing treatment to its clients. Margaret's Massages balance sheet for June 30, 2021 is as follows: Margaret's MassagesBalance SheetJune 30, 2021 Assets Current Assets: Cash $13,860 Accounts Receivable $2,470 Prepaid Insurance $770 Total Current Assets $17,100 Property, Plant & Equipment Equipment & Fixtures $19,780 Less: Accumulated Depreciation ($3,470) $16,310 Total Assets $33,410 Liabilities Current Liabilities: Accounts Payable $2,530 Total Liabilities $2,530 Stockholders' Equity Common Stock, no par $9,010 Retained Earnings $21,870 Total Stockholders' Equity $30,880 Total Liabilities and Stockholders' Equity $33,410 The following information is also included: Sales fees 70% cash and 30% on account. The balance in the Accounts Receivable account is the sales on account from last quarter. Budgeted fees earned for this quarter are: $35,400 in July, $40,800 in August and $43,300 in September. Monthly costs include: $1,270 per month for rent, $5,800 a month for salaries plus 5% bonus for fees earned over $36,800 in a month, $420 for depreciation, $250 for Insurance Expense, and 7% of sales fees earned for Miscellaneous Expense, and utilities run $230 per month. Complete the following budgets for the third quarter.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question
Margaret's Massages is a day spa providing relaxing treatment to its clients.
Margaret's Massages
Margaret's MassagesBalance SheetJune 30, 2021
Assets | ||
---|---|---|
Current Assets: | ||
Cash | $13,860 | |
$2,470 | ||
Prepaid Insurance | $770 | |
Total Current Assets | $17,100 | |
Property, Plant & Equipment | ||
Equipment & Fixtures | $19,780 | |
Less: |
($3,470) | $16,310 |
Total Assets | $33,410 | |
Liabilities | ||
Current Liabilities: | ||
Accounts Payable | $2,530 | |
Total Liabilities | $2,530 | |
Common Stock, no par | $9,010 | |
$21,870 | ||
Total Stockholders' Equity | $30,880 | |
Total Liabilities and Stockholders' Equity | $33,410 |
The following information is also included:
- Sales fees 70% cash and 30% on account.
- The balance in the Accounts Receivable account is the sales on account from last quarter.
- Budgeted fees earned for this quarter are: $35,400 in July, $40,800 in August and $43,300 in September.
- Monthly costs include: $1,270 per month for rent, $5,800 a month for salaries plus 5% bonus for fees earned over $36,800 in a month, $420 for depreciation, $250 for Insurance Expense, and 7% of sales fees earned for Miscellaneous Expense, and utilities run $230 per month.
Complete the following budgets for the third quarter.
![Cash Sales
Margaret's Massages
Sales Budget
For the Quarter Ended September 30, 2021
July
August September
Sales on Account
Total Sales
Variable Expenses:
Bonus Expense
Miscellaneous Expense
Total Variable Expenses
Fixed Expenses:
Salaries Expense
Rent Expense
Total
Margaret's Massages
Selling and Administration Budget
For the Quarter Ended September 30, 2021
July
August
Depreciation Expense
Utilities Expense
Insurance Expense
Total Fixed Expenses
Total Selling & Administrative Expenses
September
Total](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F72a5fe87-b233-4b90-b844-b5446e54494d%2F95bad4be-0ef8-403e-98ed-ab93229bcb8b%2Ficb2shy_processed.png&w=3840&q=75)
Transcribed Image Text:Cash Sales
Margaret's Massages
Sales Budget
For the Quarter Ended September 30, 2021
July
August September
Sales on Account
Total Sales
Variable Expenses:
Bonus Expense
Miscellaneous Expense
Total Variable Expenses
Fixed Expenses:
Salaries Expense
Rent Expense
Total
Margaret's Massages
Selling and Administration Budget
For the Quarter Ended September 30, 2021
July
August
Depreciation Expense
Utilities Expense
Insurance Expense
Total Fixed Expenses
Total Selling & Administrative Expenses
September
Total
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education