Prepare a budget report for the month of july 2014

Assignment Help Risk Management
Reference no: EM13722958

Case study 1:

Gonzalez Company produces one product, Olpe. Because of wide fluctuations in demand for Olpe, the Assembly Department experiences significant variations in monthly production levels.

The annual master manufacturing overhead budget below is based on 300,000 direct labour hours. In July, 27,500 labour hours were worked. The master manufacturing overhead budget for the year and the actual overhead costs incurred in July are as follows.

Overhead costs

Master budget

Actual results for
July

Variable

 

 

  • Indirect labour

$ 300,000

$ 26,000

  • Indirect material

$ 150,000

$ 11,350

  • Utilities

$ 90,000

$ 8,050

  • Maintenance

$ 60,000

$ 5,400

Fixed

 

 

  • Supervision

$ 144,000

$ 12,000

  • Depreciation

$ 96,000

$ 8,000

  • Insurance and taxes

$ 60,000

$ 5,000

Total

$ 900,000

$ 75,800

Required:

(A) Prepare a budget report for the month of July 2014, comparing actual results with budget data based on the flexible budget. Were costs effectively controlled? Explain

(B) Prepare the flexible budget graph showing total budgeted costs assuming monthly production levels range from 25,000 to 30,000 direct labour hours (use increments of 2,500 direct labour hours).

Case study 2:

Curtis Rich, the cost accountant for Hi-Power Mower Company, recently installed activity based costing at Hi-Power's St. Louis lawn tractor (riding mower) plant where three models-the 8-horsepower Bladerunner. the 12-horsepower Quickcut, and the 18-horsepower Supercut-are manufactured.

Curtis's new product costs for these three models show that the company's traditional costing system had been significantly under costing the 18-horsepower Supercut. This was due primarily to the lower sales volume of the Supercut compared to the Bladerunner and the Quickcut.

Before completing his analysis and reporting these results to management, Curtis is approached by his friend Ed Gray, who is the production manager for the 18-horsepower Supercut model. Ed has heard from one of Curtis's staff about the new product costs and is upset and worried for his job because the new costs show the Supercut to be losing, rather than making, money.

At first, Ed condemns the new cost system, whereupon Curtis explains the practice of activity based costing and why it is more accurate than the company's present system. Even more worried now, Ed begs Curtis, "Massage the figures just enough to save the line from being discontinued. You don't want me to lose my job, do you? Anyway, nobody will know." Curtis holds firm but agrees to recompute all his calculations for accuracy before submitting his costs to management.

Required:

Draft a response from Curtis to Ed Gray.

Case study 3:

Costello Corporation produces two grades of wine from grapes that it buys from California growers. It produces and sells roughly 600,000 gallon jugs per year of a low cost, high-volume product called Valley Fresh. Costello also produces and sells roughly 200,000 gallons per year of a low-volume, high-cost product called Costello Valley. Costello Valley is sold in 1-liter bottles. Based on recent data, the Valley Fresh product has not been as profit table as Costello Valley. Management is considering dropping the inexpensive Valley Fresh line so it can focus more attention on the Costello Valley product. The Costello Valley product already demands considerably more attention than the Valley Fresh line.

Frankie Costello, president and founder of Costello, is sceptical about this idea. He points out that for many decades the company produced only the Valley Fresh line, and that it was always quite profitable. It wasn't until the company started producing the more complicated Costello Valley wine that the profitability of Valley Fresh declined. Prior to the introduction of Costello Valley, the company had simple equipment, simple growing and production procedures, and virtually no need for quality control. Because Costello Valley is bottled in 1-liter bottles, it requires considerably more time and effort, both to bottle and to label and box, than does Valley Fresh. The company must bottle and handle 4 times as many bottles of Costello Valley to sell the same quantity as Valley Fresh, since there are approximately 4 litres in a gallon. Valley Fresh requires 1 month of aging; Costello Valley requires 1 year. Valley Fresh requires cleaning and inspection of equipment every 2,500 gallons; Costello Valley requires such maintenance every 250 gallons. Frankie has asked the accounting department to prepare an analysis of the cost per gallon using the traditional costing approach and using activity-based costing. The following information was collected.

 

Valley Fresh

Costello Valley

Direct materials per gallon

$1.35

$3.60

Direct labour cost per gallon

$0.75

$1.50

Direct labour hours per gallon

0.05

0.10

Total direct labour hours

30,000

20,000

Activity Cost
Pool

Cost
Driver

Estimated
overheads

Expected use
of cost drivers

Expected use of cost
drivers per product

