Accounting Expenses Budget Homework Help
- November 1, 2017
- Posted by:
- Category: Accounting QA
Best UK USA UAE Australia Canada China Accounting Expenses Budget Homework Help Service Online
1. Rundle Ltd has estimated sales for January to April as
January | $150 000 |
February | $180 000 |
March | $120 000 |
April | $165 000 |
The mark-up on cost is 50% and management requires that opening stock be 90% of sales (at cost) each month.
Required
Using an excel spreadsheet,
a. Prepare a purchases budget for the three months ending 31 March.
b. Prepare a Costs of Goods Sold budget for three months ending 31 March.
2. Refer to problem 1. Rundle Ltd provides you with the following information relating to estimated expenses.
Expense details | |
Sales representatives’ salaries | $72 000 pa apportioned equally each month |
Cartage outwards | 5% of sales |
Advertising | 3% of sales |
General salaries and wages | $144 000 pa apportioned equally each month |
Audit fees | $2 400 pa apportioned equally each month |
Payroll on-costs (treated as an administration expense) | 15% of total payroll |
Rent | $43 200 pa apportioned equally each month |
Depreciation | $27 600 pa apportioned equally each month |
Telephone | $1800 pa apportioned equally each month |
Stationery | $1 800 pa apportioned equally each month |
Interest on loan | January—$830 February—$820 March—$810 |
Bank charges | $720 pa apportioned equally each month |
Required:
Using an excel spreadsheet:
a. Prepare the marketing expenses budget for three months ending 31 March.
b. Prepare the financial expenses budget for the three months ending 31 March.
3. To demonstrate the integration of operating budgets, using the information provided in 2.1 and 2.2 now prepare a summary budgeted income statement for the three months ending 31 March. (Provide your answer in the excel spreadsheet).
4. Anshar Manufacturing makes drinking mugs. Its budgeted income statement for the coming year shows
Budgeted income statement for the year ending30-Jun | |||
$ | $ | $ | |
Sales (200 000 mugs) | 600 000 | ||
less Cost of goods sold | 390 000 | ||
Direct materials | 210 000 | ||
Direct labour | 72 000 | ||
Variable factory overhead | 48 000 | ||
Fixed factory overhead | 60 000 | ||
Gross profit | 210 000 | ||
less Operating expenses | 91 500 | ||
Selling | 42 000 | ||
Variable expenses | 33 000 | ||
Fixed expenses | 9 000 | ||
Administration and financial | 49 500 | ||
Variable expenses | 12 000 | ||
Fixed expenses | 37 500 | ||
Net profit | 118 500 |
Required
(Using the excel spreadsheet, respond to the following questions)
a. Recast the budgeted income statement so that all variable costs are grouped together, all fixed costs are grouped together, and the contribution margin is shown. Remember: Direct materials and direct labour are variable costs.
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.i. What is the flexible budget equation in this situation?
(ii) What is the average budgeted sale price for mugs?
c.Prepare a flexible budget at 190 000, 200 000 and 210 000 unit levels of activity. Show details for each individual cost item.
d. Refer to 3.1 and 3.3. The actual results for Anshar Manufacturing were:
$ | |
Sales (210 000 mugs) | 622 500 |
Variable costs | |
Direct materials | 225 000 |
Direct labour | 72 900 |
Factory overhead | 52 500 |
Selling | 37 500 |
Administration and finance | 15 000 |
Fixed costs | |
Factory overhead | 60 000 |
Selling | 10 500 |
Administration and financial | 33 000 |
Prepare a detailed performance report.
Product Code: ACC567
Looking for Accounting Expenses Budget Homework Help , please submit your details here with product code mentioned above.