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

  Definition of global health care policy

Problem 1: Definition of global health care policy? Problem 2: Analyze the global health care policy?

  What are the advantages and disadvantages of product layout

What are the seven layout strategies presented in this chapter? What are the three factors that complicate a fixed-position layout? What are the advantages and disadvantages of process layout?

  Develop a powerpoint presentation for a venture capitalist

For a fictitious business you want to start, develop a PowerPoint presentation for a venture capitalist. Include a Notes view with the words you plan to use in the presentation.

  Outsourcing and globalization

Outsourcing and Globalization - Can you provide descriptions of at least three implications of outsourcing and/or globalization for public and/or nonprofit managers and leaders.

  Why current earnings may not be a good barometer

Discuss how and why current earnings may not be a good barometer of the long-term profits of the firm

  Effective communication in a business environment

Effective communication skills are essential in the workplace. Some businesses invest in training their employees on how to effectively communicate, because effective communication skills go beyond conversations.

  Capabilities of online analytical processing

What are the capabilities of online analytical processing (OLAP)? What is the value of this tool to business? Is OLAP much different from data mining and warehousing? Explain

  Relationship to the financial planning process

Choose a passage from the Bible that provides instruction about seeking advice/counsel from a person other than God or a relative. Choose another scripture that provides an example of a person doing this. In one paragraph, explain each of the scri..

  Develop a process map depicting the product flows

4. Develop a process map depicting the product flows for the HDTV supply chain and note the potential problem areas and bottlenecks that may impact the success of Team HDX.

  Characteristics of dynamic capabilitiescharacteristics of

characteristics of dynamic capabilitiescharacteristics of dynamic capabilities include all of the following excepta

  Unconstitutional violation of the first amendment protection

Provide an opinion as to whether the City of Ignatius's ordinance was an unconstitutional violation of the First Amendment protection of free speech.

  Identify the authors purpose for book and its major themes

You are to identify the author's purpose for the book, its major themes, principles and concepts, and describe how those themes, principles, and concepts relate to the themes, principles and concepts presented by DuBrin in the text.

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