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

Finding interest expenses

200,000 in assets to get into operation with only two financing alternatives 1. 2.50 percent equity and 50% debt. you will put the entire 200,000 required to purchase the asse

Calculate the equivalent units for kali maniufacturing

Problem 1:Kali Manufacturing Inc. began the year with the following. Units ,beginning work-in-process 20,000 20% complete,Transferred to finished goods 60,000 ,Ending inventor

If the risk-free rate is 6 percent and the market risk

Stock Y has a beta of 1.25 and an expected return of 14 percent. Stock Z has a beta of .70 and an expected return of 9 percent. If the risk-free rate is 6 percent and the mark

Discuss the hr responsibilities of supervisors

Your response should be at least 75 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the tex

Compare and contrast the given chart for target

1-Year Stock Performance Yield Short Position Debt-to-Equity Ratio Operational Cash Flow (ttm) TGT 33.71% 2.58% 3.20% 0.91 $4.44 billion WMT 2.44% 2.46% 1.30% 0.59 $25.56 bi

Convenience yield and cost of carry

Explain carefully the meaning of the terms convenience yield and cost of carry. What is the relationship between futures price, spot price, convenience yield, and cost of ca

Determine the value of per share

This company pays a perpetual annual dividend of 2.5 percent of its par value. Par value is $100 per share. If investors require rate of return on this stock is 15%, determine

Thinking about retirement

Do you expect to retire at a certain age? How much preplanning will you need to do? Do you expect to retire to a life of leisure, volunteer activity, new career, and so on? Wh

Reviews

Write a Review

 
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