Get Instant Help From 5000+ Experts For
question

Writing Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ACC00714 Managerial Accounting

6 Pages / 1,472 Words Published On: 18-03-2021
Question:
Using the Excel template provided, prepare the following budgets for the twelve-month period from January 2019 to December 2019.  The first worksheet should contain your raw data and assumptions and all future worksheets should be linked to this data.  Use a different worksheet for each budget. Show all calculations and use Excel functions where possible.  While you should use examples in your text as a guide, the key to using spreadsheets is that they are structured so that others can use them and follow the flow of information without difficulty.

a.Monthly Sales Revenue and Cash Collection Budget

b.Production Budget in Units

c.Direct Materials and Cash Purchases Budget

d.Direct Labour Budget

e.Manufacturing Overhead Budget (break into variable and fixed components)

f.Monthly Operating Cost Budget

g.Ending Inventory budget for Finished Goods

h.Cost of Sales Budget

i.Budgeted Income Statement for the year ended 31 December 2019

j.Monthly Cash Budget

Your budget spreadsheet must be submitted in Excel Format (not as an appendix in your WORD document).

2.Write a report (Maximum 1,500 words) for your manager to present to the upcoming Board meeting.  The report should include:

  • an overview of the expected results for the 2019 year;
  • an analysis of the Contribution Margin for each product and recommendations regarding the products On The Beach manufacture and sell;  
  • recommendations regarding the cash position of the business; and
  • an analysis of current market conditions and future predictions that you believe should be considered when following year’s 2020 budget is prepared.  You should use broader industry data and trends from sources such as IBISWorld and the Australian Bureau of Statistics to support your recommendations.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

up arrow icon

Upload
Unique Document

Clipboard Icon

Document
Under Evaluation

wallet

Get Money
into Your Wallet

Total 6 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). ACC00714 Managerial Accounting. Retrieved from https://myassignmenthelp.com/free-samples/acc00714-managerial-accounting/corporate-environmental-management.html.

My Assignment Help (2021) ACC00714 Managerial Accounting [Online]. Available from: https://myassignmenthelp.com/free-samples/acc00714-managerial-accounting/corporate-environmental-management.html
[Accessed 07 June 2023].

My Assignment Help. 'ACC00714 Managerial Accounting' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/acc00714-managerial-accounting/corporate-environmental-management.html> accessed 07 June 2023.

My Assignment Help. ACC00714 Managerial Accounting [Internet]. My Assignment Help. 2021 [cited 07 June 2023]. Available from: https://myassignmenthelp.com/free-samples/acc00714-managerial-accounting/corporate-environmental-management.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question

Writing Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Other Samples
icon
5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.