Prepare a cash flow plan for the sandoz company

Assignment Help Finance Basics
Reference no: EM132165078

Analysis and calculations

1. Complete the following variance report (calculations required).


Budgeted sales Actual sales Variance



Product Qty $ Qty $ Qty $ %
Product X 100 20,000 120 26,000


Product Y 150 18,000 160 19,200


Product Z 200 40,000 190 36,100


Total 450 78,000 470 81,300


2. Complete the missing figures in the following variance report (calculations required).

Materials

Budget

Actual

Variance

 

 

 

 

Material A

$30,000

$28,000

 

 

 

 

 

Material B

$55,000

$59,000

 

 

 

 

 

Material C

$48,000

$45,000

 

 

 

 

 

Total

 

 

 

3. Prepare a cash flow plan for the Sandoz Company from the following information for the month of February 20xx.

Item

$

 

 

Cash sales

600,000

 

 

Collection from Accounts Receivable

1,386,000

 

 

Purchases (January 20aa)

470,000

 

 

GST payable to ATO

130,000

 

 

Salaries and wages

502,000

 

 

Interest payments

213,000

 

 

Other operating expenses paid

108,000

 

 

Loans repaid during the period

780,000

 

 

Capital expenditure

65,000

 

 

Opening cash balance

132,000

Sandoz Company

Cash Flow Plan for the month February 20xx

Opening cash balance

 

Receipts

 

Cash sales

 

Collection from Accounts Receivable

 

Other

 

Total receipts

 

Payments

 

Payments to creditors (purchases)

 

GST payable to ATO

 

Salaries and wages

 

Interest payments

 

Payments for operating expenses

 

Loans repayments

 

Capital expenditure

 

Total payments

 

Closing cash balance

 

 

4. Prepare a selling expense budget for the month of February 20xx for CDA Pty Ltd. The sales for February are expected to be $120,000. The bases to be used for budget purposes are as follows.

- Annual fixed expenses are allocated equally to each month.

- Sales staff salaries for the month are equal to 4% of sales.

- Depreciation of sales vehicles amounts to $18,000 per year.

- Sales staff insurance is 2.5% of monthly sales staff salaries.

- The advertising budget is currently $19,200 per annum.
- Sales vehicle maintenance costs the organisation 2% of sales revenue per month.

- Freight out per month is calculated a 0.65% of revenue.

- Complete the table as requested (calculations required).

Item

$

 

 

Salaries

 

 

 

Depreciation

 

 

 

Staff insurance

 

 

 

Advertising

 

 

 

Vehicle maintenance

 

 

 

Freight

 

 

 

Total

 

 

 

5. A Company expects to spend $200,000 on general administration expenses in the month of January 20aa. In February, these will be 90% of the January expenses; in March, these will be 105% of January's expenses.

The selling and distribution expenses total is expected to be 5%, and financial expenses 1% of each month's sales.

Prepare the operating expense budget for the three months January to March. The selling price for each unit is $25.

Quantities to be sold each month are as follows.

January

12,000

February

10,800

March

12,600

Complete the table as requested (calculations required).

 

January

February

March

 

 

 

 

Sales

 

 

 

 

 

 

 

Expenses

 

 

 

 

 

 

 

General and administrative

 

 

 

 

 

 

 

Selling and distribution

 

 

 

 

 

 

 

Financial expenses

 

 

 

 

 

 

 

Total expenses

 

 

 

Attachment:- Manage budget forecasts.rar

Reference no: EM132165078

Questions Cloud

Find an article on the internet : Find an article on the Internet and outline a security breach or cyber attack. Provide a link to the article and suggest a control that would mitigate against.
What property or method do you call on data : What is data? an objector an array? What property or method do you call on data (there turned json object) suchthat it returns an array of federal accounts?
Could the individual you selected be successful : Classroom discussion in an online environment requires your active participation with classmates and your instructor to create robust interaction and dialogue.
What factors typically influence the end-user decision : Discuss what role end-users typically play in incident reporting? Should end users be encouraged to report suspicious occurrences?
Prepare a cash flow plan for the sandoz company : FNSACC503 Manage budgets and forecasts - Prepare a cash flow plan for the Sandoz Company from the following information for the month of February 20xx
Discuss how a listener can pick up on the queues : Discuss how a listener can pick up on the queues from the speaker to understand the intended message.
How are authentication and authorization alike : How are authentication and authorization alike and how are they different? What is the relationship, if any, between the two?
How to build teams in terms of designing the task : Think about how to build teams in terms of designing the task, selecting the people, and then, managing their relationships.
Discuss the rationale of the policy : Discuss the rationale of the policy and how your model will assist policy makers in their decision making and implementation processes.

Reviews

len2165078

11/13/2018 1:03:43 AM

Observation/assessment Pre-assessment work completed All assessments, tasks & activities (on Moodle®) successfully Assessmenttask 2 – Analysis and calculations Did the learner demonstrate: 1. Complete the following variance report (calculations required). 2. Complete the missing figures in the following variance report (calculations required). 3. Complete the table as requested (calculations required). 4. Complete the table as requested (calculations required). 5. Complete the table as requested (calculations required).

len2165078

11/13/2018 1:03:22 AM

Marking and Criteria guide: Assessor and student must read this carefully before assessment. A 75% demonstrated competence in the answers is the benchmark only and students & assessors must note that professionally critical aspects/concepts must be included (e.g. prepare, document and present budgets and forecasting estimates, statistical analysis and measures of variance, monitor budget outcomes periodically) All parts (criteria) in the marking guide must be completed successfully for the student to achieve competence in this unit.

len2165078

11/13/2018 1:03:10 AM

Performance Evidence Evidence of the ability to: • prepare, document and present budgets and forecasting estimates that: • accurately apply accounting principles and practices • follow organisational policy and procedures • monitor budget outcomes periodically. Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

len2165078

11/13/2018 1:03:01 AM

Important: Your assessment must contain this coversheet and your own coversheet (for your “report”) Your answers & assessment submission must professional in style (Business), content and format. Maximum font size 11 points: Font Arial or Times New Roman; single spacing; clear paragraphswith appropriate punctuation, spellchecking and final submission will need to be proof-read. (i.e. few missing words or typo’s) In particular: - Use clear, non-discriminatory language - Avoid the use of jargon - Write clearly using plain English - Consider your target audience - Ensure that your responses meet the needs of the target audience (in this case your trainer or assessor). All of your work must be original.

len2165078

11/13/2018 1:02:49 AM

This assessment must be based on where you work (or have worked most recently). This Assessment is designed to test the knowledge that you have acquired throughout the unit. Use the following tips to help you answer the questions: Read each question carefully. Check with your trainer or assessor if you are not sure what the question is asking. HINT: Use these questions as subheadings to create a business style report to answer your assessment Your response to each question should aim to provide enough information to answer the question. In most cases, this can be done with just a few paragraphs. Don’t forget to refer to attachments under the heading (question) applicable

len2165078

11/13/2018 1:02:35 AM

Your answers & assessment submission must professional in style (Business), content and format. Maximum font size 11 points: Font Arial or Times New Roman; single spacing; clear paragraphswith appropriate punctuation, spellchecking and final submission will need to be proof-read. (i.e. few missing words or typo’s) In particular: - Use clear, non-discriminatory language - Avoid the use of jargon - Write clearly using plain English - Consider your target audience - Ensure that your responses meet the needs of the target audience (in this case your trainer or assessor). All of your work must be original.

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd