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:

User Account

All Pages