Reference no: EM131435806
Assignment: 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:
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?
Submit your Assignment (both your Excel and Word files).
General Guidance on Assignment Length:
The memo portion of this Assignment will typically be 2-3 paragraphs in length as a general.
Attachment:- Attachments.rar
What is the after tax cash flow if the computer system is
: ABC Company purchased a computerized system at $160000 and follows 5-year MACRS depreciation. What is the after tax cash flow if the computer system is sold in 4th year at $10000 and also if sold at $30000.
|
What are major sources of conflict throughout the lifecycle
: What are the major sources of conflict throughout the lifecycle? What are the major tasks of a Project Management Office? What factors/concepts should be included in a master plan for information systems development?
|
How high above the base of the cliff will the arrow rise
: You are standing on the top of a tall cliff and shoot an arrow from a height of 30.0 m at 25.0 m/s and an initial angle of 32.0° above the horizontal. How high above the base of the cliff will the arrow rise? Assume a level landscape.
|
What will be the optimal time to sell the machine
: A machine costs $2000 and gives cash inflow of $25000 a year for three years. If the firm can sell the machine at Year-1,2,3 , what will be the optimal time to sell the machine. The maintenance cost and the salvage value are as follows: Year Maint..
|
Prepare 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.
|
Frictionless horizontal surface as shown
: A small block of mass m1 is released from rest at the top of a curve-shaped, frictionless wedge which sits on a frictionless horizontal surface as shown. The height of the wedge is h = 5m.
|
On this basis , find the replacement strategy.
: A widget manufacturer operates two machines , each of which has a capacity of 1000 units a year. They have an indefinite life and zero salvage value. The operating cost is $2 per widget. Widget is a seasonal business.
|
Calculate a benefit-to-cost ratio
: QSO 645 Project Selection Journal Guidelines. You are a project manager for a local company that is considering installing a new content management system. Your boss has asked you to do a net present value (NPV) analysis, calculate a benefit-to-cos..
|
Employee representation across demographic categories
: Examine the percentages of employee representation across demographic categories for Tanglewood and the available labor market for Table 1.3. Are there any particular classes or jobs where the representation within Tanglewood appears to be out of lin..
|