Accounting Comprehensive Manufacturing Budget Homework Help
Best UK USA UAE Australia Canada China Accounting Comprehensive Manufacturing Budget Homework Help Service Online
You have been asked to prepare a 5 year budget forecast for the ‘Chumpy’ Dog Food canned product.
This division of the Neptune Australia company utilises a traditional manufacturing cost flow inventory and accounting system.
As at December 31st 2013 the following financial and trading data was provided
|2013 Year data (all costs are per unit)|
|Sales (Units)||52.7 million|
|Price (average 2013 price received)||$1.2500|
|Prime Costs (per unit)|
|Ingredients & Canning||$0.2150|
|Other Manufacturing Costs (per unit)||$0.5450|
|Inventory on Hand (at valuation):|
|Ingredients & Packaging (1,013,000 units)||$223,000|
|Finished Goods (2,020,500 units)||$1,580,500|
|Sales and Marketing Costs||3,275,000|
Market Research has indicated that the canned dog food market will continue to grow faster than the general economy. Sales of the Chumpy product are expected to increase in unit terms at a rate of 6% above the current long term inflation rate of 2.5%. Sales Price increases for Chumpy are expected to be kept in line with inflation during the budget period. All other manufacturing costs including direct labour and ingredient costs are expected to increase at the rate of inflation. All manufacturing costs (including overhead) are assumed to vary directly with production (unless otherwise stated). The company pays tax at the Australian Corporate tax rate which is expected to hold at current levels. The inflation rate of 2.5% is expected to hold over the 5 year budget period.
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 firstname.lastname@example.org
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 email@example.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.
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 firstname.lastname@example.org 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.
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.
- Strategic management case study help
- Case Study Assignment Help
- Trade finance case study help
- Banking case study assignment help
- Banking case study homework help
- Meaning of case study assignment help
- Child development case study homework help
- Contract law case study homework Help
- Finance accounting case studies homework help
- Company Financial statement analysis case study homework help
- Foreign assignment case study help
- HR case study homework help
- Human resource management case study homework help
- Managerial accounting case study assignment help
- Managerial accounting case study homework help
- Negotiations case study homework help
- Organization behavior case study homework help
- Project management case study homework help
- Financial statement analysis assignment help
- HBS case study assignment help
- Ratio analysis case study assignment help
- Small business case study homework help
- Project finance case studies help
- Healthcare finance case studies homework help
- MBA case study homework help
- Financial analysis business case study homework help
- Harvard business case study homework help
- Business strategy case study homework help
- Business law case study homework help
- Accounting Case Study Help
- Business case study homework help
- Finance case study help
- Corporate Finance case study homework help
- Business process case study assignment help
- Business statistics case study assignment help
The ‘Chumpy’ canned dog food factory maintains target safety stock of raw materials inventory and tin can inventory amounting to the equivalent of one (1) week of the current year’s budgeted unit production. Finished goods inventory levels are kept at the equivalent of two (2) weeks of the current year’s budgeted unit sales. At the end of the 2013 calendar year there were 2,020,500 completed units of Finished Goods in the warehouse. There was enough raw materials and tin can inventory on hand at December 31st to manufacture 1,013,000 units. The Chumpy dog food division does not utilise a Work in Process inventory account.
The Chumpy factory has been operating out of its site in Wodonga for nearly 40 years and has undergone several upgrades. The manufacturing facility is currently operating at approximately 85% of its total practical capacity of 62 million cans of dog food per annum.
(i) Using Excel develop a Sales, Production and Purchase budget as well as a budgeted Schedule of Cost of Goods Manufactured, Schedule of Cost of Goods Sold, and an Income Statement for each of the 5 years in the budget period (commencing 2014) (advice on the form of these budgets will be provided on the subject Interact site and is also available in the Appendix to Chapter 9 of the text book). This budget must also take into account the manufacturing facility practical capacity production constraint. Your spreadsheet must include a data section which enables inputs to be simply altered and ‘what if’ analysis to be undertaken. (Excel resources are provided on your Interact site to guide students on the use of the ‘IF’ formula which can be used for the budget production constraint).
Hint: All 5 years of each budget should be shown side by side (1 column per year) for ease of comparison by management. All of the budgets should be presented on one worksheet together, working down the page commencing with the Sales and then Production budgets.
You should be able to drag the formula across for the whole of the budget if the first years are properly constructed with a data input section and using absolute referencing. This makes the process much quicker and easier. An Excel help file has been placed on the Interact site to assist students.
(ii) The Neptune Australia Strategic Management Committee has before them two options for consideration. Option 1 is to leave the facility as it is and incur normal repair and maintenance costs which are already budgeted for in factory running costs. Option 2 is to undertake major capital works and upgrade the cooking ovens and production line technology which will increase practical production capacity by 25% in the 2016 year. The upgrade can be completed by the end of the 2015 calendar year. If the upgrade is undertaken it will cost the firm $600,000 in financing costs per annum commencing in the 2016 year.
Using the excel model developed in part (i) calculate the impact on sales and profit if the option of upgrading the manufacturing facility is exercised and the practical production capacity of the factory is increased by 25% (Submit results as a separate worksheet).
(iii) Given your findings from part (i) and (ii) write a report for the Strategic Management Committee of Neptune Australia recommending whether to take up the option to upgrade the production facility. In your report consider all of the strategic and financial implications to the firm of reaching its production constraint and any implications or opportunities arising from upgrading the facility and having extra productive capacity. Your grade will depend on the accuracy and depth of your analysis, and your capacity to identify strategic issues which management should consider when making their decision (approx. 300 words).
Product Code: ACC25
Looking for Accounting Comprehensive Manufacturing Budget Homework Help, please submit your details here with product code mentioned above.