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

  Calculation of ratios

Use the financial statement and additional data, calculate at least five of the following ratios for Alley corporation for 2009.

  The after tax cost of debt is 4 the cost perferred is 75

target capital structure 40 debt 10 preferred and 50 common equity. the after tax cost of debt is 4 the cost perferred

  Consider the discrete probability distribution find the

consider the discrete probability distribution. find the probability that x exceeds 5.tried to create table numbers

  Amazoncom stock prices gave a realized return of 5 -5 10

amazon.com stock prices gave a realized return of 5 -5 10 and -10 over four successive quarters. what is the annual

  What will the share price be

Consider a stock with a required return of 5 percent and a most recent dividend of $3.00. It is a growth stock and its dividend will increase by 10% next year and then maintain a constant growth rate thereafter. What is the expected share price no..

  What is the four-year holding period yield

During the time you held the investment, it paid income equal to $1,000 each year. What is the four-year holding period yield that you earned on your investment?

  Steelcase-analysis of deferred taxes-defined benefit plan

The objective is to analyze the financial statements of a publicly traded company: STEELCASE (name of company). Obtain an annual report from a publicly traded corporation. Be sure that the company has deferred taxes, a retirement plan, share-based ..

  Cumberland industriess partial balance sheets are shown

a.cumberland industriess 2010 sales were 455000000 operating costs excluding depreciation were equal to 85 of sales net

  Which cpa firm audited the financial statements

Which CPA firm audited the financial statements? What type of opinion was issued? What is Disney's fiscal year? What amount of restructuring costs did Disney expense in 2014? What was the chief cause of these costs?

  When and why should a firm consider splitting its stock

When and why should a firm consider splitting its stock?

  Calculate an abnormal return

Explain how these estimates would be used to calculate an abnormal return.

  What is the break-even level of units?

What is the break-even level of units?

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