Part A. Break-even Analysis Part B. Budgets Utility Total Month January Case Productic Cost Finished Goods...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part A. Break-even Analysis Part B. Budgets Utility Total Month January Case Productic Cost Finished Goods Inventory 500 $ 600.00 February 800 $ 660.00 March 1,200 $ 740.00 April 1,100 $ 720.00 May 950 690.00 June 1,025 $ 705.00 Cases Estimated finished goods inventory, Augi Desired finished goods inventory, Augus 300 175 Cost $12,000.00 $ 7,000.00 Materials Inventory Instructions Estimated materials inventory, August 1 Desired materials inventory, August 31 1,000 Cream Base (oz.) Oils (oz.) Bottels (oz.) 250 290 600 240 360 1. Determine the fixed and variable portion of the utility cost using the high-low 2. Determine the contrinution margin per case. 3. Determine the fixed costs per month, including the utility fixed cost from question (1). 4.Determine the break-even number of cases per month There was negligible work in process inventory assumed for either the beginning or end of the month; thus, none was assumed. In addition, there was no change in the cost per unit or estimated units per case operatina data from January. Instructions 5.Prepare the August production budget. 6.Prepare the August direct materials purchases budget. Part C. August Variance Analysis During September of the current year, Robin was asked to perform variance analyses for August. The January operating data provided the standard prices, rates, times, and quantities per case. There were 1,500 actual cases produced during August, which was 250 more cases than planned at the beginning of the month. Actual data for August were as follows: Actual Direct Actual Direct Materials Material Materials Price per Unit Quantity per Case Cream Base $ 0.160 102 (oz.) Natural Oils (oz.) Bottles 0.32 31 0.42 12.5 Actual Direct Actual Direct Labor Time Activity Labor Rate per Case (minutes) Mixing $ 18.20 19.50 Filling $ 14.00 5.60 Actual Variable Overhead $ 305.00 Normal Volume (Cases) 1,600 The prices of the materials were different from standard due to fluctuations in market prices. The standard quantity of materials used per case was an ideal standard. The Mixing Department used a higher grade labor classification during the month, thus causing the actual labor rate to exceed standard. The Filling Department used a lower grade labor classification during the month, thus causing Develop the direct materials purchases budget. Quivers Inc. Direct Materials Purchases Budget For the Month Ended August 31 Units required for production Plus desired ending inventory Total units required Less estimated beginning inventory Total materials to be purchased Unit price Total direct materials to be purchased Cream Base (oz.) Natural Oils Bottles (bottles) Total Raw Materials Units x Volume = Total Cream Base Natural Oils Bottles Part A. Break-even Analysis Part B. Budgets Utility Total Month January Case Productic Cost Finished Goods Inventory 500 $ 600.00 February 800 $ 660.00 March 1,200 $ 740.00 April 1,100 $ 720.00 May 950 690.00 June 1,025 $ 705.00 Cases Estimated finished goods inventory, Augi Desired finished goods inventory, Augus 300 175 Cost $12,000.00 $ 7,000.00 Materials Inventory Instructions Estimated materials inventory, August 1 Desired materials inventory, August 31 1,000 Cream Base (oz.) Oils (oz.) Bottels (oz.) 250 290 600 240 360 1. Determine the fixed and variable portion of the utility cost using the high-low 2. Determine the contrinution margin per case. 3. Determine the fixed costs per month, including the utility fixed cost from question (1). 4.Determine the break-even number of cases per month There was negligible work in process inventory assumed for either the beginning or end of the month; thus, none was assumed. In addition, there was no change in the cost per unit or estimated units per case operatina data from January. Instructions 5.Prepare the August production budget. 6.Prepare the August direct materials purchases budget. Part C. August Variance Analysis During September of the current year, Robin was asked to perform variance analyses for August. The January operating data provided the standard prices, rates, times, and quantities per case. There were 1,500 actual cases produced during August, which was 250 more cases than planned at the beginning of the month. Actual data for August were as follows: Actual Direct Actual Direct Materials Material Materials Price per Unit Quantity per Case Cream Base $ 0.160 102 (oz.) Natural Oils (oz.) Bottles 0.32 31 0.42 12.5 Actual Direct Actual Direct Labor Time Activity Labor Rate per Case (minutes) Mixing $ 18.20 19.50 Filling $ 14.00 5.60 Actual Variable Overhead $ 305.00 Normal Volume (Cases) 1,600 The prices of the materials were different from standard due to fluctuations in market prices. The standard quantity of materials used per case was an ideal standard. The Mixing Department used a higher grade labor classification during the month, thus causing the actual labor rate to exceed standard. The Filling Department used a lower grade labor classification during the month, thus causing Develop the direct materials purchases budget. Quivers Inc. Direct Materials Purchases Budget For the Month Ended August 31 Units required for production Plus desired ending inventory Total units required Less estimated beginning inventory Total materials to be purchased Unit price Total direct materials to be purchased Cream Base (oz.) Natural Oils Bottles (bottles) Total Raw Materials Units x Volume = Total Cream Base Natural Oils Bottles
Expert Answer:
Answer rating: 100% (QA)
ANSWER Part A Breakeven Analysis 1 Determine the fixed and variable portion of the utility cost using the highlow method High activity level June 1025 cases utility cost 705 Low activity level January ... View the full answer
Related Book For
Accounting
ISBN: 978-1285743615
26th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
Genuine Spice Inc. began operations on January 1, 2014. The company produces a hand and body lotion in an eight-ounce bottle called Eternal Beauty. The lotion is sold whole-sale in 12-bottle cases...
-
Genuine Spice Inc. began operations on January 1, 2016. The company produces eight- ounce bottles of hand and body lotion called Eternal Beauty. The lotion is sold wholesale in 12-bottle cases for...
-
A population of Ecuadorians have short stature. They have a rare genetic defect that affects the body's response to growth horm one, called Laron syndrome. Recent genetic studies have dem onstrated...
-
When are partnerships eligible to use the cash method of accounting?
-
Go to the St. Louis Federal Reserve FRED database, and find data on the personal consumption expenditure price index (PCECTPI), a measure of the price level; real compensation per hour (COM-PRNFB);...
-
"The rate at which a substance reacts is proportional to its active mass and the rate of a chemical reaction is proportional to the product of the active masses of the reacting substances." This is...
-
Melody Audio Company manufactures two models of speakers, DL and XL. Based on the following production and sales data for September 2007, prepare (a) A sales budget and (b) A productionbudget. DL XL...
-
EXPLAIN DIFFERENT WAYS IN WHICH YOU CAN PREPARE FOR SPECIFIED ROLES related to HRM?
-
Considering the sign up fee and monthly membership fee for a gym the equation c=30m+25 can be used to represent the total cost of a gym membership for m months what is the amount of the sign up fee
-
Prepare an internal memorandum explaining the general differences among intentional torts, negligence and strict liability for purposes of mindset and intent. Additionally, explain the elements of...
-
Compare and contrast the different types of property distribution methods that states follow during a divorce trial. If a married couple moves from one state to a different state that uses entirely...
-
Why do you think there are different limitations for different types of actions? Do you see any logic or patterns the differing statutes of limitations? (Hint: look at property and contract actions,...
-
"As the patriots of seventy-six did to the support of the Declaration of Independence, so to the support of the Constitution and Laws, let every American pledge his life, his property, and his sacred...
-
Refer to Figure 6-7. Using the total revenue test to verify the price elasticity between points a and b on the demand curve, what demand is? Figure 6-7 Price per unit $8 a 4 b Demand 0 5,000 10,000...
-
- 14. A firm wants to calculate its weighted average cost of capital (WACC). The company's CFO has collected the following information: The company's 12 year maturity left, 12 % coupon rate, semi...
-
The graph of an equation is given. (a) Find the intercepts. (b) Indicate whether the graph is symmetric with respect to the x-axis, the y-axis, or the origin. -3 6 -6 3 x
-
The Junior League of Yadkinville, California, collected recipes from members and published a cookbook entitled Food for Everyone. The book will sell for $ 18 per copy. The chairwoman of the cookbook...
-
The financial statements at the end of Wolverine Realty's first month of operations are as follows: Instructions By analyzing the interrelationships among the four financial statements, determine the...
-
Identify the following costs as a prime cost (P), conversion cost (C), or both (B) for a magazine publisher. a. Maintenance on printing machines b. Glue used to bind magazine c. Wages of printing...
-
Following are several tests of controls introduced in the chapter: Examine periodic reports by non-Purchasing Department personnel regarding purchase prices and practices. Observe Receiving...
-
Harold Brodkey plans to apply sequential sampling to the receiving controls used by the Ozyck Corporation, a December 31, 1999 year end manufacturer and supplier of home lighting fixtures. Based on a...
-
Few departments within a corporation, not-for-profit institution, or governmental entity can have quite as significant an influence on cost containment as Purchasing, since the purchasing function...
Study smarter with the SolutionInn App