Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

BUACC5936 Financial Management

tag 4 Downloads 5 Pages / 1,019 Words tag 21-06-2021
  • Course Code: BUACC5936
  • University: Federation University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Question:

Which require you to prepare Microsoft Excelspreadsheets based on given scenarios to monitor and review the budgets Upload this as a separate document in Google ClassroomsBased on the above Sales and COGS activities for current year; Prepare a spreadsheet with annual Sales for food and drinks and COGS for meals and drinks; in addition include columns for the monthly average and quarterly average.

Using the prepared template from continue with the following:Based on the Budget forecasting for next year, as mentioned in the scenario:Prepare a 2nd spreadsheet similar to Question 1 for the annual Profit and Loss Budget; also include end columns for average monthly and average quarterly

Based on the following assumptions prepare a 3rd spreadsheet with the actual trading activities for the 1st quarter next year.

  • Food revenue was 20% higher than the budget forecasted
  • Food Cost was 30% higher than the budget forecasted
  • Beverage sales was 15,000 units
  • Utilities Expense was $3,000
  • Wages expense $20,000
  • Rent expense was $6,500

You are required to monitor the trading activities for Simpsons Pty Ltd for the first quarter of next year and identify and record in an additional column all dollar ($) variances from the forecasted budget.In order to control costs prepare a 4th spreadsheet; identifying and recording the necessary adjustments to be made to the budget for the 2nd, 3rd and 4th quarters of next year. 

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.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 5 pages

Cite This Work

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

My Assignment Help. (2021). BUACC5936 Financial Management. Retrieved from https://myassignmenthelp.com/free-samples/buacc5936-financial-management/forecasted-budget.html.

My Assignment Help (2021) BUACC5936 Financial Management [Online]. Available from: https://myassignmenthelp.com/free-samples/buacc5936-financial-management/forecasted-budget.html
[Accessed 05 October 2022].

My Assignment Help. 'BUACC5936 Financial Management' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/buacc5936-financial-management/forecasted-budget.html> accessed 05 October 2022.

My Assignment Help. BUACC5936 Financial Management [Internet]. My Assignment Help. 2021 [cited 05 October 2022]. Available from: https://myassignmenthelp.com/free-samples/buacc5936-financial-management/forecasted-budget.html.


Stuck on Any Question

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

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

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

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?