In: Accounting
A) Moriarity Company has budgeted the following unit sales:
1st Quarter
2019 7,000
2nd Quarter 2019 3,000
3rd Quarter 2019 4,000
Beginning finished goods for the first quarter was 1,400 units. The company's policy is to maintain an inventory of finished goods as 20% of the next quarter sales. The production budget for the SECOND quarter is __________. (no dollar signs, decimals or commas) HINT: you must calculate the first quarter in order to calculate the 2nd quarter.
B)JTS Corp had the following production budget:
1st Quarter 2019 8.000
units
2nd Quarter 2019 9,000 units
Each unit requires 4 pounds of raw materials at $2 per pound. JTS wants a raw materials inventory of 40% of the next months raw materials (the same percentage was used in 2018). The raw materials budget for the first quarter of 2019 is _______________. (no dollar signs, commas or decimals)
C) Shadwell Company has budgeted the following unit sales:
1st Quarter
2019
10.000 units
2nd Quarter
2019
7,000 units
It also had the following production budget:
1st Quarter 2019
12,000 units
2nd Quarter 2019 8,000 units
Each unit requires 6 pounds of raw materials at $3 per pound. Each unit requires 1.5 hours of direct labor at $20 per hour. Manufacturing overhead is 60% of direct labor cost.
Cost of goods sold for Shadwell Company for the 2nd quarter is ____________. (no dollar signs, commas nor decimals).
Ans. A | Moriarity Company | ||||||
Production Budget | |||||||
First quarter | Second quarter | ||||||
Sales | 7,000 | 3,000 | |||||
Add: Desired Ending inventory | 600 | 800 | |||||
Total needs | 7,600 | 3,800 | |||||
Less: Beginning inventory | -1400 | -600 | |||||
Units to be produced | 6,200 | 3,200 | |||||
*Calculations for Ending inventory: | *Calculations for Beginning inventory: | ||||||
Quarter | Quarter | ||||||
1 | 3,000 * 20% | 600 | 1 | Given | 1400 | ||
2 | 4,000 * 20% | 800 | 2 | Ending inventory of Q1 | 600 | ||
Ans. B | JTS Corp. | ||||||
Direct Materials Budget | |||||||
First quarter | |||||||
Budgeted production (units) | 8,000 | ||||||
(X) Materials requirement per unit | 4 | ||||||
Materials needed for production | 32000 | ||||||
Add: budgeted ending inventory | 14400 | ||||||
Total materials requirements | 46400 | ||||||
Less: Budgeted beginning inventory | -12800 | ||||||
Materials to be purchased | 33600 | ||||||
(X) Direct materials per unit | $2 | ||||||
Total budgeted direct materials | $67,200 | ||||||
*Calculations for materials needed for second quarter : | |||||||
Second Quarter | |||||||
Budgeted production (units) | 9,000 | ||||||
(X) Materials requirement per unit | 4 | ||||||
Materials needed for production | 36000 | ||||||
*Ending inventory for current quarter = Materials requirements of 2nd quarter * 40% | |||||||
36,000 * 40% = 14,400 | |||||||
Quarter 1 beginning inventory = Ending inventory of quarter 4 of 2018 = 40% of first quarter of 2019 Materials needed for prodution | |||||||
32,000 * 40% | |||||||
12800 | |||||||
Ans. C | Particulars | Amount | |||||
Direct materials | $126,000 | ||||||
Direct labor | $210,000 | ||||||
Manufacturing overhead | $126,000 | ||||||
Cost of goods sold | $462,000 | ||||||
*Calculations for direct materials: | |||||||
Second Quarter | |||||||
Budgeted production (units) | 7,000 | ||||||
(X) Materials requirement per unit | 6 | ||||||
Materials to be purchased | 42000 |
Related SolutionsMoriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000...Moriarity Company has budgeted the following unit sales: 1st
Quarter 2019 7,000 2nd Quarter 2019 3,000 3rd Quarter 2019 4,000
Beginning finished goods for the first quarter was 1,400 units. The
company's policy is to maintain an inventory of finished goods as
20% of the next quarter sales. The production budget for the SECOND
quarter is __________. (no dollar signs, decimals or commas) HINT:
you must calculate the first quarter in order to calculate the 2nd
quarter.
Ring The Bells Co. makes one product. Budgeted unit sales for 1st Quarter, 2nd Quarter, 3rd...Ring The Bells Co. makes one product. Budgeted unit sales for
1st Quarter, 2nd Quarter, 3rd Quarter, and 4th Quarter are 580,000;
560,000; 575,000; and 590,000 units, respectively. The ending
finished goods inventory should equal 5% of the following month's
sales. The budgeted required production for 3rd Quarter is:
a. 575,000 units
b. 575,750 units
c. 574,250 units
d. 560,750 units
e. 560,000 units
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...Weller Company's budgeted unit sales for the upcoming fiscal
year are provided below:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Budgeted unit sales
35,000
37,000
28,000
33,000
The company’s variable selling and administrative expense per
unit is $3.40. Fixed selling and administrative expenses include
advertising expenses of $12,000 per quarter, executive salaries of
$53,000 per quarter, and depreciation of $34,000 per quarter. In
addition, the company will make insurance payments of $5,000 in the
first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...Weller Company's budgeted unit sales for the upcoming fiscal
year are provided below:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Budgeted unit sales
21,000
28,000
19,000
19,000
The company’s variable selling and administrative expense per
unit is $2.00. Fixed selling and administrative expenses include
advertising expenses of $14,000 per quarter, executive salaries of
$41,000 per quarter, and depreciation of $20,000 per quarter. In
addition, the company will make insurance payments of $5,000 in the
first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...Weller Company's budgeted unit sales for the upcoming fiscal
year are provided below:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Budgeted unit sales
31,000
33,000
24,000
29,000
The company’s variable selling and administrative expense per
unit is $3.00. Fixed selling and administrative expenses include
advertising expenses of $8,000 per quarter, executive salaries of
$50,000 per quarter, and depreciation of $30,000 per quarter. In
addition, the company will make insurance payments of $5,000 in the
first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...Weller Company's budgeted unit sales for the upcoming fiscal
year are provided below:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Budgeted unit sales
16,000
18,000
15,000
14,000
The company’s variable selling and administrative expense per
unit is $1.50. Fixed selling and administrative expenses include
advertising expenses of $9,000 per quarter, executive salaries of
$35,000 per quarter, and depreciation of $15,000 per quarter. In
addition, the company will make insurance payments of $4,000 in the
first quarter and $4,000 in...
Mercedes, Co. has the following quarterly financial information. 4th Quarter 3rd Quarter 2nd Quarter 1st Quarter...Mercedes, Co. has the following quarterly financial information.
4th Quarter 3rd Quarter 2nd Quarter 1st Quarter Sales Revenue $
925,800 $ 935,300 $ 933,600 $ 941,400 Cost of Goods Sold 305,700
318,300 317,900 323,100 Operating Expenses 248,900 260,300 258,500
262,600 Interest Expense 4,200 4,200 4,200 4,100 Income Tax Expense
85,500 88,400 88,400 90,900 Average Number of Common Shares
Outstanding 799,030 794,064 795,670 809,000 Stock price when Q4 EPS
released $ 24 Required: Calculate the gross profit percentage for
each quarter....
Eckert Company has budgeted the following unit sales:Eckert Company has budgeted the following unit sales:
2016
Units
April 25,000
May 50,000
June 75,000
July 45,000
Of the units budgeted, 40% are sold by the Southern Division at
an average price of $15 per unit and the remainder are sold by the
Eastern Division at an average price of $12 per unit. Instructions
Prepare separate sales budgets for each division and for the
company in total for the second quarter of 2017 by completing the
chart. Do NOT...
Coliseum Company has budgeted the following unit sales: Quarter Units Qtr. 1, 2020 60,000 Qtr. 2,...Coliseum Company has budgeted the following unit sales:
Quarter Units
Qtr. 1, 2020 60,000
Qtr. 2, 2020 50,000
Qtr. 3, 2020 40,000
Qtr. 4, 2020 80,000
The finished goods inventory on hand on December 31, 2019 was
6,000 units. 90% of the next quarter’s sales will come from
production during that quarter, and the remainder of next quarter’s
sales will come from this quarter’s ending inventory.
Required: Prepare a production budget for the first two quarters
of 2020. Include totals...
The budgeted unit sales of Weller Company for the upcoming fiscal year are provided below: 1st...
The budgeted unit sales of
Weller Company for the upcoming fiscal year are provided
below:
1st
Quarter
2nd
Quarter
3rd
Quarter
4th
Quarter
Budgeted unit
sales
24,000
25,000
21,000
22,000
The company’s variable selling and administrative expense per
unit is $2.30. Fixed selling and administrative expenses include
advertising expenses of $9,000 per quarter, executive salaries of
$44,000 per quarter, and depreciation of $23,000 per quarter. In
addition, the company will make insurance payments of $4,000 in the
first quarter and...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|