Valley
Fresh

Costello
Valley

Grape
processing

Cart of grapes

$146,000

8,000

6,000

2,000

Aging

Total months

$420,000

3,000,000

600,000

2,400,000

Bottling and
corking

Number of bottles

$210,000

1,400,000

600,000

800,000

Labelling and
boxing

Number of bottles

$140,000

1,400,000

600,000

800,000

Maintain and
inspect equipment

Number of inspections

$234000

1,040

240

800

Required:

Write a memo to Frankie Costello providing a brief description of what is activity based costing as well as an explanation of how the traditional approach can result in distortions.

Reference no: EM13722958

Questions Cloud

Offers an annual interest rate : Henry places the lump sum amount of $475 in a bank savings account today that offers an annual interest rate of 7.95% compounded 12 times per year. How much will Henry have in his account 9 years from today?
Write a description of social and political forces of times : Write a 700- to 1,050-word journal entry, either as a story or an explanation, that includes the following: A description of the social, economic, and political forces of the times
Case study on harley davidson : Discuss the interaction among the economic, political, sociocultural, and technological sectors of the business environment to identify opportunities and threats.
Unprecedented amount of information : Today, the Internet provides an unprecedented amount of information by way of blogs, videos, and podcasts. Conduct a critique of one blog, one video, and one podcast, which provide information that addresses the topic of your Final Research Paper.
Prepare a budget report for the month of july 2014 : Prepare a budget report for the month of July 2014, comparing actual results with budget data based on the flexible budget. Were costs effectively controlled - Draft a response from Curtis to Ed Gray.
Case study-brand stretch spectrum and market product grid : "Brand Stretch Spectrum and Market Product Grid" From the e-Activity, determine whether or not the product offerings that you selected are consistent with the perceived selections of the given health care entity. Explain your rational
Write an essay on andrew jackson and his presidency : Create an 4- to 5-slide presentation, using Microsoft® PowerPoint® or another multimedia tool, on Andrew Jackson and his presidency. Locate a political cartoon for each slide to represent President Jackson, and/or events in his presidency:
Case study-revitalizing a brand : Case Study-Revitalizing a Brand, Describe the current marketing communication, identity, and brand position of Plaza Home Health Services
Potential future work environment : Prepare an 11- to 15-page paper (not including the title and reference pages) that assesses a legal/ethical issue or situation relating to a current, previous, or potential future work environment.

Reviews

Write a Review

 

Risk Management Questions & Answers

  1maria just put 500 into a bank account that has a stated

1.maria just put 500 into a bank account that has a stated interest rate of 6.6. if the account pays simple interest

  Risk management and hedging strategy using swaps

Risk Management and Hedging Strategy Using Swaps:Debt for Equity Swaps - Identify from the perspectives of the Japanese and Brazilian Governments what are the advantages and disadvantages of this proposal. Could this Debt for Equity Swap Work?

  Identify a risky and a safe investment and provide

identify a risky and a safe investment and provide rationale to justify your choices. also discuss the trade-off of

  Problem 1bond abond

problem 1bond abond bunitmaturity47yearscoupon56annualprice101.79102.85-you knowfor certainthat the 3 year rate in 4

  Risk management and measurement issues

Presentation of work in the prescribed format, free from spelling and grammatical errors - higher volume of traffic-both people in cars and cargo in trucks- a safe financial system will help generate higher stable economic growth

  Qualitative risk analysis

The methods that I would likely use to perform qualitative risk analysis

  Develop a new application system for your business partner

You have been assigned as the manager on a project to develop a new application system for your business partner. You were given two weeks to develop a project plan and high level cost estimates.

  Estimate what change in interest rates next year would lead

Suppose that a bank has $5 billion of one-year loans and $35 billion of five-year loans. These are financed by $35 billion of one-year deposits and $5 billion of five-year deposits

  Research the mark cubans insider trading scandal

Find an example when an organisation took up too much risk and was unable to cope with it. Give a short summary of the situation and also provide your own comments onhow did the company's managers handled the situation? Either defend them or prose..

  Allocate for the management reserve

Calculate the net expected value for the project risks and opportunities cited above. How much should you plan for your contingency reserve budget based on the above? You must show all of your calculations. How much would you allocate for the managem..

  Why is there a need to assess risk in organizations

Why is there a need to assess risk in organizations?

  What is the risk from systems engineering perspectives

Your teams sensitivity analysis and recommendations based on the risk factor calculated for your assumption - What is the RISK from Systems Engineering perspectives if we want to become the Agent and distributer in the UAE

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