Top-Rated Free Essay

Exercise 8-3 Direct Materials Budget: Mink Caress

Satisfactory Essays
Exercise 8-3 Direct Materials Budget
Three grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia. The cost of the musk oil is $1.50 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3:

Year 2
Year 3

First
Second
Third
Fourth

First
Budgeted production, in bottles
60,000
90,000
150,000
100,000

70,000

Musk oil has become so popular as a perfume ingredient that it has become necessary to carry large inventories as a precaution against stock-outs. For this reason, the inventory of musk oil at the end of a quarter must be equal to 20% of the following quarter's production needs. Some 36,000 grams of musk oil will be on hand to start the first quarter of Year 2. Required: Prepare a direct materials budget for musk oil, by quarter and in total, for Year 2. At the bottom of your budget, show the amount of purchases for each quarter and for the year in total.

Quarter—Year 2

First
Second
Third
Fourth
Year
Required production in units of finished goods
60,000
90,000
150,000
100,000
400,000
Units of raw materials needed per unit of finished goods × 3 × 3 × 3 × 3 × 3
Units of raw materials needed to meet production
180,000
270,000
450,000
300,000
1,200,000
Add desired units of ending raw materials inventory 54,000 90,000 60,000 42,000 42,000
Total units of raw materials needed
234,000
360,000
510,000
342,000
1,242,000
Less units of beginning raw materials inventory 36,000 54,000 90,000 60,000 36,000
Units of raw materials to be purchased
198,000
306,000
420,000
282,000
1,206,000
Unit cost of raw materials
× $1.50
× $1.50
× $1.50
× $1.50
× $1.50
Cost of raw materials to purchased
$297,000
$459,000
$630,000
$423,000
$1,809,000

Solution:
First Quarter
Production needs = # of bottles x 3 grams per bottle = 60,000*3 = 180,000 grams
Desired ending inventory = Production needs for the next quarter x 0.2 = 90,000*3*0.2 = 54,000 grams
Total needs = Production needs + desired ending inventory = 180,000 + 54,000 = 234,000 grams
Beginning inventory = Ending inventory of the previous quarter = 36,000 grams
Raw Materials to be purchased = Total needs - beginning inventory = 234,000 - 36,000 = 198,000 grams
Cost of raw materials to be purchased = Raw materials to be purchased x 150 = 198,000*1,50 = $297,000

Second Quarter
Production needs = # of bottles x 3 grams per bottle = 90,000*3 = 270,000 grams
Desired ending inventory = Production needs for the next quarter x 0.2 = 150,000*3*0.2 = 90,000 grams
Total needs = Production needs + desired ending inventory = 270,000 + 90,000 = 360,000 grams
Beginning inventory = Ending inventory of the previous quarter = 54,000 grams
Raw Materials to be purchased = Total needs - beginning inventory = 360,000 - 54,000 = 306,000 grams
Cost of raw materials to be purchased = Raw materials to be purchased x 150 = 306,000*1,50 = $459,000

Third Quarter
Production needs = # of bottles x 3 grams per bottle = 150,000*3 = 450,000 grams
Desired ending inventory = Production needs for the next quarter x 0.2 = 100,000*3*0.2 = 60,000 grams
Total needs = Production needs + desired ending inventory = 450,000 + 60,000 = 510,000 grams
Beginning inventory = Ending inventory of the previous quarter = 90,000 grams
Raw Materials to be purchased = Total needs - beginning inventory = 510,000 - 90,000 = 420,000 grams
Cost of raw materials to be purchased = Raw materials to be purchased x 150 = 420,000*1,50 = $630,000

