Create a performance report using spreadsheet software

Assignment Help Business Management
Reference no: EM131268997

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.

For this Assignment, review the Static Budget Report provided. Additionally, you may find valuable information in your course text, especially Exercise 6-3.

HINT: for more information about this, see the Weekly Briefing and the Performance Report video.
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:

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

o 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: EM131268997

Questions Cloud

Mapping the process of innovation : Mapping the Process of Innovation 1.Pick an industry (e.g. groceries, airlines, publishing, etc.) and explain the innovative process that must take place for successful integration of innovation.
Business and sustainability : What is a good thesis statement for a paper on the benefits of sustainability in the fast fashion industry? Write an outline for a paper on sustainability in the fast fashion industry.
Find the production level and price per unit : What is the maximum profit (to the nearest dollar)?- Find the production level and price per unit that produce the maximum revenue. What is the maximum revenue?
Ethical environment of a company : How would you define the term "leader" and what makes a good leader in your view? What do you believe is a leader's role in shaping the ethical environment of a company and what are some ways in which this role may be carried out?
Create a performance report using spreadsheet software : Prepare a performance report using spreadsheet software, such as Excel. Hint: Read the Weekly Briefing and watch the Performance Report video on this topic.
Calculate real reactive and apparent power of the system : Write a program that provides a general solution for the network of Fig. 19.19. That is, given the resistance or reactance of each element and the source voltage at zero degrees, calculate the real, reactive, and apparent power of the system.
Regarding the distinction between profit and fee : Which is true regarding the distinction between “profit” and “fee”?
Write comprehensive job description : You are the hiring manager at a major home improvement retailer, Home Improvement Center, and need to fill a position for an exempt-status night shift supervisor. The applicants should have retail business experience, preferably in housewares, and at..
Successful global strategy include developing plans : Some factors to be considered for a successful global strategy include developing plans for creating new products, assuring customer service and products are what customers want, and recruiting skilled employees to provide this competitive advanta..

Reviews

Write a Review

Business Management Questions & Answers

  Question regarding the companies ordinance

According to Companies Ordinance, 1984, __________ shall stand retired from office at the first annual general meeting of the company.

  Exchange around the world

You are the assistant publicist for a best-selling international author who wrote an adventure novel about an improbable around-the-world trip. To promote her new novel, she will leave on a multi-city book tour. Her publisher created an Access dat..

  Explain the functions roles and activities of managers

Explain the functions, roles, and activities of managers. Research two companies within the last 3-years, not described in the book, and discuss what managerial characteristics were essential to lead change.

  Secondary sources of information available to rei

Identify three or more of the secondary sources of information available to REI? Develop a short analysis of the value of the secondary sources of information available to REI?

  Linear optimization problem

Linear optimization includes building a working model of an existing problem as well as utilizing a variety of tools to find a solution that fits within a variation of existing criteria

  Illustrate what will your audiences attitude probably

Illustrate what will your audience's attitude probably be toward your message? Will the reaction be uniform, or will it vary? Illustrate what three media would you use to communicate with your audience?

  Describe the role of a supervisor in a typical organization.

Discuss the relationship between managers, supervisors, and employees, and how these relationships assist in guiding organizations to achieve their maximum potential.

  Have you ever considered starting a business

Have you ever considered starting a business? If you were to start your own business someday, describe the revenues and costs you would consider (make sure you are describing economic profit in your analysis).

  Expected to spend on advertisement

The company's revenue for years 6 and 7 are as follows: 96/= and 100/=. Use regression analysis to estimate how much the company is expected to spend on advertisement.

  When to in-house an when to pay moreif one decides to hedge

when to in-house an when to pay moreif one decides to hedge when would one manage the hedging in-house and when would

  Competition forces roe down

Assume that the ROE and payout ratio stay constant for the next four years. After that, competition forces ROE down to 11.5% and the payout ratio increases to 0.8. The cost of capital is 11.5%.

  Conflict identification and resolution

Conflict Identification and Resolution

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