Prepare a performance report using spreadsheet software

Assignment Help Finance Basics
Reference no: EM13926752

Application: Using Performance Reports to Inform Organizational Decisions

Very often, managers are called upon to make decisions "by the numbers." In this Assignment, you will sort through a budget report from the fictitious Honey Bear Confections (HBC) organization in order to make decisions about productivity levels.
HBC is a small organization dedicated to making bear-shaped sweets with honey as a sugar substitute. You have just been promoted to a position as manager of the production department at HBC when your supervisor shows you the following report. She tells you to "get it fixed." You suspect she is alluding to a problem with productivity and efficiency.

Honey Bear Confections (HBC)

Manufacturing Overhead Static Budget Report

For the Month Ended June 20XX

 

Budget

Actual

Variance (U or F)

Production in bags of candy

10,000

12,000

2,000F

Costs:

Indirect labor

$26,000

$31,200

$5,200U

Supplies

$25,000

$29,500

$4,500U

Utilities

$19,000

$22,500

$3,500U

TOTAL

$70,000

$83,200

$13,200U

The Assignment:

Part 1: Prepare a performance report using spreadsheet software, such as Excel. Hint: Read the Weekly Briefing and watch the Performance Report video on this topic.

Part 2: For the next section of this Assignment, please utilize a word processing software (such as Word) to complete the following:

Write a short memo to your supervisor explaining your findings and your recommendations.

In your memo, as part of your recommendations, take a position on the following: Do all the variance in this example need to be examined? Why or why not?

Reference no: EM13926752

Questions Cloud

Standard deviation of the demand for the entire : Likewise, the variance of the demand for the entire three week period is the sum of the individual weekly variances. But be careful! The standard deviation of the demand for the entire 3 week period is not the sum of the individual standard deviat..
Time the client issued the initial syn : How long from the time the client issued the initial SYN did it take the server to answer with the SYN-ACK
Who is at risk of committing suicide : You are working with a psychiatric patient, Pat, who is at risk of committing suicide. Your suicide prevention model suggests that you negotiate a "safety plan" with the client (e.g., Pat will stay with a friend overnight; you will contact the fri..
Five steps of hypothesis testing : He recorded the store's sales for those four Wednesdays and then recorded the store's sales for the four alternate Wednesdays, when the signs were not displayed. On the Wednesdays with the sign, the sales were 83, 73, 81, and 79. On the Wednesdays..
Prepare a performance report using spreadsheet software : Application: Using Performance Reports to Inform Organizational Decisions, Prepare a performance report using spreadsheet software, such as Excel. Hint: Read the Weekly Briefing and watch the Performance Report video on this topic
Compute the amount of each of the end-of-year payments : Compute the amount of each of the end-of-year payments. Prepare a loan amortization schedule detailing the amount of principal and interest in each year's payment.
Confidence interval estimate for mean head circumference : Find a 95% confidence interval estimate for the mean head circumference of all two-moth old babies. What aspect of this problem is not realistic?
Minimum state finite automaton for the language : Find the minimum state finite automaton for the language specified by the finite automaton
Set theory-relations-functions and sequences : Look up a roulette wheel diagram. The following sets are defined:

Reviews

Write a Review

Finance Basics Questions & Answers

  What are different types of alternative investment vehicles

What are the different types of alternative investment vehicles? Which is preferable and why? What factors could affect the choice of such a vehicle?

  Beta analysis of hewlett packard

You are analyzing the beta for Hewlett Packard and have broken down the company into four broad business groups, with market values and betas for each group.

  Item of corporate stock

Define and discuss the item of corporate stock. What are the classes of stock? How do these classes differ?

  Distinguish between inflation risk and inflation as tax

Distinguish between inflation risk and inflation as tax

  Compute the coefficient of variation

Greengage, Corporation, a successful nursery, is planning several expansion projects. All of the alternatives promise to produce an acceptable return.

  What is the present value of growth opportunities

Next year's earnings are estimated to be $6.00. The company plans to reinvest 33% of its earnings at 12%. If the cost of equity is 8%, what is the present value of growth opportunities?

  Analysis of financial condition of a company

Analysis of financial condition of a Company under Debt management - Please analyze the financial condition of the company; under the following category - debt management

  Depreciate the equipment using straight-line method

SAC is planning the purchase of new equipment to manufacture specialty spark plugs. The new machine would allow the company to manufacture 100,000 additional spark plugs per year.

  How to fit the numbers in to come up with this answer

what is the current value of the stock? A) $100 B) $105 C) $110 D) $120 I know the answer is B) $105 but can you please show me the full formula for P and how to fit the numbers in to come up with this answer?

  How will these resources help them and further support the

how will these resources help them and further support the recommendations or guidelines you are creating on their

  Calculate npv of all lease payments

yearly payments of $50,000 paid at the starting of each of the next five years (total of $250,000). Calculate the NPV of all lease payments?

  The following table shows an estimated probability

the following table shows an estimated probability distribution for the sales of a new product in its first weeknumber

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