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

  Estimate of the variance in the electric power measurement

Calculate the ANOVA table for the model, which you have determined. What is the estimate of the variance in the electric power measurement?

  How many elements of the sample space

In an experiment, a ball is drawn from an urn containing 10 red balls and 8 yellow balls. If the ball is red, two coins are tossed. Otherwise, three coins are tossed. 1). How many elements of the sample space will have a red ball?

  What is the probability that the experiment will find

What is the probability that the experiment will find (misleadingly) that the mean score for delayed speaking is at least as large as that for early speaking?

  State the null hypothesis

State the null hypothesis. Calculate the difference between the proportions or means. Calculate the standard' error of the difference in proportions or means.

  Determine the posterior probabilities

Determine the posterior probabilities, given the following prior and likelihood probabilities.Prior probabilities P(s1) = .25 P(s2) = .40 P(s3) = .35 Likelihood Probabilities

  Comparing a new pain medication for arthritis

A clinical trial is conducted comparing a new pain medication for arthritis. Participants are randomly assigned to receive the new medication or a placebo. The outcome is pain relief within 30 minutes.

  Prepare a research articles from peer-reviewed journals

Select at least three research articles from peer-reviewed journals which report on research projects using inferential statistics.

  Calculate the correlation between the father and mother

Calculate the correlation between the father's and the mother's years of education. Is there any sign of multicollinearity? Explain.

  What is the significance of hypothesis in research what are

what is the significance of hypothesis in research? what are type i and ii errors inhypothesis

  Determine effective sample size using the power analysis

Statistics question: Need formula to determine effective sample size using the power analysis which includes 1) significance level or alpha, (2) effect size, (3) power (standard of 0.80 or 80%), and (4) sample size. Need to be able to calculate effec..

  Determine a confidence interval estimate for the mean weight

Determine a 97% confidence interval estimate for the mean weight of the carry-on luggage. For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet.

  Keeps track of the number of complaints

A customer service center keeps track of the number of complaints received each day about one of their new products. The number of complaints received over the last 11 day period are 19, 18, 22, 21, 17, 18, 22, 19, 16, 23, and 25. The IQR for this sa..

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