Calculate the total budgeted contribution margin for sydgee

Assignment Help Accounting Basics

Reference no: EM133760631 , Length: word count:1500

Assessment - Financial statement analysis on selected ASX listed company & preparation of master Budget

Written analytical Report

Section 1: Financial Statement Analysis and interpretations of selected ASX listed companies (70% weight for this section)
Assessment Description and Instructions:

The purpose of this assessment is to provide students with an understanding of financial statement analysis as well as using Microsoft Excel to aid in calculating financial statement ratios and aiding financial analysis. In business, accountants, managers, and financial analysts are required to understand how businesses or a particular business operates. Financial statement analysis by using common size calculations and percentages aids in this understanding and it also enables comparison to other businesses regardless of the absolute dollar size of these businesses.

Businesses today require that their employees can work in teams and collaborate to produce more innovative solutions, compared to what an individual can produce. Each student will be required to provide an individual report for the allocated ASX listed company analysis and calculations. This assignment involves analysing the financial statements and other information relating to selected listed Australian public companies. The selected ASX listed companies will be allocated to each individual student and uploaded on Moodle.

Each individual student is responsible for the calculations and analysis of the allocated company. The assignment is divided into two parts. Each student is responsible for collecting data from the selected ASX listed company data, analysis, drafting an answer and preparing presentation materials.

Required:

i). A brief statement of the selected company's operations and the statement of the CEO about the selected company's annual performance and strategy. You are required to write in your own interpretation not just cut and paste of the CEO's statement(s) on company's annual performance and strategies.

ii). Calculate the following ratios for 2022 and 2023 - (be sure you show the workings for supporting collected data)

iii). Using the ratios calculated in (ii) above of this case study, compare the liquidity, efficiency, profitability, solvency, and market performance of the company of your analysis.

Section 2: Master Budget (extract)
SYDGEE makes and sells upmarket carry bags for personal PC. Jon, controller, is responsible for preparing SYDGEE's master budget and has assembled the following data for 2024.

The direct labour rate includes wages, all employee-related benefits and the employer's share of payroll tax. Labour-saving machinery will be fully operational by August 2024. Also, as of 1 August 2024, the entity's enterprise agreement calls for an increase in direct labour wages that is included in the direct labour rate.

SYDGEE expects to have 30 000 bags in inventory at 31 July 2024, and has a policy of carrying 50 per cent of the following month's projected sales in inventory.

Required

(a) Prepare the following budgets for SYDGEE for the three specified months (August, Sept and October) of 2024. Be sure to show supporting calculations:
(i) production budget in units
(ii) direct labour budget in hours
(iii) direct materials budget
(iv) sales budget.

(b) Calculate the total budgeted contribution margin for SYDGEE for the captioned three months of 2024. Be sure to show supporting calculations.

(c) Discuss at least three behavioural considerations in the profit-planning and budgeting process.
[You are required to use Excel program to complete this project. You must use formulae in excel and must print out the formulae that has been used in completing this part.]

Reference no: EM133760631

Questions Cloud

Explain reasonings for its usefulness in social work : Describe conflict and explain reasonings for its usefulness in social work.

Explain the parts they worked on in the report : Explain the parts they worked on in the report. In cases of absence or late submissions, individuals will be affected individually

In what ways have you or will you shift as a leader : In what ways have you, or will you, shift as a leader? Describe how SaudiVision2030 is shifting KSA. How is the leader enabling this shift?

Which the six performance measures do you think are useful : Which two of the six performance measures do you think are the most useful indicators of how the transformation is measured? Is the transformation successful?

Calculate the total budgeted contribution margin for sydgee : ACC500 Business Decision Making, Polytechnic Institute Australia - Calculate the total budgeted contribution margin for SYDGEE for the captioned three months

Discuss the range of possible values for probabilities : Discuss the range of possible values for probabilities. Give examples to support each. Explain how she knew that this result was incorrect.

Preparing a marketing plan to be presented to the ceo : MKT500 Marketing for Managers, Polytechnic Institute Australia - preparing a marketing plan to be presented to the CEO. You are recommended

Determine leading firms in each node and using google search : Determine the leading firms in each node and using Google searches find the Revenue for each firm and sum those to get the Total Revenue value of each node.

What effect does leasing have on a firms balance sheet : What effect does leasing have on a firm's balance sheet? What effect does leasing have on a firm's capital structure?

User Account

All Pages