Prepare a variance analysis between budgeted

Assignment Help Applied Statistics
Reference no: EM131306935

Part A

1. Using the data in the Appendices regarding Cherokee Hospitality Equipment & Supplies business, complete the following:

a) List all personnel you would consult with in order to gain adequate advice prior to commencing your reports.

b) Determine management requirements

c) Prepare a 1 year budget & projected financial statement including:

d) Sales forecast, taking into account additional information in Appendix F

e) Estimated expenses / inventory costs

f) Estimated profits

g) Ensure report layout and format comply with management information requirements, are clear and error-free

Note: You must use appropriate spreadsheet or accounting software to undertake this task.

Part B

1. Using the data in the Appendices regarding Cherokee Hospitality Equipment & Supplies business, you are to compare their budgeted figures against actual figures located below:

Cherokee Hospitality Equipment & Supplies 1 year result:

Total Sales: $1,623,000

Total Purchases: $701,400

Total Expenses: $402,000e

You are to undertake the following:

a) Prepare a variance analysis between budgeted and actual figures

b) Ensure report demonstrates major differences and areas of underperformance

c) List the discrepancy and analyse it as a positive or negative one Locate the area and give at least 5 reasons why the discrepancy may have occurred

d) Utilise the data provided to determine the effectiveness of the cost budgeting techniques used

e) Give recommendations as to how their variance may be corrected for future budgets for the business. These recommendations should include systems to ensure mentoring and coaching.

The variance report should be submitted along with a written report detailing the answers to the above questions.

Attachment:- MYOB assignment.pdf

Reference no: EM131306935

Questions Cloud

Summarize the given case and research about it : Summary, Relevant research is summarized, with a clearly and logically stated theory.Transition and Development, There is a smooth and logical transition from research review to proposed study including a clear statement of purpose.Design Developm..
What are the biggest barriers to wide scale adoption : What do you think are the biggest barriers to wide-scale adoption of m-commerce by consumers? Who do you think is working on solutions to these problems and what might the solutions entail?
What is pattern seen in ice core records of carbon dioxide : What is the pattern seen in the ice core records of carbon dioxide and temperature in terms of high and low periods over the past hundreds of thousands of years (before modern human history?
What is the pressure inside the tank : The water level in the other side of the U-tube, open to the atmosphere, is 2 ft above the base. What is the pressure inside the tank
Prepare a variance analysis between budgeted : Prepare a variance analysis between budgeted and actual figures - List the discrepancy and analyse it as a positive or negative one Locate the area and give at least 5 reasons why the discrepancy may have occurred
Determine the resultant force of the water on the gate : A square gate, 4 m by 4 m, is located on the 45° face of a dam. The top edge of the gate is 8 m below the water surface. Determine the resultant force of the water on the gate, and the point through which it acts.
An investor with good knowledge of companys past record : As an investor with a good knowledge of the company's past record, to what extent do you attribute its performance problems to problems in its corporate governance?
Describe groundwater management challenges : Describe groundwater management challenges. Include in your description the types and sources of contamination, overdrawing and its effect on the water table.
Discuss the ethical dilemmas that this request raises : This will help them confirm or deny that this company is selling equipment that is used directly in the torture of political prisoners. Discuss the ethical dilemmas that this request raises and how you would react to this request.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Create graph with the trendline displayed for the regression

Create a graph with the trendline displayed for the regression. Copy and paste the results of the output to your report in Microsoft Word.

  Hdtv''s need repairs at the manufacturer expense

The warranty period must be long enough to make the purchase attractive to the buyer. For a new HDTV the mean number of months until repairs are needed is 36.84 with a standard deviation of 3.34 months. Where should the warranty limits be set ..

  Provide some demographic information

A cell phone company offers two plans to its subscribers. At the time new subscribers sign up, they are asked to provide some demographic information. The mean yearly income for a sample of 40 subscribers to Plan A is $59,100 with a standard d..

  1 listed below are the numbers of people executed in the

1. listed below are the numbers of people executed in the united states from 1976 nbsp to 1994. in 1976 the u.s.

  Quantitative analysis for decision making

Internet and the articles database in the library for a real-life illustration of simulation. For hint, type the word "Simulation" followed by a topic of interest to you. Carefully review the search item.

  Unions often oppose imports

Unions often oppose imports from what they call low-wage countries and advocate trade barriers to protect jobs from what they often characterise as "unfair" import competition" please critically analise this statement

  What test would be most appropriate?

A nurse researcher wanted to evaluate blood pressure in a set of patients/research subjects at 1, 3, and 6 months. What test would be most appropriate? Independent t-test: ANVOVA, RM-ANOVA or ANCOVA

  Comment on the production control situations

Comment on the production control situations depicted by the four control charts shown on the following page, and state what action, if any, would be necessary in each case.

  The level of calcium in the blood in healthy young adults

The level of calcium in the blood in healthy young adults varies with mean about u = 9.50 milligrams per deciliter and standard deviation about .40 milligram per deciliter. A clinic in rural Guatemala measures the blood calcium level of 64 healthy pr..

  4x5 contingency table was developed and computed

4x5 contingency table was developed and computed to 15.42. At the 0.05% level, the critical value is21.026

  Summary of the information gathered by the poll

Select the report of at least 2 polls taken on two different topics. (For example, the percent in favor versus opposed to abortion, the economy, a particular candidate, a certain product, etc. ) Various polls can be found at www.zogby.com or www.rasm..

  Find the ppv and npv for a population

Are the events of being man-made and being polluted independent and write out the sample space - Find the PPV and NPV for a population where 2% of the people have the disease.

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