Fourth Quarter
Production needs = # of bottles x 3 grams per bottle = 100,000*3 = 300,000 grams
Desired ending inventory = Production needs for the next quarter x 0.2 = 70,000*3*0.2 = 42,000 grams
Total needs = Production needs + desired ending inventory = 300,000 + 42,000 = 342,000 grams
Beginning inventory = Ending inventory of the previous quarter = 60,000 grams
Raw Materials to be purchased = Total needs - beginning inventory = 342,000 - 60,000 = 282,000 grams
Cost of raw materials to be purchased = Raw materials to be purchased x 150 = 282,000*1,50 = $423,000

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Chapter 8 Problems

    • 1246 Words
    • 5 Pages

    Chapter 8 1,4,5 1. Cray Research sold a super computer to the Max Planck Institute in Germany on credit and invoiced €10 million payable in six months. Currently, the six-month forward exchange rate is $1.10/€ and the foreign exchange advisor for Cray Research predicts that the spot rate is likely to be $1.05/€ in six months. (a) What is the expected gain/loss from the forward hedging? The expected gain from this sale can be figured by using this equation: 10,000,000(1…

    • 1246 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Text and Cases Problem 8

    • 1152 Words
    • 5 Pages

    Problem 8-3. For each of the following situations, the present value concept should be applied: 1. Your wealthy aunt just established a trust fund for you that will accumulate to a total of $100,000 in 12 years. Interest on the trust fund is compounded annually at an 8% rate. How much is in your trust fund today? 2. On January 1, you will purchase a new car. The automobile dealer will allow you to make increasing annual December 31 payments over the following four years. The amounts…

    • 1152 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Chapter 8 Programming Problems IT/210 Chapter 8 Programming Problems For each of the following problems, use the top-down modular approach and pseudocode to design a suitable program to solve it. 1. Input names of students from the user, terminated by ZZZ, and create a data file GRADES with records of the form: student(string), test1(interger), test2 (interger), test3 (interger). In this file, all test scores should be set equal to 0. Analysis Process 1. Display input student…

    • 296 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Problem Set 8 Solutions

    • 1329 Words
    • 6 Pages

    Department of Economics University of California, Berkeley Fall 2012 Econ 182 Solutions Problem Set 8 Problem 1. Exchange Rates and International Transmission a. Suppose that the US engages in a monetary expansion. Since exchange rate is pegged to the US dollar, country X’s monetary authorities are forced to expand their money supply as well (recall that i = i* under FixER). Interest rates fall in country X, output expands, and of course the exchange rate remains unchanged. On the AA-DD diagram…

    • 1329 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Chapter 8 Problem 1

    • 175 Words
    • 2 Pages

    Write “Enter test 2 score for”+ Student[K] Input Test2 Write “Enter test 3 score for”+Student[K] Input Test3 Write Newfile, Student[K], Test1[K], Test2[K], Test3[K] End For Analysis: The problems required output is the students name with scores from three tests. Each student and scores shall be listed on separate lines. The input variables needed for this program include Test1, Test2, Test3, and Student. Chapter 8 Problem 1. Part A and B…

    • 175 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Social Problems Reading 8

    • 362 Words
    • 2 Pages

    Reading 8: • What exactly is the problem? What values and goals make it a problem? o The problem is that there are both cultural/behavioral and structural/economic causes to poverty. The cultural/behavioral approach places responsibility for poverty on the personal inadequacies of the poor, welfare in general, or the design flaws of welfare programs. The structural/economic approach places responsibility for poverty on the movement of manufacturing jobs from the cities to the suburbs and the…

    • 362 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Case Problem 3

    • 936 Words
    • 4 Pages

    Case Problem 3: Hart Venture Capital 1. Let S = fraction of the Security Systems project funded by HVC M = fraction of the Market Analysis project funded by HVC Max 1,800,000S + 1,600,000M s.t. 600,000S + 500,000M ≤ 800,000 Year 1 600,000S + 350,000M ≤ 700,000 Year 2 250,000S + 400,000M ≤ 500,000 Year 3 S…

    • 936 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Accounting Problem 17-8

    • 799 Words
    • 4 Pages

    Problem 17-8 Brooks Corp. is a medium-sized corporation specializing in quarrying stone for building construction. The company has long dominated the market, at one time achieving a 70% market penetration. During prosperous years, the company's profits, coupled with a conservative dividend policy, resulted in funds available for outside investment. Over the years Brooks had a policy of investing idle cash in equity securities. In particular, Brooks has made periodic investments in the company's…

    • 799 Words
    • 4 Pages
    Good Essays
  • Good Essays

    problem set#3

    • 1031 Words
    • 4 Pages

    Problem set 3 (Answer) 7.6. A farmer uses three inputs to produce vegetables: land, capital, and labor. The production function for the farm exhibits diminishing marginal rate of technical substitution. a) In the short run the amount of land is fixed. Suppose the prices of capital and labor both increase by 5 percent. What happens to the cost-minimizing quantities of labor and capital for a given output level? Remember that there are three inputs, one of which is fixed. b) Suppose only the cost…

    • 1031 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Problem 1:Input names of students from the user, terminated by ZZZ, andcreate a data file GRADES with records of the form:student (string), test1 (integer), test2 (integer), test3 (integer)In this file, all test scores should be set equal to 0. Main Program Open GRADES Declare Name as String Call Write Grades Module Close GRADES End Main Module Write Grades Module Display "Enter Student's Name, ZZZ to quit” Input Name While Name <> "ZZZ" Write Name to GRADES Write "0 0 0" to GRADES Write newline…

    • 194 Words
    • 2 Pages
    Satisfactory Essays