Prepare Marigold & Hill’s ending inventory and cost of goods sold budget for the first quarter. Assuming that the company has no beginning and ending WIP inventory. (Round unit cost to 2 decimal places, e.g. 5.33 & all other answers to 0 decimal places, e.g. 5,275.)
Prepare Marigold & Hill’s ending inventory and cost of goods sold budget for the first quarter. Assuming that the company has no beginning and ending WIP inventory. (Round unit cost to 2 decimal places, e.g. 5.33 & all other answers to 0 decimal places, e.g. 5,275.)
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 23BEA: Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in...
Related questions
Question
100%
George Garcia, Marigold & Garcia Fabricators’ production manager, has just received the company’s sales budget for the first quarter:
Its manufacturingoverhead budget for the first quarter is as follows:
He also has received the direct materials purchases budget and direct labor budget which were as follows:
Joshua plans to have 3,200 finished bricks at a cost of $46,000 in inventory at the beginning of the year. The company applies manufacturing overhead based on direct labor hours, and the current predetermined rates are $12.25 per direct labor hour for fixed manufacturing overhead and $1.75 per direct labor hour for variable manufacturing overhead.
Prepare Marigold & Hill’s ending inventory and cost of goods sold budget for the first quarter. Assuming that the company has no beginning and ending WIP inventory. (Round unit cost to 2 decimal places, e.g. 5.33 & all other answers to 0 decimal places, e.g. 5,275.)
January | February | March | Quarter | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Budgeted unit sales
|
22,000 | 25,000 | 32,000 | 79,000 | ||||||||
Budgeted ending inventory
|
5,000 | 6,400 | 7,200 | 7,200 | ||||||||
Total units required
|
27,000 | 31,400 | 39,200 | 86,200 | ||||||||
Beginning inventory
|
3,200 | 5,000 | 6,400 | 3,200 | ||||||||
Budgeted production
|
23,800 | 26,400 | 32,800 | 83,000 |
Its manufacturing
January
|
February
|
March
|
Quarter
|
|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
DLH worked
|
4,760 | 5,280 | 6,560 | 16,600 | ||||||||
VOH per DLH
|
$1.75 | $1.75 | $1.75 | $1.75 | ||||||||
Budgeted VOH
|
8,330 | 9,240 | 11,480 | 29,050 | ||||||||
Budgeted FOH
|
101,900 | 101,900 | 101,900 | 305,700 | ||||||||
Total Budgeted MOH
|
110,230 | 111,140 | 113,380 | 334,750 | ||||||||
Noncash MOH items
|
||||||||||||
|
35,000 | 35,000 | 35,000 | 105,000 | ||||||||
Total Cash MOH cost
|
$75,230 | $76,140 | $78,380 | $229,750 |
He also has received the direct materials purchases budget and direct labor budget which were as follows:
January | February | March | Quarter | April | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Budgeted production
|
23,800 | 26,400 | 32,800 | 83,000 | 34,000 | |||||||||
Standard pounds per unit
|
× 6 | × 6 | × 6 | × 6 | × 6 | |||||||||
Production needs
|
142,800 | 158,400 | 196,800 | 498,000 | 204,000 | |||||||||
Budgeted ending inventory
|
15,840 | 19,680 | 20,400 | 20,400 | ||||||||||
Total DM required (lbs.)
|
158,640 | 178,080 | 217,200 | 518,400 | ||||||||||
Beginning inventory
|
13,000 | 15,840 | 19,680 | 13,000 | ||||||||||
Budgeted purchases (lbs.)
|
145,640 | 162,240 | 197,520 | 505,400 | ||||||||||
|
$1.00 | $1.00 | $1.00 | $1.00 | ||||||||||
Budgeted purchases cost
|
$145,640 | $162,240 | $197,520 | $505,400 |
January | February | March | Quarter | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Budgeted production
|
23,800 | 26,400 | 32,800 | 83,000 | ||||||||
Standard DLH per unit
|
× 0.20 | × 0.20 | × 0.20 | × 0.20 | ||||||||
Total DLH required
|
4,760 | 5,280 | 6,560 | 16,600 | ||||||||
Standard wage rate
|
× $20 | × $20 | × $20 | × $20 | ||||||||
Budgeted DL cost
|
$95,200 | $105,600 | $131,200 | $332,000 |
Joshua plans to have 3,200 finished bricks at a cost of $46,000 in inventory at the beginning of the year. The company applies manufacturing overhead based on direct labor hours, and the current predetermined rates are $12.25 per direct labor hour for fixed manufacturing overhead and $1.75 per direct labor hour for variable manufacturing overhead.
Prepare Marigold & Hill’s ending inventory and cost of goods sold budget for the first quarter. Assuming that the company has no beginning and ending WIP inventory. (Round unit cost to 2 decimal places, e.g. 5.33 & all other answers to 0 decimal places, e.g. 5,275.)
Direct Materials
|
||
---|---|---|
select an opening name for this budget
|
$enter a dollar amount | |
select an item
|
enter a dollar amount | |
select an item
|
enter a dollar amount | |
select a closing name for this budget
|
$enter a total amount |
Finished Goods Inventory
|
||
---|---|---|
select an opening section name :
|
||
select an item
|
$enter a dollar amount rounded to 2 decimal places | |
select an item
|
enter a dollar amount rounded to 2 decimal places | |
select an item
|
enter a dollar amount rounded to 2 decimal places | |
select a closing section name
|
$enter a total amount for this section rounded to 2 decimal places | |
select an item
|
enter a number of units | |
select a closing name for this budget
|
$enter a total amount for this budget |
Cost of Goods Sold
|
||
---|---|---|
select an opening name for this budget
|
$enter a dollar amount | |
select an item
|
enter a dollar amount | |
select an item
|
enter a dollar amount | |
select an item
|
enter a dollar amount | |
select a summarizing line for the first part
|
enter a total amount for the first part | |
select an item
|
enter a dollar amount | |
select a closing name for this budget
|
enter a total amount for the second part | |
select an item
|
enter a dollar amount | |
select an item
|
enter a dollar amount | |
select a closing cost of goods sold budget item
|
$enter a total amount for this budget |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning