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

  Important question based on financial risk

If according to the historical financial statements for Starbucks, the debt to assets ratio is 4.00 percent and is forecasted to go to zero in 2003.

  For many years japanese financial companies including

for many years japanese financial companies including insurance companies banded assets together as a method of

  New economic and market realities

from the perspective of your job; your present job or a job that you envision you may have later on. Make sure you answer this question in light of the post-2008 economic and financial realities.

  What is the equilibrium risk premium

What is the equilibrium risk premium

  Evaluate the gross profit

Evaluate the gross profit

  Problem 1 if purchasing power parity applied to big macs

problem 1. if purchasing power parity applied to big macs and a big mac cost 2.50 in the united states while the

  Calculate the net expected value for the project risks

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.

  You are considering buying or leasing a new latest bmw

you are considering buying or leasing a new latest bmw model.the dealer offers you the following terms on a leasedown

  Which bond should the investor select

An investor in the 28 percent tax bracket is trying to decide which of two bonds to purchase. One is a corporate bond carrying an 8 percent coupon and selling at par. The other is a municipal bond with a 51/2 percent coupon, and it, too, sells at ..

  How microsoft change its capital structure

Find the weighted average cost of capital and if Microsoft wants to change its capital structure (i.e., lower their WACC), what should it do?

  1 looking at the exhibit on page 571 that graphically

1 looking at the exhibit on page 571 that graphically portrays the characteristics of value and growth stocks briefly

  Minimize cash flow risk

Companys main objective is to minimize cash flow risk and explain what the company- Explain what the company should do.

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