Accounting Master Budget And Pro Forma Statements Homework Help
- August 1, 2017
- Posted by:
- Category: Accounting QA
Best UK USA UAE Australia Canada China Accounting Master Budget And Pro Forma Statements Homework Help Service Online
The following trial balance was drawn from the records of Havel Company as of October 1, 2010.
Cash | $ 16,000 | |
Accounts receivable | 60,000 | |
Inventory | 40,000 | |
Store equipment | 200,000 | |
Accumulated depreciation | $ 76,800 | |
Accounts payable | 72,000 | |
Line of credit loan | 100,000 | |
Common stock | 50,000 | |
Retained earnings | 17,200 | |
Totals | $316,000 | $316,000 |
Required
a. Divide the class into groups, each with four or five students. Organize the groups into three sections. Assign Task 1 to the first section, Task 2 to the second section, and Task 3 to the third section.
Group Tasks
(1) Based on the following information, prepare a sales budget and a schedule of cash receipts for October, November, and December. Sales for October are expected to be $180,000, consisting of $40,000 in cash and $140,000 on credit. The company expects sales to increase at the rate of 10 percent per month. All of accounts receivable is collected in the month following the sale.
(2) Based on the following information, prepare a purchases budget and a schedule of cash payments for inventory purchases for October, November, and December. Cost of goods sold for October is expected to be $72,000. Cost of goods sold is expected to increase by 10 percent per month in November and December. Havel expects January cost of goods sold to be $89,000. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month’s cost of goods sold. Seventy-five percent of accounts payable is paid in the month that the purchase occurs; the remaining 25 percent is paid in the following month.
(3) Based on the following selling and administrative expenses budgeted for October, prepare a selling and administrative expenses budget for October, November, and December. Cash payments for sales commissions and utilities are made in the month following the one in which the expense is incurred. Supplies and other operating expenses are paid in cash in the month in which they are incurred. As of October 1, no amounts were payable for either commissions or utilities from the previous month.
Sales commissions (10% increase per month) | $ 7,200 |
Supplies expense (10% increase per month) | 1,800 |
Utilities (fixed) | 2,200 |
Depreciation on store equipment (fixed) | 1,600 |
Salary expense (fixed) | 34,000 |
Rent (fixed) | 6,000 |
Miscellaneous (fixed) | 1,000 |
How it Works?
How it Works?
Step 1:- Want to buy solution for this. Please click on submit your assignment here and then fill all details and please mentioned product code at the end of the case. Product code is extremely important to locate your assignment. You can also mail us by keeping product code as mail subject to besthomewrokhelpers@gmail.com
Step 2:- As soon as we received your details, we will inform you with through email about quotations of the given assignment. Requesting you to please mention your budget. Also ensure our email besthomeworkhelpers@gmail.com should not go into your spam folder.
Step 3:- Once you agree with our price, click on pay now and pay the agreed amount and once we received the payment assignment will be delivered before agreed deadline.
Step 4:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.
Features
Our Features for Assignment Help Services
Plagiarism Free Solution
The first and foremost things that we promise to our customer is plagiarism free solution i.e. a complete and unique solution as per customer’s university requirements.
Excellent Customer Care Services
You can feel our responsiveness once you use our service. Our team of excellent and dedicated customer service representatives are always ready to provide best customer care service 24X7 . Just drop a mail to besthomeworkhelpers@gmail.com and you can receive response in just no time.
Multiple Stage Quality Assurance
We design a unique multiple stage quality assurance team to ensure plagiarism free, original, relevant and as per customer’s requirements. We not only give importance to accurate solutions or writing but also we give equal importance to references style too.
Privacy and Confidentiality
We believe in maintaining complete privacy and confidentiality of all our clients. None of the information furnished to us is shared with anyone else.
Our Clients
We receive requests from clients all over the World. Most of our customers are from USA, UK, Australia, Canada, UAE, Muscat, Oman, Qatar, UAE, New-Zealand, France Germany etc.
Related Services
- Accounting Homework Help
- Accounting Assignment Help
- Computer Science Homework Help
- Management Homework Help
- Finance Assignment Help
- Online Essay Writing Help
- Strategic management case study help
- Case Study Assignment Help
- Dissertation Writing Help
- Trade finance case study help
- Project Management Assignment Help
- Mechanical Engineering Homework Help
- Online Quiz Help
- Maths homework Help
- Online Exam Help
- Economics Assignment Help
- Economics Homework Help
- English Homework Help
- Macroeconomics Homework Help
- Microeconomics Homework Help
- Statistics Assignment Help
- Australia Taxation Homework Help
- Supply chain management homework help
- Taxation homework help
- USA taxation assignment help
- Advanced accounting homework help online
- Auditing homework writing help
- Human resource management homework help
- Nursing homework help online
- Psychology homework help online
- Sociology homework help online
- Ratio analysis homework help online
- Strategic Management Homework Help Online
- Mba operations management homework help
- Human resource management homework help
- Operations management homework help
b. Select a representative from each section. Have the representatives supply the missing information in the following pro forma income statement and balance sheet for the fourth quarter of 2010. The statements are prepared as of December 31, 2010.
Income Statement | ||
Sales Revenue | $ ? | |
Cost of Goods Sold | ? | |
Gross Margin | 357,480 | |
Operating Expenses | ? | |
Operating Income | 193,290 | |
Interest Expense | (2,530) | |
Net Income | $190,760 | |
Balance Sheet | ||
Assets | ||
Cash | $ 9,082 | |
Accounts Receivable | ? | |
Inventory | ? | |
Store Equipment | $200,000 | |
Accumulated Depreciation Store Equipment | ? | |
Book Value of Equipment | 118,400 | |
Total Assets | $314,682 | |
Liabilities | ||
Accounts Payable | ? | |
Utilities Payable | ? | |
Sales Commissions Payable | ? | |
Line of Credit | 23,936 | |
Equity | ||
Common Stock | 50,000 | |
Retained Earnings | ? | |
Total Liabilities and Equity | $314,682 |
c. Indicate whether Havel will need to borrow money during October.
Product Code: ACC207
Looking for Accounting Master Budget And Pro Forma Statements Homework Help, please submit your details here with product code mentioned above.