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

  Determining mortgage interest deduction

Sue owns a home in Arizona and in New York. She spends winters in Arizona and summers in New York. What are the limits, if any, on the deductibility of the mortgage interest?

  You own a stock portfolio invested 35 percent in stock q

you own a stock portfolio invested 35 percent in stock q 20 percent in stock r 25 percent in stock s and 20 percent in

  A discussion of the business strategy of the u.s.

Summarize the basic situation in the case including a discussion of the business strategy of the U.S. firm you identified.

  What is the economic value added eva

What is the economic value added (EVA)?

  Canon corporation expects to receive 3 million of dividend

canon corporation expects to receive 3 million of dividend income from the shares of stock it holds in fuji

  Discuss the risk of dell company

Discuss the risk of Dell  company.

  How does leverage impact risk and return

How does leverage impact risk and return? How is risk related to operating and financial leverage? Explain your answer in detail.

  Estimate the total fixed cost per month

What method did you use to make your estimates in "a" and "b" above? Are there any other possible methods that can be used? If so, state the advantages of each.

  Obtain cash flow statements of wal-mart

Obtain cash flow statements of Wal-Mart for the last two years for the publicly traded company and select two performance ratios and two coverage ratios for cash flow analysis that you think will be most effective.

  Forward discount on the dollar relative to the french france

If the one-year Eurodollar rate is 6 percent and the two-year Eurodollar rate is 7 percent, the one-year forward rate implicit in the Eurodollar yield curve is very close to:

  Financial analysis multiple choice question

When Tri-C Corporation compares its ratios to industry averages, it has a higher current ratio, an average quick ratio, and a low inventory turnover. Determine what might you assume about Tri-C?

  Discuss on stock market movement and market inefficiency

Discuss on stock market movement and market inefficiency and Assume that no other information is received and that the stock market as a whole does not move

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